In this guide 6 sections
Collections and the bank statement differ because they record different events; your software logs the moment a cashier saves a receipt, while the bank logs when funds clear. Bulk payments, advances, part instalments, returned cheques and gateway settlements sit in between. Show each gap by type.
Two ledgers record two different moments
Your software records a collection when a cashier saves a receipt, but the bank records a credit only when funds clear, which can be days later. Neither is wrong. They describe different moments.
The gap is rarely one big error. It is usually a dozen small items, each with its own cause, and chasing them one at a time eats an afternoon; start with one day. Just one.
Match every credit on the statement to a receipt, then list what is left on each side; sort the leftovers by cause before you chase any single item.
- Receipts saved but not yet cleared
- Bank credits with no receipt
- Receipts allocated to the wrong head
- Bank charges and gateway fees netted off
School fees paid in bulk across heads
A parent transfers one amount that covers tuition, transport, the lab fee and a late fine, and the bank shows a single credit. The software must split it into four heads. That is where trouble starts.
Siblings make it worse. One transfer may cover two children in different sections; if the receipt carries only one admission number, the other child still shows dues in the fee ledger.
A good fee module lets the cashier allocate one credit across heads and students. It keeps the bank reference on every line, so a query from a parent takes seconds to answer.
PG rent with advances and notice adjustments
A paying guest pays a security deposit, a month’s advance and then rent, and on exit the notice period is adjusted against the deposit. Only some of that movement ever touches the bank.
Reports that mix deposits with rent will never match the statement. A deposit is a liability you hold. It is not income you earned. Keep it in its own account.
Check the refund on exit. Many mismatches come from a refund paid in cash that the software never recorded, which leaves the deposit open long after the room is relet.
- Deposit received, held as liability
- Rent for the month, with the due date
- Notice adjustment against deposit
- Refund paid, by mode and date
Loan and chit instalments with part payments
A borrower pays two thirds of an instalment, and the software must split it between interest, principal and penalty in a fixed order. If that order differs from the signed agreement, the outstanding balance drifts every month.
Chit members add another wrinkle. A member may pay late, or settle through the foreman after an auction; then the credit lands in the bank under the foreman’s name and not the member’s.
Ask the product to show its allocation order on screen; then every part payment can be explained to the borrower and to an auditor without opening a spreadsheet.
Returned cheques and what the reconciliation view should show
A cheque deposited on Monday bounces on Thursday, yet the receipt still shows as collected. The bank shows a credit followed by a debit with a return code, and the gap stays open until someone reverses the receipt.
Software should treat a bounced cheque as an event, not an edit. It reverses the receipt, restores the dues, adds the bank charge to the payer and flags the account for follow up. Nothing is deleted.
Run one check every month, on the same date. Sort unmatched items by age and by cause, and put a name beside anything older than a week, so the list shrinks instead of growing.
- Unmatched bank credits by date
- Receipts with no clearing date
- Returned cheques and reversal status
- Gateway settlements against orders
- Charges netted off the credit
Collections to bank reconciliation sheet
Each row of this sheet carries the date, receipt number, amount received, bank credit reference and the gap. Four blocks beneath it cover pending clearance, unallocated credits, returned cheques and fees netted off; a sign off line records who matched the day and when.
Open a blank worksheet to printQuestions owners ask
How often should we reconcile collections with the bank?
Daily for cash heavy businesses, and weekly at the least for the rest; small gaps are easy to explain while the receipts are fresh. Old gaps need digging through paper.
Why does a payment gateway total never equal the bank credit?
The gateway settles in batches after deducting its fees and holding recent refunds; match the settlement report to the credit first, then match individual orders to the report.
Should deposits count as collections?
No. A refundable deposit is a liability. Show it in a separate account so income reports and the bank statement can be compared fairly.
What if the difference is small but never closes?
Look for rounding in part payments and for fees netted off by the bank. Record each as its own line, so the difference is explained and not carried forward.