Guides

Side Hustle Income Tracking Spreadsheet

Updated November 18, 2026 · A GigBuffer guide

When income comes from three apps, a few marketplace sales, and the odd client invoice, it is hard to answer a simple question: what did you actually make? Each platform has its own dashboard, its own fees, and its own idea of a “week.” A bank deposit may not match the number on the screen. A year-end form may not match either one. A single spreadsheet will not file your taxes, but it will stop you from budgeting on a number that was never yours to spend.

This guide is a practical way to track side-hustle and gig income in one place. It is general information, not tax, financial, or legal advice. It will not tell you what you owe or which expenses you can deduct. Confirm current reporting rules on IRS.gov or with a qualified professional. GigBuffer is not affiliated with Uber, DoorDash, Lyft, Instacart, or any other platform.

Why one log beats five dashboards

Platform summaries are useful, and they are incomplete. They may show gross fares but not the amount that landed in your bank. They may show “online miles” that do not match a full business-mileage log. They may hide tips, bonuses, or instant-cashout fees in a different view than payouts. If you work more than one app in the same week, none of them will add the week up for you.

A year-end information form is also not a profit-and-loss statement. Platforms may issue a Form 1099-K, a Form 1099-NEC, or related statements, depending on the work and the current IRS reporting rules. Those forms are starting points for a return, not a complete picture of net income after expenses. Read the current IRS pages for the forms that apply to you rather than assuming last year’s threshold or format still holds.

Sources: Understanding your Form 1099-K; About Form 1099-NEC; Topic no. 305, Recordkeeping.

Topic no. 305 says that if you are in business, there is not one required bookkeeping method, but you must use a method that clearly and accurately reflects gross income and expenses, and the records should substantiate both. A spreadsheet you actually fill in meets that idea better than a pile of screenshots in a camera roll.

What to record on each line

You do not need a complicated workbook to start. One row per payout, shift, or invoice is enough, with the same columns every time:

  • Date of the work or of the deposit — pick one convention and stick to it. Many people log the work date and separately record when the money arrived.
  • Source — the platform, client, or shop, so you can total by stream at month end.
  • Gross earnings — the amount attributed to the work before platform fees, if you can see it.
  • Fees and cashout charges — commissions, instant-pay fees, boosts you had to qualify for, payment processing.
  • Tips, if they are reported separately, so gross and net do not get blurred.
  • Net deposit — what actually arrived in the bank. This is the number a household budget can use.
  • Business miles and a brief note of purpose, if you drive for the work. See standard mileage vs actual expenses for how the IRS frames the two methods; a log is useful either way.
  • Other expenses paid that day or week — supplies, parking, a phone mount, a platform bag — with a receipt saved alongside the row.
  • A tax set-aside transfer, if you use that habit: the amount you moved, which is a planning number you chose, not a tax bill.

At the bottom of the week or month, add gross, fees, net, miles, expenses, and transfers. Net deposits minus cash expenses is a rough picture of cash left over. It is still not a taxable-profit figure. Mileage and other deductions, self-employment tax, and withholding from a W-2 job all change what a return will show. The log’s job is to make those later questions possible.

Gross, net, and the deposit that surprised you

Three numbers get mixed together constantly:

  • What the customer paid, or what the platform shows as earnings.
  • What you received after fees.
  • What a 1099 later reports.

If you budget from the first number, you will spend fees you never received. If you ignore the third number until April, you may be reconciling a form against a year of missing rows. Logging gross, fees, and net on the same line takes a few extra seconds and saves a weekend in January. When a deposit does not match the app, write the difference down the same day (a cashout fee, a hold, a tip that posted late) instead of assuming you will remember.

If you can, use a separate account or at least a separate tag for hustle deposits and hustle spending. Topic no. 305 does not require a particular bank setup, but a clean trail is easier to explain — to yourself mid-year, and to a professional at filing time.

A weekly habit that fits after a shift

A log that is a week late becomes a reconstruction project. A routine that can fit in ten minutes, on the same day each week:

  1. Export or screenshot each platform’s weekly summary, and save the file where the spreadsheet lives.
  2. Enter one row per source (or per shift, if you prefer that grain).
  3. Enter miles from your log, not only from the app’s total, if you are keeping a mileage record.
  4. Enter expenses from receipts in your wallet or email.
  5. Compare total net deposits in the sheet with the bank account.
  6. If you set money aside for taxes or for a slow-month buffer, record the transfer and move the money the same day.

If you skip a week, start again with the current week and backfill from the exports you saved. You do not have to make the sheet beautiful. You have to make it complete enough that a monthly total is trustworthy.

For the household side — bills, a conservative “pay,” and a buffer for uneven weeks — see How to budget on irregular income. For IRS estimated-tax due dates, see quarterly estimated tax deadlines for gig drivers.

A free CSV total, and a spreadsheet if you want the year in one file

GigBuffer is a free, private, in-browser earnings calculator for gig drivers. Upload an Uber, DoorDash, Lyft, or Instacart CSV to see weekly and monthly totals, a mileage estimate using IRS standard mileage rates, and a slow-month pay figure. Your file never leaves this device. It is a fast way to total a platform export. It is not a full-year book for every side hustle you have, and it is not a tax engine.

If you want a workbook you can keep across platforms and months, the Side Hustle Income & Mileage Tracker (Excel + Google Sheets) is built for that job: income, expenses, and business miles in one place, with a dashboard and a tax set-aside you choose. Treat it as a record. The official rules, and the numbers on a return, still live on IRS.gov and with whoever helps you file.

Keep every app in one workbook

The Side Hustle Income & Mileage Tracker (Excel + Google Sheets) logs income, expenses, and business miles with a dashboard. If you just need to total a gig-platform CSV in your browser, start with free GigBuffer.