How to Build a Side Hustle Income Tracker in Google Sheets

Quick answer. A side hustle income tracker in Google Sheets has four working tabs: an income log, an expense log categorized to Schedule C lines, a tax set-aside that pulls a percent of every deposit, and a dashboard that surfaces three numbers a personal budget hides - net profit, tax owed, and implied hourly rate. The hourly rate number is the one most side hustlers have never calculated. It is often surprising.

A side hustle that lives inside a personal budget tends to disappear into it. The $850 from a weekend freelance gig hits checking, gets absorbed into groceries and rent, and by April the bookkeeping question is “how much did this thing actually make me, and what do I owe on it?” Most side hustlers without a separate tracker answer that with a shrug.

The structure that fixes this is a small spreadsheet with four tabs. It does three things a personal budget cannot: it isolates revenue and expenses from household money, it pulls a tax cut off every deposit, and it tells you what the work pays per hour.

Why side income deserves its own tracker

The IRS Schedule C is the form sole proprietors file with their 1040 to report business income and loss (source). If a side hustle earns net more than $400 in a year, the IRS expects a Schedule C and a Schedule SE for self-employment tax, which runs 15.3 percent on top of regular income tax (source).

Two practical consequences:

• The categories on Schedule C are the natural categories for an expense log to use from day one. Rebuilding categories in March costs hours.
• Self-employment tax is a real line item, separate from income tax. A side hustler with $20,000 in net SE earnings owes roughly $2,800 in SE tax (15.3 percent on 92.35 percent of net) before any income tax. A personal budget has no place to surface this.

A separate tracker isolates the math. Revenue, expenses, tax obligation, and effective hourly rate all live in one place that you can look at in 30 seconds.

A worked example: weekend graphic design

We will use the same example throughout. Maya, a marketing manager with a day job, takes on freelance graphic design on weekends. Three to four clients a month, mostly logo refreshes and social media kits. Five months of activity.

Totals over five months: $13,850 gross, $1,170 expenses, 124 hours. We will return to these numbers in the dashboard and hourly rate sections.

The four tabs

Tab 1: Income log

One row per deposit. Not one row per invoice - that lives elsewhere if you need it. The income log is cash, because cash is what the IRS taxes for most sole proprietors.

Three things to flag here:

• The Platform fees column captures Stripe’s 2.9 percent plus 30 cents, PayPal’s percentages, Wave’s flat fee per ACH. Skip this column and effective revenue looks bigger than it is.
• Tax set-aside is the dollar amount that moves to a separate account on the day of the deposit. The percent comes next.
• After-tax net is what counts as “income” everywhere downstream. The household sees this number, not the gross.

Tab 2: Expense log

One row per business expense. The Category column is the single most important field, and it maps directly to Schedule C lines.

Common Schedule C categories for a side hustle (Part II of the form):

Sticking to these categories from the first transaction means that, at year-end, the totals copy line-by-line into tax software. Rebuilding them in February is an avoidable tax-prep tax.

Tab 3: Tax set-aside

The tax set-aside is the mechanism that prevents an April surprise. The principle is simple: every time money lands, a percent of it moves into a separate tax savings account before any of it is treated as income.

The percent is the open question. Common guidance ranges from 25 to 35 percent, and the right number depends on the filer’s federal bracket, state tax, self-employment tax, and any business deductions. A first-year side hustler in a state with income tax often lands in the higher half of that range. A low-income year with significant deductions can land in the lower half. The exact number is a tax-planning question, not a budgeting one.

A simple structure for the tab:

Two columns matter most: the running balance, and the variance against actual quarterly estimates paid. If the balance grows faster than estimates draw it down, the percent may be conservative. If the balance keeps going negative against estimates, the percent is too low. For a fuller walkthrough of estimated-tax math, the Quarterly Estimated Tax Spreadsheet post covers the safe harbor rule and a worked example.

The deposit-by-deposit mechanic is the part that works. Money sitting in operating cash starts to feel spendable. Money in a labelled tax savings account does not.

Tab 4: Dashboard

The dashboard is the 30-second view. It pulls from the three logs above.

Net profit is gross revenue minus platform fees minus business expenses. Take-home is net profit minus the tax set-aside, which is the number Maya actually sees in her household budget. Effective hourly is take-home divided by hours worked.

Hourly rate: the calculation most side hustlers skip

A logo project priced at $1,400 sounds like good money. That same project, once it takes 18 hours of design, two rounds of revisions, and three hours of email, is roughly $67 per hour before expenses, before taxes, before the platform fee. Take-home is closer to $40 an hour.

The math:

1. Project revenue minus platform fee minus direct expenses = net project revenue.
2. Net project revenue minus tax set-aside = take-home from this project.
3. Take-home divided by total hours worked = effective hourly rate.

