Most weekly budget templates are monthly budgets with thinner columns. They divide your income by four, list some expense categories, and leave you to figure out the rest. When a biweekly paycheque misses a week, or your car insurance and a quarterly bill cluster in the same seven days, the template goes silent — it has no concept of the actual calendar.
The template below is structured differently. One row per week. Income entered on the exact date it arrives. Bills recorded in the week they hit, not as monthly averages. The result is a view of your money that looks like your actual life, not a smoothed estimate of it.
What is in the template
The template has five columns and one control.
- Income. Enter pay on the exact date it arrives. Biweekly means every other row,
not a monthly total split evenly. Weeks without a paycheque are weeks your income
is
$0. That asymmetry is the point. - Recurring bills. Rent, mortgage, insurance, loan payments, subscriptions. Enter
the full amount in the week the transaction hits. A
$900annual insurance renewal goes in as$900in that week, not$75spread across twelve months. - Variable spending. A single weekly total for groceries, fuel, and discretionary spending. Use last month’s actual spending divided by 4.3 as your starting number — not what you hope to spend.
- Net for the week. Income minus bills minus variable spending. A negative net is not a crisis — it means a large bill landed that week. What matters is whether your running balance stays above your floor.
- Running balance. Your real account balance today, carried forward week by week. This is the column you read.
The floor is a single number at the top: the lowest balance you will let your account reach before you act.
Download and fill it in
Download the weekly budget template (CSV)
Open it in Google Sheets or Excel. Replace the sample rows with your own dates and amounts, starting with the current week.
- Set your floor. If you are not sure where to start,
$500is a reasonable default for most chequing accounts. Raise it after a full month, once you have seen where your tight weeks cluster. - Enter your income anchors. Find your next paycheque date and enter the amount. If you are paid biweekly, add the following pay date two weeks out. Continue for at least eight weeks.
- Add recurring bills. Every fixed expense — rent or mortgage, phone, insurance, loan payments — entered on the date it actually leaves your account.
- Fill in variable spending. Use a realistic weekly total, not an aspirational one. You can adjust after your first check-in.
- Scan the running balance. Scroll through the next four weeks. Does any week dip below your floor? That is the week to watch.
The first setup takes about an hour. After that, a Sunday check-in of under ten minutes keeps it current.
Reading the floor signal
The floor converts a vague feeling of financial tightness into a specific, visible
signal. Without it, a balance of $350 looks fine until a $500 bill clears the
next morning. With a floor set at $500, you can see that week arriving before it
does.
When a week’s projected balance crosses below your floor:
- Move money from savings before the week starts.
- Delay a non-essential purchase that was going into that week.
- Or decide the dip is acceptable and leave the plan unchanged — at least it is a decision, not a surprise.
The floor earns its keep during the weeks you would nearly skip: the one in February where a quarterly subscription, a short paycheque, and your car insurance all land inside five days. Spotted three weeks early, you have time to act. Spotted on Monday morning, you are reacting.
When the spreadsheet is no longer the right tool
A spreadsheet is the right place to start. It forces you to understand the structure before you hand it off to anything else.
The first limit is multi-account complexity. Add a second chequing account, a savings buffer, or a line of credit you want to track separately, and you are manually cross-referencing rows. Most people stop reconciling when the maintenance cost exceeds the benefit.
The second limit is the forward view. The spreadsheet shows the weeks you have entered. It does not flag the week your balance will cross the floor, project recurring patterns automatically into next quarter, or let you test what a new expense does to the next 52 weeks before you commit to it.
Recurna Flow runs the same ledger structure automatically, across all your accounts, with a full-year view and a simulation sandbox for testing changes before they happen. The floor alarm, the comparison view, and the unlimited forecast horizon are Pro features.
The structure you built in the template maps directly into Flow. The income anchors, the recurring bills, the floor — they all transfer. You are not starting over. You are switching containers.
For a step-by-step walkthrough of setting up the ledger from scratch, see Setting Up Your First Weekly Ledger.
Ready to run it automatically? Recurna Flow Pro covers the reconciliation, the floor alarm, and the full-year view — without the spreadsheet maintenance.