Multi-Donor Fund Accounting Without Spreadsheets
Three donors, five grants, one organization — how to run multi-donor accounting from a single ledger: dimensions instead of spreadsheets, shared-cost allocation, and reports in every donor's format.
One grant is manageable in a spreadsheet. Three grants from three donors — each with its own budget structure, currency, reporting calendar, and rules — is where spreadsheet accounting quietly collapses. The symptoms are familiar: a master workbook only one person understands, month-ends that take ten days, and donor reports that almost reconcile.
Why the spreadsheet fails at three grants
- Double capture — every transaction is entered in the cashbook and again in the grant tracker, and the two drift.
- Structure collision — Donor A budgets by activity, Donor B by cost category; the workbook contorts to serve both.
- Shared costs by vibes — rent split "roughly a third each" changes with cash flow, which auditors read as manipulation.
- One-person risk — the finance officer who built the workbook leaves, and institutional memory leaves with them.
The fix is dimensional, not more tabs
Multi-donor accounting works when your ledger carries dimensions: every transaction is posted once, tagged with grant, budget line, and cost center. Reports are then filters — the same data answers KRA (by account), Donor A (by activity), and Donor B (by category) without re-entry. This is the entry-time tagging principle from donor fund tracking, applied organization-wide.
| Question | Spreadsheet answer | Dimensional answer |
|---|---|---|
| What did Grant A spend on trainings in Q2? | Open tracker, hope it matches the cashbook | Filter: Grant A + training lines + Q2 |
| How is our core funding holding up? | Reconstruct from what is not in any tracker | Filter: unrestricted fund, budget vs actual |
| Which grants fund the finance officer? | Check the allocation memo… if updated | Payroll allocation report, by month |
| Total organizational spend by month? | Consolidate five tabs and pray | One report, no consolidation step |
Shared costs across donors
Rent, utilities, audit fees, the ED's salary — every multi-donor NGO must split them. The defensible pattern: a written allocation basis (headcount, effort, or direct-cost ratio), applied identically every month, visible in the ledger as allocation postings. Two donors must never be charged for the same shilling — the allocation percentages across funders always total 100%, with the unfunded remainder hitting core funds explicitly.
Watch the NICRA/overhead terms
Some donors pay a negotiated indirect cost rate instead of line-item shared costs; others cap overheads at 7–10%. Where a grant pays indirects, its share of shared costs comes from that pool — charging line-item rent on top is double recovery, a serious finding.
Calendars, currencies, and closeouts
- Maintain one reporting calendar for all grants — deadlines, formats, and responsible staff — reviewed monthly; late reports damage relationships faster than small variances.
- Hold each grant in its agreement currency with a consistent rate policy; report exchange differences explicitly (see grant budget tracking).
- Stagger closeout workloads: each ending grant needs its final report, asset disposition, and unspent-balance instruction — pipeline them rather than colliding in one month.
The payoff of dimensional accounting is compounding: the fifth grant costs almost nothing to add, because the structure already exists. That scalability is the core of what an NGO-governed ERP provides over accounting software plus heroics.
Post once, report to everyone
AWRA OpsHub carries grant, line, and fund dimensions on every transaction — five donors, one ledger, reports as filters.
See multi-donor trackingFrequently asked questions
Do we need fund accounting software, or will QuickBooks classes work?
Classes can represent grants adequately at small scale. The breakpoints are procurement trails, advance liquidation, budget-line commitments, and asset custody — controls that live outside any ledger. When findings start appearing in those areas, the gap is the system around the ledger, not the ledger itself.
How do we allocate the Executive Director's salary?
Same as any shared cost: a written basis (typically level-of-effort), donor-permitted percentages, applied consistently. Note some donors cap or exclude senior management costs — read each agreement before building the allocation.
One donor's report format is completely different from our books. What now?
Map their structure to your dimensions once, at grant setup, and generate their report through that mapping. The mistake is keeping a parallel spreadsheet in their format all year — that recreates the double-capture problem the ledger was meant to solve.
How do we show donors our co-funding commitments?
Track match contributions as their own budget lines with the same evidence discipline as donor funds — in-kind contributions valued per a written policy. Unmet match commitments are findings too, so burn-rate reviews should cover them.
