Cash flow forecast for the Christmas period: the six-week plan that stops January surprises
November is the month when cash flow surprises are born. Christmas trading, early pay dates, supplier bills landing before customers pay, and a January VAT and self-assessment season waiting on the other side. Businesses that forecast the next six weeks now will enter January calmly. Businesses that do not will spend January chasing money they already earned.
A cash flow forecast is not a complicated model. For a small business, it is a week-by-week list of money expected in and money expected out, built from facts you already have: invoices raised, invoices due, payroll dates, rent, and regular supplier payments. The point is not precision to the pound. The point is seeing a shortfall three weeks before it happens, while you can still do something about it.
Start with what is certain
Build the forecast in three layers, starting with the certainties.
First, money out that will not move: payroll, rent, loan payments, direct debits, and the December pay date if you bring it forward. If your business pays staff early in December, that cost lands in December, not January, and your forecast must show it there.
Second, money in that is already invoiced and due. List each invoice by its due date, not by the date you raised it. An invoice due on 19 December is December cash. An invoice due on 5 January is January cash, however much you wish otherwise.
Third, everything else: expected sales, expected supplier bills, and seasonal costs such as Christmas stock, temporary staff, or extra delivery charges. Be honest here. A forecast built on optimistic sales is worse than no forecast at all, because it tells you that you are safe when you are not.
The five checks that matter before Christmas
1. When do your customers actually pay?
Look at the last three months, not at your payment terms. If your terms say 30 days but your customers pay in 45, forecast on 45. December makes this worse: many finance teams close early, and an invoice sent on 12 December may not be paid until mid-January. If that is your pattern, plan for it now.
2. Chase before the break, not after it
The week before Christmas is your last real chasing window. Send statements in late November, call the larger balances in early December, and agree payment dates in writing. A customer who promises payment on 18 December is useful. A customer who goes quiet until 5 January is a January problem you could have prevented.
3. Match supplier payments to receipts
Suppliers also want paying before Christmas, and some will ask for early settlement. List your supplier bills by due date and compare them with the receipts above. If a large supplier payment falls due in a week when no customer receipts are expected, that is the gap to fix now, either by agreeing a later date or by bringing a receipt forward.
4. Keep a buffer for January
January brings its own demands: the VAT quarter, self-assessment payments on account for sole traders and partners, and the usual monthly bills, all before Christmas trading income has fully arrived. Your forecast should show a January opening balance that covers at least the fixed costs, even if December receipts slip by two weeks. If it does not, that is the warning to act on now.
5. Update it weekly until January
A forecast written in November and never revisited is decoration. Update it every week with actual receipts and payments, and re-forecast the remaining weeks. The forecast gets more accurate as Christmas approaches, and each update shows whether the plan is holding or slipping.
What a good forecast looks like
Keep it simple enough to update in 30 minutes. One row per week, columns for opening balance, receipts, payments, and closing balance. Add a short note under any week where the closing balance drops close to zero, explaining what you will do if that receipt slips. That note is the real value of the exercise: it turns a surprise into a plan.
Watch three numbers in particular. Debtor days, meaning how long customers take to pay, tells you whether chasing is working. The closing balance each week tells you when you need to act. And the January opening balance tells you whether Christmas trading actually left you better off, or just busier.
When forecasting needs outside help
Many small businesses know they should forecast but never get round to it, because the bookkeeping is behind, the bank is not reconciled, or nobody owns the weekly update. That is a common pattern, and it is fixable. A forecast built on unreconciled books is guesswork, so the first step is always clean, up-to-date records.
Once the records are current, a regular forecasting routine becomes straightforward: weekly updates, a monthly review, and a clear view of the next 13 weeks at any time. If that routine sounds useful but your team has no spare capacity to run it, look at accounting outsourcing services and FP&A services to see how forecasting and management reporting are run as a managed service.
Start this week. Six weeks of warning is worth more than six weeks of hope.

Comments
Post a Comment