Evrenus Fırat Polat · ·
Reconciliation is the routine check that what your records say you have been paid actually matches what your bank account shows. It is one of those habits that feels unnecessary right up until the one time it catches something that would have been far more painful to find later.
What it actually involves
At its core, you compare your invoice records (what you believe has been paid, and when) against your bank statement or payment processor records (what actually arrived). Anything present in one but not the other needs an explanation. Typical causes are a payment recorded but not yet deposited, a deposit with no corresponding invoice marked paid, or a duplicate entry on either side.
What it catches
- A payment that was received but never marked as paid. The invoice still shows as outstanding, and might get an unnecessary and embarrassing follow-up for money you have already collected.
- A payment applied to the wrong invoice. See cash application for why this happens and how to avoid it.
- A duplicate charge or double entry. Easy to miss without a direct comparison against the bank record.
- A processing fee that was not accounted for. A payment that arrives for slightly less than invoiced, because a payment processor's fee was deducted before deposit.
- One payment covering several invoices. A client pays one lump sum for three invoices, and you need to split it correctly.
Worked example
You opened the month with these invoices marked as paid in your records:
| Invoice | Amount | Marked paid |
|---|---|---|
| INV-0201 | $1,000.00 | May 3 |
| INV-0202 | $2,500.00 | May 9 |
| INV-0203 | $750.00 | May 15 |
| INV-0204 | $1,200.00 | May 20 |
Your records total $5,450.00. Now you look at the bank statement for May:
- May 4: deposit $1,000.00 (matches INV-0201).
- May 10: deposit $2,425.00 (INV-0202 is $2,500, so $75 is short).
- May 16: deposit $750.00 (matches INV-0203).
- Nothing for INV-0204.
Bank total: 1,000 + 2,425 + 750 = $4,175.00. The gap is $5,450 − $4,175 = $1,275.00. It splits into $75 (INV-0202 shortfall) and $1,200 (INV-0204 missing).
You check and find the $75 is a 3% processor fee on $2,500 (2,500 × 0.03 = $75). You record the fee as a cost. For INV-0204, the client has not paid, so you change it back to Sent and follow up. Without the check, that invoice would have been closed by mistake.
How to do it: step by step
- Export the bank or processor statement for the period.
- List your invoices marked paid in the same period.
- Tick each item that appears on both sides with the same amount.
- Investigate each item left unticked. Look for fees, timing differences, and wrong references.
- Correct your records: change statuses, add fee entries, fix amounts.
- Confirm the totals now agree. Note the date you completed it.
- Save the reconciled statement with your records.
How often to do it
Weekly is a reasonable default for most small businesses. It is frequent enough that discrepancies are still fresh and easy to trace, and infrequent enough not to be a daily burden. Businesses with high invoice volume may want it more often. With very low volume, monthly may be enough. What matters most is a predictable schedule rather than only when something already looks wrong.
Keep it simple
For most small businesses, reconciliation does not need dedicated software. A spreadsheet listing invoices, amounts, and payment dates, checked against a bank statement, does the job. The discipline of doing it regularly matters far more than the sophistication of the tool.
Make it easier before it starts
- Put the invoice number in your payment instructions, so clients quote it as the bank reference. See invoice numbering.
- Keep invoice statuses accurate, so you know which ones to check.
- Use one account for business income. Mixed personal and business money makes matching slower.
- Send customer statements to clients now and then. They often spot differences you missed.
Common mistakes
- Marking paid when the client says they paid. Wait until the money appears.
- Ignoring tiny differences. A $2 gap can be a pattern of fees across hundreds of payments.
- Forgetting currency conversion. Foreign payments may arrive in a different amount after exchange fees.
- Reconciling only totals. Two errors can cancel out. Match line by line.
- Skipping it during busy periods. That is when errors are most likely.
Reconciling also helps you measure collection speed. Once records are clean, your DSO and AR aging figures are reliable.
FAQ
Is reconciliation the same as bookkeeping?
No. Bookkeeping records transactions. Reconciliation checks those records against an outside source, like a bank statement.
What if I find an unidentified deposit?
Check the amount against open invoices, and ask the sender if you can see a name. Hold it as unallocated income until you know what it is for. Ask an accountant how to record it.
Do I need to reconcile if I use accounting software?
Yes. Software imports bank data, but you still need to confirm that each line is matched to the correct invoice.
How long should I keep reconciliation records?
Retention periods depend on your country and tax rules. Ask your accountant, and keep them at least as long as your tax records.
Small discrepancies rarely resolve themselves, and they compound. Treat reconciliation as a routine habit, and your records will stay something you can trust when you need them.