Reconcile bank statements and receipts by hand
A practical method for matching bank transactions to paper receipts, checking totals and finding common errors before donor reporting.
You have a bank statement for the reporting period and a pile of receipts, invoices and payment slips. The task seems simple: match each payment on the statement to a document. In practice, dates differ, amounts repeat, bank charges have no receipt, and some receipts were paid in cash rather than directly from the bank.
A careful manual reconciliation separates three questions. Did the money leave the bank? Is there a document explaining the payment? Does the expense belong in this donor report? A transaction may pass one test and fail another, so each question needs its own check.
Prepare a matching sheet before you start
Do not begin by writing ticks on random receipts. First confirm that the bank statement covers the full reporting period. Check the account name, account number, first date, last date and page numbers. If the opening balance does not follow from the previous statement, investigate before matching documents.
Create a matching sheet on paper or in a spreadsheet. Give every bank transaction a reference such as B01, B02 and B03. Give every receipt or other supporting document a separate reference such as R01, R02 and R03. Write the reference on the document in pencil or in a clear blank space.
The sheet should preserve the original facts. Record the bank date and receipt date separately rather than choosing one. Copy the amount exactly as shown, including the currency. A short purpose such as “meeting hall hire” is more useful than a broad label such as “project cost”.
Use a status column so that an uncertain item cannot quietly appear complete. Useful statuses include matched, partly matched, missing document, cash payment, bank charge, refund, outside period and needs explanation.
- Bank reference and transaction date
- Bank description or reference number
- Amount paid out or received
- Receipt reference, date and supplier
- Purpose and project or grant
- Match status and notes
- Name or initials of the person who checked it
Match from the bank statement to the documents
Work down the bank statement one line at a time. For each payment, look for a receipt, invoice marked as paid, supplier acknowledgement or other evidence. Compare the amount, supplier, date, payment reference and purpose. Do not match on amount alone.
Dates often differ for legitimate reasons. A card purchase made on 28 June may appear on the bank statement on 30 June. A transfer may be initiated on Friday and reach the supplier on Monday. Record both dates and decide which date your reporting policy uses.
For example, bank line B07 shows “Community Hall, KES 30,000” on 15 May. Receipt R12 is from the same hall, for KES 30,000, dated 14 May, and states that the payment covered a training venue. The amount, supplier and purpose agree, and the one-day difference is understandable. Cross-reference B07 to R12 on both the sheet and the receipt.
Now consider bank line B08 for KES 12,000. You find a KES 12,000 receipt, but it is from a fuel station while the statement names an office supplier. That is not a safe match. Repeated round amounts are common, so leave the line unresolved until another detail confirms it.
Not every bank line needs a shop receipt. Bank fees can usually be supported by the statement itself, although the donor may require a separate bank advice. Transfers between the organisation’s own accounts need evidence of both sides. Refunds and reversed transactions should be linked to the original payment. Money received should be matched to a remittance advice, deposit record or other source document.
A cash withdrawal is not automatically an expense. It moves money from the bank into cash custody. Link it to the cashbook or cash advance record, then check the later cash spending against its own receipts. Do not force several cash receipts onto the bank line as if the suppliers were paid directly by the bank.
- Write the bank reference on the supporting document.
- Write the document reference beside the bank line on the matching sheet.
- Use one clear tick style only for fully matched items.
- Use a question mark or separate status for unresolved items.
Check receipts that have no bank match
After working through every bank line, reverse the direction. Go through every receipt and ask where the payment came from. A receipt without a bank match is not automatically missing from the statement.
It may have been paid from petty cash, from an earlier cash advance, through another organisational account, or personally by a staff member awaiting reimbursement. It may also be an unpaid invoice rather than a receipt. Each possibility requires different evidence.
A card terminal slip proves that a card transaction was attempted or processed, but it may not explain what was bought. A supplier invoice explains the goods or services, but it may not prove payment. When possible, keep the invoice or itemised receipt together with the payment evidence.
Watch for duplicate documents. A supplier may issue an invoice, a cash sale receipt and a stamped copy for the same purchase. These are three documents but only one expense. Mark them as one document set and link all of them to the same transaction reference.
Also check whether the receipt belongs to the reporting period and the funded activity. A valid receipt from another project should not be included merely because it is in the same envelope. If shared costs are allocated between projects, keep the approved calculation and record only the relevant amount.
- Cash payment: link to the cashbook or cash advance.
- Personal payment: link to the approved reimbursement.
- Other bank account: identify that account and statement.
- Unpaid invoice: record as unpaid, not as a completed bank payment.
- Duplicate copy: group it with the original transaction.
- Wrong project or period: exclude it from the current claim and explain where it belongs.
Use totals to expose missing or misclassified items
Individual matches are necessary, but totals provide a second control. First check the statement arithmetic: opening balance plus money received, less money paid out, should equal the closing balance. A failure may indicate a missing page, a copied figure or a statement range that does not cover the intended dates.
Suppose the opening balance is KES 240,000. The account receives KES 100,000 and pays out KES 76,500. The expected closing balance is KES 263,500. If the statement shows a different figure, stop and find the reason before preparing the donor expense total.
Next, divide the KES 76,500 paid out by status. Perhaps KES 50,500 is matched directly to project receipts, KES 25,500 is a cash withdrawal transferred to the cashbook, and KES 500 is a bank fee. These amounts account for the full bank outflow, but they do not mean that KES 76,500 is the reportable expense total.
The cash withdrawal becomes reportable only as supported cash expenses are recorded. The bank fee may be allowed, disallowed or charged elsewhere under the grant rules. Some directly matched payments may belong to another project. Build the donor report from eligible, supported expenses rather than copying the total withdrawals from the statement.
If totals differ, calculate the exact difference. A difference of KES 2,000 is easier to search for than a general feeling that something is wrong. Look for one KES 2,000 line, two KES 1,000 lines, a reversed entry, or an amount entered once as money in and again as money out.
- Total all matched bank payments.
- Total bank charges and other items supported by the statement.
- Total transfers to cash or other accounts separately.
- Total unmatched bank payments.
- Total receipts awaiting a payment source.
- Recalculate the report total using only eligible expenses.
Look where errors commonly hide
Period boundaries cause many confusing matches. Review several days before and after the reporting period for payments initiated near the closing date. Keep them in the correct accounting period according to the organisation’s policy, and explain any timing difference rather than changing a date.
Reversals and refunds are easy to overlook because the original debit may already have a receipt attached. Link the debit, reversal and any replacement payment. Otherwise the expense may be counted twice or reported even though the money returned.
Split and combined payments need written links. One invoice may be paid in two instalments, or one bank transfer may settle several invoices from the same supplier. List the component amounts and confirm that their total equals the bank line. Never alter a receipt amount to make it fit.
Currency conversion can create differences. Keep the receipt in its original currency, the actual bank amount, the exchange rate source required by the donor, and any bank fee as separate facts. Do not treat an unexplained difference as exchange loss without evidence.
Finish with an unresolved-items list. For each item, state the amount, reference, problem, person responsible and follow-up date. Have someone other than the preparer review large, unusual or unclear payments where staffing allows. Store the statement, matching sheet and referenced documents together so another person can follow the work.
- Same amount but different supplier
- Receipt total that excludes delivery, tax or another charge
- Duplicate invoice and receipt recorded as separate expenses
- Refund not linked to the original payment
- Missing statement page or transaction range
- Receipt date changed to fit the reporting period
- Personal or unrelated purchase mixed with project documents
- Cash withdrawal treated as a supplier expense
Questions
What if a bank payment has no receipt?
Mark it as missing evidence and keep it out of the fully supported total until the required document is found. Ask the person who authorised or received the payment for an invoice, receipt, supplier acknowledgement or written explanation. The bank statement proves movement of money, but it may not prove what was purchased or whether the cost was eligible.
What if the receipt date and bank date are different?
Record both dates. Compare the supplier, amount, reference and purpose, then document the reason for the timing difference. Small delays can arise from card processing, weekends or transfer settlement. A date difference should be explained, not hidden by changing either source document.
Can I use an invoice instead of a receipt?
An invoice usually shows what the supplier requested, not necessarily that payment was completed. Pair it with bank evidence, a stamped paid copy, a supplier receipt or another accepted proof of payment. Follow the donor’s document requirements where they are more specific.
Should bank charges be included in the donor report?
Only if the grant agreement and reporting rules allow them. Record charges separately even when the statement is the supporting evidence. This prevents them from being mistaken for supplier purchases and makes exclusion straightforward when they are not eligible.
When is the reconciliation finished?
It is finished when all statement lines and all receipts have a documented status, the bank arithmetic works, transfers and cash movements are separated from expenses, and unresolved items are listed. A zero difference alone does not prove that every cost is valid for the donor report.
A sound manual reconciliation uses references, two-way matching, separate status labels and control totals. It shows what the bank paid, what the documents support and what the donor report may include without treating those as the same question. Honest Record can automate parts of the matching and checking, but unclear transactions still need evidence and a documented decision.
Honest Record reads the statement and receipts, matches them, applies your fund's rules and verifies every row before the Excel exists. Free 14-day trial, no card.
Upload your first month free See a sample report