1099 Tracker 2026 | Self-Employed Income, Expense & Mileage Spreadsheet with Quarterly Tax

Freelance, side hustle, Etsy shop or craft shows: if you get paid on a 1099 (or no form at all), nobody withholds tax for you. This tracker keeps your records in one place and shows roughly how much to put aside, before April surprises you.

- Income log with the form you expect: 1099-NEC, 1099-K, 1099-MISC or none

- Expense log in Schedule C categories, with business-use % for mixed costs and meals at 50%

- Mileage log that applies the 2026 IRS rate by trip date (72.5¢ to June 30, 76¢ from July 1)

- Simplified home office deduction ($5 per sq ft, up to 300 sq ft)

- Self-employment tax estimate (15.3% on 92.35% of profit, with the $184,500 Social Security wage base)

- Estimated extra federal income tax from the business, using 2026 brackets and the standard deduction (Single or Married filing jointly), plus your own state set-aside %

- Quarterly tab with the IRS periods, due dates (Apr 15, Jun 15, Sep 15, Jan 15), payments made and what is still to set aside

- Dashboard with totals by Schedule C line and warnings for rows missing a date, amount or category

Capacity: 500 income lines, 1,000 expenses, 500 trips. Fictional sample + blank copy.

What's included: Sample + blank XLSX; How to use, Dashboard, Settings, Income, Expenses, Mileage and Quarterly tabs; START-HERE guide.

Compatibility: Excel, LibreOffice Calc, Google Sheets (File > Import). No macros. Tested in LibreOffice.

Please note: A record-keeping and planning tool, NOT tax advice, and it does not file or pay anything. The estimate leaves out the QBI deduction, credits, Additional Medicare Tax, AMT and state rules, so it errs on the high side. Figures were checked on IRS.gov on 9 November 2026; confirm your own situation with a tax professional.

Digital download / refunds: Files only. UK consumers normally have 14 days to cancel; if you consent to immediate download and acknowledge losing that right, it ends when the download starts. Statutory rights for faulty or misdescribed content are unaffected.