Weekly Cash Flow Forecast Template: When and How to Use One

A monthly forecast tells you whether you’ll end the month with money in the bank. A weekly forecast tells you whether you’ll get through the month. For businesses where cash is tight or timing is uneven, that difference is everything. This guide explains when a weekly cash flow forecast template is the right tool, how to set one up and a simple weekly routine that keeps it accurate.

Why weekly beats monthly when cash is tight

Consider a business with $40,000 of receipts and $38,000 of payments in a month. The monthly forecast shows a comfortable $2,000 surplus. But if payroll of $9,000 goes out on the 7th and the 21st, rent of $4,000 on the 1st, a $10,000 supplier run in the third week, and most customers pay in the last week of the month, the weekly picture looks very different:

The month ends $2,000 up, but the balance goes negative twice. A monthly view would never show it. A weekly one shows it weeks in advance.

When to use a weekly template

• Tight cash. The less headroom you have, the more the timing within the month matters.
• Weekly or fortnightly payroll. Pay days create regular dips.
• Uneven receipts. Customers who all pay at month end, or platforms that pay out weekly.
• A lender or adviser has asked for one. Weekly forecasts are standard in refinancing and turnaround situations.
• Growth, a big contract or a crisis. Any period where the next few weeks decide the business’s future.

When things are calm, a monthly forecast may be enough, with a weekly one ready to switch on.

Setting up a weekly template

1. Choose the start day. Monday is usual; some businesses start on their payroll day.
2. Enter the opening balance across all business accounts.
3. List receipts by week. Start with invoices already sent, placing each in the week that customer usually pays. Add card and cash sales by week, and new invoices you expect to raise and collect.
4. List payments by week. Payroll on its real dates, rent and loan repayments on their due dates, supplier runs on your payment days, and tax on its deadline.
5. Set a minimum buffer. The template turns any week below it red.
6. Find the lowest week and plan around it.

The free template does the date arithmetic for you: enter the first Monday and all thirteen week headers fill in.

What goes in each line

Collections from existing invoices are the most important line. Work through your unpaid invoices and place each one in the week that customer usually pays, not the week it’s due. Leave out disputed or very old invoices until they’re resolved.

New sales are invoices you expect to raise and collect within the thirteen weeks, plus card and cash takings. For card sales, allow a day or two for settlement; for marketplaces, use their payout schedule.

Payroll goes in on each pay date, including payroll taxes and pension contributions if they are paid at the same time. If taxes are paid monthly, put them in the week they’re due.

Suppliers go in on your payment run dates. If you pay suppliers every other Friday, the forecast should show that pattern.

Fixed costs such as rent, loan repayments, insurance and software go in the week they leave the account, usually near the start of the month.

Tax goes in the week of the deadline. Quarterly sales tax or VAT payments are often the largest single payment in a quarter.

Financing lines show any overdraft or credit line drawn or repaid, so the forecast never hides reliance on borrowing.

A 15-minute weekly routine

1. Actuals. Replace last week’s forecast with what actually happened, from the bank statement.
2. Variances. Note anything that differed by more than 10 percent and why. A customer paying late? A bill you forgot?
3. Roll forward. Remove the finished week and add a new week 13.
4. Update receipts. Move any late invoices to the week you now expect them, and add new invoices.
5. Decide. Look at the lowest week in the next four. Chase, delay or arrange funding if it’s below your buffer.

Do it at the same time every week, such as Monday morning before the week’s payments go out.

Weekly forecasting in different businesses

• Restaurants and cafés: payroll and food orders are weekly; card sales settle daily. See the restaurant guide.
• Construction and trades: progress payments and supplier accounts land on specific dates; crews are paid weekly. See construction.
• Ecommerce: marketplace payouts are weekly or fortnightly, and ads are paid daily.
• Cleaning and care businesses: large weekly payrolls against monthly client invoices.
• Agencies: monthly payroll but lumpy client payments, where a weekly view shows the exact risk week.

Common mistakes

• Spreading monthly costs across weeks. Rent paid on the 1st belongs in the first week, not a quarter in each.
• Using invoice dates for receipts. Put money in the week it arrives.
• Forgetting month-end supplier runs and quarterly tax.
• Not rolling forward. A weekly forecast that isn’t updated weekly quickly becomes wrong.
• Too many lines. Twenty to thirty is plenty; weekly updates need to be quick.

Free or premium?

The free 13-week template covers the weekly essentials: automatic week dates, receipts and payments, a rolling balance, buffer warnings, a summary and a chart. Premium industry templates add a weekly view that is linked to a 12-month forecast, best and worst case scenarios, an actuals tab and a variance report, plus industry calculations such as collections timing, stock purchases or subscriber churn that feed the forecast automatically. If you only need to get through the next quarter, start free; if you want the weekly view to be part of a full year’s plan, choose the premium version for your industry.

Weekly and monthly together

The best setup is a weekly view for the next quarter and a monthly view for the year, with the first three months agreeing. The weekly forecast manages the next few paydays; the monthly one plans hiring, purchases and seasons. Premium templates link the two and include a check row that shows if they disagree. For the full method, see the 13-week cash flow forecast guide and the 12-month template guide.