Weekly vs Monthly Cash Flow Forecast: Which Should a Small Business Use?
You already have a monthly budget, and your accountant sends monthly reports. So why would anyone forecast cash week by week? Because cash doesn’t move monthly. Payroll goes out every other Friday, retainers land on the 1st, the quarterly tax payment hits in one week. A monthly total adds all of that up and hands you a single number that may never actually appear in your bank account.
The clearest way to choose is to run the same business both ways and compare what each one shows.
All figures are illustration assumptions for one invented business, the same example used in our 13 week cash flow forecast guide.
The business
- Opening cash: $30,000. Minimum cash floor: $15,000
- Payroll: $14,000 every second week
- Rent and fixed overheads: $5,700 in the first week of each month
- Loan: $1,800 monthly. Contractors and variable costs: $1,500 a week
- Quarterly tax payment: $6,000 in week 7
- Receipts over the quarter: $124,500, arriving in lumps
- Payments over the quarter: $137,700
View 1: The averaged monthly view (budget style)
This is what you get if you take the quarter’s totals and divide them evenly by month, as many budgets do. Average monthly receipts come to about $41,600, average monthly payments to about $46,000, so the business loses about $4,400 a month.
| Month | Opening | Net | Closing | vs $15k floor |
|---|---|---|---|---|
| 1 | $30,000 | −$4,412 | $25,588 | OK |
| 2 | $25,588 | −$4,412 | $21,176 | OK |
| 3 | $21,176 | −$4,412 | $16,764 | OK |
Verdict from this view: gently declining, never below the floor. Nothing to worry about this quarter.
View 2: The real monthly view (month-end totals)
Now put each payment in its actual month and look at the bank balance on the last day of each month. Month 3 here has five weeks.
| Month | Receipts | Payments | Closing | vs $15k floor |
|---|---|---|---|---|
| 1 (weeks 1–4) | $37,500 | $41,500 | $26,000 | OK |
| 2 (weeks 5–8) | $35,500 | $47,500 | $14,000 | Below |
| 3 (weeks 9–13) | $51,500 | $48,700 | $16,800 | OK |
Verdict from this view: one bad month-end, then a recovery. Month 3 looks fine.
View 3: The weekly view
| Week | Closing | Status | Week | Closing | Status | |
|---|---|---|---|---|---|---|
| 1 | $40,800 | OK | 8 | $14,000 | Below | |
| 2 | $31,300 | OK | 9 | $21,800 | OK | |
| 3 | $37,500 | OK | 10 | $13,300 | Below | |
| 4 | $26,000 | OK | 11 | $18,500 | Tight | |
| 5 | $33,800 | OK | 12 | $9,000 | Below | |
| 6 | $23,800 | OK | 13 | $16,800 | Tight | |
| 7 | $17,500 | Tight |
Verdict from this view: three weeks below the floor, and the lowest point of the quarter, $9,000 in week 12, falls inside the month that View 2 called “fine.”
Same invoices. Same bills. Three different answers. Only the weekly view shows the week where a single late client payment could mean missing payroll.
Side-by-side comparison
| Weekly forecast | Monthly forecast | |
|---|---|---|
| Best horizon | Next 13 weeks | 6 to 18 months |
| Shows payroll weeks | Yes, each run in its week | Blended into a monthly total |
| Catches mid-month dips | Yes | No, only month-end balances |
| Months with three paydays | Obvious | Easy to miss |
| Effort to maintain | ~15 min/week | ~30 min/month |
| Main use | “Can I make payroll? When will cash get tight?” | “Can I afford a hire, a lease or a slow season?” |
| Accuracy | High near term (mostly known invoices and bills) | Lower (more estimates) |
Which one should you use?
A monthly forecast is probably enough if: - you hold several months of costs in cash and rarely go near your floor - payroll is monthly, and income arrives fairly evenly - you mainly need it for bigger planning decisions
Use a weekly forecast if any of these are true: - you pay staff weekly or fortnightly - a few large clients or retainers make up most of your income - clients regularly pay late, or you’re on net-30 or longer terms - you’ve ever been unsure whether payroll would clear - you have quarterly tax payments or large annual bills to plan around - your balance regularly gets near your minimum
Most growing businesses use both. A rolling weekly 13-week forecast for the near term, where precision matters and the numbers are mostly known, and a monthly view beyond that for decisions like hiring or a new lease.
The fortnightly payroll trap
If you pay every two weeks, you’ll get 26 paydays a year, which means two months a year have three paydays instead of two. A monthly budget built on “two payrolls a month” underestimates those months by a full payroll run. A weekly forecast puts each run in its real week, so the three-payday months show up on their own. For the payroll-specific check, see how to know if you can make payroll next month.
Get a weekly forecast without building one
The 13 Week Cash Flow Forecast & Runway Planner is a ready-built weekly forecast. Set one start Monday and the 13 columns date themselves. Recurring items like fortnightly payroll, monthly rent and quarterly bills land in the right weeks automatically, and unpaid invoices drop in by expected pay date. It also gives you the monthly picture: a Runway tab with months of cash and the monthly revenue you need to break even. It works in Excel and Google Sheets.
Featured on ReadySheetGo
13 Week Cash Flow Forecast & Runway Planner — $18.99
A rolling weekly forecast with recurring payroll and overheads by frequency, aged receivables, delayable payables, scenarios, seasonality and a runway summary. Works in Excel and Google Sheets.
General information only, not accounting or financial advice. All figures are illustration assumptions for one invented business.
Frequently Asked Questions
Is a weekly or monthly cash flow forecast better?
For the next quarter, weekly is usually better for a small business, because payroll, rent, retainers and tax payments land in specific weeks and a monthly total averages the low points away. For planning six to eighteen months out, monthly is more practical. Many businesses use both: a weekly 13-week forecast for the near term and a monthly view beyond it.
When is a monthly cash flow forecast enough?
When income and costs arrive fairly evenly through the month, you hold a comfortable cash buffer, and payroll is monthly. If you pay staff weekly or fortnightly, get paid in lumps, or run close to your minimum balance, a monthly view can hide the weeks that matter.
How long does a weekly cash flow forecast take to maintain?
Once it's set up, around 15 minutes a week: replace last week's forecast with actuals, update unpaid invoices and bills, and add a new week at the end. A template that pulls invoices and recurring payments into the right week automatically keeps it at that.
What is a 13 week cash flow forecast?
A weekly forecast covering the next 13 weeks, roughly one quarter. Each week starts with opening cash, adds expected receipts, subtracts expected payments and ends with closing cash, rolling forward one week at a time.