Tax and GST

Tax-deductible expenses summary: a one-page sheet template in dollars

Build a one-page summary of possibly tax-related expenses in dollars with a flag column and SUMIFS totals your preparer can review, without guessing the rules.

Editorial illustration for Tax-deductible expenses summary: a one-page sheet template in dollars

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.

ColumnHeaderExample
ADate2026-03-14
BPayeeOffice supply store
CAmount84.50
DCategorySupplies
ETax flagYes, No or Ask
FReceipt savedYes or No
GNotePrinter 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.

CategoryFlagged YesFlagged AskRows missing a receipt
Supplies$412.50$38.001
Software$960.00$0.000
Home office$600.00$240.002
Professional fees$450.00$0.000
Total$2,422.50$278.003

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?

  1. Sort the Transactions sheet by category, then date.
  2. Check that Yes, No or Ask is filled on every row.
  3. Fill the receipt column for anything flagged Yes or Ask.
  4. Export the Summary and Transactions sheets as one workbook or two PDFs.
  5. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports