Odoo Accounting reconciliation

accounting reconciliation invoices payments

1 Odpowiedz

2274 Widoki

Dovud Qodirov

Hello!

I have a problem with invoices and payments.

I imported invoices and payments (including fully paid and partially paid ones) into the customer records. But I can’t connect the payments to the invoices. I also tried to reconcile them, but it didn’t work.

I tried to auto-reconcile them but odoo either says there is nothing to reconcile despite i haven't reconciled them or odoo says that there are records that are already reconciled, I tried to filter by "reconciled is not set" but it neither helped me.

Can you please advise how to fix this or teach how can I import invoices and payments into my odoo database from my previous system?

Cybrosys Techno Solutions Pvt.Ltd

Hi,

If invoices and payments weren’t imported with consistent journal, partner, and account references, Odoo won’t match them.

Sometimes imported payments are already flagged as “reconciled” if you used journal entries instead of payment records.

If the outstanding payment lines and invoice lines don’t share the same account (e.g., Accounts Receivable), Odoo won’t reconcile them.

Your issue comes from importing invoices and payments separately without creating the reconciliation link between them, so Odoo doesn’t know which payments belong to which invoices. To fix this, invoices should be imported first (account.move), then payments (account.payment), and finally reconciled either through Odoo’s reconciliation widget or by importing records into account.partial.reconcile.

If you don’t need full history, the easier method is to import invoices with open balances only and skip old payments. But if historical accuracy matters, you must include the reconciliation step in your import to properly link invoices and payments.

Reference

* https://www.odoo.com/sl_SI/forum/pomoc-1/accountingv17-how-do-we-import-reconciled-journal-items-with-matching-number-251248

Hope it helps

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Reconciling POS credit card transactions with bank statement accounting pos reconciliation payments	2 maj 20	10842
Manual bank transactions affected by bank feed refresh v19 accounting reconciliation	2 cze 26	1208
How can I deal with an erroneously imported bank statement in accounting? accounting reconciliation	3 gru 25	2296
How to make a partially payment on multiple Invoices for a single customer accounting invoice reconciliation payment payments	1 sty 25	8602
Possible to use Reconciliation Models for other accounts? accounting reconciliation	0 paź 24	3500

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!