Try a reconciliation
Reconcile a sample bank account
Change any figure. The difference should end at zero.
| Adjusted statement balance | 8,10,000 |
| Adjusted book balance | 8,10,000 |
| Difference | 0 |
Reconciled. Now post the charges and interest as journal entries so the books catch up.
Prefer Excel? Download our free bank reconciliation template.
A bank book for every account
Each account belongs to head office, a department or a project, and has its own book. Account numbers are visible only to authorised users.
| Date | Voucher | Particulars | Bank in | Bank out | Balance |
|---|---|---|---|---|---|
| 01-09-26 | Opening balance | 6,50,000 | |||
| 05-09-26 | BR-0210 | Funds from head office | 2,50,000 | 9,00,000 | |
| 12-09-26 | BP-0388 | Supplier, cheque 104521 | 60,000 | 8,40,000 | |
| 30-09-26 | JV-0045 | Bank charges | 3,500 | 8,36,500 |
The usual reconciling items
- Cheques not yet cashed: you've recorded them, the bank hasn't seen them.
- Deposits in transit: you've recorded them, the bank hasn't credited them.
- Bank charges and interest: the bank has recorded them, you haven't yet.
- Stale cheques: old unpresented cheques need following up, not carrying forward forever.
Bank and cash move together, so reconcile alongside the cash register. Clear what you can before year-end closing, because old differences are the hardest to explain.
Bank statement import, with a person in charge
You can import a statement as CSV or XLSX. The system suggests matches against your entries and flags unmatched or duplicate lines. Imported lines don't become accounting entries on their own, and reconciling never alters a posted transaction. If an item is missing from the books, an authorised user posts a proper journal entry.
Frequently asked questions
How often should an NGO reconcile its bank accounts?
Every month, for every account. Busy accounts during an emergency response benefit from weekly checks.
Who should do the reconciliation?
Ideally someone who doesn't prepare the payments, with a second person approving it. In a small office, the reviewer's sign-off matters even more.
Does the system handle mobile banking too?
bKash, Nagad and similar accounts have their own book and can be reconciled against their statements the same way.
Can we mark individual transactions as reconciled?
Yes. Authorised users mark them, and those marks carry into the next month's reconciliation.
Read next
The complete NGO accounting library
- Foreign funded NGO accounting
- NGO project accounting software
- Fund transfer accounting entries
- Restricted and unrestricted funds
- NGO chart of accounts
- Fixed asset register
- NGO payroll and salary register
- Opening balance and year-end closing
- Consolidated financial reports
- Price: Excel, Tally or NGO system?
- Trust, foundation and charity accounts
Last updated 7 November 2026