TToolWise Digital This on Etsy →

Catalog

1099 & Self-Employed Tax Tracker

Instant download Secure checkout Google Sheets & Excel Formula guarantee

Secure one-time checkout by Stripe — instant download. Also available on Etsy.

Every 1099 payment by payer, every deductible expense, the mileage at the right IRS rate — and exactly what to set aside each quarter, calculated from your own numbers instead of a "save 30%" guess. Built for freelancers, contractors, gig workers and anyone who gets paid on a 1099 and dreads April.

What’s inside

  • Income — 400 rows, payer dropdown (list your payers and platforms once), payment method; by month, quarter, year and payer
  • 1099 Forms — for each payer: what you logged vs the amount on the 1099-NEC or 1099-K they sent, the difference, and a status: matches / MISMATCH / not received yet / no form expected (under $600)
  • Expenses — IRS Schedule C categories in a dropdown, a deductible % per row (meals 50%, a shared phone 60%), deductible amount calculated; by category with a chart
  • Mileage — odometer in, deduction out; only Business deducts; both 2026 IRS rates (72.5¢ to 30 June, 76¢ from 1 July) picked by trip date
  • Dashboard — income, deductions, net profit, set-aside for the year and per week, 1099 forms expected, mismatches to chase, business miles
  • Quarterly — self-employment tax (12.4% Social Security to the 2026 $184,500 wage base, applied cumulatively, + 2.9% Medicare on 92.35% of profit), the half-SE deduction, federal + state set-aside, 1040-ES payments made vs still to pay, optional prior-year safe-harbour floor
  • Start Here tab, printable Quick-Start guide, Sample + Blank copies, and a free phone calculator (nothing uploaded)
  • 68 automated formula checks passed before listing; Google Sheets or Excel

Who it's for: anyone paid on a 1099 — designers, developers, drivers, consultants, marketplace sellers — who wants a real set-aside number each quarter and a clean Schedule C in April.

The 1099 reconciliation is the part nobody else does: the IRS gets a copy of every form, so a payer's form that says more than you logged is caught before you file. $12.99, one-time.

Sheets + Excel

Works in free Google Sheets or Microsoft Excel — your choice.

Free phone tool

Includes a browser version so you can use it on the go.

Instant download

Delivered the moment you buy. Nothing shipped.

Formula guarantee

If a formula doesn't work as described, we fix it or refund you.

Questions

How is the quarterly set-aside calculated?

Each quarter's net profit flows in from the Dashboard. The sheet applies 92.35% of it to self-employment tax (12.4% Social Security up to the 2026 $184,500 wage base, applied cumulatively across quarters, plus 2.9% Medicare), takes the half-SE deduction, then adds the federal and state income-tax percentages you set. Estimated payments are due 15 April, 15 June, 15 September 2026 and 15 January 2027. It is an estimate, not tax advice.

What is the 1099 Forms tab for?

Payers must send a 1099-NEC (or a platform a 1099-K) when they pay you $600 or more, and the IRS gets a copy. The tab compares your own log per payer with the form they sent and flags a mismatch, a form still missing, or one not expected — so you chase it before you file, not after a notice.

Does it cover the mid-year mileage rate change?

Yes. 72.5¢ per business mile through 30 June 2026 and 76¢ from 1 July (IRS Announcement 2026-11); the sheet picks the rate by trip date and both rates are editable for next year.

More from the shop

Browse the full catalog

See all 328 tools →