If you sell on the side, the number that matters is not how much came in. It is how much you kept after platform fees, supplies, ads, and the other costs of doing the work. A spreadsheet is still one of the simplest ways to see that number clearly, as long as you log consistently and review it on a schedule.
In 60 seconds: Create one place to record every sale and every business cost. For income, log the date, where it came from, the gross amount, and any platform fees. For expenses, log the date, vendor, amount, and a category. Total those rows by month so you can see profit, not just revenue. A free one-tab tracker will do this for you; a fuller bookkeeping sheet adds fees, mileage, and a tax set-aside.
Why a spreadsheet still works
A shop dashboard is useful, but it is incomplete. It shows sales on one platform. It does not subtract packing you bought at the grocery store, a share of your software, or the miles you drove to the post office. If you sell in more than one place, you also have to add those reports together yourself.
One spreadsheet solves that. You keep a dated list you can open in Google Sheets or Excel and share with a tax preparer. It will not file a return or replace professional advice. Used well, it will stop April from becoming a shoebox problem.
What to log for every sale
Log income as soon as you can after the money is earned, not months later. One row per order, payout, or invoice is easier to audit than a monthly lump sum. Include at least:
- Date. Use the order or invoice date consistently. Dates are what later group income into estimated-tax periods.
- Source or platform. A dropdown beats free-typed names, because “etsy” and “Etsy.com” will not total together cleanly.
- Order or invoice ID so you can match a row to a payout report.
- Gross amount. What the buyer paid, including shipping you charged — not only the deposit that hit your bank.
- Platform fees for that sale. If the exact fee is not in yet, leave a place for it and update the row from the payout report. Do not guess.
- Net proceeds: gross minus fees. This is still not profit; expenses have not been subtracted.
If you sell on a marketplace, fees are often the first leak in a profit number. We walk through that in more detail in Etsy and marketplace fee tracking. The short version: always prefer the fee on your payout statement over a rule of thumb.
What to log for every expense
Business expenses belong in the same file, on a separate tab or in a clearly marked section. For each cost, record the date, vendor, amount, and a category you can total at year-end. Many sole proprietors later report these categories on IRS Schedule C, so stable names — supplies, advertising, software, shipping — make the hand-off easier. Note whether you saved a receipt, and add a short description when “misc” would not be enough.
Keep personal spending out of the business log. Some costs are only partly deductible — business meals are a common example under current federal rules — so the amount you paid and the amount you may deduct are not always the same. A spreadsheet can apply a percentage; it cannot tell you whether a cost is allowed. That is a question for a tax professional and current IRS guidance.
How to set up the sheet
You can start from a blank workbook or a template. Use one file per tax year, with a clear name, and work only in your copy. Two tabs — or one tab with an Income/Expense type column, as the free tracker uses — are enough to start. Freeze the header row, use dropdowns for platforms and categories, and delete any sample rows before you begin.
Add monthly totals for income, fees, expenses, and profit (a SUMIFS on the date column in Sheets or Excel). Then review once a month: add missing fees from payout reports, file stray receipts, and look at the profit number. If the number surprises you, that is the system working.
Profit is a formula, not a vibe
A useful monthly profit figure looks like this:
Gross sales − platform fees − business expenses − (mileage or other vehicle amounts you are tracking) = profit for the period.
People often stop after gross sales or a bank deposit. Both overstate the business. Deposits also skip unpaid payouts and can include transfers that are not income. Once you have a profit number you trust, you can decide how much to set aside for taxes. There is no official percentage; many self-employed people start with 25% to 30% of profit, then adjust with a professional. See how much to set aside for taxes as a side hustler (general information, not tax advice).
Common mistakes (and how to avoid them)
- Logging only what arrived in the bank. You will miss fees, pending payouts, and costs paid from a personal account.
- Waiting until tax season. Reconstructing a year of Etsy statements, PayPal exports, and receipts is possible. It is also miserable, and it is when errors creep in.
- Using too many slightly different category names. “Shipping,” “Postage,” and “USPS” will not add up unless you standardize.
- Forgetting marketplace ads, subscriptions, and listing fees. These are easy to overlook because they are deducted automatically or charged on a different date than the sale.
- Skipping mileage. If you drive for the business, a contemporaneous mileage log is separate from the income and expense log. See how to track mileage for side gigs. The IRS publishes a standard mileage rate; it changes, and a good template lets you edit it.
- Treating the spreadsheet as tax advice. It is a record. Your facts, your state, and current law decide what you owe.
When to move beyond a one-tab log
A simple tracker may be all you need if you have one sales channel and a preparer who only wants monthly totals. Upgrade when you sell on more than one platform, want fee estimates next to each sale, or need mileage, a quarterly set-aside, and year-end totals grouped like IRS Schedule C in the same file. That is the job of the 2027 Side Hustle Bookkeeping Tracker. Every fee rate in it is editable, because platforms change their pricing.
A simple way to start this week
- Download a template or open a blank workbook and save a copy for the current year.
- Enter last month’s sales from each platform’s payout or order report, including fees.
- Enter last month’s business expenses from receipts and statements.
- Check the monthly profit figure. If it feels too high, you probably missed fees or costs. If it feels too low, check for personal items that do not belong.
- Put a repeating reminder on your calendar for a short monthly review.
You do not need a perfect system on day one. You need one file, honest numbers, and a habit of keeping them up to date. The rest — fees, mileage, tax set-asides — can be added as the hustle grows.
Frequently asked questions
Do I need accounting software to track a side hustle?
No. A well-built spreadsheet is enough for many sole proprietors and small sellers, especially in the first years. Software can help later if you have employees, inventory across many channels, or a bookkeeper who prefers it. The important part is a complete, consistent log.
Can I use Google Sheets instead of Excel?
Yes. If you start with an .xlsx file, upload it to Google Drive and choose File, then Save as Google Sheets. Work only in your copy. The free Margin Map Co. tracker is built to work in both.
Is a spreadsheet the same as filing taxes?
No. A spreadsheet is a record-keeping tool. It organizes numbers you can hand to tax software or a preparer. It is not a tax return and it is not tax advice.
Disclaimer. This article is for general information only. It is not tax, legal, or accounting advice. Margin Map Co. is not a tax preparer. Rules depend on your situation and current law. Check IRS.gov and consult a qualified professional before you act.