From Invoice to Books: Simple Bookkeeping for Service Businesses

Bookkeeping for a service business is a smaller job than the word suggests. There's no inventory, no cost of goods sold worth mentioning, and usually no payroll in the early years. You're really tracking three things: money in, money out, and invoices still waiting on payment. Keep those three straight all year and tax season shrinks to an afternoon.

The Three Records That Are Your Books

• An income log: one row per invoice, with the number, client, date sent, amount, status, and the date it was paid
• An expense log: date, vendor, amount, category, and a short note, fed weekly from your bank feed
• An open invoice list: everything unpaid and how overdue it is. Accountants call this accounts receivable; you can call it the chase list

Two spreadsheets cover all three, since the open list is just the income log filtered to unpaid rows. Consistent invoice numbers are what keep the income log sortable and searchable, and there's a clean scheme for that in how to number invoices.

From Invoice to Books, Step by Step

1. 1Finish the work, send the invoice the same day, and save the PDF
2. 2Add a row to the income log with status Sent
3. 3When payment lands, mark the row Paid with the date, and match it to the bank deposit
4. 4If the client wants proof of payment, issue a receipt and file a copy alongside the invoice
5. 5Drop both PDFs into the year's folder, Income side
6. 6Once a week, scan the open list and nudge anything overdue before it ages

The tooling for the paper side is already solved: the free invoice generator handles layout and math on the way out, and the receipt maker produces the proof of payment when money comes in. Your job is just the log in the middle.

The Monthly Close, Minus the Jargon

Once a month, sit down with the bank statement and your two logs and make them agree. Every deposit should match an invoice row; every withdrawal should match an expense row. Anything unmatched gets solved now, while the memory is days old instead of months. Then total the month: income, expenses, and the difference, which is your profit. Watching that number monthly is how you catch a slow quarter while there's still time to do something about it. For a typical solo business the whole ritual takes thirty to forty five minutes, and it's the habit that separates businesses that know their numbers from businesses that guess at them.

Cash or Accrual, in One Paragraph

Cash basis means you count income when money actually arrives and expenses when they're actually paid. Accrual means counting when income is earned and costs are incurred, whether or not money has moved yet. Most small US service businesses pick cash basis on their first return because it matches what the bank statement says and keeps the monthly close simple. The choice carries tax consequences and the rules vary by state and country, so confirm it with a local accountant once rather than relying on an article, this one included.

What Your Books Should Answer

A working system answers three questions in under a minute each: how much did I make last month, who owes me money right now, and what have I spent on any given category this year. Those three cover tax filing, cash flow decisions, and most of what a lender ever asks for. If one of them takes real effort to answer, tighten the system before adding anything new to it. Complexity added on top of confusion just buys prettier confusion.

When a Spreadsheet Stops Being Enough

Spreadsheets are legitimate books. Auditors care whether records are accurate and complete, not which logo sits in the corner of the software. Move to a real accounting app when the sheet starts costing you: heavy recurring billing, contractors to pay and report, sales tax filings in more than one state, or a lender or accountant requesting statements the sheet can't produce. Businesses that migrate from tidy spreadsheets have an easy time of it. The mess migrates too, so clean up first, then switch.