What we do
Tools
Industries
Department
How we workLet's talk →
Home/Odoo/Odoo Bank Reconciliation When Lines Won't Match
Odoo Accounting

Odoo Bank Reconciliation: Clearing the Matching List, and the Lines That Never Arrive

The bank journal card on your Accounting dashboard says there are lines to reconcile, and most of them are card fees, a few customer payments and one Stripe payout. Odoo matches a lot of this for you: by reference first, then by amount once it knows the partner, and reconciliation models take care of the fees that repeat. What it can't do is reconcile a line it never received, or split a payout into sales it never saw.

Reconciling one bank line in Odoo

Open the list: on the Accounting dashboard, click x to reconcile on the bank journal card. That shows only the lines still open. Odoo's docs call this the bank matching view.

Accounting dashboard Bank journal card x to reconcile

Match it: click Reconcile on the line and pick the invoice, bill or payment it settles. For a bank charge with no document behind it, use Set Account instead.

Line not there at all? It never reached Odoo. Click Fetch Transactions on a synced journal, or load a downloaded statement with Import file from the journal's menu.

Bank journal menu Import file

Working down the Odoo bank matching list

  1. 1

    Let automatic matching go first

    With no partner on a line, Odoo compares its label with the Number, Customer Reference, Bill Reference and Payment Reference of open invoices, bills and payments. With a partner set, it looks for that partner's items by amount, an exact match first, then one with an early-payment discount taken.

    Watch for: a customer who types their own reference on the transfer. Nothing in the label matches, so the line sits there until you give it a partner.

  2. 2

    Set the partner on lines Odoo couldn't place

    Click Set Partner and choose the customer or vendor. Odoo then has amounts to compare against, and the right invoice often appears as a suggestion straight away.

  3. 3

    Reconcile against one document or several

    Reconcile opens a search of customer invoices, vendor bills and payments. Tick more than one when a single transfer paid several invoices. A deposit of several checks recorded as a batch payment goes through Batches instead, and each payment in the batch becomes its own counterpart.

  4. 4

    Write off what has no document

    Bank charges, interest and small differences go through Set Account, which posts the full amount to the account you choose. You can edit the line afterwards if only part of it belongs there.

  5. 5

    Turn a fee that repeats into a reconciliation model

    Accounting dashboard Bank journal dropdown Reconciliation: Models New

    A Manual model shows up as a button on matching lines. An Automated one applies itself to any line that meets its conditions: journal, partner, amount, or a label that contains, doesn't contain or matches a regex.

    Watch for: two automated models that both fit a line. Odoo applies the first one in the sequence, so put the narrow rule above the broad one.

Odoo bank lines that refuse to clear

Your bank isn't covered by bank sync

How you'll know: The journal was made with Add new bank, and nothing appears in it unless someone imports a file.

Fix: Import the statement in a format Odoo reads: CAMT.053, OFX, QIF, CSV or XLSX (CODA for Belgian banks). CSV and XLSX need their columns mapped the first time. If the bank can deliver files by SFTP or through its own API, that step can run without anyone downloading anything.

A processor payout lands as one deposit

How you'll know: One Stripe or marketplace line equals dozens of sales, minus refunds and fees, and no single invoice comes close to its amount.

Fix: You need the payout's breakdown from the processor's side. With it, the deposit can be reconciled against the invoices it actually paid, and the fees posted as their own line.

A file import overlapped days that bank sync already fetched

How you'll know: The same payment appears twice, and one copy will never find anything to match.

Fix: Delete the extra line with Delete Transaction from its ellipsis menu, and import only the dates the sync doesn't cover.

Bank synchronization or a statement file in Odoo

Bank sync

Odoo fetches the lines

  • Needs an Odoo Enterprise subscription. Odoo connects to over 26,000 institutions through providers such as Plaid in the US and Canada.
  • Connect from New on the Accounting dashboard, or Connect bank in the bank journal's menu.
  • Syncs every twelve hours, with Fetch Transactions for an on-demand pull. Some banks only give three months of history.
File import

Someone brings the statement in

  • Works for any bank that exports CAMT.053, OFX, QIF, CSV or XLSX.
  • Each import is only as current as the last download.
  • CSV and XLSX layouts differ by bank, so the column mapping has to be right before Test and Import.

If bank sync lists your bank, use it. If it doesn't, the matching tools are just as good, and the only real problem is getting the file in on time.

Odoo bank reconciliation questions

Does Odoo have bank reconciliation built in?

Yes. Odoo Accounting matches bank lines against invoices, bills and payments in its bank matching view, and reconciliation models handle recurring lines such as bank fees, either as a button you click or automatically.

Does Odoo support automatic bank feeds?

Yes, through bank synchronization on Odoo Enterprise, which pulls transactions every twelve hours from banks its providers cover. Coverage depends on your bank and country. Where it isn't available, statements come in as imported files.

What is the difference between automatic and manual reconciliation in Odoo?

Automatic reconciliation is Odoo matching a line on its own, from the reference in the label or the partner and amount, or through an automated reconciliation model. Manual reconciliation is everything left over: a partial payment, an odd fee or a line with no obvious counterpart, which a person clears with Reconcile or Set Account.

Can Odoo reconcile multiple bank accounts or companies?

Yes. Each bank account is its own journal with its own card on the dashboard, and a multi-company database reconciles each company's journals separately. That suits a business running several entities or accounts through one Odoo setup.

Who builds the statement feed when Odoo's bank sync doesn't cover our bank?

Where the bank delivers statement files by SFTP or an API, n-frames builds the job that collects them and loads the lines into the right bank journal through Odoo's external API. For Stripe and other processors, n-frames builds the pull of each payout's detail, so the deposit reconciles against real invoices.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.