How to reconcile receipts against your bank statement
Reconciliation means checking that every line on your bank statement has a receipt behind it, and that every receipt shows up on the statement. Done by hand across dozens of documents it is slow and error-prone.
This guide shows how to get both sides into checked tables and match them, which is the fastest way to close your books or prepare for an accountant.
Turn the statement into a table
Start with the source of truth. Convert your bank or mobile money statement into a clean, categorised table so you have every transaction with its amount and date.
- 1Open the Check a statement task and add the statement PDF.
- 2Review the extracted transactions and fix any category that looks wrong.
- 3Keep this table open as the reference you will match against.
Extract the receipts into the same shape
Upload the batch of receipts and invoices. Each one is read for its amount, date, VAT and supplier, and the whole pile becomes one verified table you can compare line for line.
Check a batch of receiptsMatch and find the gaps
With both sides as tables, matches line up by amount and date, and anything unmatched stands out: a payment with no receipt, or a receipt that never cleared. Those exceptions are exactly what an accountant or auditor asks about.
Frequently asked questions
- What does it mean to reconcile a statement?
- It means confirming that every transaction on your bank statement has a matching receipt or invoice, and that nothing is missing or duplicated on either side.
- Can I reconcile a mobile money statement the same way?
- Yes. A MoMo statement is read into a table just like a bank statement, then matched against your receipts.
- Do I need an accountant to do this?
- No. This gets your records into a clean, matched state yourself. It also makes an accountant faster and cheaper if you do use one.