How to Track Side Hustle Income With a Simple Spreadsheet

The simplest reliable way to track side hustle income is a spreadsheet with two tabs — one for money in, one for money out — updated in a fifteen-minute session once or twice a month. You don't need accounting software, a bookkeeper, or anything beyond the free spreadsheet app you already have; you need five columns, consistent categories, and the habit.

This article gives you the exact structure, the routine that keeps it current, and the handful of extras (mileage, inventory) that certain hustles need. Set it up once in twenty minutes and tax season stops being archaeology.

Why bother tracking at all

Three reasons, in ascending order of importance:

• You'll know if the hustle is worth it. Revenue is a vanity number. After platform fees, supplies, and mileage, a "$600/month" hustle might net $220 — worth knowing before you scale your hours into it.
• Deductions are money. Every legitimate business expense reduces your taxable profit, but only if you can find and prove it. Untracked expenses are a voluntary donation to the tax bill. The full picture of what you owe and why lives in our guide to side hustle taxes.
• The IRS expects records. Platforms report your gross payments on 1099 forms. If you're ever asked to support your numbers, "it's somewhere in my bank statements" is a bad place to stand. Your spreadsheet plus receipts is a perfectly acceptable bookkeeping system for a sole proprietor.

The two-tab spreadsheet

Create one spreadsheet per calendar year. Name it something like Side Income 2026. Two tabs.

Tab 1: Income

One row per payment received:

Rules that keep this tab honest:

• Record gross, not just the deposit. Platforms report gross to the IRS; if your records only show net deposits, your numbers won't reconcile with the 1099-K and you'll have silently hidden deductible fees. Gross in one column, fees in the next.
• One row per payment, entered from source records — platform dashboards, invoices, payment app history — not from memory.
• Cash counts. A $40 cash tutoring session goes in the sheet the same day. Cash is the easiest income to lose track of and the worst to reconstruct.

Tab 2: Expenses

One row per business purchase:

Pick 6–10 categories and stick with them all year — for most hustles: Supplies, Software/subscriptions, Fees, Equipment, Mileage/vehicle, Marketing, Shipping, Other. Consistent categories are what turn a pile of rows into a tax-ready summary; renaming them mid-year creates the exact mess you're trying to avoid.

Two supporting habits:

• Keep receipts digitally. Photograph paper receipts and drop them in one cloud folder per year. The spreadsheet says what happened; receipts prove it.
• Only business expenses. The blended personal-and-business purchase ("groceries plus printer paper") is the enemy — split it at entry time, or better, stop making blended purchases. This gets radically easier if hustle spending flows through a separate bank account for the hustle, which makes your bank statement a checklist for the expense tab.

The fifteen-minute monthly routine

The system lives or dies on cadence, not sophistication:

1. Pull up source records — platform dashboards, the hustle bank account, the receipt folder.
2. Enter the month's income rows, gross and fees, from the source records.
3. Enter the month's expense rows and match receipts.
4. Reconcile: does the sheet's net income roughly match what actually landed in the account? Chase any gap now, while you remember what it was.
5. Glance at the running totals (a SUM per column at the top of each tab is all you need): profit so far, and whether your tax set-aside is keeping pace.

Fifteen minutes monthly beats four hours quarterly and beats two lost weekends in April by a mile. High-volume hustles — resellers, or gigs that pay weekly with constant small deposits — may want a weekly five-minute version instead, because forty tiny payouts are miserable to reconstruct at month-end.

Add-ons for specific hustles

Mileage log. If you drive for the work — deliveries, supply runs, client visits — mileage is commonly among the biggest deductions available, and it requires a contemporaneous log: date, purpose, start/end odometer or miles. Add a third tab with those four columns, or use a mileage-tracking app and export it. Reconstructed-from-memory mileage is the classic disallowed deduction. This one matters enormously for delivery and rideshare work, where miles largely determine whether the hustle is profitable at all. The per-mile deduction rate changes yearly — as of 2026, check IRS.gov for the current figure.

Inventory tab (resellers). If you're flipping items for profit, you need to know what each sold item cost you. Add a tab: item, date acquired, cost, date sold, sale price. Your profit per item is the sale price minus cost minus fees minus shipping — and cost-of-goods records are exactly what separates "sold $8,000 on a 1099-K" from "made $2,300 in actual profit" when you file.

Invoice column (freelancers). If clients pay on invoices, add invoice number and paid/unpaid status to the income tab. Now the same sheet doubles as your who-owes-me tracker — the unglamorous backbone of freelancing.

When to graduate from the spreadsheet

The spreadsheet's honest ceiling:

• Fine indefinitely: one or two income sources, under roughly 30–40 transactions a month, no employees, simple or no inventory.
• Consider bookkeeping software when: you're invoicing many clients, transactions climb into the hundreds monthly, you have inventory across platforms, or you form an LLC with its own filing needs. Entry-level bookkeeping tools typically run in the $10–$40/month range — worth it when data entry time costs you more than that, and not before.
• Consider a tax professional when: profit reaches a level where quarterly estimates, retirement-plan contributions for the self-employed, or entity choices are in play. Good records make that conversation cheaper, because you're paying for advice instead of cleanup.

Note the trigger is volume and complexity — not income. A $3,000/month freelance hustle with four clients fits in a spreadsheet forever.

The bottom line

Two tabs, five columns each, gross income with fees broken out, consistent expense categories, receipts in a folder, fifteen minutes a month. That's a complete bookkeeping system for a typical side hustle — enough to know your real profit, claim every deduction, and back your numbers if anyone asks.

Tracking is one leg of the money side; the others are covered across the money management aisle — where the profit should go once you can see it (what to do with extra income) and how to keep the tax share separated before you spend it. Clean books make every other money decision easier, because for once you'll be deciding with real numbers.