Tip Tracker Spreadsheet for Servers & Bartenders, No Tax on Tips Deduction Tracker 2025-2028, Overtime Log, Excel PDF

No Tax on Tips deduction tracker for servers, bartenders and tipped workers. Track qualified tips, tax forms and estimated deductions for 2025–2028, all in one organized recordkeeping system.

Built for tipped employees and eligible self-employed workers, the No Tax on Tips Deduction Tracker helps you organize tip records and prepare information for tax filing or a review with a tax professional.

This is a recordkeeping and estimation tool. It is not tax preparation software and does not promise that any amount qualifies for a deduction.

WHAT'S INCLUDED

• Excel tip and deduction tracking workbook
• 16-page fillable PDF
• Interactive offline HTML dashboard
• Daily tip log: cash, card, tip pool, tip-out, service charges and auto-gratuities
• 11-question eligibility checklist
• W-2 / 1099 reconciliation
• 2026 W-2 Box 12 Code TP and Box 14b occupation code fields
• Federal deduction estimator with the $25,000 cap and MAGI phaseout
• Married-filing-jointly and valid-SSN checks
• Self-employed net-income limitation
• Bonus qualified overtime tracker (FLSA premium; $12,500 single / $25,000 married filing jointly cap; W-2 Box 12 Code TT)
• Year-end tax-prep summary

BUILT AROUND 2025–2028 FEDERAL RULES

For eligible taxpayers, the maximum qualified-tip deduction is $25,000 per return.

The deduction phases out by $100 for each $1,000 of MAGI above:
• $150,000 (all filers except married filing jointly)
• $300,000 (married filing jointly)

Married taxpayers must file jointly to claim it, and a valid SSN is required.

Self-employed workers are limited to the net income of the business in which the tips were received.

Not every amount labeled a "tip" qualifies. Eligibility depends on federal rules, including whether the tip was voluntary and whether your occupation is on the IRS/Treasury tipped-occupation list.

HOW IT WORKS

1. Download the XLSX, PDF and HTML files.
2. Log tips each shift by type.
3. Keep voluntary tips separate from service charges and automatic gratuities.
4. Complete the eligibility checklist.
5. Compare your log with your W-2 and 1099 forms.
6. Enter your MAGI to see an estimated potential deduction.
7. If you work overtime, track the qualified FLSA premium separately.
8. Review the year-end summary before filing or meeting with a tax professional.

Microsoft Excel is recommended. The XLSX file can be imported into Google Sheets, but some formulas, formatting and dropdowns may behave differently.

The HTML dashboard opens in any modern browser and works offline. Your data is stored on your device. It does not connect to the IRS, your employer, payroll or tax software. Use Export Backup regularly.

WHO IT'S FOR

• Restaurant servers and bartenders
• Hospitality and service workers who receive tips
• Eligible self-employed tipped workers
• Workers who want organized daily tip records
• Anyone preparing records for a tax professional
• Workers who also earn FLSA overtime

Listing an occupation here does not guarantee eligibility.

FAQ

Q: Does this make my tips tax-free?
A: No. This tracks a federal income-tax deduction that may apply to qualified tips. Tip income is still reportable, and Social Security and Medicare taxes still apply. State and local treatment varies.

Q: Does every tipped worker qualify?
A: No. Eligibility depends on the type of tip, your occupation, filing status, SSN, income and other federal rules. Check current IRS guidance before claiming the deduction.

Q: What is Code TP?
A: On 2026 W-2 forms, Box 12 Code TP reports cash tips you reported to your employer, and Box 14b shows your tipped occupation code. The workbook provides fields to record and reconcile both.

Q: What does the overtime section track?
A: Only the premium portion of FLSA-required overtime (the extra "half" in time-and-a-half), not every dollar of overtime pay. On 2026 W-2 forms it's reported in Box 12 Code TT.

Q: Does the estimator tell me exactly what to claim?
A: No. It gives an estimate based on the information you enter. Your actual deduction depends on federal law and your circumstances.

IMPORTANT

This product is an educational, organizational and recordkeeping tool. It is not tax, legal, accounting or financial advice and is not tax-return preparation software.

No deduction, refund, tax savings or eligibility result is guaranteed.

"No Tax on Tips" is the common name of a federal income-tax deduction. It does not mean tip income is excluded from all taxes.

Mandatory service charges and automatic gratuities should not be treated as qualified voluntary tips.

Tax rules, IRS guidance and forms can change. Verify current requirements with the IRS and consult a qualified tax professional before filing.

DIGITAL DOWNLOAD

Instant digital download. Nothing will be shipped.

You'll receive XLSX, PDF and HTML files. The dashboard does not submit tax forms, access payroll records or file a return.

Keep your own backups. For use by the purchaser only; please do not resell or redistribute.

HomeReadyToolkit
Practical systems for life's important transitions.