Find the week cash runs short
Start with cash you can actually use. Put payroll, tax and committed supplier payments in the week they fall due. Use expected collection dates for customer receipts.
Cash Flow Forecasting | Consult EFC
Can you cover payroll if a major customer pays late?
How the handover works. We agree who updates receipts and payments, who checks the opening cash balance and when the team reviews exceptions. Bring the next payroll or supplier deadline and the receipt most likely to slip. See the 13-week forecast example.
Illustrative cash forecast. With £90,000 available and £100,000 due, a delayed £45,000 receipt leaves a £10,000 shortfall. If payroll is the last payment due that week, the forecast shows how much must be covered before payday.
See the worked 13-week cash forecastTell us which payment is due and when. We can build a 13-week forecast from your bank balance, expected receipts and committed payments.
Consult EFC builds cash forecasts for UK SMEs and technology businesses. From a 13-week receipts-and-payments view to a rolling planning model, we connect the numbers to practical actions and an update routine your team can maintain.
Start with cash you can actually use. Put payroll, tax and committed supplier payments in the week they fall due. Use expected collection dates for customer receipts.
Move the receipt into the week it is likely to arrive. Compare the lowest weekly cash balance with the buffer you want to keep. Agree who will chase the receipt and when you need a funding or spending decision.
The brief
A cash flow forecast sets out expected receipts, payments, opening cash and closing cash for defined periods. It focuses on payment timing. A profit forecast, a bank balance and an unused lending limit do not by themselves establish the cash available for the next commitment.
A decision before a spreadsheet
Map payroll, suppliers, tax, debt payments and committed spending alongside realistic collection dates. Identify the weeks that need attention.
Explore hiring, stock, development, implementation and capital spending against the cash the business can reasonably expect to collect.
Organise the forecast and supporting assumptions for the agreed audience. A forecast can inform a lender or investor, but does not guarantee finance.
Choose the right horizon
A detailed short-term receipts-and-payments schedule. Useful when collections, payroll, supplier terms or near-term funding need close attention. Forecast actual dates where material; monthly averages can hide a weekly shortfall.
A longer planning view, with the period, detail and update cadence agreed for your decision. Connect trading, working capital, investment and financing rather than extend a flat run-rate indefinitely.
Where you need a connected profit and loss account, balance sheet and cash flow, explore financial modelling services. A standalone weekly cash schedule answers a different question from a fully integrated business model.
Explore the detail
Illustration only: flat weekly receipts and payments for 13 weeks. The delayed amount is moved from week 2 to week 4, and the extra payment occurs in week 3. No other tax, funding, seasonality or intra-week movements are added automatically. Include relevant cash flows in your inputs. Not a forecast or advice for your company.
| Week | Baseline closing cash | Stressed closing cash |
|---|
Build from the records
Agree the bank balances, entities, currencies, restricted amounts and valuation of any currency balances relevant to the forecast. Do not treat every balance as freely available cash.
Use receivables, payables, contracts, payroll and other commitments. Distinguish expected cash from pipeline, unsigned funding, disputed balances or undrawn facilities with conditions.
Document collection assumptions, cost changes and management responses. Name who updates each input and what triggers escalation when the actual result differs.
Keep the forecast useful
A short-term forecast needs an update cycle. Compare actual cash movements with the previous forecast, explain differences, refresh expected dates and extend the horizon. A missed collection may be a timing issue, a dispute or a change in recoverability; the response depends on the reason.
The output can include a weekly action list covering collections, payment timing, committed spending and financing questions. Management actions remain subject to contractual obligations, available approvals and any relevant professional advice.
For continued leadership of cash, reporting and the broader finance agenda, see fractional CFO support. The cash runway stress test provides a separate monthly planning illustration.
An illustrative weekly view starts with £90,000 of available cash, adds £45,000 of confirmed receipts and deducts £100,000 in payroll, supplier and tax payments. Closing cash is £35,000, leaving £10,000 above a £25,000 minimum. If £20,000 of receipts slip, cash falls £10,000 below the minimum.
Use that downside to agree which collections to chase and which payments need review. See the worked 13-week cash-flow example.
A clearer brief. Practical outputs.
Identify the entities, currencies and bank balances included. Distinguish available cash from restricted balances and confirm which facilities are available under the agreed assumptions.
Connect collections, payroll, suppliers, tax, debt service and planned spending to expected timing. Assign an owner and evidence to important assumptions.
Compare forecast with actual cash, explain changes and record actions. Separate a timing difference from a permanent shortfall or a new spending commitment.
£80,000 opening + £45,000 receipts − £60,000 payments.
£65,000 opening + £30,000 receipts − £55,000 payments.
If £20,000 of those receipts arrives later, week 2 closing cash is £20,000.
Illustrative figures, not a client result or forecast. A delayed receipt may recover later; a bad debt is a different assumption. The complete forecast must also reflect all relevant payments and financing.
The useful question is what management can do before the pressured week: collect an overdue balance, change planned spending, negotiate terms or investigate funding. Decisions remain with management, and an unapproved facility should not be treated as cash already available.
Start with a 13-week receipts-and-payments view where near-term liquidity is the priority. Use a connected financial model when longer-term growth, profitability and funding assumptions need to be tested together. Compare financial modelling support ↗
How we work
Clarify your objective, audience, information, deadlines, deliverables, responsibilities, fee and VAT treatment.
Assess the records, definitions and assumptions. Identify gaps and any accounting, tax, legal or specialist input required.
Complete the agreed work, document important judgements and review outputs with the relevant people.
Explain checks, limitations, ownership and updates. Additional work and recurring support are agreed separately.
Your questions
It is a weekly view of opening cash, expected receipts, expected payments and closing cash over thirteen weeks. It helps management identify timing pressure and update near-term decisions.
Profit follows the accounting policies used to recognise income and costs. Cash follows payment timing. Credit sales, stock, capital spending, tax and debt movements can make the two materially different.
Normally bank balances, aged receivables and payables, collection expectations, payroll, tax dates, debt payments, contracts and planned spending. We agree the data sources and responsibilities for the brief.
Yes. We can agree specific collection changes and show their effect on cash. The illustration on this page moves an entered receipt from week two to week four; it does not assess whether the customer will actually pay.
The engagement must define the intended audience and any reliance terms. We can prepare agreed outputs, but acceptance and financing decisions remain with the third party.
A weekly update is often useful for a 13-week view. The appropriate cadence depends on the business, cash pressure, reporting needs and the reliability of incoming information.
The fee and timing depend on the records, entities, currencies, horizon, detail, scenarios and ongoing support. Scope, fee, VAT treatment and responsibilities are agreed before work begins.
No. It is a simple illustration using flat weekly receipts and payments, one delayed receipt and one one-off payment. It excludes unentered items and intra-week timing. A professional forecast needs business-specific information.
Yes. Customer collection dates, stock, supplier payments, tax, debt repayments and investment can create a cash gap even when the accounts show a profit.
Recurring updates can be included if agreed. We define who supplies actual cash data, revises assumptions, reviews variances and approves actions. A one-off build does not automatically include an ongoing reporting service.
Work directly with Kishen
Tell us the objective, where things stand and any important date. A short outline is enough to start.
Kishen Patel is an ICAEW Chartered Accountant with experience across Big Four audit, investment banking and corporate advisory. Consult EFC has advised 100+ businesses and remains sector agnostic.
We agree scope, information, responsibilities, fee, VAT treatment and timing before work begins. An introductory call does not commit you to an engagement.
Prefer to explore first? Use the relevant assessment tool for an immediate planning result and downloadable action plan. It is not professional advice.