Profit records activity; cash follows payment timing
A company can recognise revenue before collecting the invoice and incur costs before paying suppliers. Forecasting only the profit and loss account misses those movements. Begin with a reconciled balance sheet so existing debtors, creditors and obligations are not lost.
Distinguish the opening position from new forecast activity. Collections from old debtors may support early cash even if new sales collect slowly. Conversely, old tax or supplier liabilities can create outflows unrelated to the month’s reported profit.
Model receivables from actual commercial terms
Use invoice timing, payment terms and observed collection behaviour where available. A simple debtor-days calculation can be a starting point, but milestones, disputes and large customers may require separate schedules. Document which receipts are uncertain.
In a simplified hypothetical steady-state business, increasing monthly sales from £100,000 to £150,000 at 60-day collection terms increases the receivables funding requirement by roughly £100,000, before tax and other timing effects. The example illustrates exposure; the detailed cash schedule should determine the model result.
Include stock and supplier timing together
More sales may require purchasing inventory well before delivery. Link buying to lead times, stock policy and the expected cost of goods, then apply supplier payment terms. Treat minimum orders and committed purchases explicitly where material.
Do not assume supplier credit expands indefinitely with revenue. Limits, deposits or shorter terms can change the cash requirement. Model the position under the actual arrangements and identify where the plan depends on a supplier agreeing something new.
Capture step costs and investment dates
Additional premises, machinery or managers may be required before the related revenue arrives. Include deposits, implementation costs and the period before productive capacity is available. Separate capital expenditure from depreciation to avoid confusing cash payments with accounting charges.
A forecast that adds staff only after sales have increased may reverse the actual operating sequence. Discuss recruitment and training lead times with the relevant manager. Timing assumptions should reflect how the business delivers, rather than making the cash result look more comfortable.
Read the cash low point and financing separately
Show cash before new funding, proposed funding and the resulting balance as separate lines. Identify the month or week of the low point and the headroom relative to the company’s own operating needs. A positive year-end balance does not prove there is no earlier shortfall.
If borrowing is included, model drawdown timing, interest, fees and principal repayments using the proposed terms. Mark facilities as committed or uncommitted. The forecast should reveal the funding requirement rather than automatically fill it with an unexplained loan.
Trace one month from sales to bank cash
Choose the month with the lowest forecast balance and reconstruct its receipts and payments. Check which items originate in earlier periods and which obligations fall outside the profit and loss account. This makes a funding discussion concrete and helps identify timing errors that can be obscured by an annual cash summary.
| Area | Evidence to examine | Question to resolve |
|---|---|---|
| Receipts | Opening debtors and new invoice collections | Are payment dates supported rather than assumed equal to sales? |
| Payments | Suppliers, payroll, tax and other obligations | Are old balances and irregular amounts included? |
| Investment | Deposits, capital purchases and financing | Does the schedule use payment dates instead of depreciation? |
Use the model to test operational choices
Compare changes such as phased recruitment, customer deposits, slower expansion or different purchasing patterns. Include their commercial consequences; reducing stock can affect availability, and asking for deposits may influence demand. Keep the original case visible for comparison.
Consult EFC can discuss an integrated financial model for the decisions and reporting you need. Begin with the growth plan and data available. The useful output is a transparent funding picture and explicit alternatives, not an assurance that growth or finance will be achieved.
Your preparation checklist
- Reconcile the opening balance sheet and existing obligations.
- Link collections and purchasing to actual terms.
- Include setup costs and investment before revenue arrives.
- Show cash before funding, the low point and downside headroom.
Frequently asked questions
Can a profitable forecast still need finance?
Yes. Receivables, inventory, investment and repayment timing can consume cash despite reported profit.
Is a monthly cash forecast always detailed enough?
Not necessarily. Tight cash positions or uneven payments may need a weekly view alongside the longer-term model.
Should borrowing be a balancing figure?
Show the need separately and include borrowing only with explicit assumptions about availability, timing, cost and repayment.
Sources and scope
This is general preparation guidance. Worked examples are original hypothetical illustrations, not client outcomes, market multiples or individual advice. Agree the purpose, evidence and scope before commissioning professional work.
Professional background: ICAEW technical resources. These links provide context and do not imply endorsement, assurance or compliance for an individual engagement.
Explore the related questions
Discuss the decision with Consult EFC
Tell us the decision, approximate timing and the information available. We will discuss suitability, scope and fees before work begins. Please arrange a suitable channel before sharing confidential documents.