A 13-week (one quarter) cash flow forecast tracking weekly inflows and outflows. Covers customer receipts, supplier payments, payroll, tax, and discretionary spend. Shows opening balance, net cash movement, and closing balance for each week.
What's included
Template preview
Step by step
Enter your current bank balance as the opening figure for week one. This should match your bank statement.
Estimate customer receipts using your accounts receivable ageing report. Include other income such as interest and grants.
List all planned payments — supplier invoices, payroll, rent, tax, loan repayments, and discretionary spend.
Check that no week drops below your minimum cash threshold. If it does, consider delaying discretionary payments or accelerating collections.
Each week, replace the forecast with actuals and add a new week at the end to maintain the 13-week horizon.
Watch out
Using P&L figures instead of cash — remember that revenue is not the same as cash received
Forgetting quarterly tax payments (VAT, Corporation Tax) that cause cash spikes
Not including annual payments (insurance, subscriptions) that only appear once a year
Related templates
Import this template directly into Grove FP and start planning. No credit card required.
FAQ