Business Bookkeeping Spreadsheet: Simple Monthly Books

Hey folks, it's Ren here. Every autumn I do a strange little ritual at the bottom of the garden: I tally up the veggie patch.

Seedlings, two bags of soil, the water, the stakes the wind snapped in October. This year the patch cost $310 and gave back roughly $180 worth of tomatoes and beans. My neighbour swears his garden pays for itself. He has never once written a number down.

Most micro businesses are run like my neighbour's garden. Money going in, money coming out, and a warm feeling standing in for the maths.

The fix is not accounting software or an MBA. It is one tidy file: a business bookkeeping spreadsheet.

"Never take your eyes off the cash flow because it's the lifeblood of business." — Richard Branson

🔍 Why most micro businesses fly blind

Most owners of very small businesses judge the month by glancing at the bank balance, and the bank balance answers almost nothing.

It is one number wearing three disguises. It contains money you have not earned yet, hides money you have earned but not received, and quietly includes the tax office's share pretending to be yours.

• Invoices you have sent but not been paid for are invisible in the balance.
• An annual bill paid up front makes one month look terrible and the next eleven look better than they are.
• The tax owing on every dollar of profit sits in the balance looking spendable.
• Two months of receipts in a shoebox is not a record, it is an archaeology project waiting for tax time.

If your current system is a shoebox and a hopeful feeling, please do not be hard on yourself. It is the default setting for busy owners, and it is fixable in one quiet morning.

What should a business bookkeeping spreadsheet actually track?

A business bookkeeping spreadsheet needs two ledgers, money in and money out, plus a summary tab that totals each category by month. That is the whole architecture. Everything else is decoration.

Here is what belongs in each ledger.

Tab	Columns
Money in	Date, customer or source, description or invoice number, amount, tax component, date it hit the bank
Money out	Date, supplier, category, amount, payment method, receipt reference
Summary	Each category totalled by month, a profit line, and a tax set-aside line

Categories deserve one deliberate decision: pick 8 to 12 and make them match the expense lines on your tax return. Rent, software, materials, vehicle, insurance, fees, marketing, and so on.

When the categories mirror the return, tax time stops being translation work. Your accountant reads the summary tab and nods.

💵 One quarter, three different answers

A micro business quarter can produce three completely different answers to the question of how the business went, and all three are true at once. I ran a worked quarter to show the spread.

Take a one person studio. Over the quarter it invoiced $11,800 and collected $9,400 of it, with $2,400 still sitting in two unpaid invoices. It paid $5,280 in expenses, including a $1,140 annual insurance premium up front, of which only $285 really belongs to this quarter.

Now ask how the quarter went.

The question	Where it shows up	The number
What did the bank do?	Bank statement	up $4,120
What did we earn?	Books summary tab	$7,375 profit
What can I actually spend?	After the 25% tax set-aside	$2,276

