Every small business starts the same way: a spreadsheet. One tab, a few columns — date, what you spent, how much — and a quiet promise to keep it updated. It works for about three weeks. Then a receipt gets thrown away before it's logged, a row gets skipped during a busy month, and by tax season the sheet is a fiction you only half-trust. The spreadsheet didn't fail because you're disorganised. It failed because it asks you to do the worst part — data entry — at the worst time, long after the money left your hand.
Here's how to track business expenses without one, and what actually replaces it.
Why the spreadsheet always rots
Three failure modes, and every dead expense sheet has at least one:
- Capture friction. The spreadsheet lives on your laptop; the receipt is in your hand at a counter. The gap between those two moments is where expenses go to die. Anything that makes you wait until you're home means some receipts never get entered at all.
- No image behind the number. A row that says "Office Depot — $48.10" is a claim, not evidence. If it's ever questioned — by an accountant, by the tax office — the number without the receipt image is worth very little. (Faded thermal receipts make this worse; see what OCR gets wrong on receipts.)
- Drift. You miss a week, tell yourself you'll catch up, and never do. A sheet that's 80% complete is more dangerous than no sheet, because you trust it.
What "tracking an expense" actually requires
Strip it down and every system — spreadsheet, app, shoebox — is trying to capture the same five things, plus one:
- Date, merchant, amount, category, and tax — the fields your accountant needs.
- The image of the receipt itself — the evidence those fields stand on.
And then the thing the spreadsheet quietly ignores: a place all of it lives that won't disappear when your laptop does. A row in a sheet has no receipt attached; a photo in your camera roll has no fields. You need both, together, somewhere durable.
The methods, worst to best
- Camera roll. Zero friction to capture, zero structure after. Six months later it's two thousand photos with no merchant, no total, no way to add up a category. Better than nothing, barely.
- Spreadsheet plus a folder of photos. The honest DIY setup: log the row, save the image to a Drive folder. It works if you're disciplined, and it's genuinely fine for a sole trader with a handful of expenses a month. The catch is it's two manual steps every time, and the moment a teammate is involved it breaks. (Here's how to organise that folder well if you go this route.)
- Capture at the point of sale. The version that doesn't rot: photograph the receipt the moment you get it, let OCR read the merchant, amount, and date off the image, confirm, done. The entry happens while you're still standing at the counter — the one moment you'll never forget the context.
Doing it without a spreadsheet
The whole trick is to move the work from "later, at a keyboard" to "now, with a camera." That inverts all three failure modes: there's no capture gap because you capture on the spot, there's always an image because the image is the record, and there's no drift because there's nothing to catch up on.
You can try the OCR step yourself right now — the free receipt scanner reads a receipt in the browser and hands you back the fields. That's the engine. What a tool adds on top is everywhere those fields then go: filed by month, grouped by trip or client, totalled by category, and — if you use Starlog — backed up to your own Google Drive in a clean per-company folder tree, so the source images live somewhere you control rather than locked inside an app. When tax season comes, the export is one tap: a spreadsheet and every image, already done.
The takeaway
The spreadsheet isn't the enemy — the timing is. Any system that asks you to record expenses later, from memory, at a keyboard, will rot. Move capture to the moment of purchase, keep the image attached to the number, and put both somewhere durable, and you can stop maintaining the sheet entirely — because it's building itself as you go.