How do I fix reconciliation problems in Odoo accounting?

Steps

1. Identify account: bank suspense, receivable, or payable with growing unreconciled balance.
2. Use Reconcile menu or bank reconciliation model to load unmatched lines.
3. Match payment move lines to open invoice residual amounts using reconcile widget.
4. For bank feeds, map partner and account on recurring reconciliation models.
5. Correct invoices posted to wrong account or without proper payment term linkage.
6. Write off immaterial differences to dedicated write-off accounts with approval.
7. Lock dates after reconciliation period close to prevent backdated edits.

Common mistakes

• Reconciling lines in different currencies without exchange difference entries.
• Creating manual payment entries without linking invoice reconcile models.
• Leaving bank statement lines in suspense instead of mapping rules.
• Editing reconciled moves instead of unreconcile and repost.
• Mixing company_id on moves in multi-company databases.

Odoo version notes

Bank reconciliation UI improved across Odoo 16–18 Enterprise accounting; Community includes core reconcile on move lines. Online sync features vary by edition and localization. Multi-currency revaluation runs on separate wizard—do not confuse with invoice matching. After upgrade, retest reconciliation models imported from older chart templates.

When to bring in help

If the fix touches custom modules, regulated traceability, or production outages, a focused rescue sprint beats months of trial and error. See our Odoo service.