Simple Bookkeeping for Side Hustles: A Weekly System

By Cedar & Ledger · Updated October 31, 2026

When a side hustle is small, bookkeeping feels like overkill. Then tax time arrives and you're scrolling through a year of bank statements trying to remember which purchases were for the business. Simple bookkeeping fixes that, and "simple" is the key word: one account, one spreadsheet, a folder of receipts and about 20 minutes a week.

This guide sets up that system from scratch. It's written for side hustles like reselling, freelancing, crafts, tutoring, pet sitting or delivery driving: one person, one or a few income streams, no employees. If your business is bigger than that, the basics still apply, but you may want an accountant or accounting software sooner.

Step 1: Separate the money

The single biggest time-saver is keeping business money apart from personal money. Open a second checking account (many banks offer free ones) and, if you can, a card you use only for business purchases. Then:

• Have all side-hustle income paid into that account: platform payouts, client payments, cash you deposit.
• Pay business expenses from it, and nothing else.
• When you want to pay yourself, transfer money to your personal account and record it as an owner draw, not an expense.

If you can't open a separate account yet, you can still do this: tag business transactions in your spreadsheet as you go. It's just more work, and mistakes are easier to make.

Step 2: Choose a short list of categories

Categories are what turn a list of transactions into useful totals. Keep the list short. You want enough to answer "where does the money go?" and to match up with your tax return, but not so many that you hesitate over every entry.

A starting list for most side hustles:

• Income: Sales or Services (add one line per income stream if you have more than one), Refunds given (as negative income), Other income
• Expenses: Supplies and materials, Cost of items sold (for resellers), Platform and payment fees, Shipping and postage, Software and subscriptions, Advertising, Phone and internet (business share), Mileage or vehicle, Equipment, Education, Other

In the US, sole proprietors usually report business income and expenses on Schedule C, so it helps to name your expense categories in a way that maps to its lines. Check the current form instructions, or ask a tax preparer, rather than guessing what's deductible.

Step 3: Build a one-sheet ledger

Create a spreadsheet with a tab named Ledger and these columns:

Put your category list on a second tab called Categories and use Data > Data validation to turn the Category column into a dropdown that reads from it. Do the same for Type. Dropdowns are what keep the totals reliable: "Shipping", "shipping" and "Postage" would otherwise be three different categories.

Step 4: Record platform payouts the right way

This trips up a lot of sellers. Marketplaces and payment apps usually pay you a net amount after taking fees, but the income you report is generally the gross amount. Payment platforms and marketplaces may also report your gross sales to the IRS on a Form 1099-K, so your books need to match the gross figure.

So instead of one line for the payout, record two:

• Income: the gross sales for the period (from the platform's report or monthly statement)
• Expense: the platform and payment fees, in the "Platform and payment fees" category

The difference should equal what landed in your bank account. If it doesn't, there's usually a refund, a shipping label or an ad charge you haven't recorded yet. For Etsy sellers, the Etsy fee calculator shows how the fees on a single sale break down.

Step 5: Keep receipts where you'll find them

Make one folder in Google Drive, Dropbox or on your computer called "Business receipts 2026", with a subfolder for each month. When you buy something for the business, take a photo of the receipt or save the email as a PDF, and name it with the date, vendor and amount: "2026-11-03 Post Office 14.50.pdf". In the ledger, mark Receipt as Yes or paste a link to the file.

How long to keep records depends on your situation; the IRS publishes guidance on this, and many people keep business records for several years. How to organize business receipts has a fuller system.

If you drive for the business, keep a mileage log too (date, start and end location, purpose, miles). The mileage deduction calculator turns miles into an estimated deduction at the standard rate.

Step 6: The 20-minute weekly routine

Pick a fixed time, such as Sunday evening, and do the same four things every week:

1. Download or open the week's transactions from your business account, card and any platforms.
2. Add each one to the ledger with a category. If you're not sure, use "Other" and add a note; fix it later.
3. Match receipts to expenses and file any you haven't saved.
4. Move money for taxes into a separate savings account (see Step 8).

A week's worth of transactions for a small side hustle usually takes a few minutes. Skipping a month is what makes bookkeeping feel hard. Our weekly bookkeeping routine guide goes deeper on this habit.

Step 7: Add a monthly summary

Create a tab called Summary. In column A list your categories; across row 1 put the months (use the first day of each month as a date). Then, in B2:

=SUMIFS(Ledger!$E:$E, Ledger!$D:$D, $A2,
        Ledger!$A:$A, ">=" & B$1,
        Ledger!$A:$A, "<" & EDATE(B$1, 1))

Copy it across and down. Add a "Total income" row, a "Total expenses" row and a "Profit" row (income minus expenses). That's a basic profit and loss statement. Once a month, look at three numbers: profit, your biggest expense category, and whether profit is moving in the right direction. To sanity-check a month by hand, use the free profit and loss calculator.

Also check that the ledger agrees with the bank: the ending balance in your business account should equal the starting balance plus income minus expenses minus owner draws for the month. If it's off, something is missing. How to reconcile a business bank account walks through finding the gap.

Step 8: Set money aside for taxes

Side-hustle income usually doesn't have tax withheld, so you may owe income tax and, in the US, self-employment tax on your profit. Many people move a fixed share of each payout into a separate savings account during the weekly routine. The right share depends on your total income, deductions and where you live. How much side hustle money to set aside for taxes explains the main factors, and the side hustle tax calculator gives a rough estimate. If your side income is large, look into quarterly estimated payments.

Step 9: Close out the year

At year-end, your Summary tab already shows income and expenses by category for the whole year. Add up miles from your mileage log, collect any 1099 forms you receive and compare them to your ledger, and save the ledger, summary and receipts folder together. The tax prep checklist for side hustlers lists what to gather before you file or meet a preparer. Then make a copy of the spreadsheet for the new year and start fresh.

Prefer it set up for you?

Everything above works in a blank spreadsheet. If you'd rather start with the dropdowns, monthly summary and dashboard already built, the Small Business Bookkeeping Spreadsheet ($12, Excel and Google Sheets) has a transactions tab with room for 1,500 entries, a profit and loss that fills itself in by month and category, a dashboard, and a summary of the expenses you mark deductible. It's optional.

This is general information, not tax, legal or accounting advice. Tax rules depend on where you live and change over time; check official sources or a qualified professional.

Try the free profit and loss calculator →

Related template: read about the Small Business Bookkeeping Spreadsheet

See all Cedar & Ledger templates