Most budget templates do bookkeeping. This one does analysis.
A budget template tells you what you spent. This one tells you what it means: whether you can absorb a shock, which categories are quietly drifting, and how long your money lasts if your income stops.
Seven tabs in Google Sheets. You enter transactions. Everything else is derived.
The variance convention most templates get backwards
Spend less than you budgeted on an expense and that is favourable, so it shows as a positive number. Earn more than you budgeted, also favourable, also positive.
Most templates simply subtract, which means earning more than planned appears as a negative. It is the single most common error in budget spreadsheets, and you can check this one against your own numbers in about thirty seconds.
Operating leverage, applied to your household
Every category is classified as Fixed, Variable, Discretionary or Savings. Fixed costs are committed: rent, insurance, loan payments, none of which you can cut this month. Discretionary spending can stop tomorrow. Variable sits between.
The higher your fixed share, the less able you are to respond to a shock. That is the same operating-leverage logic used to analyse a company, applied to a household. The workbook calculates:
- Downside flex. All discretionary plus the cuttable share of variable.
- Stressed burn. What life costs when you are being serious.
- Runway. How long liquid assets last, in months.
Income shock scenarios
Four scenarios, calculated from your own numbers: income down 20 percent, 30 percent, 50 percent, and gone entirely. Each shows the monthly gap, how long your liquid assets cover it, and how much longer if you cut discretionary spending.
Where income still covers that spending level, the scenario reads covered, because nothing is being drawn down at all. This is arithmetic, not a forecast. The point is to know the number before you need it.
The paycheck calendar
If you are paid every two weeks you receive 26 paycheques a year, not 24. Two months carry a third one. A budget built on two paycheques a month loses those, and they are the months where saving is actually possible.
Monthly averaging
All actuals are averaged over the months present in your data, so they compare like for like against a monthly budget. Comparing a three-month total to a monthly budget is a common and expensive error.
Requirements
- A free Google account. Google Sheets only, Excel cannot run the automation.
- Menu commands need a desktop browser. Entering transactions works fine on the phone app.
- This workbook makes no external request at all. No email, no other Drive files, no server.
- No subscription, no app, no monthly fee.
Honest limitations
- Transactions are entered manually. There is no bank sync and no automatic categorisation.
- There are no charts. This workbook reports numbers, not pictures.
- Not a tax tool, and not financial advice.