Tips and Overtime Tracker 2026, No Tax on Tips Shift Log Spreadsheet
Log your shifts and see your estimated qualified tips and overtime deductions for 2026, with the income limit applied. Built for tipped employees and hourly employees paid on a W-2.
WHAT YOU GET
• Dashboard: tips you kept, hours worked, tips per hour, overtime hours, estimated overtime premium, estimated deductions and a rough tax savings number
• Shift log: hours, cash tips, card tips and tips paid out; service charges listed apart and not counted. Or type monthly totals
• Overtime counted by pay week (you pick the day your pay week starts), with the premium part only, as the IRS rules describe
• Deductions tab: the tips and overtime limits, the income limit and the reduction, worked out for your filing status
• W-2 Check: type your W-2 boxes when they arrive and the deductions use your employer's numbers
• Plain-word checks and an IRS Figures tab with every limit and its source. For tax year 2026 only
HOW IT WORKS
- On Setup, pick your filing status and type your income estimate. Log each shift's hours and tips.
- 2. Read the Dashboard. When your W-2 arrives, type its boxes on W-2 Check.
FORMAT
Excel (.xlsx). Works in Google Sheets (free) and Microsoft Excel. Includes a short READ ME. Opens with sample data so you can see it working; clear it in seconds. Formulas are protected (no password), so nothing breaks while you type. Instant download.
WHO MADE THIS
Built by someone who develops pricing and financial models for multi-million-dollar enterprise contracts for a living. Same discipline, made simple for your own numbers.
GOOD TO KNOW
• Digital download: nothing is shipped.
• For personal use. Please don't resell or share the file.
• Estimates for planning, not tax advice. Tax rules change; every rate, limit and date sits on one tab with its source (irs.gov, read October 29, 2026) so you can update it. Check with the IRS or a tax preparer before you file or pay.
• The tips deduction is for jobs on the IRS list of tipped occupations (IRS.gov/TippedOccupations); you need a valid Social Security number, and married filers must file jointly. This file is for employees, not the self-employed.
• Your employer's W-2 amounts are the ones that count. The file shows an estimate.
• Questions? Email tidyrate@outlook.com.
Text and layouts were created with AI tools and reviewed and edited by the seller.