13-Week Cash Flow Forecast: What It Is and How to Build One

A 13-week cash flow forecast is the short-term cash plan that lenders, turnaround advisers and experienced finance teams rely on. It shows receipts, payments and the closing bank balance for each of the next thirteen weeks. It is detailed enough to catch the week payroll and a supplier run collide, and short enough that most of the numbers are already known.

Why 13 weeks?

Thirteen weeks is one quarter. That length is a deliberate balance:

• Long enough to include a full payroll cycle, a quarterly tax payment, month-end supplier runs and a slow-paying customer, all at the same time.
• Short enough that most of the cash is already known: invoices have been sent, bills are scheduled, staff costs are fixed and orders are booked.
• Weekly detail reveals problems that a monthly forecast averages away. A month can end with a healthy balance even if the second week dips below zero.

When you need one

• Cash is tight and you need to know which week is the pinch point.
• You pay staff weekly or fortnightly.
• A bank, lender or investor has asked for one.
• You are going through a turnaround, refinancing, a large project or rapid growth.
• A major customer has started paying late, or you’ve lost one.

Even when none of these apply, many businesses keep a 13-week forecast alongside their 12-month plan because it takes little time and gives early warning.

What goes in it

The most important line is usually collections from existing invoices. Build it from your aged receivables list, customer by customer, placing each invoice in the week that customer realistically pays. Lenders look closely at this line, because it’s where optimistic forecasts go wrong.

How to build it, step by step

1. Set the weeks. Week 1 starts on the Monday after today. Label each column with its start date.
2. Enter the opening balance across all operating accounts.
3. Forecast collections from your aged receivables list, using each customer’s real payment behaviour.
4. Add new sales that will be invoiced and collected within the 13 weeks, and card or cash sales by week.
5. Schedule payroll on actual pay dates, including taxes and pension contributions.
6. Schedule supplier payments from your payables list and payment run dates.
7. Add everything else: rent, loan repayments, tax payments, insurance and planned purchases.
8. Calculate closing balances and flag any week below your minimum buffer.
9. Every week, replace week 1 with actuals, record the variances, drop it and add a new week 13.

A worked example

A business starts with $21,000 in the bank and a $12,000 minimum buffer. Payroll of $9,800 is paid every other week, rent at the start of each month and a $6,400 tax payment in week 7.

The early weeks look comfortable. But collections from older invoices shrink each week as they are paid off, payroll weeks keep coming, and the tax payment in week 7 takes a large bite. Carrying the forecast across all thirteen weeks shows how close the later weeks come to the buffer, which tells the owner to chase the slowest customers and line up new invoices now, while there is still time for them to pay.

Building collections from your aged receivables

Collections deserve extra care because they are usually the largest and least certain line. Start from your aged receivables report, the list of unpaid invoices grouped by how overdue they are, and place each customer’s invoices in the week you expect the money:

Two rules keep this line honest. First, use behaviour, not terms: a customer on 30-day terms who always pays in 50 days goes in at 50. Second, leave out disputed or very old invoices entirely, and treat them as upside if they arrive. Lenders will ask about both.

For new sales, forecast invoices you expect to raise in the next few weeks and apply the same payment behaviour. Sales invoiced in week 10 on 30-day terms won’t appear in the forecast at all, which is correct: they are next quarter’s cash.

Who owns the forecast

Give one person responsibility for updating the forecast every week, usually the owner, finance manager or bookkeeper, and review it in a short weekly meeting with whoever manages sales and purchasing. The meeting should end with decisions: which invoices to chase, which payments to hold, and whether anything needs to change in the weeks ahead.

Variance: the part most people skip

The real value of a 13-week forecast comes from comparing it with what happened. Each week, record the difference between forecast and actual for each line, and write one line of explanation for any big gap. After a few weeks, patterns appear: a customer who is always two weeks late, supplier payments that run higher than expected, card settlements that take an extra day. Adjust the assumptions, and the forecast becomes steadily more accurate.

What lenders look for

If you are preparing a 13-week forecast for a bank or lender, expect them to check:

• That collections are based on aged receivables and realistic payment timing, not invoice dates.
• That payroll, taxes and rent are complete and on the right dates.
• That the forecast has been updated every week with actual figures.
• Variance explanations for material differences.
• The minimum balance across the 13 weeks, and how it compares with any facility limit or covenant.

Common mistakes

• Using invoice dates instead of payment dates for receipts.
• Forgetting non-weekly items such as quarterly tax, insurance renewals and annual subscriptions.
• Building it once and not rolling it forward.
• Ignoring the financing lines, so the forecast hides reliance on an overdraft.
• Too much detail. Twenty to forty lines is enough; more makes weekly updates slow.

13-week vs 12-month forecast

The two do different jobs. The 13-week forecast manages cash now: it decides which invoices to chase this week and whether a payment can go out on Friday. The 12-month forecast plans the year: seasonal swings, hiring, investment and funding. The best setup links them, so the first three months of the annual view agree with the weekly detail. For the monthly method, see how to make a cash flow forecast; for the basics, what a cash flow forecast is.

Free and premium templates

Premium industry templates link a 13-week weekly view to a 12-month monthly view and a 3-year outlook, with best and worst case scenarios, an actuals tab and a variance report, so you can plan the short term and the long term in one file. Browse them by industry.