Bank Reconciliation in Odoo Accounting: A Step-by-Step Guide

Table of Contents

• Why Bank Reconciliation Matters
• Accessing the Reconciliation View
• Creating Transactions and Statements
• Reconciling Transactions
• Key Takeaways
• References

Why Bank Reconciliation Matters

Bank reconciliation is the process of matching bank transactions with accounting entries. While not strictly a legal requirement on its own, it is essential for maintaining accurate financial records — which is a legal requirement.

Regular reconciliation also helps you:

• Keep track of payment follow-ups
• Maintain up-to-date accounting records
• Catch discrepancies before they become problems

Accessing the Reconciliation View

To start reconciling in Odoo:

1. Open the Accounting app
2. Click the Reconcile button on your bank journal

The reconciliation view is split into two main areas:

• Left panel — Your bank transactions. Black numbers are incoming payments; red numbers are outgoing payments.
• Bottom panel — Open items and payments available for matching.
• Top panel — The matching window showing selected transactions and their suggested matches.

By default, Odoo filters to show only unmatched transactions. Remove the "Not Matched" filter to see previously reconciled entries, indicated by a green check mark.

Creating Transactions and Statements

Adding a New Transaction

Click the New button in the reconciliation view, fill in the transaction details, and save.

Grouping Transactions into Statements

To create a bank statement:

1. Hover over the last transaction you want to include
2. Click the Statement button that appears
3. Odoo groups every transaction since the previous statement
4. Confirm the starting and ending balance
5. Optionally set a reference and attach a PDF of the bank statement

Access any statement later by clicking its ending balance on the reconciliation view. From there you can edit, print, or delete it.

Reconciling Transactions

Odoo highlights suggested matches in blue based on the partner, reference, or amount. Here are the most common scenarios:

Matching with Early Payment Discounts

When a payment amount does not exactly match the invoice amount due to an early payment discount, Odoo detects the difference and suggests posting it to the appropriate discount account. Click Validate to confirm.

You can also click the invoice link to review the original document before validating.

Batch Payments

When a single bank transaction covers multiple invoices, navigate to the Batch Payments tab, select the correct batch, and validate.

Bank Fees and Manual Operations

For transactions like bank fees without a matching open item:

1. Select the transaction
2. Go to the Manual Operations tab
3. Choose the correct account (e.g., bank fees expense account)
4. Validate to create a new journal entry and reconcile

Searching for Specific Entries

Each transaction may have a default partner filter applied. You can modify this filter and search by:

• Partner name
• Journal entry reference
• Amount

This is useful when you need to match a payment against a specific bill rather than the suggested entry.

Handling Unknown Transactions

For transactions without a reference or clear match:

1. Select the transaction
2. Click To Check
3. Investigate later

Find all "to check" transactions from your bank journal dashboard under the To Check link.

Key Takeaways

• Reconcile regularly to keep your books accurate and up to date
• Use Odoo's automatic matching suggestions to speed up the process
• Leverage batch payments, manual operations, and the "to check" feature for edge cases
• Set up Reconciliation Models to automate recurring entries like bank fees

For more advanced workflows, explore Odoo's bank synchronization and reconciliation models features.

---

References

• Bank Reconciliation | Odoo Accounting — Odoo