AnalystBuilt home Etsy shop

Bundles

Side Hustle Tax Kit

A 1099 tax tracker, an invoice tracker and a gig driver log: three spreadsheets for one side hustle tax year

from $24.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

A side hustle tax year has three moving parts: clients who pay late, app shifts that cost you miles, and estimated taxes due four times a year. This kit gives each part its own spreadsheet. A 1099 tax tracker for forms, quarterly estimated payments and deductions, an invoice tracker that shows who still owes you, and a gig driver tracker that turns your shifts into real pay per hour and work miles.

Made for US freelancers, 1099 contractors and gig drivers who mix client work with driving for apps.

What's included

  • Self-Employed Tax Tracker 2027, our 1099 tax tracker

    Where tax time comes together. List every client and app that pays you, and it shows which 1099s to expect, which have arrived and whether each one matches your own income records. Plan four quarterly estimated payments for federal and state, set money aside at your own %, sort costs by Schedule C line, keep your mileage log for taxes, and print a one-page summary and a document checklist for your tax preparer. 10 tabs.

  • Invoice & Receivables Tracker

    For your client work. Log invoices and partial payments, print an itemized invoice, copy a polite reminder email, and see what's overdue, who to follow up with today and which clients pay slowly. 8 tabs.

  • Gig Driver Mileage & Earnings Tracker

    For driving. One row per shift with miles, hours, pay, tips and app fees. It works out what you keep per hour and per mile once fuel, upkeep and wear are paid for, maps your best days and hours, compares your apps and totals your work miles by week and month. 8 tabs.

Why the set

  • Every payer in one check: log client payments and app payouts in the Tax Tracker's Income tab and each 1099 is compared with your own total
  • A simple weekly routine: bill clients, log shifts, then bring the week's payouts, miles and work costs into the Tax Tracker
  • Set money aside as you earn and see each quarterly payment as Paid, Due soon, Partial or Late
  • One color rule in all three files: cream cells for your numbers, gray cells for formulas
  • Made by a data analyst: every number is a formula you can trace. No subscription, no bank or app linking

How you get it

  1. Download on Etsy

    Buy the set on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download
  2. Make a copy

    Click each MAKE A COPY button in the PDF, one per spreadsheet: your copies are saved to your Google Drive. Prefer Excel? Open the .xlsx files.

    How to make your copy
  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets links + quick guide
  • side-hustle-tax-kit-excel.zip — Excel versions, one folder per template

Good to know

  • Three separate files that each work on their own; nothing is linked between them. START-HERE.pdf shows which totals to copy across and when.
  • Each file has its own made-up sample data (a freelance designer, a design studio and a driver), so the numbers in the photos don't match from file to file. Clearing the samples takes a few minutes.
  • Set-aside amounts and planned payments use percentages you choose. They are a planning estimate, not a tax calculation, so check with a tax professional.
  • The Gig Driver Tracker uses miles and US dollars; you type your own app names. Not affiliated with any rideshare or delivery company.
  • Already own the 1099 Tax Tracker? The Invoice Tracker and the Gig Driver Tracker are also sold on their own.
  • Best on a computer; the Google Sheets phone app is fine for checking numbers.
  • Using a Mac?
  • For use in one business. Please do not resell or share the files.
  • Listing images show real screenshots of these templates with sample data.

Record-keeping and planning tools, not tax, accounting or financial advice.

Designed by me with the help of AI tools.

Templates in this set