Donor and statutory reporting: Building one trail from report to ledger

The snapshot

A donor wants a report against a budget line and a period. The law wants financial statements for the entity. Teams often build the donor pack in a spreadsheet that never quite ties to the ledger that will be audited.

The strong versions of both reports start from the same place: a chart of accounts that can be mapped, a transaction that can be opened, and a person who owns the number. Alignment is whether the same shilling can be found in both packs.

The trap

Month nine, a programme officer exports “the project sheet.” It has its own codes. Headquarters has another. The statutory trial balance has a third. A cost sits in all three under different names, and one of them is late by a month. The donor pack is submitted. The audit starts. Nobody can walk from the report line back to the voucher without rebuilding the sheet.

The numbers were close enough to send. They were not the same record.

This is an illustration, so the point can be said out loud. It is not a client matter.

What they share

Three things show up in a donor pack that holds, and in statutory reporting that holds:

• One ledger. Project codes can sit on the transaction. They should not replace the books.
• A map. Each donor line points at accounts, and the map is kept when the budget is revised.
• An owner. Someone can say who prepared the pack, who checked the tie-out, and which items were left open.

Evidence is the same shape in both: the voucher, the bank line, the approval, the period. A narrative that says the activity happened does not replace the cost that was incurred. Restricted funds stay restricted in the ledger, not only in the covering email.

When funding is layered — a grant, a government subvention, unrestricted income — the map matters more. Complexity is a reason to keep one trail.

What to do

• If you prepare the donor pack: tie it to the trial balance before it leaves the finance office. A pack that only lives in a sheet will be rebuilt under pressure.
• If you sign the statutory statements: ask which project balances are inside the figures, and whether the restriction is still visible.
• If you manage the grant: keep the budget revision and the coding change with the report, not in a folder that finance never sees.
• If you commission the audit: ask for the bridge between the donor line and the ledger line. If the bridge is a fresh spreadsheet built for the visit, the trail is thin.