How to Reconcile Your Bank Statement in Odoo (17, 18, 19)
Bank reconciliation is the most asked question on the Odoo forum, so here is one done start to finish. These steps are from Odoo 19, and they work the same way in 17 and 18.
Open the bank reconciliation
Go to Accounting so the dashboard shows. Your bank's card shows how many statement lines still need matching. Click Reconcile.
Look at the list of bank lines
On the left are the transactions from your bank. Each one needs to be matched to something in Odoo: an invoice, a bill, a payment or an account.
Validate the easy ones
When the amount and the customer line up, Odoo suggests the invoice for you. If it's right, click Validate. Done.
One deposit that pays two invoices
Click the deposit, then add both invoices from the list of open items underneath. The amount left to match should reach zero. Then click Validate.
Lines with no invoice, like a bank fee
Some lines have nothing to match. Pick the account the line belongs to, such as Bank Fees, and click Validate.
Let Odoo fill in the lines that repeat
If the same line shows up every month, go to Accounting > Configuration > Reconciliation Models and make a model for it once. From then on Odoo fills it in for you.
Check the balance
When the list is empty, go back to the dashboard. Check that the balance on your bank's card matches the ending balance on your bank statement. If it matches, you're reconciled.
A line that won't match
That usually means something was entered twice, or entered as a journal entry instead of a payment. Look for a second payment on the same customer or vendor before you force the line to match.