For Maya’s full five months: net profit $12,264, minus tax set-aside $3,678, equals take-home $8,586. Divided by 124 hours, the effective hourly rate is roughly $69.

That number is information, not a verdict. Some questions it answers:

• Would Maya accept $69 per hour for a regular job in this field? If yes, the side hustle is paying competitively. If no, the work is underpriced or the time estimate is off.
• Which clients pay the highest effective rate? The income log paired with a Project hours column shows that. Some clients pay 2x the rate of others on the same kind of work.
• Are revisions eating the margin? If quoted hours are 8 and actual hours are 18, the implied rate on that project drops by half. That is a pricing signal, not a willpower problem.

The point of tracking hours is not virtue. Tracking hours shows whether the implied hourly rate matches what you would accept for a regular job. That is information you can use to decide whether to raise prices, drop a low-margin client, or simply stop quoting jobs that take twice as long as planned.

Per-client profitability

A column called Project hours on the income log enables per-client analysis. Sum revenue by client, sum hours by client, divide. The result is sometimes a sharp contrast.

A small example, three of Maya’s clients over the five months:

Bright Coffee and Mednet pay roughly the same hourly. Northbridge pays 40 percent less for the same kind of work. That is a number worth seeing once a quarter, even if no immediate decision follows.

The 1099 reconciliation at year-end

In January, payers send 1099-NEC forms for any contractor they paid $600 or more during the year. The IRS expects the numbers on those forms to match what gets reported on Schedule C.

The income log is what makes that reconciliation a 20-minute task instead of a frantic afternoon. Filter the log by Client, sum the Gross amount column for the year, and compare to the 1099-NEC totals as they arrive. If the spreadsheet shows $7,400 from one client and the 1099-NEC shows $6,800, one of them is missing a payment. Catching this in January is much easier than catching it in April with a tax preparer waiting on a number.

A side note: not every client sends a 1099. Income under $600 from a payer often arrives with no form. It is still income, still taxable, and still belongs on Schedule C. The spreadsheet is the record of total income, regardless of how many 1099s arrive.

For the broader deduction map, see 25 Self-Employed Tax Deductions for 2026, which covers home office, vehicle, health insurance, and retirement contributions in detail.

When household and side hustle interact

The side hustle tracker handles the business side. The personal budget handles the household side. They meet at one number: the take-home that transfers from the side hustle’s holding account into household checking.

How that meeting point usually looks:

• Stable side hustle income: the household budget can treat it like a second paycheck.
• Lumpy month to month: the baseline method works the same as it does for full-time freelancers. Pay yourself a fixed monthly amount, let the variance live upstream in a holding account. The budget for irregular income post walks through the four-tab structure for that.
• Growing toward primary income: the same spreadsheet structure scales. The income log gets longer, the expense log adds rows, and the tax set-aside percent may need to rise as bracket rises. The framing changes more than the spreadsheet does.

For the freelancer-side cash flow piece that tracks invoiced revenue against payment timing, see Freelancer Cash Flow Spreadsheet: Monthly Reconciliation in 15 Minutes.

When the side hustle outgrows the spreadsheet

Signals the spreadsheet is straining:

• More than 20 clients per month, with multiple invoices each. Invoice management starts to want a dedicated tool.
• Inventory tracking. Spreadsheets handle revenue and expenses well. Cost of goods sold with units is harder.
• Payroll. The first 1099 contractor is fine in the expense log. The first W-2 employee usually means a payroll service.
• Multi-state tax exposure. Selling across state lines into sales-tax-collecting states adds complexity that accounting software handles better.

Below those thresholds, a spreadsheet usually wins. Lower cost, more flexible reports, faster setup, and the categories already match Schedule C.

Templates that fit

• “I want a free starting point for tracking 1099 income from multiple payers” - The free 1099 Income Tracker covers the income log side with a single sheet and sample data. Good fit for a side hustle with two or three clients and no expense complexity.
• “I want invoices, payments, expenses, and a 12-month forecast in one workbook” - The Cash Flow Forecast template is the paid version with all the structure above plus a forward projection and A/R aging. Fit when the side hustle is growing past two or three clients.
• “I want Schedule C categories with quarterly estimate math built in” - The Annual Tax Planner pairs with either of the above and handles the year-end tax view across both personal (Schedule A) and business (Schedule C) deductions.

The paid templates use the same Schedule C category structure, so they line up against each other as a side hustle bridges into a small business.

Related

• Freelancer Cash Flow Spreadsheet: Monthly Reconciliation in 15 Minutes
• 25 Self-Employed Tax Deductions for 2026
• How to Budget with Irregular Income in Google Sheets