Account Reconciliation Reports in Odoo#
Reconciliation verifies that the general ledger matches the detailed sub-ledger records. Unreconciled items - open invoices not matched to payments, bank transactions not linked to journal entries - cause balance sheet inaccuracies. Odoo's reconciliation reports surface them before close.
Types of Reconciliation in Odoo#
1. Customer AR Reconciliation
GL Balance (Accounts Receivable 1200) = Sum of all open customer invoices minus payments
2. Vendor AP Reconciliation
GL Balance (Accounts Payable 2100) = Sum of all open vendor bills minus payments
3. Bank Reconciliation
GL Balance (Bank 1100) = Bank statement closing balance
4. Payroll Payable Reconciliation
GL Balance (Payroll Payable) = Sum of unprocessed payslips
Checking AR Reconciliation#
Accounting → Reporting → Aged Receivable:
- Sum of all entries = total AR balance
Cross-check:
Accounting → Reporting → General Ledger → filter by account 1200:
- Closing balance should equal the aged receivable total
If they differ: some invoice or payment isn't properly linked. Find with:
Accounting → Accounting → Journal Entries → filter by account 1200, unreconciled.
Checking Bank Reconciliation#
Accounting → Bank → [Account] → Reconciliation:
- Odoo shows: GL balance vs. last imported bank statement balance
- Any difference = unreconciled transactions
Unreconciled items typically:
- Transactions in Odoo not yet on the bank statement (timing difference - okay)
- Transactions on the bank statement not in Odoo (error - needs a journal entry)
Running the Reconciliation Report#
Accounting → Reporting → Reconciliation Report (or via the Audit menu):
- Shows accounts where GL ≠ sub-ledger
- Identifies which specific transactions are unreconciled
- Exportable to Excel for detailed investigation
Fixing Unreconciled Items#
Open invoice with no payment: follow up with customer or post a bad debt write-off
Payment with no invoice: look for a missing invoice or mis-applied payment
Bank transaction with no GL entry: create the missing journal entry
GL entry with no bank transaction: timing difference - verify on next statement
After each fix, re-run the reconciliation report - target: all major accounts reconciled before period close.