Skip to content

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.

Thirteen weeks, rolled forward Nothing saved

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.

Receipts and payments expected in each of the thirteen weeks
WeekWeek endingReceiptsPayments
1—
2—
3—
4—
5—
6—
7—
8—
9—
10—
11—
12—
13—

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.

  1. Closing cash for a week is its opening cash plus its receipts minus its payments.
  2. Opening cash for week one is the figure you enter; for every later week it is the previous week's closing cash.
  3. Week-ending dates run seven days apart from the date you give for week one.
  4. The base case uses your receipts and payments as entered.
  5. The tight case lowers every week's receipts by your receipts percentage and raises every week's payments by your payments percentage.
  6. The strong case does the opposite: receipts up by the receipts percentage, payments down by the payments percentage.
  7. 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?
Cash only, in the week it moves. Receipts are customer payments you expect to land, loan proceeds and owner contributions; payments are payroll and its taxes, rent, supplier bills on their due dates, loan payments, sales tax and owner draws. An invoice you send this week is a receipt in the week the customer pays it, and a bill you receive is a payment in the week you pay it, so the sheet follows the bank, not the profit and loss.
How do I pick the percentages for the tight and strong cases?
From your own history. Look at how far a slow month's collections fell short of an average month's, and how much payments rose when something went wrong, and use those gaps as the tight case; use a good month's gaps the other way for the strong case. If you have no history yet, a modest round figure on each side shows how sensitive the lowest week is, which is the point of running the cases.
Does the forecast save what I type?
No. The sheet runs in your browser and nothing you enter is sent anywhere or stored; reloading the page clears it. Download the CSV before you leave if you want to keep the figures, or print the page. The page sends one anonymous event saying the forecast was run, with no figures in it.
Where should the opening cash figure come from?
From a reconciled bank balance: the balance on your last bank statement, adjusted for deposits and payments that have cleared since, agreed to the cash account in your books. A forecast that starts from an unreconciled balance carries its error into all thirteen weeks, which is why the forecast and the reconciliation belong together.
When is a 13-week forecast worth handing to someone else?
When the lowest week comes close to zero, when a lender or a board asks for it, or when nobody has time to roll it forward every week. Rolling it forward means replacing the oldest week with actuals from the reconciled books and adding a new week at the end; that discipline is what makes the forecast worth reading.

More free tools: the tools page.

Free books review (832) 702-3325