How to reconcile bank movements
What is it for?
Reconciling means telling Odoo what each bank movement corresponds to: the receipt of a customer invoice, the payment of a supplier invoice, or an expense that only appears on the statement (a fee, stamp duty). Until a movement is reconciled, the money is in the bank account, but the invoice stays open or the expense has not been booked yet.
When to use it?
- Right after you import a statement (How to import the bank statement).
- Before you close the month: the What is there to do with the banks? panel shows how many Bank movements to reconcile are left.
- To book the fees, interest and taxes the bank charges directly to the account: adjustments to the bank account are booked here, not with a manual entry (How to make a manual journal entry).
Where to find it?
Accounting › Reconcile › Bank reconciliation (in the Banks and cash group).
Before you start
- Your profile is Accountant. With it you can do every step in this article (tested with the Accountant profile).
- The movements are already in Odoo: you have imported the statement.
- The invoices the movements correspond to are entered and confirmed. A receipt for an invoice that does not exist yet stays unreconciled.
- The example continues the one in How to import the bank statement: at Empresa Demonstração, Lda, on 29/10/2026, 6 movements to handle, among them the receipt of 1.107,00 € from Construções Marão (
FT D26/31), the -12,50 € fee of 20/10/2026, the -123,00 € transfer to Papelaria Central and the -0,50 € stamp duty.
How to use it
- Open Accounting › Reconcile › Bank reconciliation. On the left are the movements to handle, with the count and the totals Incoming and Outgoing. Above are the filters To reconcile, Reconciled and All, the journal (All journals, Bank, Recibos (RG)), the dates From and Up to and the sort order. Click a movement: on the right you see the Date, the Amount, the Journal, the Partner and the State To reconcile.
- A receipt from a customer. Choose
TRF CONSTRUCOES MARAO LDA FT D26/31(1.107,00 €) and click Suggest matches. Suggestions for “…” opens, with the Partner identified (Construções Marão, Lda) and the suggestions in order of Confidence. In the example there are two, with the same amount:FT D26/31with High (“exact amount within 30 days, document number in the description, partner name in the description”) andFT D26/32with Medium (only the amount and the name). Check the number in the bank description and click Accept on the right line (FT D26/31). The screen says “This bank line is already reconciled.” and the invoice becomes paid. - A payment to a supplier, chosen by hand. Go back to Bank reconciliation and choose
TRF SEPA PAPELARIA CENTRAL LDA FT A2026/318(-123,00 €). Below the buttons are the tabs Receipts, Payments, Accounting and Manual operations, each with the open documents you can choose. Under Payments there are two invoices of 123,00 €:FTF/2026/00046from Papelaria Central, Lda (Probable match, Exact amount) andFTF/2026/00048from another supplier (only Exact amount). Tick the box ofFTF/2026/00046and click Confirm reconciliation. When Odoo has a suggested match, it also shows it at the top, in a Suggested match box with the Reconcile button, which does the same. - A bank fee. Choose
COMISSAO MANUTENCAO CONTA(-12,50 €) and click Direct entry. In the Direct entry from the bank line window, under Reconciliation model, choose Bank Fees: the Account changes to6888 Outros não especificadosand the Entry label to “Taxas bancárias”. Leave VAT empty. Click Book and reconcile. - An expense without a model. For stamp duty (
IMPOSTO DO SELO S/ COMISSAO, -0,50 €), click Direct entry, leave Reconciliation model empty and choose the Account (in the example,6812 Impostos indiretos); click Book and reconcile. - Check the count: in the example, it goes from 6 to 2 movements to handle (the transfer received without reference, 380,00 €, and the September fee, -12,50 €).
Expected result
- Each reconciled movement leaves To reconcile and appears under Reconciled.
- Each reconciliation creates a journal entry in the miscellaneous operations journal, which takes the amount out of the transit account
120001 Conta Transitória(where the import put it) and moves it to the customer, the supplier or the expense. In the example, checked in the ledger:
| Movement | Journal entry | Debit | Credit |
|---|---|---|---|
Receipt FT D26/31, 1.107,00 € | OD/2026/… | 120001 Conta Transitória 1.107,00 | 2111 Clientes gerais (Construções Marão) 1.107,00 |
Payment FTF/2026/00046, 123,00 € | OD/2026/… | 2211 Fornecedores gerais (Papelaria Central) 123,00 | 120001 Conta Transitória 123,00 |
| Fee, 12,50 € | OD/2026/… | 6888 Outros não especificados 12,50 | 120001 Conta Transitória 12,50 |
| Stamp duty, 0,50 € | OD/2026/… | 6812 Impostos indiretos 0,50 | 120001 Conta Transitória 0,50 |
FT D26/31andFTF/2026/00046become paid. Account120001is back to zero for these movements.
6888 Outros não especificados; some use 6268 Outros serviços or 6988 Outros gastos de financiamento) and the treatment of fees for VAT (exempt, VAT Code (CIVA), art. 9, no. 27) and for stamp duty.
Important notes
- The buttons this article did not use. Reconcile in one click accepts the suggested match in one go; only use it after you read the suggestion. Without a safe match, it refuses with “No open item is a plausible match for this line …” and reconciles nothing: then choose the document in one of the tabs. Register payment and reconcile creates the payment of an invoice and reconciles it with the movement. The Manual operations tab and Narrow down by date help you look for documents the suggestion did not find.
- Two invoices with the same amount. The suggestion compares the amount, the date (a 30-day window) and the bank text. With two documents of the same amount, choose by the number or the name in the description, never by the amount alone.
- VAT in a direct entry. The VAT list starts with withholding taxes (IRS 23 %, 16,5 %…). A bank fee carries neither VAT nor withholding: leave the field empty, unless your certified accountant says otherwise.
- If you reconciled wrongly, undo the reconciliation. In the first filter choose Reconciled, click the movement and click Undo reconciliation (the Reconciled documents button next to it first shows what the reconciliation linked). The Undo the reconciliation window shows the movement and the documents and asks for the Reason. Click Undo reconciliation again: the movement goes back to To reconcile and counts again in movements to handle. Nothing is deleted: the reconciliation entry stays and is reversed by another one, dated today, with the reference “Undo reconciliation: …”. Done with the Accountant profile; the Certified accountant profile also has the button. A payment registered from the movement stays, still to be reconciled with the bank, and the invoice remains paid. In the example,
TRF SEPA Papelaria Central, Lda - FT PAP/2026/118(-492,00 €): entryOD/2026/00008(120003 Pagamentos Pendentesdebit and120001 Conta Transitóriacredit, 492,00 €) was reversed by a new entry,OD/2026/…(the same accounts, the other way round); paymentPBNK1/2026/00001stayed and invoiceFTF/2026/00037remained paid. Then reconcile the movement again with the right document. - What this list does not see. Only movements that have already been imported appear. A movement the bank made that is not yet in an imported statement does not count towards movements to handle.
Common problems
“No open item matches this line”
- Symptom: in Suggest matches, Number of suggestions 0 and “No open item matches this line: check the amount, the date window in the banking configuration, or the description.” (in the example,
TRF RECEBIDA - REF DESCONHECIDA, 380,00 €). - Cause: the bank does not say whose money it is and there is no open invoice with that amount within the 30 days.
- What to do: look for the customer by amount in the Receipts tab or in Manual operations. If the invoice has not been issued yet, leave the movement unreconciled until it is. Do not book it to an expense or income account just to get it off the list.
The Confirm reconciliation button does nothing
- Cause: no document is ticked in the tab's list.
- What to do: tick the box on the left of the document and click again.
The movement and the documents differ
- Symptom: when you click Confirm reconciliation, “The movement and the documents differ by …, outside the tolerance: choose partial reconciliation (the rest stays open) or write-off (with account and reason), or select other documents.”
- Cause: the amount of the ticked document is not the amount of the movement.
- What to do: tick the right document. If the bank really paid a different amount, follow one of the options in the message.
The Undo the reconciliation window does not accept the reason
- Symptom: without a reason, “Some required fields are empty. Fill in the fields marked in red to be able to save.”; with fewer than 5 characters, “Write why the reconciliation is undone (at least 5 characters).”.
- What to do: type the reason, with at least 5 characters. It is saved with the operation.