TRACK 06Money & legal · Lesson 2 of 8

Simple bookkeeping for side hustles

A plain system for tracking side hustle money with a separate account, a simple spreadsheet, saved receipts and a monthly review.

"Bookkeeping" sounds like a guy in a green visor counting coins by candlelight. For a side hustle, it's a lot less dramatic. It's just writing down money that comes in, money that goes out, and keeping proof.

That's it. You don't need fancy accounting software to start. You need a separate bank account, a spreadsheet, a folder for receipts, and a few minutes on a regular schedule.

By the end of this, you'll have a simple system you can set up in an afternoon and keep up with in a few minutes a week. It won't make you an accountant. It will make you the kind of person who knows where their money went.

The short version

  • Open a separate bank account for your side hustle so business money and personal money stop mixing.
  • Write down every dollar in and out in a simple spreadsheet, and save a receipt for each one.
  • Set money aside for taxes as a habit, and review your numbers once a month.

Step one: get a separate bank account

This is the single most useful thing you can do, and it's not even bookkeeping yet.

When your side hustle money lands in the same account as your groceries, rent and streaming services, sorting it out later is miserable. You end up scrolling through months of bank statements trying to remember whether that charge was a business tool or a pizza.

A separate account fixes that. Business money goes in. Business expenses come out. Everything else stays in your personal account.

What kind of account?

Some people open a business checking account. Some sole proprietors just open a second personal checking account and use it only for the side hustle. Banks and credit unions have different rules, requirements and fees, so ask yours what they offer and what they need from you.

Then connect that account to your payment processor for payouts, and use a card tied to it for business purchases only.

One account for the business, one for your life. Don't cross the streams.

Step two: set up a simple spreadsheet

You can use Google Sheets, Excel, or any free spreadsheet program. Make one spreadsheet for the year with these columns:

  1. Date - when the money moved
  2. Description - what it was, in plain words, like "Template sale" or "Domain renewal"
  3. Category - a simple label, like Sales, Fees, Software, Supplies, Advertising, Refunds
  4. Money in - amount received
  5. Money out - amount spent
  6. Receipt - where the receipt lives, like a file name or "email from processor"
  7. Notes - anything you'll want to remember later

That's the whole thing. Each row is one transaction. A transaction is any single event where money comes in or goes out.

Example rows

Here's what a few lines might look like, written out:

  • Date: the 3rd. Description: Planner sale. Category: Sales. Money in: the sale amount. Receipt: processor email.
  • Date: the 3rd. Description: Processor fee on planner sale. Category: Fees. Money out: the fee amount.
  • Date: the 10th. Description: Design tool subscription. Category: Software. Money out: the charge. Receipt: saved PDF.

Notice the fee gets its own line. Many processors pay you the sale minus their fee. Writing both down shows you what you actually earned and what it cost you to get paid.

Keep categories boring

Don't make 40 categories. Start with five to eight that cover most of what you do. You can add more later if you need them. A tax professional can also tell you which categories are useful for your tax return.

Step three: track every dollar, in and out

Every dollar means every dollar. The small fee. The tiny refund. The domain renewal you forgot about. The thing you bought "for the business" that you'll probably use for the business.

Why bother with the small stuff? Because small stuff adds up, and because business expenses may reduce what you owe in taxes. An expense you didn't write down is an expense you probably can't remember later.

How often?

Pick a rhythm you'll actually keep:

  • Daily if you have a lot of sales
  • Weekly for most side hustles
  • Every time it happens if you'd rather do it in the moment

Weekly works for most people. Pick a day, put it on your calendar, and spend ten minutes copying transactions from your business bank account and processor into the sheet.

Step four: save every receipt

A receipt is proof of a transaction: an email confirmation, a PDF invoice, a paper slip, or a statement from your processor.

Make one folder for the year, with a subfolder for each month. When you get a receipt:

  1. Save it to that month's folder. For paper receipts, take a clear photo with your phone.
  2. Give it a plain file name, like the date and what it was.
  3. Note in your spreadsheet where it is.

Email receipts are easy to lose in a crowded inbox. Make an email label or folder called something like "Business receipts" and drop them in as they arrive. Better yet, save a copy to your receipt folder too.

Step five: set money aside for taxes, as a habit

Side income usually doesn't have taxes taken out automatically. That means a chunk of what you earn may not really be yours to spend. It may belong to the tax bill that shows up later.

The easiest way to avoid a nasty surprise is to treat tax savings as a habit. Every time money comes in, move some of it into a separate savings account and don't touch it.

How much? I'm not going to give you a percentage, because the right amount depends on your income, your state, your expenses and the rest of your tax situation. A tax professional can help you pick a number that makes sense for you. The habit matters more than getting the number perfect on day one.

If you end up saving more than you needed, that's a good problem to have.

This is general information, not tax advice. For official information on self-employment and estimated taxes, see irs.gov.

Step six: review it once a month

Once a month, sit down with your spreadsheet and your bank statement for twenty minutes or so. Ask:

  • Does my spreadsheet match my business bank account? If not, what's missing?
  • How much came in this month?
  • How much went out, and on what?
  • Did I save for taxes from every payment?
  • Is there a subscription I'm paying for and not using?

You can add a simple total at the bottom of each month: money in, money out, and the difference. That difference is roughly what the business made, or lost, that month.

A monthly look turns bookkeeping from a chore into information you can use.

Over time, these monthly check-ins show you patterns. Which products sell. Which tools are worth keeping. Whether this side hustle is growing, holding steady, or quietly costing you money. Better to know.

Do this next

Count the money. It's the only way to know if there is any.

This is general information to help you learn, not legal, tax or financial advice. Every situation is different, and nobody can promise results, including me. If money or the law is involved, check your state's rules or talk to a qualified professional.
Sean "SAMX"

Veteran. Gen Xer. Thirty-plus years building things on the web. I write these so you can skip some of the expensive mistakes.

Build with me