13-Week Cash Flow Template: Free Download and Guide

A 13-week cash flow forecast covers exactly one quarter, week by week. Short enough to be accurate. Long enough to show you where the problems are coming from. This guide explains what the template looks like, how to fill it in correctly, and what to do with the output.

No accounting software required. No bookkeeper needed.

What a 13-week cash flow forecast actually is#

A cash flow forecast is not a P&L. It does not record revenue when you earn it or costs when you incur them. It records money when it moves. Cash in when it lands in your account. Cash out when it leaves.

The 13-week format is a rolling, short-horizon view. Roughly a quarter, which makes it useful for operational decisions, investor conversations, and spotting a tight position before it becomes a crisis. Most businesses that use this format update it weekly, rolling the horizon forward as each week closes.

The direct method is the right approach. You list actual receipts and actual payments, week by week, and track the closing balance at the bottom. That single number tells you whether you have a problem.

The structure of the template#

A standard 13-week cash flow forecast template has three sections, stacked vertically, with a column for each of the thirteen weeks.

The first section is cash receipts. Every source of money coming in gets its own row. Customer payments. Loan drawdowns. Tax refunds. Grant receipts. Each row shows the week the cash actually arrives, not the week the invoice was raised.

The second section is cash payments. Every category of outgoing money gets its own row. Payroll. Rent. Supplier invoices. VAT. Corporation tax. Software subscriptions. Loan repayments. The more granular you are here, the more useful the forecast becomes.

The third section is the net and running balance. Net cash for the week is receipts minus payments. The closing balance is last week's closing balance plus this week's net. That running total is the number you watch.

The rows you need in receipts#

Only include cash you expect to receive in a specific week, based on realistic payment timing.

Customer receipts. The amount and the week depend on your payment terms. If you invoice on net-30 terms, a sale in week one does not appear in receipts until week five or six. Founders consistently overstate this section by confusing invoiced revenue with received cash.

Financing receipts. If you are drawing down a loan or have a credit facility, include the drawdown date here, not the approval date.

Other receipts. Tax refunds, R&D credits, asset sales, or anything else that will land in the account. Only include it if you have reasonable certainty about the timing.

The rows you need in payments#

This is where most forecasts go wrong. People include the obvious costs and miss the lumpy ones.

Payroll. Your single largest regular payment in most businesses. Include employer taxes and any pension contributions paid in the same run.

Rent and rates. Usually monthly, so they appear in one week per month, not spread across four.

Supplier payments. Map these to when you actually pay, not when you receive the invoice. If you pay on net-60 terms, a cost incurred in week one does not appear until week nine.

VAT. This is the one people are least honest about. VAT quarters create large, irregular outflows. Put the exact payment date in the correct week.

Corporation tax or income tax. Same logic. Large, infrequent, and often forgotten until the week before it is due.

Software, subscriptions, and services. Small individually, significant collectively. Annual subscriptions in particular create one-off spikes.

Loan repayments. Fixed date, fixed amount. Easy to include, easy to forget.

How to fill in the template week by week#

Start with the opening balance. That is your cash in the bank today, or at the start of the first week you are forecasting. Write it above week one.

Work through receipts first. For each customer or income source, identify which week the cash will arrive. If you have outstanding invoices, use the invoice date plus your payment terms to estimate the receipt week. Recurring revenue arrives on the same day each period.

Then work through payments. Go category by category. For regular weekly costs, fill across all thirteen columns. For monthly costs, identify the payment date and put the amount in only that week's column. For quarterly costs, same approach.

Calculate the net for each week. Receipts minus payments. A positive net means cash is building. A negative net means cash is leaving.

Calculate the closing balance for each week. Opening balance plus cumulative net. Watch for any week where the closing balance goes negative. That is your problem week.

Reading the output#

The closing balance row is the most important row in the template. Run your eye along it from left to right.

If the balance stays positive throughout, you have no immediate cash crisis. You can use the forecast to plan ahead: when to hire, when to invest, when to approach a lender.

If the balance dips negative at any point, you have a specific problem in a specific week. That is useful information. You know exactly how large the shortfall is and exactly when it occurs. That lets you act: accelerate a customer receipt, delay a non-critical payment, draw down a credit facility, or raise the issue with an investor before it becomes urgent.

A forecast that shows a problem is not a bad forecast. It is a forecast doing its job.

The difference between a tight week and a structural problem#

A single negative week is usually a timing issue. A large payment falls in the same week as a gap in receipts. You can often solve this by adjusting payment timing or pulling forward a receipt.

Several consecutive negative weeks, or a balance that never recovers, is a structural problem. Your business is spending more than it is taking in, and the gap is not closing. That requires a different response: a pricing review, a cost reduction, a fundraise, or a frank conversation with your investors.

