Tools · 13-week forecast
A 13-week cash forecast, built from your own numbers.
Enter the cash you start with and what you expect to come in and go out each week. The sheet carries the balance forward thirteen weeks and runs a tight case and a strong case beside your base case, so the lowest week is visible before it arrives.
Runs in your browser; nothing you type is sent or saved. Print it, or download it as a CSV.
How a week works
Opening cash
Week one opens on your reconciled bank balance; every later week opens on the week before's closing figure.
Receipts in, payments out
Cash in the week it moves — not the week it is invoiced or billed.
Three cases
Your percentages move receipts and payments against you for the tight case, and in your favor for the strong one.
The sheet
Your opening cash, thirteen weeks of receipts and payments, two percentages.
Working template — fill in your own figures. Not client data.
Download as CSV — your forecast once it's filled in, or the blank template. Columns: week-ending date, opening cash, receipts, payments, ending cash, scenario.
A forecast is only as good as the balance it starts from and the actuals it is rolled forward with. When the lowest week is close to zero, or a lender wants the forecast every month, our advisory work keeps it rolled forward on reconciled books.
The arithmetic
How the sheet carries cash forward, week by week.
- Closing cash for a week is its opening cash plus its receipts minus its payments.
- Opening cash for week one is the figure you enter; for every later week it is the previous week's closing cash.
- Week-ending dates run seven days apart from the date you give for week one.
- The base case uses your receipts and payments as entered.
- The tight case lowers every week's receipts by your receipts percentage and raises every week's payments by your payments percentage.
- The strong case does the opposite: receipts up by the receipts percentage, payments down by the payments percentage.
- The lowest week in each case is the week with the smallest closing cash — the number the forecast exists to show.
A blank cell counts as zero. Amounts are rounded to whole dollars for display; the CSV keeps two decimals. The cash-flow page explains how a forecast like this is kept against the books, and budgeting and forecasting covers the longer view.
FAQ
Using the sheet, and when to hand it over.
What counts as a receipt and what counts as a payment in a 13-week forecast?
How do I pick the percentages for the tight and strong cases?
Does the forecast save what I type?
Where should the opening cash figure come from?
When is a 13-week forecast worth handing to someone else?
More free tools: the tools page.