Business
Profitable but No Cash? Your 13-Week Cash Flow Forecast
Your sales are growing. Your accounts show a profit. So why does paying the next wage bill still feel uncomfortable? For many small business owners, the missing piece is the timing of money. A sale can look good in the accounts weeks before the customer pays. Meanwhile, wages, suppliers and rent keep leaving the bank.
Profit and cash flow answer different questions
Under accrual accounting, profit reflects income earned and costs incurred, rather than simply the money received and paid. Cash flow tracks the actual movement of money. A profitable business can therefore face a cash shortage. This distinction is particularly useful for limited company owners; a cash basis tax calculation follows different recognition rules, but it still does not replace a forward looking cash plan.
Think of a cleaning company that pays staff each month but invoices commercial clients on longer terms. Winning another contract may increase expected profit while creating an immediate need to fund extra wages. Growth can use cash before it generates cash. Looking only at turnover can hide that pressure.
Why use a rolling 13-week cash flow forecast?
Thirteen weekly columns give you roughly three months of visibility. That is a practical starting point for spotting payment gaps, rather than a legal requirement or a guarantee. Choose a longer horizon if your trading cycle needs it. Keep an annual forecast too, especially for seasonal costs or funding applications; Business.gov.uk recommends a 12-month forecast when preparing for funding.
The useful question is not just how much cash you expect at the end of the quarter. It is which week has the lowest balance. A healthy month end figure can hide a difficult payroll date halfway through the month. Check daily timing as well when the weekly margin is tight.
Build it around bank dates, not invoice dates
Start with the actual cleared opening bank balance. Enter customer receipts in the week you realistically expect payment, using invoice due dates and payment history. Keep uncertain sales separate from confirmed receipts. A verbal promise or a quote that has not been accepted should not quietly become guaranteed money.
Then list payments by their expected bank date: wages, suppliers, rent, subscriptions, loan repayments, equipment purchases and relevant tax payments. Include VAT consistently if registered, with the corresponding settlement or refund in the correct period. Ask your accountant to check the treatment if you are unsure. Do not mix net sales with gross supplier payments.
Use one simple calculation in each column: opening cash plus receipts minus payments equals closing cash. Carry that closing figure into the next week's opening balance. Show any overdraft facility separately so borrowed headroom is not mistaken for your own cash. Do not count an unapproved loan as available funding.
A worked example: the £4,000 gap hiding behind sales
This is an invented illustration, not a client case. A business starts week one with £8,000. It expects £4,000 of customer receipts and must pay £9,000, leaving £3,000. In week two it expects another £3,000 and has £10,000 of payments due. Its forecast closing cash is minus £4,000. That negative figure signals a funding gap; it does not mean the bank will allow those payments.
A £12,000 customer payment expected in week three will not pay week two's bills. If that receipt slips into week four, the pressure lasts longer. The forecast makes the timing visible while there is still time to discuss deposits, invoice milestones or agreed payment arrangements. These are options to explore, not assumptions to insert before anyone agrees.
Test the forecast before relying on it
Create a second version with your largest receipt delayed by two weeks. Then try lower sales or a supplier payment arriving earlier. These are planning scenarios, not predictions. Compare the lowest balance in each version and choose a minimum cash buffer suited to your commitments. There is no single safe buffer for every business.
Make Monday's review a 15-minute habit
Replace last week's estimates with actual bank movements, investigate the differences, and add a new week at the end. Confirm the next payroll, major supplier payments and customer receipts. Record who will chase each overdue invoice and when. Keep actions next to the numbers so the forecast leads to decisions rather than becoming another spreadsheet you avoid.
For businesses in Basildon, Leigh on Sea and across the UK, up to date bookkeeping gives this exercise a stronger starting point. EvolveBooks can help connect monthly bookkeeping and management accounts with practical cash planning, in English or Spanish. If sales look healthy but the bank balance tells a different story, tell us where the pressure is coming from and we can discuss suitable support.