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

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.

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.

See the Week Cash Gets Tight Before It Arrives

The 13 Week Cash Flow Forecast & Runway Planner — 14 tabs and 1,816 formulas for a small business cash forecast: a rolling 13-Week Forecast grid driven from one start Monday (opening cash, receipts, payments, closing cash and headroom above your cash floor); a Runway tab with the first week below your floor, the date you run out if nothing changes, your lowest balance and break-even monthly revenue; Receivables aged Current/1-30/31-60/61-90/90+ with DSO and expected pay dates; Payables with Can Delay flags; Recurring payroll, rent, retainers and loans by frequency (weekly, fortnightly, monthly, quarterly); Base/Best/Worst Scenarios; Seasonality; Forecast vs Actual accuracy scoring; and a Dashboard that ranks invoices to chase and bills you could hold, with 20 data checks. Sample quarter pre-filled. Works in Excel and Google Sheets.

View on Etsy — $18.99