How to see the book balance and the items pending reconciliation

What is it for?

The balance the bank reports and the balance the accounts hold for the bank account are rarely the same. The Pending reconciliation items map shows the difference and explains it: on the bank side, the statement lines not yet reconciled; on the accounting side, the bank account movements that have no statement line. The Monthly reconciliation position shows the same, month by month, for a year.

When to use it?

• At the end of the month, to have the explanation of the difference between the statement and the bank account.
• After reconciling bank movements, to see what is left to deal with.
• To know how many days each pending item has been open.
• Do not use it as proof that the bank is right: the map only sees the statements that have already been imported (How to import the bank statement).

Where to find it?

• Pending items map: Accounting › Review › Taxes and treasury › Pending reconciliation.
• Monthly position: Accounting › Reconcile › Banks and cash › What is there to do with the banks? and, in Supporting lists, Monthly reconciliation position.

Before you start

• Your profile is Accountant. With it you can do every step in this article, including exporting to PDF (tested with the Accountant profile). To see another company's map, the user must have access to it (company selector, in the top corner).
• The bank statement has been imported.
• The example is the Banco journal of Empresa Demonstração, Lda, on 01/11/2026.

How to use it

1. Open Accounting › Review › Taxes and treasury › Pending reconciliation. The Pending reconciliation items map window opens, with Company, Bank journal and As of (today).
2. In Bank journal, choose Banco and click Generate map.
3. Read the Reconciliation block. In the example: Bank balance -€2,168.41, Book balance €29,764.09 and Difference (bank - book) -€31,932.50. The difference is explained by the Bank side total €367.50 and the Accounting side total €32,300.00: 367.50 - 32,300.00 + Not explained by the lists 0.00 = -31,932.50. The screen says so: “Diferença = total do lado do banco - total do lado da contabilidade + valor não explicado pelas listas” (difference = bank side total - accounting side total + amount not explained by the lists). Further down, in the With payments in transit block, the In transit total (-€36,972.06 in the example) adds up the payments already posted that are not yet in the bank account. Added to the book balance it gives the Accounting balance with payments in transit (-€7,207.97), and the bank minus that balance is the Difference with payments in transit (€5,039.56): 367.50 - 32,300.00 - (-36,972.06) + 0.00 = 5,039.56. Payments in transit are not part of the first difference (see “Important notes”).
4. Open the Bank tab: the statement lines not yet reconciled, with the Date, the Description, the Amount, the Age (days) and the Age bracket. In the example, two: the account maintenance fee (-€12.50, 50 days, “31 to 60 days”) and the transfer received without a reference (€380.00, 37 days).
5. Open the Accounting tab: the bank account movements without a statement line (57 in the example, shown 40 at a time, the first dated 02/01/2025). Open In transit for the payments that are not yet in the bank account, which the product calls “pending payments”: in the example, 32 payroll payments from June to September 2026, posted on 30/10/2026 (-€36,972.06 in total). They stay here until they are reconciled with the statement.
6. To keep it, click Export PDF or Export XLSX. New query goes back to the window of step 1.
7. To see the whole year, open the Monthly reconciliation position, choose the Bank journal (Banco), check the Year (2026) and click Generate position. The table shows, for each month, the Bank balance, the Book balance, the Difference, the Movement of the month, the Statement lines, how many are Reconciled, the % reconciled and the Pending at the end. In the example: 72 statement lines in the year, 70 reconciled, 97.2%; the Difference at the end (-€31,932.50) is the same as in the map.

Expected result

• The map and the monthly position give the same Difference at the end (-€31,932.50) and the sum of the two sides adds up: €367.50 - €32,300.00 = -€31,932.50. With the payments in transit, the calculation is different: €367.50 - €32,300.00 - (-€36,972.06) = €5,039.56, equal to the bank minus the book balance with payments in transit (-€2,168.41 - (-€7,207.97)).
• The PDF repeats the screen (checked on the monthly position: bank_position_BNK1_2026.pdf, with the company header, the year, the issue date and the user).
• This article creates no journal entries: it is a query.

Important notes

• A steady difference of €32,300.00 is not an error in the map. In the demonstration, the accounts have 57 movements posted directly to the bank account, without a statement. In a real company, each one is a movement to be justified with the statement or corrected. Pending validation by a certified accountant: the accounting treatment of the movements on the accounting side that the statement does not confirm.
• Two differences, two calculations. The Difference (bank - book) only compares what is in the bank account: it is the sum of the two sides and does not include payments in transit. The Difference with payments in transit adds to the book balance the payments already posted that the bank has not yet debited. Do not mix the two: the In transit total (-€36,972.06 in the example) is larger than the first difference (-€31,932.50) and is not part of it.
• The map only sees what is in Odoo. A movement the bank made that is not yet in an imported statement does not appear in the bank's pending items.
• The position for a past month shows today's state. As the screen says, “a past month shows what is reconciled today”, and lines ignored or marked as duplicate are not counted.
• Opening balance. The 2026 position opens with €0.00 in the bank and -€78,700.00 in the accounts (Opening difference €78,700.00): the balance before 2026 does not come from statements.

Common problems

A bank journal without a statement

• Symptom: for a journal that exists but has no statements or movements yet (in the example, the new Banco exemplo journal, created as explained in How to create a bank or cash account), the map opens with everything at €0.00, Last statement date empty and the three lists empty.
• What it means: €0.00 does not prove that the bank is right; it only says fiscaldoo has nothing to compare. Import the statement (How to import the bank statement) and generate the map again.

In a new company the list is not empty

• What you see: a new company, with no journal entries or statements (in the example, Empresa Teste Filial), already has the Banco journal. When you open the Bank journal field, the list offers Banco; “No records” does not appear.
• What the map shows: choose Banco and click Generate map: balances and totals at €0.00 and the three lists empty, as for the journal without a statement above. To see another company's map, the user must have access to it (seen with the Administrator, switching company in the selector in the top corner).
• What it means: €0.00 does not prove that the bank is right: it only says there is nothing to compare yet. Import the statement (How to import the bank statement) and generate the map again.

“Some required fields are empty”

• Symptom: when you click Generate map without choosing the journal, “Some required fields are empty. Fill in the fields marked in red to be able to save.” appears.
• Cause: the Bank journal is empty.
• What to do: choose the journal (Banco) and click Generate map again.