Nonprofit Management Accounts template for Google Docs

The first pages of the Nonprofit Management Accounts template

Every page (8)

Overview

Trustees need to know which money can be spent on what, and how many months of running costs the charity could cover. This template answers that in order: a one-page summary, income by fund, spending against budget, restricted fund movements, reserves against policy, and cash.

The sample follows Brindlewick Holdings, a fictional charity, for the year to 31 March 2027: income of £2,640k, a surplus of £177k, restricted funds of £362k and free reserves of £583k, or 5.4 months of unrestricted spending. Replace the figures with your ledger totals and keep a cause for every line that breaches your threshold.

Useful for

A finance officer preparing the quarterly or year-end pack for the trustees' finance committee
A charity manager explaining restricted fund balances to a funder before a grant is renewed
A treasurer checking free reserves against the charity's policy before approving next year's budget

What's included

Executive summary with headline figures, four findings and a recommendation
Income by fund with a trend chart, a fund split and a key figures table
Budget, forecast and actual spending with a one-line cause for each material line
Restricted funds statement with opening balance, movement and free balance
Reserves page with fund balances by quarter and a callout on months of cover
Cash page and a cash flow statement that reconciles surplus to the bank

How to use it

1
Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.
2
Change the year end and replace the summary figures with your own income, spending, surplus and months of reserves.
3
Copy fund totals from your ledger into the tables, keeping restricted and unrestricted funds apart, and check that totals add up.
4
Set your materiality threshold, then write a one-line cause for each line that breaches it and delete the rest.
5
Delete the Make it yours page, then share the pack with your trustees.

What you need

Requirements

A Google account with access to Google Drive

Works with

Google Docs
Microsoft Word (download the .docx)

Questions

Is this charity management accounts template free?

Yes. Make a copy in Google Docs and it is yours to edit, with no sign-up here and no cost.

Can I use it for months or quarters rather than a full year?

Yes. Change the period headings and the figures. The layout works for any period, as long as you keep budget and prior-period columns for comparison.

Is the sample content real?

No. Brindlewick Holdings, its people and every figure are fictional and made up for the example. Replace them with your own before you share it.

#management-accounts
#charity-finance
#restricted-funds
#reserves-policy
#trustee-report
#google-docs

More Google Docs templates More finance templates

Monthly Management Accounts
Docs + Word8 pages
Free
Annual Report
Docs + Word6 pages
Free
Monthly Business Budget
Excel
Free

Also in Finance

All finance templates

Get this template