2 min read
Why 13 Weeks?
A 13-week window represents one quarter — long enough to catch seasonal dips and payment cycles, short enough that individual line items remain credible. Beyond 13 weeks, cash forecasting shades into longer-term modelling where assumptions carry more weight than data.
For most trading limited companies, this horizon covers the vast majority of predictable obligations: payroll, supplier terms, VAT quarters, and loan repayment dates. Lenders and investors frequently request this format when assessing short-term liquidity.
Structure of the Template
The template is organised into three bands: opening cash balance, receipts, and payments. Each band runs across 13 weekly columns, with a fourth column for the forecast total and a fifth for actuals-to-date.
- Receipts: customer remittances, intercompany transfers, asset disposal proceeds, grant drawdowns
- Payments: supplier BACS runs, payroll, HMRC PAYE/NIC, VAT, loan principal and interest, capital commitments
- Net movement: receipts minus payments per week, cumulative to closing balance
A variance column for each week disciplines the forecast — unexplained variances of more than 10% week-on-week should trigger a commentary note.
Feeding the Template with Reliable Data
The most common failure mode is populating receipts from invoice dates rather than expected payment dates. Always convert to expected receipt dates using actual debtor payment history, not nominal credit terms. Where a debtor consistently pays at 45 days on 30-day terms, model 45 days.
For payments, use confirmed BACS dates rather than invoice due dates. A payment run on a Friday affects cash on Monday; model the bank-value date, not the accounting date. This distinction is immaterial over a year but significant within a 13-week window.
Using the Forecast to Trigger Action
The closing balance row is the actionable output. Any week showing a projected negative balance — or a balance below a director-set minimum threshold — should automatically flag a decision point: accelerate receipts, defer discretionary payments, or draw on an existing revolving credit facility.
If no facility exists and the gap cannot be bridged operationally, a 13-week forecast with a clearly labelled funding requirement is exactly the document a commercial lender will want to see first. It demonstrates management awareness and quantifies the ask precisely.
Frequently asked questions
Should the 13-week forecast include VAT on receipts and payments?
Yes — the forecast should reflect actual cash movements, which means VAT-inclusive amounts on both sides. Model the VAT payment to HMRC as a single outflow on the relevant payment date, not spread across the quarter.
How often should we update the forecast?
Roll the forecast forward by one week each week, adding a new week at the far end and locking the prior week as actuals. A monthly update will miss intra-month liquidity pinch points entirely.
Can this template be used to support a funding application?
Yes. A completed 13-week cash flow with a clearly labelled funding gap and a note explaining the root cause (e.g. a large order requiring upfront materials spend) is a standard supporting document for a commercial term loan or revolving credit facility. Figures are illustrative of your position, not a guarantee — confirm with your adviser before submitting to any lender.
Funding for UK limited companies
Credicorp lends to your company, not to you personally — short-term working capital with no personal guarantee. See what your business could access.