Tax Deduction Tracker in Google Sheets: Schedule A Categories, Row by Row

Quick answer. A tax deduction tracker in Google Sheets is a spreadsheet with one row per deductible expense and columns for date, category, amount, payee, payment method, and receipt link. The categories should mirror IRS Schedule A lines (medical, taxes paid, interest paid, gifts to charity, casualty losses, and miscellaneous) so the year-end totals roll up directly into what you file. Our Annual Tax Planner sets this up with formulas already in place.

Most people only think about deductions in March. By then you’re rummaging through a year of bank statements, trying to remember whether that $184 Best Buy charge was a work monitor or a birthday gift for your brother. A tax deduction tracker in Google Sheets fixes that by turning a once-a-year scramble into ten minutes a week.

This guide walks through the exact columns a working deduction tracker needs, how the categories map to IRS Schedule A, and why the threshold math (itemized vs. the 2026 standard deduction) matters more than the raw deduction total. If you want to skip straight to a working template, our Annual Tax Planner covers all of this plus quarterly estimated taxes and a deduction vs. standard comparison.

What a tax deduction tracker needs to do

A good deduction tracker records each eligible expense as it happens, categorizes it in a way the IRS accepts, and totals each category so you can decide whether to itemize or take the standard deduction. Everything else is polish.

You want three behaviors built in:

1. Single-entry logging. One row, one expense. No double booking across sheets.
2. Category totals that update automatically. The year-to-date total for medical, charitable, state tax, and so on should always be current.
3. A live comparison against the standard deduction. If your category totals don’t beat $15,000 single or $30,000 married filing jointly for 2026, itemizing won’t help you and you can stop worrying about receipts.

That last piece is the one most templates miss. Logging every eligible expense is wasted effort if you’re going to take the standard deduction anyway, and you won’t know that until your categories are tracked.

The seven columns every row needs

Here’s the minimum viable schema I use. It’s the same structure the Annual Tax Planner ships with.

Seven columns. That’s it. Anyone who sells you a 40-column deduction tracker is solving the wrong problem.

Schedule A categories mapped to rows

IRS Schedule A has six sections in 2026. Here’s how each maps to a spreadsheet category dropdown.

Medical and dental expenses (Line 1 through 4)

Only the portion above 7.5 percent of your adjusted gross income counts. For someone with an AGI of $80,000, that’s a $6,000 floor. Anything logged below that total is padding.

Typical rows: out-of-pocket doctor visits, prescription drugs, dental work, eyeglasses, mileage to medical appointments (22 cents per mile in 2026), long-term care premiums up to the age-based limit.

Taxes you paid (Line 5 through 7)

Capped at $10,000 for SALT (state and local tax) through at least 2025, with ongoing legislation debate for future years. Includes state income tax or general sales tax, real estate tax, and personal property tax on vehicles.

One row per property tax bill, one per quarterly state estimate, one per annual vehicle registration where applicable.

Interest you paid (Line 8 through 10)

Primarily mortgage interest from Form 1098 and investment interest. Each Form 1098 becomes one row at year end. Don’t forget points paid at closing if you bought or refinanced a primary residence.

Gifts to charity (Line 11 through 14)

Cash gifts go on one line; non-cash on another; carryover from a prior year on a third. Track each donation at the time you give it, not in December when you’re reconstructing. Non-cash gifts over $500 need Form 8283.

Typical rows: weekly tithe, one-off disaster relief, Goodwill drop-offs with itemized lists, donor-advised fund contributions.

Casualty and theft losses (Line 15)

Only federally declared disaster areas qualify through at least 2025. Most years, most filers have zero in this category. Leave the row schema in place; it costs nothing.

Other itemized deductions (Line 16)

Narrow category. Gambling losses up to winnings, certain unrecovered pension investments, casualty losses from a federally declared disaster that weren’t fully covered by insurance. If you’re entering rows here regularly, you likely need a tax professional, not a spreadsheet.

The formula that does the real work

The single most useful cell in a deduction tracker is the one comparing your itemized total to the standard deduction. In Google Sheets it looks like this:

=IF(SUMIF(Category, "<>", Amount) > 30000, "Itemize", "Standard")

That’s for married filing jointly in 2026. For single filers, swap 30000 for 15000. For head of household, use 22500.

The logic is simple: if your total deductions beat the standard, itemize. If not, take the standard and stop logging. This one cell tells you whether the spreadsheet is worth your time this year.

Of course the real formula is a little more nuanced since medical has that 7.5 percent AGI floor and SALT is capped. In the Annual Tax Planner, the dashboard handles those carveouts in a second row so the comparison is apples to apples.

A worked example

Sarah is married filing jointly, AGI $120,000. Here are her 2026 category totals logged by category in the spreadsheet.

$27,700 is below the $30,000 standard deduction for MFJ. Sarah takes the standard and doesn’t itemize this year. Without the tracker, she’d have spent three weekends in March pulling receipts to arrive at the same conclusion.

The spreadsheet turned a losing itemization bet into a 30-second decision. Next year she’ll know to aggressively push non-essential charitable giving into a single year (a strategy called “bunching”) to beat the threshold in alternating years.

Where the tracker lives in the Annual Tax Planner

The Annual Tax Planner ships with three connected sheets:

• Deduction Log. The row-by-row entry sheet, with the seven columns above and a Category dropdown pre-populated with Schedule A lines.
• Dashboard. Category totals, the standard-deduction comparison, and the SALT-cap and medical-AGI-floor adjustments.
• Quarterly Estimates. For self-employed or side-income earners, pulls deduction totals into estimated tax calculations.

You can set up the log manually using the schema above. You can also buy the template for $29 and skip the setup. I’ve built this both ways. The time savings from a preconfigured category dropdown is real if you’re tracking 100 plus rows a year.

What I’d add after a year of using one

Three things I didn’t think mattered and turned out to matter a lot.

A notes column on each row for “why I think this qualifies”. By October you’ve forgotten whether the $340 Airbnb was the business trip or the family weekend. A one-line note at entry saves hours at filing.

A “pending docs” flag. Some deductions (donor-advised fund contributions, medical reimbursements pending from an HSA) don’t resolve until weeks after the spend. A flag column keeps you from double-counting.

A year-over-year comparison column on the dashboard. Your charitable giving history matters for bunching strategy. Your medical spending pattern matters for deciding whether to elect an HSA next year. Once you’ve tracked two years, the comparison is the most useful number on the page.

How to start if you don’t have a template yet

1. Open a blank Google Sheet.
2. Paste the seven column headers from the schema above.
3. Add a Data Validation dropdown on the Category column with the six Schedule A lines.
4. In a summary cell above row 1, write =SUMIF(B:B, "Medical", E:E) and clone it for each category.
5. In another cell, write the IF comparison against the standard deduction.
6. Start logging.

Thirty minutes of setup. Eight or nine minutes a week of entry during the year. Zero scrambling in March.

If you’d rather not build from scratch, the Annual Tax Planner is $29 and includes the dashboard, the SALT cap logic, the medical AGI floor, the charitable sub-lines, and the quarterly estimates sheet. It also ships in both Google Sheets and Excel.

For a deeper look at the full 2026 self-employed deduction list, see our 25 deductions post for 2026. For quarterly due dates and safe-harbor math, see the quarterly estimated tax walkthrough.

Get the template

• Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.
• Annual Tax Planner — Schedule A and Schedule C categories with quarterly estimate math built in.
• Tax Deduction Tracker Ultimate ($19) — Advanced version with 100 rows, auto SALT cap and medical AGI floor math, and tax-savings estimates by bracket.