How to match bank payments to invoices, without a spreadsheet

Money comes into your bank account every week. Some of it is from customers, some is a refund, some is interest. To know who still owes you, you have to pair each payment with the invoice it pays. Accountants call this reconciliation. Most businesses do it in a spreadsheet, late at night, once a month. It does not have to be that slow, whether your bank is in London, Dubai, Austin or Pune.

Why matching matters

If you do not match payments, two things go wrong. First, you chase the wrong people. Nothing spoils a good customer faster than a reminder for a bill they paid last week. Second, your books are wrong. Your list of unpaid invoices is too long, your cash looks tighter than it is, and at tax time you have to untangle months of payments at once.

Matched payments give you a short, true list of who owes you. That list is what makes getting paid faster possible.

The manual way, and why it is slow

Done by hand, it usually looks like this:

1. Download the bank statement.
2. Delete the payments going out, like rent and salaries.
3. For each payment in, read the description and guess who sent it.
4. Search your invoices for that customer and an amount that fits.
5. Mark the invoice paid, or note the part that is still due.

With ten payments a month this is fine. With fifty it takes an evening. The slow part is step 3. Bank descriptions are short and messy, like “WIRE IN BREW STREET CAFE LLC” or “NEFT/MEHTA PHARMA LTD/SEP BILLS”, and the payer name often is not the name on your invoice.

What makes a payment easy to match

You can make most payments match themselves, before they even arrive:

• The invoice number in the payment reference. Almost every way to pay by bank has a short note field: the reference on a UK Faster Payment, the remittance line on a SEPA transfer in Europe, the memo on an ACH payment or wire in the US, the note on a UPI or NEFT payment in India. If it says HP/26-27/0012, there is nothing to guess. Ask for it on the invoice, in plain words.
• The exact amount. When the customer pays exactly what the invoice says, the amount alone often points to one invoice. A pay link or QR code for the amount still due keeps round-offs and typos out.
• One invoice per payment, where you can. Ask regular customers to mention all the invoice numbers when they pay several at once.

The tricky cases

Part payments

A customer pays $2,000 of a $4,720 invoice. Record it against that invoice, and $2,720 stays due. Do not mark it paid, and do not leave it unmatched either, or you will chase the full amount again.

One payment for several invoices

Bigger customers often pay a month of bills in one transfer. Look for open invoices from that customer that add up to the amount received. If nothing adds up exactly, apply it to the oldest first and ask what the rest is for.

Bank fees on international transfers

A client abroad sends AED 10,000, and AED 9,925 arrives. The missing part went to the banks that passed the money along. Record what arrived as a part payment, so the invoice shows the small amount still due. Then decide. If you agreed that the client pays all fees, ask for the rest. If you agreed to carry the fees yourself, or it is not worth chasing, close the gap with a credit note so the invoice does not sit as unpaid forever. Our guide on billing clients abroad covers how to agree who pays the fees before you send the invoice.

In India: short payments from TDS

Many business customers in India deduct TDS (tax deducted at source) before paying you. On a ₹1,18,000 invoice, that is ₹1,00,000 plus 18% GST, a customer deducting 2% on the ₹1,00,000 pays ₹1,16,000. The ₹2,000 is not lost. It is tax paid in your name, which you claim back later. So record it as TDS, not as money still owed. The rate depends on the kind of work and the rules, which change, so check with your CA. Our guide on why your client paid less explains it step by step.

A payer with a different name

The invoice says Brew Street Cafe, the bank says R K HOLDINGS, the owner's other company. The first time, you have to ask or remember. After that, note that this payer belongs to this customer, so next time it is obvious.

Money that is not a sale

Bank interest, a refund from a supplier, money you moved from your own savings account. Set these aside so they do not sit in your list forever.

How it works in Openn Invoice

This is the whole job, in the order you see it on the Match payments page:

1. Download your statement from your bank's website or app as Excel, CSV or PDF, and upload it under Upload your bank statement. The statement is read in its own currency, taken from the file itself. Only money coming in is added. For a PDF, you see what was read before anything is added. Scanned PDFs cannot be read.
2. Each payment shows up under To check with its best guess: Very likely or Maybe, and the reasons, like “Description mentions HP/26-27/0012” or “Exact balance due”. It looks at the invoice number in the description, the exact amount, the payer name and payers seen before.
3. Click Yes, match to accept a guess, Pick another invoice to choose it yourself, or Not a sale to set it aside. When you pick an invoice yourself, it tells you whether the payment clears it or leaves some still due.
4. When there are several sure ones, Match 3 likely payments (or however many there are) does them in one go.
5. Everything you match appears under Recently matched, with Undo next to it if you got one wrong.

Uploading the same dates twice is safe: payments already added are skipped. So a good habit is to upload a fresh statement once a week, clear the list in a few minutes, and send reminders only to the invoices that are still open. For the wording of those, see our payment reminder messages.

The short version

• Matching payments to invoices keeps your list of who owes you short and true.
• Ask for the invoice number in the payment reference, and make paying the exact amount easy.
• Record part payments, and split one payment across several invoices.
• Bank fees on a transfer from abroad: record a part payment, then chase the rest or close it with a credit note. In India, record TDS as TDS.
• Upload your statement, in any currency, once a week and confirm the matches. It takes minutes, not an evening.