For treasurers of clubs and small charities

Clubs and small charities

• 

  For treasurers of clubs, societies and small charities

  Treasurer's cash book

  Write down every penny in and out, once. The cash book adds it up by category, keeps the bank and the cash tin apart, and tells you at the year end whether it agrees with the bank statement.

  £9Excel (.xlsx) and Google Sheets

• 

  For treasurers of charities that aren't companies

  Receipts and payments year-end accounts

  Keep the charity's cash book through the year, with each receipt and payment given a category and a fund. At the year end the workbook lays the totals out the way the Charity Commission's receipts and payments accounts do: receipts, payments, transfers and cash funds by fund, with last year alongside. It uses the new limits: for years ending on or after 30 September 2026, charities that aren't companies can use receipts and payments accounts with gross income up to £500,000.

  £9Excel (.xlsx) and Google Sheets

• 

  For membership secretaries and treasurers of clubs and societies

  Membership subscriptions tracker

  List your members and what each one pays. The tracker looks up the fee for each membership type, shows who has paid, who has part paid and who still owes, and adds up what's come in by cash and bank.

  FreeExcel (.xlsx) and Google Sheets