How to Create a Monthly Budget That Survives Real Life
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Sheetzy guide
By Mani Dazzle, Template maker at Sheetzy · 20 November 2026
Whether you file a Schedule C in the US or a Self Assessment in the UK, the expectation is the same: a record of every bit of income your business earned and every expense you claim against it, kept for several years after you file.
Nobody asks for fancy software. They ask for records that are complete, consistent and backed by proof. A spreadsheet you update every week beats a shoebox of receipts handed to an accountant in a panic - and it usually beats abandoned accounting software too.
Tab one, Income: date, client, invoice number, amount, paid or unpaid. Every payment that lands gets a row the day it lands.
Tab two, Expenses: date, what it was, category, amount, and a link to the receipt photo in Drive. Categories matter more than perfection - keep them stable and tax time becomes a sorting exercise, not archaeology.
Tab three, Invoices: invoice number, client, date sent, amount, due date, date paid. This tab is your answer to the question every freelancer dreads in a cash-tight month: who still owes me money?
Tab four, Mileage and home costs: work trips with distance and purpose, plus the share of home internet, phone and workspace you claim. These are the expenses people forget all year and then under-claim.
Pick a fixed slot - Friday afternoon works because the week is fresh. Open the bank app and the sheet side by side. Add this week's income rows, add this week's expense rows, snap photos of any paper receipts and link them.
Then two checks: does every bank transaction have a row, and does every row have proof? Fifteen minutes, done, and your books are never more than a week stale. The freelancers who get burned at tax time are not the ones with bad systems - they are the ones whose last update was four months ago.
Set your expense categories once, and name them the way your tax form names them: advertising, software and subscriptions, professional fees, travel, phone and internet, equipment, office costs. A US Schedule C and a UK SA103 use different words, but the buckets are nearly identical.
When every expense already sits in the right bucket, the annual return is addition, not investigation. Your accountant (or your future self at 11 pm on deadline day) will thank you.
Mixing personal and business spending in one account is the classic. It doubles your Friday time and makes every deduction arguable. A separate account, even a basic free one, pays for itself in a month.
The quiet killer is small cash expenses: parking, postage, the stationery run. None feel worth logging, and together they are often hundreds a year you paid tax on for no reason.
And the January trap: telling yourself you will reconstruct the year from bank statements. You will miss the cash costs, forget what half the card payments were for, and swear you will do it weekly next year. Start the weekly habit this Friday instead.
The signals are honest ones: more than a couple of hundred transactions a month, VAT registration in the UK, staff on payroll, or several income streams that need separating. At that point accounting software or a bookkeeper is not a cost - it is insurance.
Until then, a spreadsheet plus a bit of structure goes a long way. If you want a head start, our general journal entry template (Ledgerline) enforces balanced debit-credit rows if you prefer classic bookkeeping, and the invoice tracker keeps the who-owes-me question answered. Same weekly routine, just with the columns pre-built.
Not at the start. If you have a handful of clients and a few dozen expenses a month, a disciplined Google Sheets system covers everything the tax office asks for. Software earns its cost later, when volume or VAT registration makes manual tracking risky.
In the UK, HMRC expects records kept for at least five years after the 31 January submission deadline for that tax year. In the US, the IRS generally says three years from filing. Keep digital copies of everything - a Drive folder of receipt photos counts.
Every payment you receive, every business expense with proof, invoices you have issued, bank statements, and mileage logs if you claim vehicle costs. The rule of thumb: if money moved for the business, there should be a row for it.
Yes, if the system is simple enough to keep up weekly. Four tabs and a fixed 15-minute slot beat a perfect setup you abandon by March. Having an accountant check the year once at tax time is still money well spent.
Five steps, one spreadsheet, and a weekly habit that takes less time than making chai. Here is the monthly budget method we build into every template.
Half to needs, a third to wants, a fifth to savings. The 50/30/20 rule is the lowest-effort budget that still works - here is how to run it with real numbers.