The maths behind the middle row: $11,800 earned, minus the $4,425 of costs that belong to the quarter ($5,280 paid, less the $1,140 prepay, plus this quarter's $285 share of it), leaves $7,375. Set aside 25% of that for tax, roughly $1,844, and the cash you can safely draw is $2,276.

Top to bottom, those answers sit more than $5,000 apart. Same business, same quarter.

Here is the part almost nobody says out loud: each number has exactly one job. Profit tells you whether the pricing works. Spendable tells you what you can pay yourself. Bank movement tells you almost nothing except that nothing bounced.

Most owners run the whole business on the third one. The books exist so you can stop.

Bookkeeping, budget or cash flow: which sheet answers what?

Bookkeeping records the past, a budget plans the future, and a cash flow forecast times the gap between them. Micro business owners get sold all three as if they were the same sheet, and they are not.

Sheet	The question it answers	Direction
Bookkeeping spreadsheet	What actually happened last month?	Backward, the record
Budget spreadsheet	What do we plan to earn and spend?	Forward, the plan
Cash flow spreadsheet	When does the money actually land?	Forward, the timing

The order matters. Books first, because a budget built on guessed numbers inherits the guessing, and a forecast built on nothing is astrology with gridlines.

Once your books have three months of real categories in them, the other two sheets almost write themselves. If the timing side is your pain point, the 13 week business cash flow spreadsheet picks up exactly where the books leave off.

🛠️ The monthly close: 20 minutes that runs the whole system

The monthly close is the entire system, and skipping it is the one reliable way spreadsheet bookkeeping fails. Not because the file breaks. Because months stack up.

A month you close while it is fresh takes 20 minutes. A year you reconstruct in one sitting takes a lost weekend, and half the categories end up as guesses.

Here is the routine.

1. Set up the three tabs. Money in, money out, and a summary tab that totals each expense category by month.
2. Pick a close day. The first Saturday of every month, coffee in hand, calendar reminder set.
3. Download last month's bank statement. A CSV export from your business account is the easiest thing to work through line by line.
4. Match every statement line to a ledger row. Anything on the statement that is not in the books gets added, and anything in the books that never hit the bank gets flagged.
5. Move your tax set-aside. Transfer your chosen percentage of the month's profit into a separate account before the number starts feeling spendable.
6. Read the summary tab. Two quiet minutes on which categories crept and whether the quarter is tracking ahead of or behind the last one.

That is it. No debits and credits, no journal entries. Match, categorise, set aside, read.

When does a spreadsheet stop being enough?

A spreadsheet stops being enough at the point where the books need to do things rather than just record things. For most micro businesses that point arrives much later than the software ads suggest.

The honest thresholds, in the order they usually arrive:

• Your first employee. Payroll brings withholding, leave and superannuation calculations that you should not be hand rolling in a sheet.
• Real inventory. Once stock on hand needs counting and valuing, a ledger row per purchase stops describing reality.
• Invoice volume. Past roughly 25 to 30 transactions a week, the monthly close outgrows its 20 minutes and automation starts paying for itself.

Sales tax registration, like GST, is not on the list. It adds a column and a quarterly rhythm, but plenty of registered sole traders run happily on a sheet for years.

There is no shame in staying on a spreadsheet, and no prize for staying past the point it hurts. The books tell you when: if the close keeps blowing out past an hour, you have outgrown the tin.

🚧 Mistakes to sidestep

• Running the business through your personal account. Fix it: open a separate everyday business account so the statement you reconcile only contains business lines.
• Categorising from memory weeks later. Fix it: close monthly, because a $47 line you can name today is a mystery by September.
• Counting an invoice as income the day you send it. Fix it: log it when sent, but only the paid date moves it into the month's income.
• No receipt reference column. Fix it: name receipt photos R-01, R-02 and so on to match the column, and any number can be proven in under a minute.
• Skipping the tax set-aside in a tight month. Fix it: the percentage applies to profit, not to how the month felt, and it moves the same day you close.

If your business lives on a marketplace, the same two ledger system works with one twist: the platform takes its fees before the money lands. The Etsy seller bookkeeping guide walks through recording gross sales, fees and payouts so your income line is not quietly understated.

🎯 Your action steps this week

• Open a blank spreadsheet tonight and make the three tabs. Ten minutes, no formatting perfectionism.
• Backfill only the current month from your bank statement. Do not start with January.
• Pick your close day and set the repeating reminder before you close the laptop.
• Decide your tax set-aside percentage. A ten minute chat with an accountant beats guessing.
• If cash also floats through a physical tin, pair the books with a petty cash spreadsheet so the float reconciles too.

❓ Frequently asked questions

Can I really do my business bookkeeping in a spreadsheet?

Yes, for most sole traders and micro businesses a spreadsheet is genuinely enough. If you have no employees, no stock to count and fewer than around 25 to 30 transactions a week, two ledgers and a monthly reconciliation cover everything your tax return needs. The point where software earns its subscription is payroll, inventory, or an invoice volume you can no longer keep up with.

What columns should a business bookkeeping spreadsheet include?

The money in ledger needs the date, the customer or source, a short description or invoice number, and the amount. The money out ledger needs the date, the supplier, the category, the amount, the payment method and a receipt reference. Add a tax component column if you are registered for GST or sales tax. A summary tab then totals each category by month.

How is a bookkeeping spreadsheet different from a budget spreadsheet?

A budget is the plan and the books are the record. A budget spreadsheet sets out what you intend to earn and spend next month, while a bookkeeping spreadsheet records what actually happened, categorised and reconciled against the bank statement. You need the books first, because a budget built on guessed numbers inherits the guessing.

How long should I keep my bookkeeping records?

Keep them for at least five years in Australia and up to seven in the United States depending on your situation, counted from when you lodge the return they support. A spreadsheet makes this painless: one file per financial year, plus a folder of receipt photos named to match your receipt reference column, and the whole archive fits in a cloud drive.

My neighbour still reckons his garden pays for itself. He might even be right. Neither of us will ever know, because only one of us writes the numbers down.

Your business deserves better than the warm feeling. Give it 20 minutes a month.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.