See what elimination changes
Same year, added up two ways
Sample figures from one organisation with four units, in BDT.
| Receipts: outside funding + transfers in | 18,50,000 |
| Payments: real expense + transfers out | 13,30,000 |
| Closing cash and bank | 5,20,000 |
The closing figure is right, yet the report says you received 18.5 lakh and paid out 13.3 lakh. Both are inflated by 8.5 lakh of your own transfers.
- Consolidated (right). Same cash, honest totals. Transfers and due-from and due-to balances are removed.
Reports at every level
| Report | What it answers |
|---|---|
| Day Report | What moved in cash, bank and mobile banking today? |
| Ledger | What happened in this account, line by line? |
| Trial Balance | Do debits equal credits, with opening, period and closing columns? |
| Balance Sheet | What do we hold and owe, and what's the fund balance? |
| Funding and expense reports | What came in by source, and what went out by category? |
| Transfer Register | Which transfers happened, and do both sides agree? |
Each runs for one unit or the whole organisation, in PDF, CSV and print, on A4 with your logo, report date, page numbers, and prepared-by and approved-by lines.
The Day Report keeps cash honest
Closing balance = opening + outside receipts + transfers in − transfers out − expenses paid, plus or minus adjustments. It tracks only real cash movement. An unpaid bill doesn't lower cash, and a receivable doesn't raise it. Those two appear in separate notes, so you see both pictures without mixing them.
What a consolidated balance sheet should show
- Assets: cash, bank, mobile banking, receivables, fixed assets less accumulated depreciation.
- Liabilities: salary, supplier and AIT payable, plus others.
- Fund balance: opening, current year surplus or deficit, restricted and unrestricted.
- Missing on purpose: any due-from or due-to between your own units.
If consolidation doesn't balance
- Open the Transfer Register and look for transfers posted on one side.
- Compare each unit's due-from with the matching due-to.
- Check for money in transit at the cut-off date.
- Correct by a proper entry, not by editing the report.
Frequently asked questions
Is consolidation done by hand each year?
No. Reports are generated from posted entries, and internal balances are identified by their accounts and Transfer IDs. A person still reviews any differences.
Can the board see only the consolidated view?
Yes. Give them a role that opens consolidated reports without the entry screens.
Does this replace our audited statements?
No. It produces the figures and schedules your auditor works from. Statutory audit reports come from your audit firm.
Can we export to Excel for our own analysis?
CSV export is included on all major reports, and XLSX can be added.
Read next
The complete NGO accounting library
- Humanitarian NGO accounting software
- Foreign funded NGO accounting
- Restricted and unrestricted funds
- NGO chart of accounts
- Cash register software
- Bank book and reconciliation
- Fixed asset register
- NGO payroll and salary register
- Voucher approval and audit trail
- Price: Excel, Tally or NGO system?
- Trust, foundation and charity accounts
Last updated 7 November 2026