Cash Flow Forecasting | Consult EFC

Cash Flow Forecasting Services

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 forecast

Tell 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.

01Define the decision
02Build the evidence
03Explain the next step
100+ businesses advisedWork directly with KishenICAEW Chartered AccountantSector agnostic

A 13-week forecast you can use at the next cash meeting

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.

Test the late payment

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.

Tell us the payment date

The brief

What should this work
help you decide?

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

What does your forecast
need to help you decide?

01

Protect near-term liquidity

Map payroll, suppliers, tax, debt payments and committed spending alongside realistic collection dates. Identify the weeks that need attention.

02

Test growth commitments

Explore hiring, stock, development, implementation and capital spending against the cash the business can reasonably expect to collect.

03

Prepare a funding conversation

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

Weekly visibility.
A connected forward view.

A 13-week cash forecast

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 rolling cash forecast

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

A delay can change
the week that matters.

Lowest stressed closing cash

Calculating…

First negative stressed closing balance

Calculating…

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.

See all 13 weekly balances
WeekBaseline closing cashStressed closing cash

Build from the records

Dates, evidence
and accountable assumptions.

01

Reconcile opening cash

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.

02

Explain receipts and payments

Use receivables, payables, contracts, payroll and other commitments. Distinguish expected cash from pipeline, unsigned funding, disputed balances or undrawn facilities with conditions.

03

Record scenarios and owners

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

An operating rhythm.
Not a one-off file.

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.

Sample output from a 13-week cash forecast

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.

The forecast should lead to a weekly cash decision

A reconciled opening position

Identify the entities, currencies and bank balances included. Distinguish available cash from restricted balances and confirm which facilities are available under the agreed assumptions.

Receipts and payments by date

Connect collections, payroll, suppliers, tax, debt service and planned spending to expected timing. Assign an owner and evidence to important assumptions.

A live action and variance log

Compare forecast with actual cash, explain changes and record actions. Separate a timing difference from a permanent shortfall or a new spending commitment.

Illustrative week 1£65,000

£80,000 opening + £45,000 receipts − £60,000 payments.

Illustrative week 2£40,000

£65,000 opening + £30,000 receipts − £55,000 payments.

Week 2 delayed-receipt case£20,000

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

A defined brief.
A practical working process.

Agree the decision and scope

Clarify your objective, audience, information, deadlines, deliverables, responsibilities, fee and VAT treatment.

Review the information

Assess the records, definitions and assumptions. Identify gaps and any accounting, tax, legal or specialist input required.

Build, challenge and explain

Complete the agreed work, document important judgements and review outputs with the relevant people.

Handover and next steps

Explain checks, limitations, ownership and updates. Additional work and recurring support are agreed separately.

Your questions

Cash Flow Forecasting,
explained.

What is a 13-week cash flow forecast?

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.

How is cash forecasting different from profit forecasting?

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.

What information do you need?

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.

Can you model delayed customer payments?

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.

Can a lender or investor use the forecast?

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.

How often should the forecast be updated?

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.

How much does a cash forecast cost?

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.

Is the calculator on this page a forecast for my company?

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.

Can a profitable business still need a cash forecast?

Yes. Customer collection dates, stock, supplier payments, tax, debt repayments and investment can create a cash gap even when the accounts show a profit.

Do you update the forecast for us each week?

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

Bring your next decision.
We will help define the work.

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.