Business Performance Consulting Sdn Bhd User Guides
10

Bank Statements

Odoo 19 Enterprise · Accounting

Bank statements bring your actual bank transactions into Odoo so they can be matched against recorded payments and invoices — a process called reconciliation.

Process lifecycle

New editable Processing ready Validated reconciled
1

Add a bank account

Accounting Configuration Add a Bank Account

Before importing statements you need a bank account configured in Odoo. Go to Configuration → Add a Bank Account. A list of Malaysian banks appears. Select your bank and click Connect. If your bank is not listed, click Create it and enter the account number, bank name, and BIC manually.

2

Import a bank statement

Accounting Dashboard Bank (three dots) Import Statement

From the Accounting Dashboard, click the three dots (⋮) next to your Bank widget and select Import Statement. Upload your bank statement file. Odoo will parse the file and create statement lines ready for reconciliation.

Supported import formats
CAMT.053 SEPA recommended Cash Management format. Preferred for EU banks.
CSV Comma-separated values. Most Malaysian banks can export this format.
OFX Open Financial Exchange format. Used by some international banks.
QIF Quicken Interchange Format. Legacy format, still supported.
3

Online bank synchronisation

Accounting Dashboard Bank ONLINE SYNCHRONISATION

Odoo Enterprise supports direct connection to supported banks via a third-party provider. Click Online Synchronisation on the Bank widget to set up the connection. Once configured, Odoo will automatically pull new transactions on a schedule. Check Accounting → Configuration → Online Synchronisation for available Malaysian banks.

Manual vs automatic If your bank is not supported for online sync, export a statement from your online banking portal and import it manually. Most Malaysian banks support CSV export.
4

Create a bank statement manually

Accounting Dashboard Bank Create or Import Statements

You can also create a bank statement manually by entering transactions directly. Enter the Reference, Journal, Date, Starting Balance, and Ending Balance. Then add individual transaction lines with their date, label, partner, and amount. This is useful for small volumes or when file import is not available.