treasurersheetTry it free

For volunteer treasurers

A year of bank statements in. A draft receipts and payments account out.

Small charities, clubs, scout groups and PTAs usually report on a simple cash basis: what came in, what went out, and the cash at the bank. The Charity Commission's receipts and payments template sets out the headings.

Upload the year's statements and get every line under those headings (you can change any), restricted funds kept apart, transfers between your own accounts cancelled out, and a check that it all agrees with the bank. You add the other assets and the liabilities from your own records.

Try it with one statement

No sign-up. PDFs or photos. We don't keep your statements.

How it works

1

Add the year's statements

Current and savings accounts, as PDFs or photos.

2

Check the headings

AI suggests a heading for every line (donations, subscriptions, hall hire, insurance…). Anything uncertain is flagged, and you can change any heading.

3

Download the draft

Receipts and payments by fund (Section A), cash at bank, the reconciliation and every transaction, for the trustees and your examiner to check. You add any other assets and the liabilities.

Prices

FreeFirst statementSee how it reads yours
£14.99A year's accountsUp to 40 statements, across up to 3 accounts

One-off, paid from the group's funds if you like. No subscription, no account. Unused credits are refunded on request.

Also free: check your Gift Aid donor list against HMRC's schedule rules. It runs on your computer; nothing is uploaded.

Questions

Is this the official template?
No, it's a draft in the same layout as the Charity Commission's CC16 receipts and payments template (England and Wales). Scottish charities use OSCR's pack. We aren't connected to either regulator.
Who approves the accounts?
The trustees (or your committee). If your charity needs an independent examination, the examiner checks them too. treasurersheet gives you a draft and the working behind it.
What about restricted funds?
Lines that show money given for a specific purpose, and spending of it, go in the restricted column. You can change any line. It warns you if a restricted fund looks overspent.
Is it the full set of CC16 accounts?
No. You get Section A (the receipts and payments account) and the cash at bank part of Section B. CC16's statement of assets and liabilities also lists other assets and liabilities (for example equipment owned, money owed to or by the charity), which you add from your own records.
Does it use AI?
Yes, to read each statement and suggest a heading. The totals, fund columns and bank reconciliation are ordinary arithmetic.
What happens to the statements?
We don't keep them or the figures: they go straight back to your browser, and the spreadsheet is made on your own device. Our AI provider deletes them within 30 days (see the privacy notice).
Is this accounting advice?
No. It isn't tax, accounting or legal advice. The trustees check and approve the accounts; check the figures before you submit or file anything.
Can we pay as a charity or club?
Yes. The terms include data processing terms for organisations, accepted when you upload.