1099 Tax Tracker Spreadsheet, Mileage Log, Self Employed Quarterly Tax Estimator, Schedule C Expense Tracker, Rideshare, Phone Sync

Works on your phone AND your computer: edits sync automatically through Google Drive (Google Sheets) or OneDrive (Excel), so you log a payment, expense or trip once and see it everywhere.

Self-employed? Stop guessing what you owe. The 1099 Side-Hustle Tax & Mileage Tracker logs your income, expenses and business miles, sorts them by Schedule C line, and estimates your self-employment tax, income tax, take-home and quarterly 1040-ES payments - automatically. Built for 1099 contractors and consultants (oilfield and field service too), rideshare and delivery drivers, and anyone with a side hustle.

WHAT'S INCLUDED
- Excel edition (.xlsx, no macros) - Excel on Windows/Mac + the Excel phone app (sync through OneDrive)
- Google Sheets edition - a 'Make a copy' link (in the included PDF) that saves your own copy to Google Drive and the Google Sheets app
- Quick-start PDF guide (setup, phone & computer sync steps, every tab explained)
- Step-by-step 'Phone & Computer Sync' tab inside the file

FEATURES
✔ Income Log - client/platform dropdown, gross, platform fees, 1099-NEC / 1099-K / 1099-MISC flag
✔ Expenses - Schedule C categories with line numbers, business-use %, receipt Y/N (missing receipts highlighted), meals auto-limited to 50% (80% option for DOT hours-of-service)
✔ Mileage Log - odometer start/end or just miles, purpose, client, parking & tolls; IRS rate picked by date (2026: 72.5¢ Jan-Jun, 76¢ from Jul 1 - both editable)
✔ Per Diem & Travel - enter your GSA M&IE rate, 75% first/last travel day rule, meal-limit applied
✔ Quarterly Taxes - 1040-ES due dates, pay-as-you-earn payment estimates, paid tracker, status colors (Paid / Due soon / Past due), set-aside progress bar + chart
✔ SE tax at 15.3% on 92.35% of profit with an editable Social Security wage base ($184,500 for 2026)
✔ Your own federal & state % (blank until you enter them - no made-up rates)
✔ Clients tab - payments, gross, fees and miles per client to match your 1099s in January
✔ Year-End Summary - net profit, Schedule C line totals, mileage deduction, estimated tax and take-home, income-by-month chart, deductions donut, data bars. Print it for your tax preparer
✔ Mobile Entry + Mobile Dashboard - log income, expenses or miles in seconds; next payment, set-aside and profit at a glance
✔ Locked formulas (no password), cream input cells, EXAMPLE data you can clear

HOW IT WORKS
1. Download and open the Excel file, or click the Google Sheets link and Make a copy.
2. Settings: tax year, your clients/platforms, your tax rates when you know them.
3. Log as you go - on your phone or computer.
4. Check Quarterly Taxes before each due date. At year end, print the Year-End Summary.

IMPORTANT
This is a digital download - nothing will be shipped. Estimates for planning only - NOT tax, legal or accounting advice; it does not file anything. Tax rates, rules and due dates change every year - check irs.gov and a tax professional. Mileage and wage-base values are editable so you can update them each year. Requires Excel 2016 or newer or Microsoft 365 (including the Excel app) or a free Google account. Not affiliated with the IRS, Uber, DoorDash or Etsy.