Payment Reconciliation, Demystified

Peneu Editorial Team · 7 July 2026 · Updated 26 September 2026 · 7 min read

Cover illustration explaining payment reconciliation

Every business that takes payments has three records of the same money: its own orders or invoices, the payment provider's transactions and settlements, and the bank statement. Reconciliation is checking that they agree, and explaining exactly where they don't. It's unglamorous, and it's where money quietly goes missing when it isn't done.

The three-way match

Reconciliation is really two matches chained together.

A mismatch at either step needs a reason. Most have ordinary explanations; the ones that don't are why you reconcile.

What is matched to what
Match	Question it answers
Orders to provider transactions	Was every order we marked paid actually paid, and is every payment tied to an order?
Provider settlements to bank credits	Did the money the provider says it sent actually arrive?

Why totals mislead

Matching daily totals feels efficient and hides problems. A missing ₹1,200 payment and an unexplained extra ₹1,200 elsewhere cancel out in a total and remain two real problems. Match transaction by transaction, on references, and totals take care of themselves.

Common mismatches, and what they usually mean

Most differences fall into a handful of patterns.

Common reconciliation mismatches
What you see	Usual cause
Settlement lower than sales	Provider charges and taxes deducted before settlement
Order paid, no settlement yet	Still within the settlement cycle, or a holiday in between
Payment with no order	A customer paid twice, or paid outside the normal flow
Negative line in a settlement	A refund or chargeback taken from the payout
Order marked paid, payment failed	The order was updated from the browser, not the provider's notice
Bank credit with no settlement report	A settlement from another provider or account

References are everything

Reconciliation becomes automatic when every payment carries a reference you created: your order or invoice number, passed to the provider and returned in its reports. For bank transfers, a unique account number per customer (a virtual account) does the same job. Without references, matching becomes guesswork by name and amount.

A daily routine that works

Reconciliation done daily takes minutes; done monthly, it takes days and still misses things.

Pull yesterday's provider transactions, settlements and bank statement automatically.
Match orders to transactions on your references; flag orders paid without a payment and payments without an order.
Match settlements to bank credits; flag short or missing credits.
Give every exception an owner and a date, and close it with a reason.
Review the exception list weekly for patterns, such as one provider or method that keeps causing trouble.

With more than one provider

Each provider has its own report format, fee structure and settlement calendar. Normalise them into one format keyed on your references before matching, so the routine above works the same whichever provider a payment went through.

Go deeper

Questions about your own payment setup?

Talk to Peneu