How to Do Your Own Bookkeeping for Schedule C (Free Template)

If you're self-employed, a freelancer, or run a single-member LLC, your business income and expenses land on Schedule C of your tax return. And here's the thing nobody tells you when you start: you don't need QuickBooks, and you don't need to pay a bookkeeper $150 an hour to do this. You need a system, a couple of hours, and a place to put your numbers.

This guide walks through exactly how to keep your own books for Schedule C — start to finish — and gives you a free spreadsheet to do it in.

What Schedule C actually asks for

Schedule C is simpler than it looks. It's really just two questions:

  1. How much money did your business bring in? (gross receipts)
  2. What did you spend to run it? (expenses, broken into categories like advertising, car, supplies, and so on)

Subtract expenses from income, and the result — your net profit or loss — flows to your 1040 and gets taxed. That's the whole game. Your job as your own bookkeeper is to feed those two numbers accurately, with records to back them up.

Step 1: Separate business from personal

The single best thing you can do is use a dedicated bank account (or at least a dedicated card) for the business. It doesn't have to be a fancy business account — a second checking account is fine. This one habit makes everything downstream easier, because your bank statement becomes your bookkeeping.

If your business and personal money are mixed in one account, you can still do this — you'll just spend more time marking which transactions are personal (and therefore excluded).

Step 2: Get your transactions in one place

At tax time (or better, monthly), log into your bank and export your transactions to a CSV or spreadsheet file. Almost every bank offers 'Download' or 'Export.' That file is a list of every dollar in and out — the raw material for your books.

You don't type transactions in one by one. You paste the export and let a spreadsheet do the sorting.

Step 3: Categorize each transaction

This is the part people dread, but it's mechanical. Every transaction is one of three things:

  • Money in — usually income (client payments, sales)
  • Money out — an expense, which belongs on a specific Schedule C line
  • Neither — an owner draw, a transfer, or a personal charge you exclude

The Schedule C expense categories you'll use most:

  • Advertising
  • Car and truck expenses
  • Contract labor
  • Insurance
  • Legal and professional services
  • Office expense
  • Supplies
  • Travel and (50%) meals
  • Utilities

The fastest way to categorize is by keyword rules: 'anything from SHELL is Car and truck,' 'anything from UPWORK is Contract labor.' Set the rule once, and every matching transaction sorts itself — this year and next.

Step 4: Don't miss the deductions you're entitled to

New self-employed filers almost always under-claim. Watch for:

  • The business-use share of your phone and internet
  • Software and subscriptions you pay monthly
  • Mileage (the standard mileage rate is generous — track your business miles)
  • A home office, if you have a space used regularly and only for work
  • Bank, Stripe, PayPal, and Square fees

Every one of these is a legitimate deduction that lowers your tax — but only if you captured it.

Step 5: Reconcile — the step almost everyone skips

Here's the professional move that separates clean books from a guess: reconcile to your bank. Your beginning bank balance, plus everything that came in, minus everything that went out, should equal your ending bank balance. If it doesn't, you missed a transaction — and it's far better to find that now than after you file.

This is a two-minute check that catches the most common bookkeeping mistake there is: a forgotten transaction that quietly overstates (or understates) your profit.

Step 6: Pull your totals onto Schedule C

Once everything's categorized, your totals by category map directly onto Schedule C's numbered lines. Advertising totals go on line 8, car expenses on line 9, and so on. Your net profit is line 31. Transfer the numbers (or hand the summary to your tax preparer) and you're done.

The shortcut: a spreadsheet that does steps 3–6 for you

You can build all of this in a blank spreadsheet — or you can start with one that already does it.

Our Free Mini Expense Tracker gives you the core loop: paste a few transactions, set a keyword rule, and watch the Summary tab total everything up. It's free, it's yours to keep, and your data never leaves your computer.

Download the free tracker →

When you're ready to do a whole year, the full Self-Employed (Schedule C) workbook takes it the rest of the way:

  • Paste your entire bank export — hundreds of rows sort themselves via 90+ built-in vendor rules
  • Your Schedule C, Profit & Loss, and Balance Sheet build themselves
  • A Cash Balance tab checks your books against your bank so nothing's missing
  • A 'Needs Attention' view shows only the rows still to categorize
  • Mileage log, home-office calculator, and monthly/quarterly views included

It's a one-time $39 (Flex, up to 1,000 transactions) or $49 (Pro, up to 3,000) — you own it, no subscription.

See the Self-Employed workbook →

FAQ

Do I need accounting software for Schedule C?
No. A spreadsheet is enough for most sole proprietors and single-member LLCs. Software like QuickBooks is built for businesses with payroll, inventory, and accrual accounting — more than most freelancers need, at a recurring cost.

Cash or accrual?
Most self-employed people use cash basis — you count income when you receive it and expenses when you pay them. That's exactly how a bank-export-based workflow works.

How often should I do this?
Monthly is ideal (an hour a month beats a panicked weekend in April). But even doing it once before filing works, as long as you have your full-year bank export.

This is general information, not tax advice, and is not affiliated with the IRS. Confirm your specific situation with a qualified tax professional.

Back to blog