Odoo Accounting reconciliation

accounting reconciliation invoices payments

1 Besvara

2312 Vyer

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

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
Reconciling POS credit card transactions with bank statement accounting pos reconciliation payments	2 maj 20	10863
Manual bank transactions affected by bank feed refresh v19 accounting reconciliation	2 juni 26	1268
How can I deal with an erroneously imported bank statement in accounting? accounting reconciliation	3 dec. 25	2365
How to make a partially payment on multiple Invoices for a single customer accounting invoice reconciliation payment payments	1 jan. 25	8659
Possible to use Reconciliation Models for other accounts? accounting reconciliation	0 okt. 24	3551

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!