Why 13 weeks?
Thirteen weeks covers one quarter -- long enough to see the shape of your near-term cash position, short enough to forecast with genuine accuracy. Unlike a 12-month cash flow forecast, which is necessarily built on assumptions, the 13-week forecast is built on known commitments: invoices already issued, bills already received, payroll dates already fixed.
For businesses managing tight liquidity, navigating a turnaround, or preparing for due diligence, the 13-week cash flow forecast is non-negotiable.
The structure
A 13-week forecast has three sections:
Opening cash balance. The actual cash in the bank at the start of week one. Pull this from your bank feed, not your accounting system -- the two often differ due to timing.
Weekly cash inflows. Break these into categories: customer receipts (based on invoices outstanding and expected payment dates), other income, loan drawdowns, and any one-off inflows like asset disposals or tax refunds.
Weekly cash outflows. Payroll (typically monthly but allocate to the week it pays), supplier payments (based on invoices payable and payment terms), tax payments (VAT, corporation tax, PAYE), debt service, rent, and discretionary spend.
The closing balance for each week becomes the opening balance for the next.
Building the receipts forecast
This is where most teams struggle. The key is to forecast based on when cash actually arrives, not when revenue is recognised:
Step 1. Export your aged debtors report. Each outstanding invoice has an expected payment date based on payment terms.
Step 2. Apply a collection adjustment. If your average customer pays 10 days late, shift the expected receipt accordingly. Be honest -- optimistic collection assumptions are the fastest way to a cash crisis.
Step 3. For revenue not yet invoiced, estimate the invoice date based on your sales pipeline or contract schedule, then add payment terms.
Building the payments forecast
Payments are more predictable than receipts:
Payroll. Known to the penny. Include employer NI and pension contributions, which often pay on different dates from net salaries.
Suppliers. Export your aged creditors report and schedule payments by due date. Flag any large or unusual payments.
HMRC. VAT payments (monthly or quarterly), PAYE and NI (monthly), corporation tax (quarterly instalments for larger companies). These dates are fixed -- missing them incurs penalties and interest.
Committed costs. Rent, loan repayments, insurance, and lease payments. These rarely change and can be hard-coded.
Maintaining the forecast
The 13-week forecast is a living document. Update it weekly:
- Replace the completed week with actual cash movements
- Add a new week 13 at the end
- Update receipts based on the latest aged debtors
- Adjust for any new commitments or changes
Red flags to watch for
- Any week showing a negative closing balance
- Receipts consistently arriving later than forecast
- A downward trend in cumulative cash position
- Heavy payment clustering in a single week (reschedule if possible)
A well-maintained 13-week forecast gives the CFO early warning of cash pressure, typically four to eight weeks before it becomes critical. That lead time is the difference between a managed solution and an emergency.