Bookkeeping for the self-employed: two ledgers, one P&L, twenty minutes a month
One-person businesses handle bookkeeping in one of two broken ways. Most do nothing — a shoebox of receipts, a bank statement, and a vow to "sort it out at tax time." The rest over-correct into subscription accounting software built for companies with payroll and inventory, where they use 5% of the features and still dread opening it. The system a freelancer or sole proprietor actually needs is smaller than both: money in, money out, and a profit number you look at once a month. Here's that system, whole.
The income ledger: money in, with a status
One row per invoice or payment: date, client, invoice number, amount — and a status (paid, invoiced, overdue). The status column is what separates a ledger from a wish list, because a one-person business has two different income numbers and conflating them is how cash crunches sneak up:
- Income — what's actually been paid. This is what the P&L counts.
- Outstanding — what's been invoiced and hasn't arrived. This is the number that tells you whether next month is funded, and its overdue subset is your chase list (the invoicing guide covers how to chase without burning the relationship).
Small honest note on method: counting income when it's paid (and expenses when they're paid) is called cash-basis bookkeeping, and it's how most one-person businesses run because it matches the bank account. The alternative, accrual, counts invoices when earned — if you have a reason to care about the difference, that's an accountant conversation, not a spreadsheet setting.
The expense ledger: money out, with a category
One row per expense: date, vendor, amount, category — picked from a short fixed list, not typed freehand. The category discipline is the highest-leverage habit in this whole article, for two reasons:
- Tax time becomes an export instead of an excavation. If your categories roughly mirror the Schedule C expense lines — software, supplies, insurance, advertising, travel, and so on — then April is "sum each category, hand it over." Skip the discipline and April is four hundred bank transactions asking, one at a time, what was this? (What's actually deductible, and the mileage question, is its own guide.)
- Creep becomes visible. A category breakdown is where you discover that "software subscriptions" quietly became your second-biggest cost, or that this year's supplies spend doubled. You can't see creep in a pile; you can't miss it in a table.
The P&L: the number the whole system exists for
With both ledgers kept, the profit-and-loss statement is just arithmetic per month: income minus expenses, net profit. Say a month reads $6,200 in, $1,850 out — $4,350 net, with $2,400 still outstanding. Those four numbers are the business's vital signs, and they take one glance. Lay twelve months side by side and you get the rest of the picture: your seasonality (which months always sag), your trajectory (is net growing or is revenue growing while net stands still?), and the red months that deserve a post-mortem rather than a shrug. This monthly net is also the number your quarterly estimated-tax payments and your own rate math should be standing on — a business that doesn't know its monthly net is guessing at both.
The twenty-minute ritual
The system runs on one monthly appointment with yourself:
- Enter the month. Log any income and expenses you didn't capture as they happened. (Capturing as you go turns this step into nothing.)
- Chase the overdue. Read the outstanding list, send the reminders. Two minutes that routinely recovers real money.
- Read three numbers. Net profit vs. last month, outstanding total, top expense category. If one of them surprises you, dig; if not, close the file. That's the whole job.
Twenty minutes a month, every month, beats a heroic weekend in January every time — not just for taxes, but because the January-only bookkeeper spends the whole year flying blind and finds out in winter how the year went. The monthly reader knew in June.
When you've actually outgrown the spreadsheet
Honesty about the boundary: a two-ledger workbook is the right size for a service business of one. You've outgrown it when you hire an employee (payroll withholding is not a spreadsheet hobby), when you carry real inventory at volume, when you're collecting sales tax across multiple states, or when a lender or investor needs formal statements. Those are good problems — graduate to real software or a bookkeeper when one arrives. Until then, the subscription mostly buys features you don't use and a monthly fee your P&L has to earn back.
Two ledgers and a P&L that updates itself
The Small-Business Bookkeeping Workbook is this article as a working file: an income ledger with invoice status (overdue rows flag themselves, outstanding totals live), an expense ledger with an editable category dropdown — add a category and it appears on the dashboard automatically — and a dashboard with the monthly KPI ribbon, the 12-month view with red negative months, and the full expenses-by-category table. 200 income rows and 300 expense rows ready to go. Pure formulas, no macros, sample data included so it works the moment it opens.
The quiet truth about small-business bookkeeping is that the hard part was never the accounting — it's two ledgers and a subtraction. The hard part is having a place to put things that's pleasant enough that you actually put things there. Build that, keep the monthly appointment, and the books stop being a dread and start being the instrument panel. (A record-keeping tool and a habit, to be clear — not accounting or tax advice; your accountant gets the export, and the judgment calls.)