How to Perform Bank Reconciliation in Odoo Accounting

Master Bank Reconciliation in Odoo Accounting. Learn automated bank sync, OFX/QBO/CSV imports, reconciliation models, write-offs, bank fee rules, and foreign currency exchange adjustments.

How to Perform Bank Reconciliation in Odoo Accounting
Odoo Bank Reconciliation Tool

1. Understanding Bank Reconciliation in Odoo

Bank reconciliation is the process of matching external bank statement transactions against internal accounting records (customer invoices, vendor bills, and manual payments). Accurate reconciliation guarantees that your balance sheet reflects true liquid cash.

Odoo simplifies this by using an interactive split-view Reconciliation Widget. Left-hand lines represent bank statement feeds, while right-hand cards show matching invoices, bills, or payment transactions suggested by Odoo’s matching engine.

Step 1: Connecting Bank Feeds or File Import

Odoo provides two methods to feed statement lines into your accounting database:

Method A: Automated Online Bank Synchronization

1

Add Bank Account

Go to Accounting Dashboard > Configuration > Add a Bank Account.

2

Authenticate Bank Institution

Search for your financial institution (supported via Plaid, SaltEdge, or Yodlee). Authenticate securely. Odoo fetches transaction feeds automatically every 24 hours.

Method B: Manual Statement Import (OFX, QBO, CAMT, CSV)

1

Download File from Online Banking

Export your bank statement file in OFX, QBO, CAMT.053, or CSV format.

2

Import File into Odoo

Go to Accounting Dashboard > Bank Journal > Import Statements. Upload the file. Odoo parses statement date, description, reference, and amount automatically.

Step 2: Mastering the Odoo Reconciliation Tool

On your Accounting Dashboard, click Reconcile X Items on the Bank Journal card. The reconciliation workspace opens:

Step 3: Setting Up Automated Reconciliation Models

Automate recurring transactions (rent, merchant processing fees, utility bills, bank charges) so you never classify them manually again.

Go to Accounting > Configuration > Reconciliation Models. Click New:

Model Name: Merchant Gateway Fee (Stripe/PayPal)
Type: Rule to suggest counter-part entry
Label Condition: Contains "Stripe Fee" OR "Merchant Charge"
Action:
• Account: 650100 Merchant Processing Fee Expense
• Amount Type: Percentage of Balance (100%)
• Tax: 0%

Step 4: Handling Complex Bank Scenarios & Fees

Scenario: Wire Transfer Fee Deduction

A client owes $1,000 for Invoice #1042. They wire payment, but the intermediary bank deducts a $25 wire fee, resulting in an incoming bank statement line of $975.

1

Select Statement Line ($975)

In the reconciliation tool, select the incoming $975 line.

2

Select Original Invoice #1042 ($1,000)

Click Invoice #1042 on the right. Odoo alerts: -$25.00 Balance Difference.

3

Click “Manual Operations” / Apply Fee Rule

Click Manual Operations, choose Account 650000 Bank Wire Fees, and enter 25.00. The balance difference becomes $0.00. Click Validate.

Step 5: Multi-Currency & Foreign Exchange Adjustments

If your bank operates in USD but you bill an international client in Euros (EUR):

Step 6: Bank Reconciliation Audit & Monthly Closing

To verify bank reconciliation completion at month-end:

  1. Go to Accounting > Reporting > Bank Reconciliation Report
  2. Verify Computed Balance in Odoo equals Last Statement Balance
  3. Check for any un-reconciled outstanding checks or uncleared deposits
🔧

zSmartFix Editorial Team

Step-by-step technical guides tested on real hardware. Our guides are independently written and freely accessible to everyone.

Leave a Reply

Your email address will not be published. Required fields are marked *