Odoo Help


Conciliation of invoices and pays

on 4/9/15, 6:21 AM 1,120 views

Hello, I have Odoo 8.

Follow this situation: a customer pays me $1000. I generate a "Customer payment" in "Accounting -> Customer payments". Then, the same customer, buys me two invoices of $100 each one. I want to set the two invoices paid and that the client has $800 of balance.

What is the best way to do this? Thanks!    



| 6 4 7
Lodz, Poland

On 4/9/15, 2:32 PM

The first way ->

a) menu Accounting/Periodic Processing/Reconcilation/Manual Reconcilation

b) menu Accounting/Payment Follow-up/Reconcile Invoices & Payments  (module account_followup must be installed)

The second way -> Customer view -> Jurnals Items -> check selected -> More -> Reconcile Entries

You select entries with the same account number (one debit and one credit). If Credit != Debit  you click on button Partial reconcile in next step (or Reconcile with Write-Off if expected is to divide the payment for parts). How to select correct Account number? -  this account has ... type = Receivable ... and has checked ... Allow Reconciliation = 1

The third way  -> menu Accounting/Bank and Cash/Bank Statements.

Create new bank Statement, insert new payment and reconcile with selected invoices or other entries

The fourth way -> install and use module account_voucher + The first way or/and The second way

PS. Invoice is Paid if all corresponding account move lines are reconciled, see method test_paid() in account_invoice.py

First way: I don't have menu "Payment follow-up" inside Accounting tab. Need I to install any other module? I have "account_accountant" module. Second way: I do this, but what entries I have to select? I have two entries for each transaction, one in the debit and one in the credit. And then, have I to do a partial conciliation or a reconciliation cancellation? Thanks!

on 4/9/15, 4:38 PM

Another way. Answer updated.

on 4/10/15, 5:42 AM

The reconciliation with bank statements works for cash pays?

on 4/10/15, 7:04 AM

In menu Bank and Cash you have both: Bank Statements and Cash Registers, works similar.

on 4/10/15, 7:15 AM

Queston 2) In the "other way", in the most cases credit != debit. So I do a partial reconcile. But the entries are still there! Only Odoo adds a "Ref of conciliation" which is a code like "A1, A2, etc". How works this? And the invoices are still "Open", not "Paid".

on 4/10/15, 7:25 AM

Ref of conciliation ... see my answer: https://www.odoo.com/forum/help-1/question/please-what-is-the-link-between-vouchers-and-invoices-in-the-tables-75860#answer-75861

on 4/10/15, 9:07 AM

Ok, moves with the same reconcile_id.name are reconciled, but still I can see there in the "Manual reconciliation" with the filter "unreconciled" and the invoice are still "open". I only want to set invoice -> "paid" in the most simple way when the payment is before the invoice...

on 4/10/15, 9:24 AM

Answer updated. I reconcilation is full and ok, invoice sate = Paid.

on 4/10/15, 10:33 AM

I have the module account_voucher. The partial reconciliation, is not a full reconciliation? I know that the invoice is paid if I do a "reconciliation with cancellation" but if I do a partial reconciliation, why not?

on 4/10/15, 2:47 PM

When you select Partial Reconcile invoice is not "Piad", only value "to pay" = 0. Your needs are waiting "Reconcile with Write-Off".

on 4/10/15, 3:13 PM

Ok. I am searching a way to automatically set the invoices paid if the customer has "balance ($)" > "total invoice ($)" and decrease the balance. Is there any way? Thanks you a lot for the patient!

on 4/10/15, 3:58 PM

The third way

on 4/10/15, 4:19 PM

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 platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 4/9/15, 6:21 AM
Seen: 1120 times
Last updated: 4/10/15, 6:19 PM