Skip to content
العربيةLet’s talk

Practical guide

How to match one bank transfer to several customer invoices in Odoo

Follow one customer transfer through Odoo Bank Matching. Check the invoice allocation, any existing payment and the balance left by a short payment.

Lava Solutions · · 3 minute read

A calculator and green pencil beside an open squared notebook on a desk.
Illustrative stock photo. Photo: Cht Gsml / Unsplash.

A customer pays two invoices in one transfer. The bank gives you one line, sales gives you two invoice references, and a colleague may already have registered a payment. Ask your Odoo implementation team to show where each amount ends up. The test is complete when another accountant can reconstruct the allocation from the bank transaction and explain any balance still owed.

Prepare the deposit and the evidence for its allocation

Use a test company, one bank journal, one customer and one currency. Choose two posted customer invoices with known open balances. Record the bank date, currency, amount and reference alongside the remittance advice that identifies the invoices. If the customer has another invoice for exactly the same amount, the remittance reference will help you distinguish the two.

Open the customer’s invoices and inspect any payments already recorded. For the first run, use invoices with no registered payments. If you later repeat the test with payments already posted to an outstanding receipts account, trace those payment entries to the invoices and use the eligible payment items when matching the bank line. Recording the same receipt again would make the test harder to reconcile.

Prove the exact match before trying the exception

Fictional example. A customer owes 650 JOD on invoice A and 350 JOD on invoice B. Its remittance advice assigns those amounts to A and B. The bank statement shows one incoming transfer of 1,000 JOD.

  1. In Odoo 20, open the bank journal’s Bank Matching view. Find the incoming 1,000 by date, reference and amount. Inspect any suggested match before accepting it.
  2. If the transaction still needs matching, use Reconcile to select the existing items. Check the customer, invoice references, currency and balances on both lines. Two unrelated items can also add up to 1,000.
  3. Review the result from both sides. The one bank line should account for the full 1,000 and both invoice balances should be zero. Keep the bank reference and both invoice numbers together on your test sheet.

Leave an unexplained difference visible

Start a separate run from the original open invoices. This time the bank shows 980 JOD. In the example, the customer confirms that 650 is for invoice A and 330 is for B. Ask the reviewer to demonstrate that allocation and leave the unpaid 20 on B as an open balance. The bank line can be fully accounted for while invoice B still has money due. Odoo’s bank reconciliation guide describes a partial match when the bank amount falls short of the invoice.

Now remove the customer’s allocation from the scenario. The 20 difference alone does not establish a bank fee, discount or underpayment on B. Record what is known, obtain the bank advice or customer clarification, and have the person responsible for the account decide how to treat it. A proposed journal entry needs its own supporting evidence and approval.

Agree what finance needs for sign-off

Keep separate columns for the bank amount, each matched item, each invoice balance afterwards, any unresolved difference and the next owner. Ask a second reviewer to start from the bank line and find the same records without the presenter’s help. For wider finance setup, use the Odoo accounting setup checklist. To plan a reconciliation demonstration, share a fictional or anonymised settlement example with Lava.

Sources & further reading

A useful next step

Bring one real workflow.

Share the process you want to improve, the systems involved and the decision you need to make.

Talk to Lava ↗