13-week cash forecast

13-week cash forecast inputs

First day of week 1

Each week covers 7 days from the start date.

Opening bank balance (AUD) Minimum cash buffer (AUD) Original receipt week Receipt to delay (AUD) Delay in whole weeks

Enter bank receipts and payments for each week, including GST where cash includes it. Include BAS, payroll, super, loan payments, capital purchases and drawings in their expected payment weeks. The initial zeros are empty planning amounts. A delayed receipt must already be included in the original week’s total.

Week	Receipts (AUD)	Payments (AUD)
1	Week 1 receipts	Week 1 payments
2	Week 2 receipts	Week 2 payments
3	Week 3 receipts	Week 3 payments
4	Week 4 receipts	Week 4 payments
5	Week 5 receipts	Week 5 payments
6	Week 6 receipts	Week 6 payments
7	Week 7 receipts	Week 7 payments
8	Week 8 receipts	Week 8 payments
9	Week 9 receipts	Week 9 payments
10	Week 10 receipts	Week 10 payments
11	Week 11 receipts	Week 11 payments
12	Week 12 receipts	Week 12 payments
13	Week 13 receipts	Week 13 payments

Calculate

Enter the inputs and calculate.

Receipts delayed beyond week 13 appear separately in the result and CSV. They do not enter this horizon’s closing balance. To compare scenarios, download each before changing the delay.

Download forecast CSV

Save or load inputs

Save inputs to a file on this device and load it later to continue. The file is read in your browser, and an invalid file changes nothing.

Save inputs Load inputs (replaces the current forecast)

How it works

Weekly closing cash = opening cash + receipts − payments. Each closing balance opens the next week. Funding gap = minimum buffer − lowest opening or weekly closing cash, with a floor of zero. It is a planning gap, not a lending decision. Weekly totals can hide a shortage within the week.

business.gov.au: cash flow

The Lumbridge cash flow case works the same question with a 45-day receipt delay.

One of the nine business calculators. Calculations run in this browser. The calculator code does not send your inputs to a server or save them automatically. To check, disconnect from the internet once the page has loaded, then calculate. Use Save inputs to download a local scenario file, then Load inputs to resume it.

Planning estimates in AUD. Confirm tax treatment, liability amounts and dates separately. Amounts round to the nearest cent, with exact half cents rounded up.

Written by Ryan Duguid in his own time and on his own equipment. He is a Provisional CA ANZ Member. CA ANZ has not endorsed this site or its tools.