Skip to Content
Q&A

Why your bank balance in Odoo differs from your statement, and how to find it

Three figures to compare, a step-by-step search and the change to bank consistency in Odoo 20

Back to all Q&A
November 4, 2026 by
Why your bank balance in Odoo differs from your statement, and how to find it

In short: A difference between Odoo and your bank almost always has a traceable cause. First compare three figures on one date: the balance on the statement, the balance of the bank transactions in Odoo and the general ledger balance of the bank account. Then check the opening balance, missing and duplicate transactions, manual entries and payments posted directly on the bank account. In Odoo 20 entries on the bank account must come from bank transactions.

Bank statement and accounting screen side by side, with a difference between the two balances being traced

The bank says one amount, Odoo says another. It is one of the questions we regularly get at our helpdesk, and the cause is usually simpler than it seems at first. But you do have to know which figure you are looking at, because Odoo shows more than one.

This article is written for Odoo 19 and explains how to find the difference step by step. We use the labels of the English interface. Whether and how you correct something in a closed period is something to discuss with your accountant.

Three figures that are easily confused

Before you search, separate these three:

  • The bank's balance: the ending balance on your statement or in your banking environment, on a specific date.
  • The Balance on the Accounting Dashboard: on the bank journal's card. This is the running balance of the bank transactions in Odoo, plus any payments posted directly on the bank account.
  • The general ledger balance: everything posted on the bank account in the general ledger, including manual entries.

The card can show more. Last Statement appears when the last statement's ending balance differs from the Balance. Payments shows payments on the outstanding account that are not yet linked to the bank. Misc. Operations shows posted items on the bank account that are not linked to a bank transaction or payment, dated after the last statement. That last line is often the first clue.

How Odoo posts bank movements

Each bank transaction gets a journal entry on the main account of the journal, with a suspense account as counterpart until it is reconciled. So an unreconciled transaction is already in the balance. Reconciling replaces the suspense account with the right account, and does not change the bank balance.

Registering a payment works differently. By default it creates no journal entry at all, and the bill or invoice gets the status In payment until it is reconciled. If you use outstanding accounts, the payment is posted there. In neither case does it change the balance on the bank account, unless the main bank account itself is set as the outstanding account. We return to that below.

Step by step: finding the difference

Step 1: choose one date

Take the end date of your last bank statement. Note its ending balance. Do not compare it with today's dashboard figure, because that also includes later transactions. Many differences disappear here. To check the general ledger, filter the report on that same date.

Step 2: check the statements in Odoo

From the Accounting Dashboard you open the statements of the bank journal. A statement has a Starting Balance and an Ending Balance. The running balance is the Starting Balance plus the transactions. Odoo shows a warning if the Starting Balance does not equal the previous Ending Balance, or if the Ending Balance does not equal the running balance.

That warning does not block saving. So a statement with a warning can simply exist. Go through them from old to new. The first statement that no longer matches shows you in which period the difference arose.

Step 3: check the opening balance

Did you start with bank synchronisation or import halfway through a period? Then the amount before that date is missing. According to the documentation you create an opening transaction for the balance on the date you start. Without it, Odoo can stay off by a fixed amount, however well everything else is entered.

Step 4: look for missing and duplicate transactions

Compare the transactions in the period with your statement. Remove the Not Matched filter so you also see those already reconciled. A bank connection can miss transactions, and a file can be imported twice. See setting up a bank connection via PSD2 for how the connection works.

For duplicates, open the Actions menu in the Bank Matching view and click Find Duplicate Transactions. Odoo compares amount, date and account number, or the transaction ID with synchronised transactions. Review the proposal yourself before you delete anything.

Step 5: look for manual entries on the bank account

Click Misc. Operations on the journal card, or filter the general ledger on the bank account and look for lines without a bank transaction. A manual correction or opening entry posted directly on the bank account makes the general ledger differ from the transactions. Note that the Misc. Operations line only counts entries after the last statement, so older entries show up only in the general ledger.

Step 6: check payments posted directly on the bank

If the main bank account is set as an outstanding account, registering a payment posts directly on that account and the bill or invoice immediately becomes Paid. The Balance then includes that payment, even if the bank has not processed it yet. Check this under Accounting, Configuration, Journals, on the Incoming Payments and Outgoing Payments tabs of the bank journal.

Step 7: check the currency

For a bank account in a foreign currency, compare in the currency of that account. A difference in the company currency can be caused by exchange rates, and is a different question from a missing transaction. Discuss that kind of difference with your accountant.

What the amount of the difference tells you

  • Exactly the amount of one transaction: a transaction is missing or duplicated.
  • A fixed amount in every period: this points to the opening balance.
  • The difference grows at some point: check the statement where it starts, and the import of that period.
  • Only the general ledger differs: look for manual entries on the bank account.
  • Only the dashboard differs: look for payments posted directly on the bank, or compare the dates again.

Correcting it, and what not to do

Add a missing transaction as a bank transaction, either through import or manually with New in the journal. Remove a real duplicate. Avoid solving a difference with a loose manual entry on the bank account, because that only hides the cause.

Does the difference fall in a period that is already closed or has a lock date? Then involve your accountant before you change anything. See also the year-end closing checklist.

What changes in Odoo 20

According to the release notes, all journal entries that affect bank accounts must originate from bank transactions in Odoo 20. Statement validation gives clearer feedback, and a new report shows reconciled and unreconciled items at the end of a period. Payment statuses have also been renamed, so In Process becomes Paid and Paid becomes Reconciled.

Do you currently post manually on the bank? Then agree before the upgrade how you will handle that from now on. Read more in Accounting in Odoo 20 and the upgrade checklist.

What this means for you

A short monthly routine prevents a long search at year-end:

  1. Reconcile open transactions and check the Balance on the journal card.
  2. Create a statement with the ending balance from your bank and resolve any warning.
  3. Compare the general ledger with the statement on that same date.
  4. Look at the Misc. Operations line and find out why each entry is there.

Frequently asked questions

Why does the bank balance in Odoo differ from my bank statement?

The most common causes are a missing opening balance, missing or duplicate bank transactions, manual entries on the bank account, payments posted directly on the bank account, and comparing on two different dates. So always compare on one date.

Do unreconciled bank transactions change the balance in Odoo?

No. A bank transaction is already on the main account of the bank journal. As long as it is not reconciled, its counterpart sits on a suspense account. The balance is then correct, but the counterpart account has not yet been determined.

What does Odoo 20 change for the bank balance?

Odoo 20 enforces bank consistency: entries on a bank account must come from bank transactions. You get clearer messages when closing statements, and there is a new report that summarises the bank reconciliation.

Finally

Have you been searching for a difference for a while, or do you want your bank process set up properly? Contact DAADit Group or take the free Business Scan.

in Odoo

Question not answered?

Our Odoo consultants are happy to think along with you. Book a no-obligation intro call.

Book an appointment
From payment reminder to notice of default: building follow-up levels in Odoo
A structure in levels that keeps customer relationships intact, with clear limits on what Odoo should do by itself