Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


In manual reconciliation, how to 'keep-open' residual amounts instead of 'write-off', like in payment vouchers?

Mohammad Alhashash
on 2/16/13, 3:08 PM 6,683 views

In payment voucher, if the amounts do not match exactly, it is possible to fully reconcile invoices and keep the difference open. In manual reconciliation, the only available options are 'Write-Off' and 'Partial Reconcile'.

I want to do full reconciliation and keep the remaining the difference amount open, like in payment voucher but the payments are already posted and can cannot be split. I thought of two options:

  1. Create new reconciliation module similar to account_reconcile. It should create a new entry in a special journal 'Reconciliation Entries' with receivable debit and credit equal to the difference to allow reconciling one line and keep the other line open. A due date, name and comment can be added to the open line.

  2. Select 'Write-Off' and set 'Accounts Receivable' as the write-off account instead of an expense account.

Is there a better method to handle this issue? Are there any consequences or side-effects for the above solutions.



| 5 6 9
Lisse, Netherlands
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
On 2/23/13, 9:00 AM

I do not complete understand. I have the impression:

full reconciliation and keep the remaining the difference amount open

is a contradiction in itself.

I have something similar and I think it does exactly what you want. However I don't want it ... It looks like we need to change positions and we are both happy. In my situation the result was "The Write-Off could be found on the Profit and Loss Report. So far so good. But one problem remained: the write-off amount (In our case 0.01) was still to be found in the Aged Partner Balance report. That's should be zero right?"

I have post this in a comment in the answer on my question: https://accounts.openerp.com/forum/Help-1/question/700

The situation is for v6.1

By full reconciliation I mean mark the invoice as paid. For example, when a customer has an invoice of $10,500.00 pays $10,000.00 you may want to mark the invoice paid but the $500 open to be collected later. Or he may pay $11,000.00, so you keep the extra $500 to be deducted from next invoice. The option is available if you reconcile within a payment voucher, but not in manual reconciliation. Please check this discussion and comment 8 on bug lp:1008774 .

Mohammad Alhashash
on 2/23/13, 9:57 AM

BTW, I'll check your problem and try to help.

Mohammad Alhashash
on 2/23/13, 10:01 AM
Anton Chepurov
On 3/12/14, 8:07 AM

Any solution to this problem so far?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)


Asked: 2/16/13, 3:08 PM
Seen: 6683 times
Last updated: 3/16/15, 8:10 AM