The most useful tax-related summary is one where every number can be backed up. Build an Excel table with a column for the type of evidence you hold for each expense, total it by category with SUMIFS, and count the rows that lack evidence with COUNTIFS. Your accountant gets a list that is easy to review, and you find the gaps while there is still time to fill them.
How do you set up the table?
In Excel, enter a header row and your data, select it, and choose Insert then Table. Name the table Expenses in the Table Design tab. Using a table means formulas refer to column names and grow with new rows automatically.
- Date
- Payee
- Amount
- Category
- TaxRelated (Yes, No or Ask)
- Evidence (Receipt, Invoice, Statement only or None)
- Note
Evidence is the column that makes this template different. 'Statement only' means the payment is on your bank statement but you hold nothing else.
What formulas give you the summary?
On a Summary sheet, with categories in A2 downwards:
- Total flagged: =SUMIFS(Expenses[Amount], Expenses[Category], $A2, Expenses[TaxRelated], "Yes")
- Rows lacking proof: =COUNTIFS(Expenses[Category], $A2, Expenses[TaxRelated], "Yes", Expenses[Evidence], "None")
- Amount lacking proof: =SUMIFS(Expenses[Amount], Expenses[Category], $A2, Expenses[TaxRelated], "Yes", Expenses[Evidence], "None")
Keep column names simple, with no spaces or hyphens, such as Amount, Category, TaxRelated and Evidence, so the references stay easy to read. Excel 2016 and newer support this structured syntax.
What does a finished summary look like?
| Category | Total flagged | Rows with no evidence | Amount with no evidence |
|---|---|---|---|
| Equipment | £1,180.00 | 1 | £95.00 |
| Travel | £326.40 | 3 | £112.40 |
| Training | £540.00 | 0 | £0.00 |
| Phone and internet | £384.00 | 0 | £0.00 |
| Total | £2,430.40 | 4 | £207.40 |
The totals check out: 1,180 + 326.40 + 540 + 384 is 2,430.40, and 95 + 112.40 is 207.40. These are illustrative only.
When should you review the evidence column?
Monthly, not annually. Filter the table to show TaxRelated equal to Yes and Evidence equal to None, and deal with each row: find the receipt, or change the flag to Ask and add a note. Ten minutes at the end of the month beats rummaging through a mailbox next spring.
How do you keep the categories steady?
Use a data validation drop-down for Category, TaxRelated and Evidence, so typing errors cannot split one category into two. In Excel, select the column, choose Data, then Data Validation, then List, and type the allowed values separated by commas.
What if you are using Google Sheets instead of Excel?
The idea carries over. Google Sheets has no Insert Table feature in the same form, but you can use ranges such as $C$2:$C$500 with the same SUMIFS and COUNTIFS functions. For the first formula, =SUMIFS($C$2:$C$500, $D$2:$D$500, $A2, $E$2:$E$500, "Yes") works in both, where C holds the amount, D the category and E the flag. The structured table names are Excel-only, so if you share the file with someone using the other program, ranges are the safer choice.
Whichever you use, test the totals once by hand. Filter to one category, add the amounts with your calculator, and compare with the formula.
A handover checklist
- Filter TaxRelated to Yes or Ask and confirm every row has a category.
- Run the no-evidence count and clear it where you can.
- Save a dated copy as a PDF alongside the workbook.
- Write a short note on anything that changed from last year.
- Ask your accountant whether they want the raw table, the summary or both.
SpendixAI is built around India and rupees, so we do not offer it for pound-based filings, although its categories can carry tax-deductible settings and its reports summarise by category in the same spirit.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

