Tax Deduction Spreadsheet | 2026 Tips, Overtime and Car Loan Interest Planner for Excel and Google Sheets | W-2 Box 12 Reconciliation

The deduction isn't new money. It's money you have to prove.

Four new federal deductions arrived for tips, overtime, car loan interest and being 65 or older — and then the 2025 W-2 arrived with no box for any of them. Nobody kept records, because nothing asked them to. For 2026 that changes: employers must report qualified tips in Box 12 code TP and qualified overtime in code TT. The people who actually collect these deductions in April 2027 are the ones logging them right now. This file is the log, the math and the receipt trail in one place.

Log it as it happens. Claim it when it counts.

WHAT THE FILE FINDS — from the sample year that ships inside (Marisol Vega is sample data, not a customer)
· $14,986 of new deductions she can prove — $10,458 of qualified tips over 72 logged shifts, $3,140 of overtime premium, $1,388 of car loan interest — worth $1,798.32 of federal tax at a 12% marginal rate.
· $9,418.97 of overtime pay is only $3,139.67 of deduction. Only the FLSA premium half qualifies; the $6,279.30 straight-time part is ordinary wages. Claim the whole check and you overstate by $6,279.30.
· $2,016 of automatic service charges kept out of the tip total, where they belong, with $14,542 of headroom still left under the $25,000 tips cap.
· Her employer's Box 12 code TT says $2,569.67. Her own log says $3,139.67. The file flags the $570 variance and prints the ask-for-a-corrected-W-2 prompt.
· One dollar of extra income at $100,000 of MAGI costs $200 of car loan interest deduction and $24 of real federal tax. The cliff analyzer shows you the edge before you step off it.

WHAT'S INSIDE — 14 connected tabs
Start Here · Setup · Dashboard · Tips Log · Overtime Log · Auto Loan Interest · Senior Deduction · Deduction Engine · W-2 Reconciliation · Withholding and Estimated Tax · Itemize vs Standard · Tax Projection · Records and Key Dates · Reference

The logs are built to be lived in: 150 formula-ready rows for shifts, 150 for overtime weeks, a 60-month auto loan interest schedule, an eight-test vehicle eligibility gate, and a Reference tab that cites every outside figure with its source and its as-of date.

WHAT YOU DOWNLOAD — one zip, eight files
· 2026-Tax-Deduction-Command-Center.xlsx — the main workbook
· Bonus Themes folder — the same workbook in Light, Dark and Editorial
· Quick-Start-Guide.pdf — 13 pages, start to finish in under five minutes
· ACCESS-YOUR-TEMPLATE.pdf — one click opens your own copy in Google Sheets
· README - Start Here.txt and LICENSE.txt

FOUR COLOR THEMES INCLUDED — Classic, Light, Dark and Editorial, same engine.

WORKS IN EXCEL AND GOOGLE SHEETS — one file, both engines. Open the xlsx in Microsoft Excel, or use the included one-click access PDF to make your own Google Sheets copy. No add-ons, no subscription, nothing that reaches out to the internet.

HONEST ENGINEERING
3,478 formulas · recalculated clean · 493/493 independent math checks · every screen in this listing is the real file. No subscription. Free lifetime updates.

Marisol Vega is shipped sample data, not a customer — every screen works the moment you open it, and clears in one select-and-delete when you're ready for your own numbers.

PLEASE READ
This is a planning tool, not tax, legal or financial advice. Confirm every figure with a tax professional or at IRS.gov before you file or change your withholding. Two things this file will keep telling you, because they are the most expensive misunderstandings in the category: a deduction is not a FICA exemption — Social Security and Medicare tax still come out of your tips and overtime, and state tax usually applies — and all four of these deductions run for tax years 2025 through 2028 and then sunset. Three tax years remain after 2026. Any projection past 2028 is speculation.

WATCH THE FULL WALKTHROUGH ON YOUTUBE: https://youtu.be/VmLvhhsMCq0

YOU MAY ALSO LIKE
· Medicare Cost Comparison Spreadsheet: https://www.etsy.com/listing/4545409639/medicare-cost-comparison-spreadsheet
· Caregiver Planner Spreadsheet: https://www.etsy.com/listing/4545413093/caregiver-planner-spreadsheet-eldercare
· Health Insurance Comparison Spreadsheet: https://www.etsy.com/listing/4545249975/health-insurance-comparison-spreadsheet
· Student Loan Payoff Spreadsheet: https://www.etsy.com/listing/4545247349/student-loan-repayment-planner-rap-idr
· Paycheck Budget Spreadsheet: https://www.etsy.com/listing/4524036009/paycheck-budget-spreadsheet-budget-by

Instant download · personal use · by NicheToolkits