A tax-related summary is a one-page list of expenses you think might matter at filing time, grouped by category with a total for each. Build it from a transaction list with a flag column, then use SUMIFS to total the flagged rows by category. The sheet does not decide what is allowed. It makes sure your preparer sees everything in one place, and rules change, so confirm the current position with them or the official source.
What columns does the transaction list need?
Keep one master sheet called Transactions, with a header row in row 1 and data from row 2 down.
| Column | Header | Example |
|---|---|---|
| A | Date | 2026-03-14 |
| B | Payee | Office supply store |
| C | Amount | 84.50 |
| D | Category | Supplies |
| E | Tax flag | Yes, No or Ask |
| F | Receipt saved | Yes or No |
| G | Note | Printer paper and toner |
The flag is your own opinion, not a verdict. 'Ask' is the honest value for anything borderline.
How do you total flagged items by category?
On a second sheet called Summary, list your categories in column A starting at A2. In B2, total the flagged amounts for that category:
- =SUMIFS(Transactions!$C$2:$C$500, Transactions!$D$2:$D$500, $A2, Transactions!$E$2:$E$500, "Yes")
- For items you are unsure of, in C2: =SUMIFS(Transactions!$C$2:$C$500, Transactions!$D$2:$D$500, $A2, Transactions!$E$2:$E$500, "Ask")
- A grand total in B20: =SUM(B2:B19)
The argument order is the sum range first, then each pair of range and criterion. Both Excel and Google Sheets accept this form. Using $C$2:$C$500 instead of whole columns keeps the formula quick and easier to check.
What does a worked summary look like?
The numbers below are invented.
| Category | Flagged Yes | Flagged Ask | Rows missing a receipt |
|---|---|---|---|
| Supplies | $412.50 | $38.00 | 1 |
| Software | $960.00 | $0.00 | 0 |
| Home office | $600.00 | $240.00 | 2 |
| Professional fees | $450.00 | $0.00 | 0 |
| Total | $2,422.50 | $278.00 | 3 |
Check: 412.50 + 960 + 600 + 450 is 2,422.50, and 38 + 240 is 278. The last column counts rows with F set to No for the category, using =COUNTIFS(Transactions!$D$2:$D$500,$A2,Transactions!$E$2:$E$500,"Yes",Transactions!$F$2:$F$500,"No").
Which items should be flagged Ask?
Anything that mixes personal and work use, anything you cannot recall, and anything where you are unsure of the category itself. Do not guess to make a total look better. A higher 'Ask' column is not a failure; it is a to-do list for your preparer meeting.
What should the report not try to do?
It should not calculate tax, apply limits or decide what is eligible. Those are judgement calls that depend on your circumstances and on rules that change. The sheet's job is narrower: collect, label and total, so the person who does make the decisions starts from a clean picture. If you are tempted to add a column that says how much you expect to save, leave it out. A number like that can mislead you into spending money you have not yet confirmed you will get back.
It is also worth adding a column called Reason, a few words on why you flagged the line. 'Used for client project' is more useful at filing time than a Yes with no story behind it.
How should you hand it over?
- Sort the Transactions sheet by category, then date.
- Check that Yes, No or Ask is filled on every row.
- Fill the receipt column for anything flagged Yes or Ask.
- Export the Summary and Transactions sheets as one workbook or two PDFs.
- Write three lines about anything unusual this year.
SpendixAI is built around India and rupees, and its categories carry tax-deductible and ITC-eligible settings, but it is not aimed at dollar filings, so this sheet is the tool for readers in the US.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

