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