"Simple is Beautiful" is a series of leaflets explaining how "ordinary" volunteer Trustees, without any special financial expertise, can set up their small charity accounts to be easy and understandable to all.
And in a way that does NOT require them (or even the Treasurer) to be professional accountants.

EconomicsBooksAND the leaflets are accompanied by a downloadable spreadsheet to show how they can be put into practice.

"Simple is Beautiful" has been inspired by the 1970s (but even more relevant today) iconic book, Small is Beautiful:  Economics as if People Mattered, by E.F.Schumacher, and the more recent (2017) Doughnut Economics:  Seven Ways to Think Like a 21st-Century Economist by Kate Raworth.
Both review the follies of thinking that the solution to all our problems is big global market-driven, profit-hungy corporations and the financial thinking (and obfuscational accountancy practices) which go with that.

Click on the leaflet titles (below) to open them as downloadable PDF files.

The leaflets are NOT a full and comprehensive guide to Charity Law and all the associated regulations.   They are just an overview, in simple everyday language (rather than legalistic/accountancy jargon) of the main points for those who want to run their small charity efficiently and effectively, or to help trustees who have encountered one of the many common difficulties.

So if you are expecting your charity’s annual income to be more than £250,000/yr, or to own property, or to employ more than 3 staff then you will probably need to seek additional professional guidance elsewhere.

The topics covered in this series are:

What Accounts ALL Small Charities MUST Keep

The Role of the Charity Treasurer (and assistants)   (Also on the "Starting a Charity" page)

Recording & Managing Your Charity’s Funds

Budgets & Cash Flows

Financial Controls CheckList

A Bank Account
Originally written for new charities being set up, this leaflet may also be useful to existing charities wanting
to review their banking services.

Preparing the Trustees' Annual Report & Accounts

 a: Guidance Notes

 b: Blank Template  (MS-Word format)

Simple Accounts Spreadsheet

The "Simple Accounts Spreadsheet" referred to in the leaflets above can be downloaded (click on the links below) so that you can see if it might be suitable for your charity.   If you think they might be useful you are welcome to save them to your own computer(s).

Both spreadsheets are "open source" - ie: all the structure and formulae used are open and visible to users to see how the spreadsheet works so that they can adapt and develop the ideas an concepts to suit their own needs.
But the spreadsheets remain the copyright of Small Charity Support and exploiting them for commercial gain is NOT permitted.

First devised more than 10 years ago and used by many small charities since then, the spreadsheet has, inevitably, been regularly "tweaked" and updates since then.
But in 2020 the spreadsheet (both the "Blank" and the "Example" versions have been extensively revised to:

  • Make the structure and formulae of the spreadsheet more robust, efficient and reliable;
  • Increase the functionality of the spreadsheet;
  • Demonstrate that the complexity of Accruals accounting procedures and the distortions of Cash(Receipts & Payments) accounting procedures are due more to those "obfuscational accountancy practices" than to any fundamental differences in the way that charity's financial transactions have to be recorded, monitored and managed to run the charity in a "business-like" manner (ie: Efficiently, Effectively & Economically (AND Ethically and Ecologically as well);
  • Enhance the spreadsheet's role in producing regular internal monitoring & management reports as well as also being able to produce end-of-period external reports, in both Accruals and Receipts & Payments formats - eg: the statutory Annual Report for submission to the charity's members, donors and other stakeholders, whether or not the charity is also required to submit it to the Charity Commission;

However, the underlying data structure and way that the spreadsheet works have not been changed, other than to add the facility to #-tag transactions with the fund to which they relate.   So it is straightforward for existing users of earlier versions of the spreadsheet to download the new version, configure it to their existing Categories structure.   They can then transfer their existing transaction data to the new version and continue working as before.
If your charity is an existing user of the spreadsheet and needs some guideance on transferring to the new version, let us know and we'll do our best to help if we can.

The spreadsheet comes in two versions:
(1) an Example version, containing real (but anonymised) data to illustrate how the spreadsheet works in practice;
(2) a Blank version, in which there are no transactions data and none of the categories have been set (other than the main headings suggested by the Charity Commission) to avoid the need for new users to clear away existing data in order to set up their own requirements.

There is also a comprehensive set of instructions showing how to set up and use the spreadsheet.

Blank
Version without any data   (revised 28-Sept-20)

Example
Version with data to experiment with   (revised 28-Sept-20)

Instructions
The instructions
on how to set up and use the spreadsheet, all illustrated with screen shots, now come in 4 separate volumes:

    1. Introduction:   An overview of what the spreadsheet does;
    2. Setting Up:  How to configure the blank worksheet to meet the needs of your charity;
    3. Data Entry & Analysis:  How to enter transactions data into the spreadsheet, amend the data when necessary, and produce both in-built standad financial monitoring & management reports (eg: Budget & Cash-Flow) and how to use facilities like Sorting & Filtering to produce your own ad hoc reports;
    4. End-of-Year Reporting (coming soon):  How to use the spreadsheet to prepare formal external reports (eg: the Trustees' Annual Accounts) in both Accruals and Receipts & Payments formats (simultaneously) compatible with Charity Commission guidelines.

Both spreadsheets have been created using Microsoft Office 365(R) but appear to work satisfactorily in other software, eg: LibraOfficeCalc(R).

To use the spreadsheet you'll need to be rather more than a spreadsheet novice - ie: you'll need to have a reasonable understanding of how formulae work, copying & pasting, etc.   But you won't need to be an expert.

 

Your comments - PLEASE

Do let us have your comments on the spreadsheet - you can e-mail them to This email address is being protected from spambots. You need JavaScript enabled to view it.
Compliments, queries, criticisms, brickbats (so long as they are constructive) are all welcomed.
Small Charity Support's mission is to make life easier and more effective for other small charities.
If we are doing things right, that's good and encouraging to know so that we can try to do more.
But if we're doing things badly we need to know about that, too, so that we either put it right or stop doing it to avoid harming others.

 

lawyer
Please remember to read our Legal Notice

 

 Intellectual Property and Copyrights
Crown Copyright Acknowledged.
All the other materials on this website are the intellectual property and copyright of Small Charity Support
.   All Small Charity Support's services & materials are made available free of charge & royalties for use by bona fide small charities & not-for-profit community organisations
.

However, small charities and not-for-profit organisations are requested to e-mail Small Charity Support (This email address is being protected from spambots. You need JavaScript enabled to view it.) for confirmation of permission to use the spreadsheets royalty-free.

Use of the materials, directly or modified, for commercial or other for-profit purposes is NOT permitted.