13-Week Cash Flow Forecast: A Step-by-Step Guide

A 13-week cash flow forecast is the most direct way to see whether your business has enough money to operate over the next quarter. It works week by week, tracking real receipts and real payments, so you know exactly when your balance gets tight and whether you can cover what is coming. This guide walks through how to build one from scratch, what to put in each section, and the mistakes that make these forecasts unreliable.

What a 13-week forecast is for#

Thirteen weeks is roughly one quarter. That horizon is long enough to spot a problem before it arrives, and short enough that your estimates stay grounded in things you actually know: which invoices are outstanding, when payroll runs, what your rent date is.

It is not a strategic model. It does not tell you whether your business will succeed. It tells you whether you will run out of money in the next 90 days.

The format is almost always direct method. You list every expected receipt. You list every expected payment. The difference is your closing balance for that week, which becomes the opening balance for the next. That single closing number tells you whether you have a problem.

If you want to understand why the direct method is the right choice for short-horizon forecasting, the comparison in direct vs indirect cash flow forecasting is worth reading before you start.

Set up your structure before you enter a single number#

The structure of a 13-week forecast is fixed. You need a row for your opening cash balance. A section for receipts. A section for payments. A net cash row showing receipts minus payments. A closing balance row that carries forward to the next week.

That is it. Everything else is filling in the receipts and payments sections with the right line items.

Build it in columns across the top, one column per week, labelled either Week 1 through Week 13 or by actual calendar dates. Dates are better. When you are trying to match a payment to a specific week, knowing it falls in the week of 6 October is more useful than knowing it is Week 4.

Start with your opening balance#

Week 1's opening balance is your current bank balance. Not your accounting balance. Not your projected balance. The actual number in your bank account right now.

If you have multiple accounts, use the total across all operating accounts you draw from to pay expenses. Do not include money that is earmarked, restricted, or sitting in a separate account you never touch for operations.

This number anchors everything. If it is wrong, every week that follows is wrong.

Fill in receipts from what you actually know#

Receipts are money coming into your bank account. Not revenue recognised. Not invoices raised. Money received.

Work through what you know first. Invoices already sent with known payment terms. Subscription renewals on known dates. Retainer payments from existing clients. Loan drawdowns already agreed. Any grants or tax credits with confirmed payment dates.

For each receipt, put it in the week you expect the money to land in your account, not the week you earn it or invoice it. A £10,000 invoice sent today on 30-day terms lands in Week 5, not Week 1.

Be honest about collection risk. If a client pays slowly, do not put the receipt in Week 4 because that is when the invoice is technically due. Put it in Week 6 or 7 because that is when they actually pay. This is the line people are least honest about, and it is the one that causes the most surprises.

For new sales you expect to close, apply a probability weighting or exclude them from the base case entirely and model them as a separate scenario. Mixing confirmed receipts with hoped-for sales in the same row makes the forecast useless as a risk tool.

Fill in payments with more precision than you think you need#

Payments are where most of the work is. Every payment your business makes needs to sit in the right week.

Fixed, recurring payments are straightforward. Payroll. Rent. Software subscriptions. Loan repayments. List them once, identify which week they hit, and replicate across all 13 weeks. If payroll runs on the 15th and the last day of the month, you know exactly which weeks those are.

Variable payments take more effort. Supplier invoices. Freelancer fees. Marketing spend. Tax payments. For each one, find the actual due date or expected payment date and place it in the right week.

Tax payments deserve particular attention. VAT returns, corporation tax instalments, and PAYE payments all fall on fixed dates and are often large enough to create a visible dip in your closing balance. Missing them is the most common way a 13-week model produces a false sense of security.

Work through your payment categories clearly. Payroll. Rent. Software. Supplier invoices. Tax. Loan repayments. Contractor fees. Anything else that regularly leaves your account.

Calculate net cash and closing balance for each week#

Once receipts and payments are in, the arithmetic is simple.

Net cash equals total receipts minus total payments for that week. Closing balance equals opening balance plus net cash.

The closing balance for Week 1 becomes the opening balance for Week 2. Carry this forward across all 13 weeks without breaking the chain. Break it, and the model stops being a forecast and becomes a collection of disconnected snapshots.

Look at the closing balance row in isolation once you have finished. The lowest point in that row is your minimum cash position over the 13-week horizon. That is the number that matters. If it goes negative, you have a problem that needs addressing before it arrives, not after.

Identify your low points and act on them#

A 13-week forecast is only useful if you read it and respond to it.

Mark every week where the closing balance drops below your minimum operating threshold. For most early-stage businesses, that threshold is roughly one month of fixed costs. If your fixed monthly costs are £25,000, your closing balance should stay above £25,000 at all times.

