How to turn supplier price changes into a cash-flow forecast

A higher invoice total alone proves very little. The order may be larger, the pack size may differ, or a credit may be missing. The useful signal is the change in price for the same item and unit.

That signal must then pass through four questions: what changed, how much will you buy, when will you pay, and what cash remains afterwards?

A unit-price change becomes a cash issue only after volume and timing

Start with two comparable invoice lines. Match the supplier, product, specification, pack size and unit of measure. Check any discount, credit and VAT treatment before calculating the movement.

1. Unit-price change: new unit price − old unit price.
2. Weekly purchase-cost change: unit-price change × expected weekly quantity.
3. Forecast cash effect: weekly purchase-cost change placed in each week the supplier payment will clear.

Do not rank changes by percentage alone. A 5% increase on a high-volume protein may remove more cash than a 25% increase on a garnish bought once a month.

HMRC says VAT-registered businesses must retain the invoices they receive and record the value of purchases. That makes the reviewed supplier invoice the right evidence source, but not the finished forecast. GOV.UK VAT record-keeping rules: https://www.gov.uk/charge-reclaim-record-vat/keeping-vat-records

One beef price rise removes £5,460 from a 13-week plan

The following Metro Kitchen example is illustrative. Assume the same specification of beef mince rises from £31.40 per kg to £38.40 per kg. The restaurant expects to buy 60 kg each week and pays that supplier in the same week.

1. Unit-price increase: £38.40 − £31.40 = £7.00 per kg.
2. Percentage increase: £7.00 ÷ £31.40 × 100 = 22.3%.
3. Weekly cost increase: £7.00 × 60 kg = £420.
4. Thirteen-week impact: £420 × 13 = £5,460.

Suppose the restaurant protects a minimum operating buffer of £20,000. The baseline forecast sits £4,000 above it. The updated forecast sits £1,460 below it.

The invoice change has therefore moved from a cost alert to a dated decision. The owner can review menu price, portion size, waste, purchase volume or supplier terms before the buffer is crossed.

This does not mean every £420 must leave in the invoice week. If payment terms are 14 days, put the cash movement into the payment week. Business Wales advises recording forecast costs when they are paid, not when the invoice arrives: https://businesswales.gov.wales/topics-and-guidance/starting-a-business/start-and-business-planning/cashflow-forecast

Price decreases matter only when the saving survives the volume test

Track decreases with the same discipline. Suppose cooking oil falls from £3.85 to £3.50 per litre. At 40 litres a week, the saving is £0.35 × 40 = £14 a week, or £182 across 13 weeks.

That is useful, but it does not offset the £5,460 beef increase. The net 13-week pressure from these two reviewed movements is still £5,278.

Check that the lower price covers the same product, quality, pack and terms. A cheaper substitute with a lower yield can increase the real cost per portion. Involiqo cost-per-portion guide: https://involiqo.com/blog/cost-per-portion-restaurant

Move the reviewed invoice change into the payment week

A short weekly routine keeps invoice evidence and cash planning connected:

1. Review new invoice lines before saving them.
2. Compare the unit price with the last like-for-like purchase.
3. Confirm whether the change is temporary, disputed or expected to continue.
4. Multiply the unit difference by realistic weekly quantity.
5. Add the revised supplier payment to the correct forecast week.
6. Recalculate the lowest cash point and buffer headroom.
7. Give one response an owner and a date.

The British Business Bank says a cash-flow forecast should include outgoing cash, including raw materials, and should be updated as estimates become more exact: https://www.british-business-bank.co.uk/business-guidance/guidance-articles/finance/how-to-create-a-cash-flow-forecast-in-4-steps

Involiqo can hold reviewed invoice line items and show price, quantity, supplier and spending movement over time. Use that evidence to update the business forecast. Do not assume an alert has automatically changed a separate forecasting model.

For the full forecast structure, continue with the Involiqo 13-week restaurant cash-flow forecast guide: https://involiqo.com/blog/13-week-cash-flow-forecast-restaurant

Three forecast errors hide the real exposure

Should one expensive invoice change the forecast?

Change the forecast when the invoice is valid and the price is likely to affect future purchases. Treat a one-off substitution, missed discount or disputed charge separately. Record the assumption and review the next comparable invoice. One unusual line is a prompt to check, not proof of a permanent supplier increase.

Which date belongs in the cash forecast?

Use the date the payment should clear. The invoice date supports the audit trail, while the due date controls cash timing. If a supplier bill is uncertain, label it as estimated rather than quietly removing it. A forecast should show the possible pressure before the bank balance confirms it.

Should supplier prices be forecast including VAT?

For cash planning, start with the amount expected to leave the bank. Keep the VAT basis consistent across weeks and maintain the separate records your VAT position needs. Accounting and tax treatment can differ from the operational cash view, so confirm material decisions with the business’s accountant.

Five controls make the calculation reliable

1. Compare the same unit, not only the same description.
2. Separate unit-price movement from quantity movement.
3. Use expected volume, not last week’s volume by default.
4. Put cash into the payment week, not automatically the invoice week.
5. Reconcile forecast and actual supplier payments each Monday.

GOV.UK says a limited company’s records must include money spent, debts, stock and goods bought. The forecast remains a management estimate, but its inputs should still trace back to reliable records: https://www.gov.uk/running-a-limited-company/company-and-accounting-records

Key takeaways

• An invoice total does not isolate a supplier price change.
• Unit-price change × expected volume gives the operating cost effect.
• Payment timing determines when that effect reaches cash.
• Price decreases deserve the same check as increases.
• The lowest revised cash point should trigger the decision.

Turn the next invoice alert into one decision

Review the largest verified weekly cost movement first. Put it into the 13-week forecast, name the lowest cash week and decide what must change before the next order.

Sources

• HMRC: keeping VAT records — https://www.gov.uk/charge-reclaim-record-vat/keeping-vat-records
• GOV.UK: company and accounting records — https://www.gov.uk/running-a-limited-company/company-and-accounting-records
• British Business Bank: how to create a cash-flow forecast — https://www.british-business-bank.co.uk/business-guidance/guidance-articles/finance/how-to-create-a-cash-flow-forecast-in-4-steps
• Business Wales: cash-flow forecast — https://businesswales.gov.wales/topics-and-guidance/starting-a-business/start-and-business-planning/cashflow-forecast