The 13-week format makes this distinction visible. A spreadsheet that only shows monthly totals can hide a week-three crisis inside a month that looks fine in aggregate.

Common mistakes in 13-week forecasts#

The most common mistake is using invoiced revenue instead of received cash. If you raise an invoice in week two but your customer pays on net-45 terms, that cash does not appear until week eight or nine. Putting it in week two makes the forecast useless.

The second most common mistake is forgetting lumpy payments. VAT. Annual software renewals. Tax bills. These are predictable if you look for them, but they do not appear in a weekly payroll run, so people miss them. Go through your last twelve months of bank statements before you build the forecast and list every non-recurring payment you find.

The third mistake is building the forecast once and never updating it. A 13-week forecast that was accurate in week one is a historical document by week four. The value comes from rolling it forward weekly, comparing what you forecast against what actually happened, and updating the remaining weeks based on new information.

Turning the template into a live tool#

A static spreadsheet gets you started. The problem is maintenance. Every time headcount changes, a new contract comes in, or a payment date shifts, you have to rebuild the relevant rows manually. In a spreadsheet with thirteen columns and thirty-plus rows, that creates errors.

The other limitation is that a spreadsheet template gives you the cashflow statement and nothing else. You cannot see runway beyond thirteen weeks. You cannot see what the P&L looks like. You cannot share a formatted version with an investor without copying it into a presentation.

If you are at pre-seed or seed stage and need more than a snapshot, bluprnts builds the full financial picture from your business inputs directly. You enter your products and pricing, headcount, costs, and any financing lines, and it derives the P&L, balance sheet, cashflow, and runway automatically. No accounting software required. No existing ledger needed. The app is free to start with no credit card required.

For a deeper look at building the forecast itself, the guide on how to build a 13-week cash flow forecast covers the mechanics in more detail. If you want to extend the horizon beyond thirteen weeks, how to build a cash flow forecast covers the longer-range approach.

What the template cannot do#

A 13-week cash flow forecast is a short-horizon operational tool. It is not a financial model. It does not show you whether your business is profitable over twelve months. It does not tell you when you will run out of money if your growth assumptions change. It does not give an investor the three-statement model they need to assess your business.

For those purposes, you need a proper financial model built from your business drivers. The 13-week forecast is the operational layer on top of that model, not a replacement for it.

It also cannot compensate for bad inputs. If you are optimistic about receipt timing, or if you forget a major payment category, the forecast will tell you everything is fine right up until the week it is not. The discipline is in being accurate, not optimistic.

If you have never built a cashflow forecast before and want to understand the foundations first, forecasting cash flow without accounting data explains how to do it from scratch using only your business inputs.

FAQs#

What is a 13-week cash flow forecast template?
A 13-week cash flow forecast template is a structured spreadsheet with a column for each of thirteen weeks and rows for every category of cash receipt and payment. It calculates a weekly net cash figure and a running closing balance, showing you exactly when cash is tight and by how much.

Why 13 weeks specifically?
Thirteen weeks is one quarter. Short enough to forecast with reasonable accuracy based on known invoices, payment terms, and fixed costs. Long enough to see problems coming with enough time to act. Longer horizons become less reliable because too many inputs are uncertain.

How do I fill in the receipts section accurately?
Use your actual payment terms, not your invoice dates. If a customer pays on net-30 terms and you invoice them in week one, the cash arrives in week five or six. Go through your outstanding invoices and map each one to the week the payment is likely to land based on the invoice date plus your terms.

What is the difference between a cash flow forecast and a P&L?
A P&L records revenue when it is earned and costs when they are incurred, regardless of when cash moves. A cash flow forecast records money only when it enters or leaves your bank account. A business can be profitable on a P&L and still run out of cash if customers pay slowly or if large payments cluster in the same week.

How often should I update a 13-week cash flow forecast?
Weekly. At the end of each week, record what actually happened, compare it to what you forecast, and roll the horizon forward by one week. The forecast becomes more accurate over time as you understand your actual payment patterns.

Can I use a 13-week cash flow template to raise investment?
It helps, but it is not sufficient on its own. Investors typically want a 12 to 24-month financial model showing the full P&L, balance sheet, and cashflow, along with runway projections under different scenarios. The 13-week forecast is an operational tool; the investor model is a strategic one. You need both.

What should I do if the closing balance goes negative in my forecast?
Identify the specific week and the size of the shortfall. Then work out whether it is a timing problem (a large payment and a gap in receipts coinciding) or a structural problem (costs consistently exceeding receipts). Timing problems can often be solved by adjusting payment dates. Structural problems require a change to the business model, a cost reduction, or additional funding.