Guides › Side Hustle Income Tracker Spreadsheet: A Complete Setup

Side Hustle Income Tracker Spreadsheet: A Complete Setup

Side income tends to arrive from several places at once: a marketplace payout, a client transfer, a few digital sales, a tutoring session paid in cash. Without a simple record it is impossible to know whether the hustle is actually profitable, and tax time becomes a scramble through old emails. This guide sets up a side hustle income tracker in Google Sheets or Excel with four tabs that take less than ten minutes a week to maintain.

What the tracker needs to answer

Before building anything, decide what you want to know each month. For most side hustles it comes down to five questions:

1. How much money came in, and from which source?
2. How much went to fees, materials and tools?
3. What is left as profit?
4. How much of that should be set aside for tax?
5. How many hours did it take, and what is the real hourly rate?

Every tab below exists to answer one of these. Anything that does not help answer them is optional.

Tab 1: Income

One row per payment received. Columns:

• Date received: the date the money reached your account, not the sale date. This keeps the sheet in line with your bank statement.
• Source: a dropdown of your platforms and clients (Etsy, Fiverr, Client A, Cash…). Using data validation keeps names consistent, which the summary relies on.
• Gross: the amount before fees, from the platform's statement.
• Fees: platform, payment and payout fees for that payment.
• Net: =C2-D2. This should match what landed in your bank.
• Note: invoice number, order ID, anything that helps you find the original record.

Many platforms let you download a monthly CSV. Paste it into a scratch tab and copy the totals over, rather than entering every tiny sale by hand.

Tab 2: Expenses

Columns: Date, Vendor, Category (dropdown), Amount, Receipt link. Keep categories few and stable: Materials, Shipping, Software, Advertising, Equipment, Education, Other. If you later need tax categories specific to your country, you can map these onto them. Store a photo or PDF of each receipt in a cloud folder and paste the link into the last column. That single habit will save you hours if you ever need to justify an expense.

Only include expenses that are genuinely for the side hustle. If something is used for both personal and business purposes, such as a phone, rules on what can be claimed differ by country, so check your tax authority's guidance before you record a share of it.

Tab 3: Hours

Columns: Date, Task, Minutes. Record in fifteen-minute blocks; minute-level precision is not necessary and makes the habit harder to keep. Include all work: production, listing, customer messages, packing, learning and bookkeeping. This tab is what turns profit into a real hourly rate, and it is often the most eye-opening one.

Tab 4: Monthly summary

Put the months January to December in column A (as real dates, the first of each month). Then:

• Revenue: =SUMIFS(Income!C:C, Income!A:A, ">="&A2, Income!A:A, "<"&EDATE(A2,1))
• Fees: same formula on column D.
• Expenses: same pattern on the Expenses tab amount column.
• Profit: Revenue − Fees − Expenses.
• Tax set-aside: =MAX(0, Profit) * $H$1, where H1 holds your set-aside percentage.
• Hours: the SUMIFS of minutes for the month, divided by 60.
• Hourly rate: =IF(Hours=0, 0, (Profit − Tax)/Hours).

Add a total row and a simple column chart of profit by month. To see the result for a single month without a spreadsheet, try our side hustle profit calculator.

Setting money aside for tax

Side income is taxable in most countries, and usually nobody withholds that tax for you. The safest habit is to move the set-aside percentage into a separate savings account every time a payment arrives, not at the end of the year. What percentage to use depends on where you live and your total income, so check the official guidance from your tax authority or ask a professional. Some countries also have thresholds below which side income does not need to be declared, or must be declared differently; these rules change, so check the current year's guidance rather than relying on a blog post. Our freelancer tax set-aside guide explains the payment-by-payment method in detail.

Reading the numbers

After two or three months the summary tells a clear story. Look for:

• Revenue concentration: if one platform or client is most of your income, that is a risk worth knowing about.
• Fee creep: fees as a percentage of revenue. If it is climbing, a platform may have changed its pricing, or you may be selling more low-price items.
• Hourly rate trend: a rising rate means you are getting faster or charging more. A falling rate is a signal to reprice or drop the least profitable work.

Keeping the money separate

Using a separate bank account for the side hustle, even an ordinary free personal account, makes the tracker far easier. Every transaction in that account belongs on the sheet, and reconciliation is a matter of checking the balance matches. It also makes it obvious when you are subsidising the hustle from your personal money.

Weekly routine

Pick a fixed time, such as Sunday evening, and spend ten minutes: add new payouts and fees, add expenses with receipt links, add the week's hours, and transfer the tax set-aside. Monthly, glance at the summary. Quarterly, compare it with your goals. That is the whole system.

When a spreadsheet is no longer enough

A spreadsheet comfortably handles a side hustle with a few dozen transactions a month. If you start issuing many invoices, holding inventory, or registering a business, accounting software or an accountant may be worth it. Until then, a clean sheet is cheaper and teaches you your numbers. If you invoice clients, the Freelancer Income Tracker template adds invoice status, overdue tracking and a tax set-aside column out of the box.

Checklist: setting up in one evening

1. Create the four tabs: Income, Expenses, Hours, Summary.
2. Add dropdowns for sources and expense categories.
3. Enter this year's payouts so far from platform statements.
4. Add expenses with receipt links.
5. Estimate hours for past months, then record precisely from now on.
6. Set your tax set-aside percentage and transfer any amount you are behind on.

FAQ

What should a side hustle income tracker include?

Income by source with fees, expenses by category with receipts, hours worked, and a monthly summary of profit, tax set-aside and hourly rate.

Should I record gross or net income?

Record both. Gross minus fees should equal what reached your bank account. Tax rules usually look at gross income and allowable expenses.

How much should I set aside for taxes?

It depends on your country and income. Check your national tax authority or a tax professional, then set the percentage in the sheet.

Do I need a separate bank account?

It is not always required, but a separate account makes tracking and reconciling much easier.

Will this work in Excel and Google Sheets?

Yes. SUMIFS, EDATE and data validation are available in both.

For general education and planning only. Not financial, tax or legal advice. Check important decisions with a qualified professional.