Bank Reconciliation and Payment Matching: Simple Process for Small Businesses
Your bank statement may show one balance, your books may show another, and a customer invoice may still appear unpaid even though money has reached your account. These are related problems, but they do not always have the same cause.
This guide is for small-business owners in their first one to three years of business who need to identify missing bank entries and link receipts with the correct invoices.
Quick summary
- Bank reconciliation compares your bank statement with the bank account recorded in your books.
- A bank reconciliation statement explains why the two balances are different on a particular date.
- Payment reconciliation matches each receipt or payment with the correct invoice, bill or advance.
- Reconcile regularly so missing entries, incorrect customer balances and unidentified payments do not build up.
What is Bank Reconciliation?
Bank reconciliation means comparing the bank account in your books with the bank statement for the same period. The aim is to identify why the balances differ. You may find:
- a transaction that the bank has recorded but you have not;
- an entry in your books that has not yet appeared in the statement;
- a duplicate or incorrect entry.
A difference does not always mean that someone has made a mistake. Some transactions appear on different dates because of processing time. However, every difference should still be identified and explained.
Bank Reconciliation vs Payment Reconciliation
| Area | Bank reconciliation | Payment reconciliation |
|---|---|---|
| Main question | Does the bank balance in the books agree with the bank statement? | Which invoice or bill does this payment belong to? |
| Records checked | Bank ledger and bank statement | Payment, customer or supplier account, and invoice or bill |
| Main result | The balance difference is explained | The correct invoice or bill is marked paid |
| Common problem | Bank charges are missing from the books | A customer has paid, but the invoice still appears unpaid |
Area
Bank reconciliation
Payment reconciliation
Area
Bank reconciliation
Payment reconciliation
Area
Bank reconciliation
Payment reconciliation
Area
Bank reconciliation
Payment reconciliation
A bank account may reconcile even when a receipt has been linked to the wrong customer or invoice. Both checks are therefore necessary.
Common Reasons for Bank Reconciliation Differences
Timing differences
A payment may be recorded in your books before it appears in the bank statement, or the bank may record it before you enter it. Examples include:
- a cheque deposited near the end of the month but not yet credited;
- a cheque issued but not yet presented;
- a card or payment-gateway settlement still being processed; or
- a transfer initiated close to the statement closing date.
These are timing differences. They should be monitored, but the transaction should not be recorded twice.
Missing or incorrect entries
The bank may record a transaction that has not yet been entered in your books. Common examples include bank charges, interest, loan instalments, automatic debits and direct customer deposits. Your books may also contain duplicate or incorrect entries, such as:
- a duplicated receipt;
- an incorrect amount;
- a transaction posted to the wrong bank account; or
- a receipt entered under the wrong customer.
How to Reconcile a Bank Statement
Follow these steps using your books and bank statement for the same period.
1. Select the period
Choose a clear start and closing date, such as 1 July to 31 July. Download the complete bank statement for this period and open the bank account recorded in your books or accounting software. Do not compare a full-month ledger with an incomplete bank statement.
2. Check the opening balance
The opening balance should agree with the closing balance from the previous completed reconciliation. If the balances do not agree, check whether:
- a previous entry was changed or deleted;
- a backdated transaction was added;
- the earlier reconciliation was incomplete; or
- the opening balance was entered incorrectly.
3. Match the transactions that agree
Compare each bank-statement entry with your books. Check the date, amount, customer or supplier name, bank reference number, and invoice or bill number, where available. Do not match transactions using only the amount. Two customers may pay the same amount on the same day.
4. Separate the unmatched entries
Separate unmatched transactions into timing differences, missing entries, incorrect entries, reversals and unidentified payments so you know what action each one requires.
5. Record or correct the entries
Record genuine transactions that the bank has processed but your books do not show, such as bank charges, interest and direct customer payments. Correct duplicate entries, wrong amounts and incorrect customer allocations. Keep a clear record of the correction instead of deleting entries simply to make the balances agree.
6. Confirm the reconciled balance
After recording corrections, confirm that the adjusted book balance agrees with the bank statement after allowing for genuine timing differences. List any remaining timing items in the BRS and review old unmatched entries separately.
Bank Reconciliation Statement Example
Suppose a retailer’s books show a bank balance of ₹1,00,000 on 30 June, while the bank statement shows ₹96,500. The retailer finds three differences:
- A cheque deposit of ₹5,000 was recorded in the books but had not yet appeared in the bank statement.
- Bank charges of ₹500 appeared in the statement but had not been entered in the books.
- A customer transferred ₹2,000 directly into the bank, but the receipt had not been recorded.
The reconciliation would look like this:
| Bank reconciliation statement as at 30 June | Amount |
|---|---|
| Balance as per books before corrections | ₹1,00,000 |
| Less: Bank charges not recorded in the books | ₹500 |
| Add: Customer receipt not recorded in the books | ₹2,000 |
| Adjusted balance as per books | ₹1,01,500 |
| Less: Cheque deposited but not yet credited | ₹5,000 |
| Balance as per bank statement | ₹96,500 |
Bank reconciliation statement as at 30 June
Amount
Bank reconciliation statement as at 30 June
Amount
Bank reconciliation statement as at 30 June
Amount
Bank reconciliation statement as at 30 June
Amount
Bank reconciliation statement as at 30 June
Amount
Bank reconciliation statement as at 30 June
Amount
The retailer should record the ₹500 bank charge and the ₹2,000 customer receipt. The ₹5,000 cheque should not be recorded again. It should remain as an outstanding item until it is credited, returned or cancelled.
How to Match Payments With Invoices
After reconciling the overall bank balance, match each receipt or payment with the correct invoice, bill or advance.
| Payment situation | What to do |
|---|---|
| One payment for one invoice | Confirm the customer, amount and transaction reference, then mark the invoice paid. |
| One payment for multiple invoices | Divide the receipt across the invoices it settles instead of applying the full amount to one invoice. |
| Part-payment | Record the amount received and leave the remaining invoice balance outstanding. |
| Payment received before invoicing | Record it as a customer advance or unallocated receipt until the correct invoice is raised or identified. |
| Payment after TDS deduction | Record the bank receipt and verified TDS separately, then adjust both against the invoice. |
| Net gateway settlement | Match the full invoice amount, then record gateway fees, refunds and other deductions separately using the settlement report. |
Payment situation
What to do
Payment situation
What to do
Payment situation
What to do
Payment situation
What to do
Payment situation
What to do
Payment situation
What to do
Apply the same process to outgoing payments by linking each bank payment with the correct supplier bill, advance or expense.
How Often Should You Reconcile?
How often you reconcile should depend on the number and type of transactions your business handles. A new business with few transactions can usually complete a formal reconciliation every month.
A business receiving regular UPI and bank payments should also review unidentified receipts each week. Businesses using card machines, marketplaces or payment gateways may need to match settlements daily or every few days.
Do not wait until the end of the financial year. Old differences become harder to trace because invoices, messages and payment references may no longer be easy to find.
How To Prevent Future Mismatches
A few simple habits can reduce reconciliation work:
- Record receipts and payments on the day they happen.
- Ask customers to mention the invoice number in the payment reference.
- Use a separate bank account for business transactions wherever practical.
- Keep bank statements, settlement reports and payment confirmations together.
A spreadsheet can work when transaction volume is low. As the number of invoices and payments grows, accounting software can reduce manual matching.
Conclusion
Bank reconciliation helps you identify missing, incorrect and delayed transactions, while payment reconciliation ensures that receipts and payments are linked to the correct invoices or bills. Completing both regularly keeps your bank balance, customer dues and supplier payments reliable.