Every small business owner who has let expense tracking slide knows what to do about it. Capture receipts, categorise consistently, review regularly. The advice is not the missing piece.
The missing piece is that "review regularly" is not a task. It has no start, no end, and no place in a calendar, so it loses every time it competes against something that does — a client call, an invoice, a delivery. Six weeks later the backlog has reached the size where starting it requires an afternoon nobody has.
What works is converting it into two appointments with explicit finish conditions.
The weekly ten minutes
Pick a fixed slot. Friday at four, Monday at nine — the time matters less than it being the same one every week, because the point is to stop deciding.
Three checks, and you are done when all three pass:
1. Uncategorised count is zero. One formula on a summary tab — =COUNTIF(Category,"") — gives you the number. Fix the rows it finds. These are quick now and expensive in four months, because the information needed to categorise them lives in your memory and nowhere else.
2. Nothing is still in physical circulation. Wallet, van, jacket, the pile by the till. Any receipt that has not been captured is a receipt that will be lost, and thermal paper left in a vehicle through a warm week is often already unreadable.
3. Last week's largest expense is correct. Sort descending, look at the top row, confirm the category and the amount. The biggest transaction carries the most consequence if it is wrong, and checking one row takes fifteen seconds.
Ten minutes, with a clear definition of finished. That definition is what makes it survivable — an open-ended "review the expenses" never ends, so it never starts.
The monthly half hour
Once a month, three different checks that the weekly pass cannot catch.
Reconcile against the bank. Every business transaction on the statement should have a row; every row should correspond to a transaction. Unmatched items in either direction are the interesting ones — usually a personal card used for a business purchase, or a duplicate.
Read the category totals. Not for accuracy, for surprise. A category that has doubled, or one that is suddenly empty, almost always indicates a classification drift rather than a change in the business. Finding it after one month means correcting a handful of rows.
Check the subscriptions. Filter to recurring charges and read the list properly. Most small businesses are paying for at least one tool nobody has opened in six months, and the monthly review is the only moment anyone looks.
What to do when it has already lapsed
If you are reading this with eleven weeks of backlog, do not start by entering receipts. Start from your bank statement export, mark every row as business or not, then sort what remains by amount and work from the top down. The largest twenty per cent of transactions typically account for most of the money, and starting there means a partial catch-up still captures most of the value.
Then begin the weekly habit from today rather than from the backlog. The two jobs are separate, and conflating them is why catch-ups stall.
Why capture is the part to automate
The weekly ten minutes only works if capture already happened. If Friday's session involves typing in twenty receipts, it is not a ten-minute appointment and it will be skipped.
That is the specific thing worth automating. Scan2Sheet turns capture into photographing the receipt — merchant, date, amount, and tax are extracted, the category is assigned, and the row lands in your Google Sheet with the image linked. Duplicates get flagged before they reach the sheet, which matters as soon as more than one person is scanning.
What that leaves for Friday is reviewing rather than typing, which is a ten-minute job rather than an hour-long one. The distinction decides whether the habit survives a busy month, and a busy month is the only real test.
Put both appointments in the calendar now, with the three weekly checks written in the invite so you never have to remember what the slot is for.