How to Manage Bank Transactions in Odoo Accounting

Table of Contents

• Why Bank Transaction Reconciliation Matters
• Importing Bank Transactions from a File
• Creating Bank Transactions Manually
• Setting Up Automatic Bank Synchronization
• Which Method Should You Choose?
• Next Steps
• References

Why Bank Transaction Reconciliation Matters

One of the fundamentals of sound accounting is reconciling payments with bank transactions. This ensures your bank records match your accounting entries, keeping your books accurate and audit-ready.

In Odoo Accounting, there are three ways to get bank transactions into your system: manual entry, file import, and automatic bank synchronization.

Importing Bank Transactions from a File

The quickest way to get started is importing a bank statement file directly.

1. Go to the Accounting Dashboard
2. Under the Bank journal, click Import File

3. Select your bank statement file (CSV, OFX, QIF, or CAMT formats)
4. Odoo automatically maps the column names from your file to the corresponding fields in the bank statement model

5. Adjust the mapping if needed, then click Test
6. If everything looks valid, click Import

To review your imported statement, click the three-dot menu (kebab menu) on the bank journal and select Statements.

Creating Bank Transactions Manually

For one-off entries, you can create individual bank transactions.

1. From the Accounting Dashboard, under the Bank journal, click New Transaction

2. Fill in the details:
   • Date — when the transaction occurred
   • Label — a description (e.g., "Invoice 5 payment")
   • Partner — optional, select the related contact
   • Amount — positive for incoming, negative for outgoing

3. Click Save and Close

This method works well for occasional adjustments but is not practical for high transaction volumes.

Setting Up Automatic Bank Synchronization

For hands-free transaction management, connect your bank account directly to Odoo.

How to Connect

1. From the Accounting Dashboard, click Connect Bank

2. Choose your region — locally or worldwide

3. Search for your bank institution
4. Select your bank and follow the authentication steps

5. Confirm the configuration and proceed

Once connected, Odoo automatically pulls your bank transactions into the system on a regular schedule. No more manual uploads or data entry.

Sandbox vs. Production

When testing, you can select the Sandbox option. For your live production database, always use the non-sandbox connection to ensure real transaction data flows correctly.

Which Method Should You Choose?

Method	Best For	Effort
File Import	Initial migration, periodic bulk uploads	Medium
Manual Entry	One-off corrections, occasional transactions	High
Bank Sync	Daily operations, ongoing reconciliation	Low

For most businesses, bank synchronization is the recommended approach. It eliminates manual work and ensures your records stay current automatically.

Next Steps

• Set up bank synchronization for all your active bank accounts
• Configure reconciliation models to auto-match common transactions
• Review the Odoo Bank Synchronization documentation for provider-specific setup guides

---

References

• Bank transactions & bank synchronization | Odoo Accounting — Odoo