Add a first tab called Read me that answers five questions on one page: where do I enter data, what do the colours mean, which cells must I not touch, how do I close the month, and who do I ask. Then protect the formulas and test the guide by asking someone to add one entry while you watch. This is worth doing before you travel, fall ill or hand over the household accounts.
What belongs on the Read me tab?
| Section | What to write |
|---|---|
| Purpose | One sentence: this sheet tracks the household's monthly spending and bills |
| Where to enter | Which tab and which columns, with an example row |
| Colour codes | What each fill colour means |
| Do not touch | Which cells and tabs hold formulas |
| Month close | A short numbered routine |
| Who to ask | Name and phone number of the sheet owner and of your CA or adviser |
| Where papers are kept | Where bills, statements and policies are filed, in words |
Keep the whole thing under one screen. If it needs scrolling, it will not be read.
How do you describe where to enter data?
Be literal. Write: go to the tab called Data, go to the first empty row, type the date, a short description, pick a category from the dropdown, type the amount and pick the payment mode. Then show one worked example row, for instance 12-Apr-2026, Vegetables, Groceries, 180, Cash. A person who has never opened the sheet should be able to copy the example.
What should the colour codes say?
- Yellow cells: type here.
- Grey cells: formulas, leave alone.
- Red text on the summary tab: you are over the limit for that category.
- Green: bill paid.
Use few colours. Four is plenty, and consistency across tabs matters more than style.
How do you protect the cells nobody should touch?
Unlock only the input cells, then lock the rest. In Excel, select the input cells, open Format Cells, Protection and clear Locked, then choose Review, Protect Sheet. In Google Sheets, use Data, Protect sheets and ranges and set who can edit. This prevents accidental overwriting. It does not secure the sheet against someone determined, so do not store sensitive identifiers in it.
Also write the date of the last review at the top of the Read me tab. Someone opening the sheet in a year should know whether the instructions still match the sheet.
What does the month-close routine look like?
- Enter any remaining cash expenses for the month.
- Check that each bank and card statement for the month has been entered or pasted.
- Check that the Uncategorised count on the summary tab is zero.
- Compare the closing balance on each statement with the sheet's total for that account.
- Save a copy named with the month, for example Household 2026-04, in the backup folder.
- Add a one-line note on anything unusual this month.
How do you test the guide?
Hand the sheet to the person it is for and ask them to add one expense and find this month's total, without any help. Watch where they hesitate, and fix the wording there. Repeat once a year, around April, when the financial year starts and the sheet often changes.
When the guide grows too long
If the Read me tab grows past a page, the sheet may have become hard to hand over. Some families move to a tracker with a simpler daily routine. SpendixAI takes statement uploads as PDF, CSV or Excel and uses Google sign-in, so there is no password to pass around, but Pro covers one personal workspace and it is not a team tool, so check that it suits how your household shares the work.
- One page, under one screen.
- A worked example row.
- Locked formulas, unlocked inputs.
- A tested month-close routine.
- No logins written anywhere in the file.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