When you spot a low point, you have three options. Accelerate a receipt — chase an invoice, ask for early payment, negotiate a deposit. Defer a payment — talk to a supplier, push back a non-critical spend. Add a receipt — draw on a credit facility, bring forward a planned investment round.

The forecast does not solve the problem. It gives you enough notice to solve it yourself.

Update it every week#

A 13-week forecast built once and never touched is a historical document within a fortnight. The value is in the update cycle.

Every week, replace the estimates for the week just passed with what actually happened. Adjust the remaining weeks based on what you now know. Move receipts that did not arrive. Add payments that came in unexpectedly.

This weekly discipline does two things. It keeps the forecast accurate. And it forces you to confront the gap between what you expected and what happened, which is where most of the useful learning about your business lives.

The update should take 20 to 30 minutes if the structure is clean. If it takes longer, the structure needs simplifying.

What a 13-week forecast cannot tell you#

It cannot tell you whether your business model works. It cannot replace a P&L. It cannot show you whether you are profitable or what your gross margin looks like.

Those questions belong to a different kind of model. If you need a full picture that includes a P&L, balance sheet, and runway alongside your cash flow, you need something that builds all three from your business inputs together. That is a different exercise from a 13-week cash flow forecast, and the two serve different purposes.

For founders who need both the short-horizon cash view and the longer investor-ready financial picture, forecasting cash flow without accounting data covers how to build that fuller model when you do not have a bookkeeper or accounting system in place.

When to use a 13-week forecast versus a longer model#

Use a 13-week forecast when you need to manage operational cash. It is the right tool when you are watching a tight position, navigating a funding gap, or trying to time a large payment.

Use a longer model when you are planning for growth, preparing for an investor conversation, or trying to understand your runway over 12 to 18 months. A full cash flow forecast built from your business drivers gives you that horizon.

The two are not substitutes. Many founders run both at the same time: the 13-week model for day-to-day cash management, and a longer driver-based model for strategic decisions and investor conversations.

If you need the longer model but do not have an accounting system or finance hire to build it, bluprnts builds the full three-statement picture directly from your business inputs. No accounting software required. You can start at bluprnts.ai.

Frequently asked questions#

What is a 13-week cash flow forecast?#

A 13-week cash flow forecast is a rolling, week-by-week projection of money coming into and going out of your bank account over the next 13 weeks. It uses the direct method, listing actual expected receipts and payments rather than accounting entries, so you can see your closing cash balance at the end of each week and identify any points where your balance could go negative.

Why 13 weeks specifically?#

Thirteen weeks covers one quarter, which is long enough to spot a cash problem before it becomes a crisis, and short enough that your estimates remain grounded in things you actually know. Longer horizons require too many assumptions to be reliable for operational cash management. Shorter horizons do not give you enough notice to take corrective action.

What is the difference between a 13-week cash flow forecast and a P&L?#

A P&L shows revenue and costs on an accrual basis, meaning it records transactions when they are earned or incurred, not when cash moves. A 13-week cash flow forecast records money only when it physically enters or leaves your bank account. A business can be profitable on a P&L and still run out of cash if its customers pay slowly and its suppliers demand payment quickly.

How often should I update a 13-week cash flow forecast?#

Weekly. At the start of each week, replace last week's estimates with actuals and adjust the remaining weeks based on what you now know. The forecast loses most of its value if it is not kept current, because the whole point is to give you advance warning of a tight position while you still have time to act.

What should I do when the forecast shows a negative closing balance?#

A negative closing balance in any week means you are projected to run out of money before the end of that week. Your options are to accelerate a receipt — chase an outstanding invoice, request a deposit, draw on a credit facility — defer a payment by negotiating extended terms with a supplier or pushing back a non-critical spend, or add new cash through a loan, investment, or grant. The forecast gives you the notice; the action is yours to take.

Can I build a 13-week cash flow forecast without accounting software?#

Yes. A 13-week forecast is built from direct knowledge of your expected receipts and payments, not from accounting records. You need to know your bank balance, your outstanding invoices, your fixed payment dates, and any variable payments due. A spreadsheet or a purpose-built forecasting tool works. Accounting software is useful for pulling historical actuals but is not a requirement for building the forecast itself.

Is a 13-week cash flow forecast the same as a runway calculation?#

No. A runway calculation tells you how many months of operating expenses your current cash balance covers, usually expressed as a single number. A 13-week forecast shows you the week-by-week movement of cash, including the timing of specific receipts and payments. Runway is a summary metric. A 13-week forecast is an operational tool that shows you exactly when and why your cash position changes.