Most budget templates start with a month. You list income at the top, expenses below, subtract, and arrive at a number that means something on the 1st and almost nothing by the 15th — and nothing useful on a Tuesday in November when your car insurance renewal, a short-week paycheque, and a credit card due date all land in the same seven days.
A weekly ledger starts with the week. Not the average week, but the actual weeks on your calendar, with the actual bills on the dates they hit. The first setup takes an hour. After that, it runs on its own.
This guide walks through the five inputs your ledger needs, how to calibrate the one number that protects you from the bad weeks, and what the first reconciliation actually looks like.
The five inputs a weekly ledger needs
A weekly ledger is not a detailed transaction log. It is a structure that takes what you already know about your money and makes it visible, week by week, before the money moves. Five things go in.
Income anchors. When do you get paid, and how much? Write down the date and amount
for every income source — salary, contract payment, side income — as it actually
arrives. A biweekly paycheque of $2,400 is not $1,200 twice a month. It is
$2,400 on a specific Friday, every other week, landing in specific calendar weeks.
The weeks it misses are weeks your balance does not grow. Those gaps matter.
Recurring bills. Every fixed expense that leaves your account on a known schedule:
rent, mortgage, insurance, subscriptions, loan payments, phone. Record the amount and
the date. Most of these are exact — a recurring bill you anchor once stays anchored.
Annual and semi-annual bills go in here too, at the full amount on the date they
actually hit, not spread as a monthly average. Your ledger should show the $900
insurance hit in the week your balance actually drops by $900.
Variable categories. Groceries, fuel, eating out, discretionary spending — you set a weekly budget for each. These are the only estimates in your ledger. Set them based on what you actually spend over a normal month, divided by 4.3. Do not use an aspirational number. An honest weekly grocery budget that you hit consistently is more useful than an optimistic one you revise every month.
Account floors. The floor is the lowest balance you are willing to let your
chequing account reach before you take action. It is not a spending target. It is a
minimum threshold: a signal that tells you money needs to move before the tight week
arrives, not after. Without a floor, a balance of $400 looks fine in a vacuum. With
a floor set at $500, you know you are already below your buffer and need to act.
Current balances. Your starting point. What is in your chequing account right now, and in any other accounts you track? The ledger projects forward from this number. An approximate starting balance produces an approximate forecast. Use the actual figure from your bank account, not a rough estimate from memory.
That is the full list. You do not need a category for every merchant, a colour-coded breakdown of last month’s spending, or a running total of impulse purchases. You need the five inputs above, entered once, maintained with a weekly check-in.
Setting your account floor
The floor is worth more time, because most people skip it when they first set up a ledger — and then wonder why the numbers feel wrong even when the weekly totals are technically positive.
Here is why it matters. Your ledger might show a positive ending balance every week
of the year. But if that balance dips to $220 in the third week of October because
three bills landed in a six-day window, and a $280 credit card minimum is due the
next morning, the weekly total tells you nothing useful. You are technically fine over
the month. You are not fine that week.
A floor converts that vague discomfort into a specific number. The space between your actual balance and the floor is not spending money — it is a buffer against clustering, against bills that land in the same stretch by coincidence, against months where income arrives on the 17th and the mortgage leaves on the 1st.
How to set it: start with the largest single-week cash event in your calendar year —
the overlap of rent or mortgage and a major annual renewal, for example — and add a
$200–$300 margin. That sum is a reasonable floor for most chequing accounts.
If you are new to tracking this and do not yet have a sense of your tight weeks,
$500 is a sensible starting point. Raise it after a full cycle, once you have seen
where the hard months actually cluster.
Anchoring recurring transactions
The most valuable thing you do when setting up a weekly ledger is also the most one-time: entering every recurring transaction.
Every bill that leaves your account on a fixed or near-fixed schedule gets entered once. Rent on the 1st, phone on the 15th, streaming on the 22nd, insurance in March and September. Once they are in the ledger, they carry forward automatically. You do not re-enter them. You do not think about them again unless the amount changes.
This is the step that turns a transaction log into a forward-looking structure. You are not recording the past. You are encoding what you already know about the future, so the ledger can show it to you before it happens.
A few categories to anchor carefully:
Annual and semi-annual bills. Car insurance, home insurance, property tax, registration renewals — these are the expenses most likely to surprise people who only track monthly averages. Enter the full amount on the real date. The ledger should show the hit in the week it lands, not a smoothed monthly estimate. The whole point of this structure is to see that week coming.
Biweekly paycheques. Enter them on actual pay dates, not as monthly totals. The difference between a pay period that ends on the 4th and one that ends on the 18th matters when a large bill lands on the 6th. Averaging destroys that signal.
Variable or irregular income. If your income fluctuates — contract work, self-employment, commission — anchor a baseline you are confident you will earn in a typical period, and treat anything above it as unplanned income when it arrives. A conservative anchor that you regularly beat is more honest than an optimistic one that leaves your forecast perpetually short.
Once the recurring entries are in place, the scaffolding is done. The ledger now knows more about your financial calendar than most budgeting apps will ever surface.
Walking through your first reconciliation
Reconciliation is the weekly check-in that keeps your ledger accurate. Done consistently, it takes under ten minutes. Skipped for a month, it becomes a two-hour audit.
Pick one fixed time each week — Sunday evening works for most people — and do the same four things:
Check your actual balance. Open your bank account and note the real number. Compare it to what your ledger predicted for today. If they match within a few dollars, move on. If they differ by more than that, something hit that you did not expect — a refund, a forgotten charge, a bill that cleared a day early. Identify it and record it.
Log variable spending from the past week. Groceries, fuel, eating out, any
discretionary purchases. You do not need to enter every individual transaction. You
need enough to keep your category totals honest over the month. If you budgeted
$160 for groceries and spent $195, note the difference. If you spent $130, note
that too. Accuracy over four weeks, not perfection each Sunday.
Look at the next two weeks. What is coming? Any large bills you have not yet entered, any income that may be delayed, any planned purchase? Adjust forward entries if something has changed. This step takes sixty seconds when your recurring entries are accurate and five minutes when they are not.
Check your floor. Does any week in the next two weeks dip below it? If yes, you have time to act now: move money from savings, delay a non-essential purchase, or simply know the week will be tight and stop adding anything to it. The forecast has done its job — it found the problem while you still had room to move.
That is the complete reconciliation. Batch, not real-time. Once a week, not once per transaction.
On the free tier of Recurna Flow, you get a 12-week view of your ledger — enough to see most seasonal clusters before they arrive. The full 52-week view, the account floor alarm, and the ability to test a new expense before you commit to it are Pro features.
A template you can start with today
If you want to get the structure in place before you choose a tool, the spreadsheet below gives you the framework: one row per week, columns for each income source and recurring bill, a variable spending total, and a running balance. The floor sits at the bottom — a single number you set once.
Download the weekly ledger template (CSV)
Fill in the first month by hand. This is deliberate: entering your own numbers forces you to confront the real dates and amounts you live with. After a month, you will know exactly what your ledger needs to show — and whether a spreadsheet is still the right container for it.
When to stop using a spreadsheet
A spreadsheet is the right place to start. It makes you understand the structure before you hand it off to automation. But it has a ceiling, and most people reach it within a year.
The first limit is multi-account complexity. A second chequing account, a savings buffer, a line of credit you want to track against its own floor — adding a second account means manually cross-referencing two sets of rows. That kind of maintenance is the thing that makes people stop reconciling.
The second limit is the forward view. A spreadsheet shows the weeks you have entered. It does not automatically flag the week your balance will cross the floor, project recurring patterns into the next quarter, or let you test a new car payment against the next 52 weeks before you commit to it. You have to rebuild the logic for every new question.
If you find yourself spending more time maintaining the spreadsheet than reading it, that is the signal. The structure you built here maps directly into a tool built around the same model.
The 52-week cash flow forecast is the natural next step — it shows how to read a full year of your ledger at once, find the tight weeks before they arrive, and test decisions against your real calendar before you commit.
Ready to run the ledger without the spreadsheet? Recurna Flow Pro does this automatically, every week, across all your accounts.