Self-Employed Tax & 1099 Tracker 2027: Excel & Google Sheets Bookkeeping for Freelancers
Stop dreading tax season. Keep your freelance, side-hustle or small-business numbers organized all year, so filing Schedule C is quick and quarterly estimated taxes never sneak up on you.
$12.99 one-time payment, instant download
Delivered as an instant XLSX/PDF download (available right after checkout).
What's included
- Income log with a 1099-expected flag and payment method.
- Expense log with a drop-down of IRS Schedule C categories (line numbers shown), business-use % and automatic 50% meals.
- Mileage log: odometer in, miles and deduction out (rate editable).
- Quarterly taxes: 2027 due dates (Apr 15, Jun 15, Sep 15, 2027 and Jan 18, 2028), profit per period, a suggested payment and live "due in X days / overdue / paid" reminders.
- 1099 check: compare 1099-NEC, 1099-K and 1099-MISC forms with your own records.
- Dashboard: monthly income, expenses, profit, category totals, a chart, estimated self-employment and income tax, and a "set aside %".
- Quick-start guide (PDF) plus a sample file and a blank file.
Who it's for
US freelancers, 1099 contractors, Etsy and Amazon sellers, rideshare and delivery drivers, creators and consultants.
Good to know
- Works in Excel and Google Sheets. No macros, no add-ons, no subscription.
- The mileage rate is editable: update it when the IRS publishes the 2027 standard mileage rate.
- Not tax advice: this is an organizing and estimating tool only, not tax, legal or financial advice. Verify with IRS.gov or a tax professional.