Guide
A small business expense spreadsheet that actually gets used
A spreadsheet is a good expense system for a small business, right up until the volume beats you. It costs nothing, it exports to anything, and your accountant can already read it. The template below is the one we would use ourselves: seven columns, no macros, no gate. What follows is how to run it — and where, honestly, it stops scaling.
The seven columns you need
Date, merchant, description, category, amount, payment method, receipt reference. That is a complete expense record for most small businesses. Anything beyond it — VAT or sales tax split, job or client, billable flag — is worth adding only if you will actually use it, because every column is a decision you make on every row.
The column people leave out is description, and it is the one that decides whether the sheet is worth anything in a year. A row reading 15/03, Wickes, 42.10, Materials tells you nothing you could defend; 15/03, Wickes, plasterboard for Northgate bathroom, Materials, 42.10 answers the question without you being in the room. Six words is enough, and it is only cheap to write on the day.
The receipt reference column is the whole trick
Give every receipt a filename you can find — 2026-03-15-wickes-42.10 — and put that same string in the sheet. The spreadsheet then becomes an index into a folder of images rather than a claim you cannot support. A row without a findable receipt behind it is a number, not a record.
This is the step that makes a spreadsheet defensible instead of merely tidy. Publication 583 lists what counts as a supporting document — cancelled cheques, account statements, credit card sales slips, invoices, petty cash slips — and the sheet is not one of them. It is your summary of them. Keep the underlying documents somewhere the filename resolves, and keep them backed up somewhere other than the machine holding the sheet.
Set it up so a month is one filter
One sheet, one row per expense, no tab per month. Dates in a real date format, amounts as numbers with no currency symbol typed in, categories from a fixed list rather than free text. Then a month, a category or a client is a filter, and totals are a pivot table you build once.
The tab-per-month layout is the most common way a small business spreadsheet ruins itself. It looks organised in March and by December you have twelve sheets that cannot be summed without a formula that references all of them, and one of the tabs has an extra column somebody added in July. One flat table is uglier and survives. If you want monthly views, get them from a pivot, not from the file structure.
Use a fixed category list, from the start
Pick your categories once, keep them in a second tab, and use data validation to make the category column a dropdown. Free-typed categories drift — Travel, travel, Travel , Transport — and every variant silently breaks your totals. This costs five minutes on day one and saves an afternoon of cleanup later.
Three to six categories is usually right at the start. If you are unsure which, the line items on the form you already file are a defensible starting set, since they are the buckets your figures have to land in eventually anyway. The companion page on expense categories works through how to choose them and how many is too many.
Reconcile against the statement monthly
Once a month, open the business account statement and tick off each line against a row in the sheet. Two things fall out: spending you forgot to record, and rows with no receipt behind them. Both are cheaper to fix in the month they happened than in April.
This is also the only reliable way to catch the expense you paid personally and never reimbursed, which is the most commonly missed deduction in a small business and the one nobody's software finds for you. The statement-matching routine, including what to do about lines with no receipt at all, has its own page linked below.
Where a spreadsheet stops working
At roughly thirty to fifty receipts a month, for most people. The failure is not the spreadsheet — it is the typing. Every row costs about a minute of manual transcription, and once that is fifty minutes of admin you do not want to do, the sheet stops being current, and a sheet that is not current is worse than no sheet because you trust it.
The other two limits arrive later. Multi-user editing goes wrong quietly — two people, one file, one overwrite. And a spreadsheet holds no images, so the link between a row and its receipt is a naming convention you have to maintain by hand forever. None of this makes a spreadsheet a bad choice at small volume. It makes it a choice with a known end point.
We sell an app, and this template is still free
This site also argues, on another page, that spreadsheets break down for receipt keeping. Both things are true. Below a certain volume the sheet is the right answer and we are not going to pretend otherwise to sell an app; above it, typing is the thing that stops you and that is what a scanner fixes.
Our AI Receipt Scanner photographs a receipt and extracts the fields into a searchable record, with scanning and organising free and export behind Pro. If you move to it later, this template's column layout is close to what the export produces, so the migration is not a rewrite. If you never move, the template is still yours — it has no gate, no email capture and no expiring link.
Questions
Common questions
What should a small business expense spreadsheet include?
Date, merchant, description of what the spend was for, a category from a fixed list, amount, payment method, and a reference that points to the receipt image. Add tax split, client or job, and a billable flag only if you will use them.
Is a spreadsheet enough for business expenses?
Yes at low volume, provided the receipts themselves are kept and findable. The spreadsheet is a summary; the supporting documents are the receipts, invoices and statements behind it. It stops being enough when manual typing gets bad enough that you stop keeping it current.
Is this template free?
Yes — plain CSV, no email address, no account, no macros. Open it in Excel, Numbers, Google Sheets or LibreOffice, delete the two example rows and start.
Should I use one sheet per month?
No. Use one flat table with a date column and get monthly views from a filter or a pivot table. Tab-per-month layouts drift apart over a year and cannot be totalled without fragile cross-sheet formulas.
How do I link a spreadsheet row to its receipt?
Name each receipt image with the date, merchant and amount — 2026-03-15-wickes-42.10 — and put that exact string in a reference column. The sheet becomes an index into your receipt folder, so any row can be traced back to the document supporting it.
When should I move from a spreadsheet to an app?
When transcription is the reason the sheet is out of date. For most people that is somewhere around thirty to fifty receipts a month. Below that an app is overhead; above it, the minute-per-row cost is what quietly kills the habit.