How to build a 13-week cash-flow forecast for a restaurant

To build a 13-week cash-flow forecast, put one week in each column and start week one with cleared bank cash. Enter income when it will clear and payments when they are due. Calculate closing cash for every week. Each Monday, replace estimates with actuals and add a new week 13.

A monthly forecast can hide the Friday when wages and a supplier run leave together. A 13-week view keeps those pressure dates visible while there is still time to change an order, chase a receipt or speak to a supplier.

Thirteen weekly columns expose pressure that a monthly total hides

Create one column for each of the next 13 weeks. Use the Monday start date as the column heading so nobody has to guess which seven days a figure covers.

The British Business Bank says a forecast should cover at least the business's cash-flow cycle. It also says income belongs in the period when money reaches the bank, not when the sale or invoice is recorded.

1. Opening cash.
2. Card settlements, cash banked, delivery-platform payouts and other receipts.
3. Approved supplier invoices, grouped by payment date.
4. Net payroll and the separate PAYE and National Insurance payment.
5. Rent, rates, utilities, loan payments and regular subscriptions.
6. VAT and other dated tax payments.
7. Net cash movement, closing cash and the minimum buffer.

The next column's opening cash must equal the previous column's closing cash. Add a final row for headroom above your minimum buffer; a negative figure is the week that needs an action.

Confirmed and expected cash need separate labels

Not every forecast figure carries the same confidence. Mark each receipt or payment as confirmed, expected or provisional.

Confirmed cash includes the cleared opening balance, scheduled card settlements, approved supplier invoices and fixed direct debits. Expected cash can include forecast sales, draft rota payroll and a supplier order that has not been invoiced. Provisional cash covers events that could move or disappear.

This prevents a £9,000 weekend sales forecast from looking as certain as £6,400 already sitting in the bank.

Involiqo gives the near-term forecast an operational anchor: Cash Left shows the current position, while Bills Due and approved invoice details provide supplier totals and payment dates. You can trace a weekly supplier figure back to the bills behind it instead of repeating last month’s average.

Metro Kitchen falls from £19,350 to £13,850 in week three

The figures below are illustrative. Metro Kitchen starts Monday with £18,400 of cleared cash and protects a £10,000 minimum buffer.

1. Week 1: £14,600 comes in. Supplier bills, wages and other payments total £13,700. Closing cash is £19,300.
2. Week 2: £13,900 comes in and £13,850 goes out. Closing cash is £19,350.
3. Week 3: £12,800 comes in. Supplier bills are £7,640, wages are £5,200, VAT is £4,300 and other payments are £1,160. Total cash paid is £18,300.
4. Week 4: £14,100 comes in. Supplier bills, wages, rent and other payments total £16,600. Closing cash is £11,350.

Headroom above the £10,000 buffer falls to £3,850. It then falls again to £1,350 in week four. The problem is visible two Mondays before the restaurant would notice it from the bank balance alone.

The owner can now test a specific action. Moving a non-essential £2,200 equipment payment from week four to week seven would lift week-four closing cash to £13,550. That is a timing scenario, not a claimed saving.

Tax dates belong in the exact week they clear

Do not spread quarterly VAT evenly across 13 weeks. Put the full payment in its actual week and build the reserve before that date.

GOV.UK says VAT returns are usually submitted every three months. The online filing and payment deadline is normally one calendar month and seven days after the accounting period ends. Confirm the exact date in the business’s VAT account.

GOV.UK says monthly electronic PAYE payments are due by the 22nd of the next tax month; postal cheque payments must arrive by the 19th. Allow for weekends, bank holidays and the time needed for payment to clear.

Keep net wages and the HMRC payment separate. Combining them can hide the later week when PAYE and National Insurance leave the account.

Five shortcuts make a 13-week forecast unreliable

• Recording sales in the week they happen. Use the card processor or delivery platform’s settlement date.
• Repeating a flat supplier estimate. Replace it with approved invoice totals for the weeks where bills already exist.
• Leaving VAT inside the bank balance. Show the expected payment on its due date and protect the reserve before then.
• Counting one payment twice. Match invoice schedules, direct debits and planned payment runs before adding them.
• Letting the forecast stop at week 13. Every Monday, close the completed week and add a new final week.

A Monday roll keeps the forecast useful

1. Replace last week's forecast receipts and payments with actual bank movements.
2. Reconcile the opening cash for the new week.
3. Add newly approved invoices to their payment weeks.
4. Update card settlements, payroll, rent and tax dates.
5. Review the lowest closing-cash week and the buffer headroom.
6. Assign one action, one owner and one deadline.
7. Add a new week 13 using the best available sales and cost assumptions.

Record the reason for every large change. A short note such as “Metro Meats invoice moved from week 4 to week 3” prevents the next review from reopening the same question.

Frequently asked questions

Why use 13 weeks rather than 12?

Thirteen weeks gives you a full quarter plus one weekly review point. It can show a quarterly VAT payment, three monthly rent or PAYE cycles and the supplier timing around them. It is still short enough to update with operational evidence rather than distant annual assumptions.

Should restaurant sales be entered gross or net of VAT?

Enter the cash amount expected to reach the bank so the weekly balance reconciles. Then keep the estimated VAT liability in a separate row and place its payment in the correct week. Use your accounting records and scheme to confirm the amount; this article is not a VAT calculation method.

How accurate should weeks 9 to 13 be?

Use honest estimates and label their confidence. Base sales on comparable weeks, known bookings and closure dates. Base supplier spend on recent invoice patterns and expected order volumes. The later weeks will change; the value comes from seeing the direction and updating it every Monday.

Key takeaways

• Put one week in each column and carry closing cash into the next opening balance.
• Record receipts and payments in the week cash clears, not the accounting date.
• Use approved invoice due dates for near-term supplier costs.
• Put VAT and PAYE in their exact payment weeks.
• Roll the forecast every Monday and protect a visible minimum buffer.

Your forecast should name the week that needs a decision

A 13-week forecast is useful when it points to one pressure week, one cause and one action. Start with cleared cash, separate confirmed figures from estimates and replace supplier averages with approved bills as they arrive.

Sources

• British Business Bank: How to create a cash-flow forecast in four steps — https://www.british-business-bank.co.uk/business-guidance/guidance-articles/finance/how-to-create-a-cash-flow-forecast-in-4-steps
• GOV.UK: Sending a VAT Return — https://www.gov.uk/submit-vat-return
• GOV.UK: Pay employers’ PAYE — https://www.gov.uk/pay-paye-tax
• Involiqo: How to work out how much cash your business actually has left — https://involiqo.com/blog/practical-cash-flow-review-stock-based-businesses
• Involiqo: Supplier invoice approval checklist — https://involiqo.com/blog/supplier-invoice-approval-checklist
• Involiqo: Spot supplier price increases in invoice data — https://involiqo.com/blog/spot-supplier-price-increases-invoice-data