Itemized Deductions Tracker Excel for anyone deciding whether itemizing actually beats the standard deduction — SALT log, mortgage interest and charitable log, medical and other deductions, and a side-by-side comparison…
About this template
Itemized Deductions Tracker Excel for anyone deciding whether itemizing actually beats the standard deduction — SALT log, mortgage interest and charitable log, medical and other deductions, and a side-by-side comparison with the standard deduction. Know what every deduction is really worth — before you file.
$24
Excel & Google Sheets template — instant download on Etsy
SALT Log — date, description, category, and amount paid for every state income tax and property tax payment, with the SALT cap shown. Deductible SALT is the lesser of what you paid and the cap.
Mortgage and Charitable Log — date, description, category, amount, Claimed flag, and claimed amount for mortgage interest from Form 1098, cash gifts, and noncash donations. A donation with no receipt stays unclaimed.
Medical and Other Deductions Log — date, description, category, and amount for medical costs, with the 7.5 percent of AGI floor and the deductible amount, plus any other deductible items.
Itemized vs Standard Comparison — totals by category pulled by formula, the standard deduction for your filing status, which one wins, by how much, and the estimated tax saved.
Dashboard — total itemized, standard deduction, the difference, SALT cap used, largest category, medical shortfall, and the missed donation.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Itemized Deductions Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Itemized Deductions Tracker track?
The Itemized Deductions Tracker tracks SALT Log; Mortgage and Charitable Log; Medical and Other Deductions Log; Itemized vs Standard Comparison; Dashboard.
What do the example numbers show?
The included example shows: SALT paid 17,800 (state income tax 10,400, property tax 7,400); SALT cap 40,000 (2026 estimate); deductible SALT 17,800; cap used 44.5 percent.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.