13-Week Cash-Flow Forecasting for Trades

The Importance of Cash Flow for Trades

Cash flow in a trades business isn’t an accountancy nicety — it’s the thing that keeps doors opening and fuel in the van. You can have a profit on paper and still be flat broke in the bank. I’ve seen profitable firms stop work because they couldn’t pay for materials. Think of a five-day kitchen job: you buy sinks, units and tiling upfront, pay a plasterer mid-week, and expect the final payment on practical completion. If those cash timings miss you, the job grinds to a halt and you lose reputation and margin. A live forecast points out those weeks before they arrive so you do something sensible about them.

Too many sole traders treat drawings like an afterthought. They take money out as they need it and aren’t clear about the impact on the business account. Limited companies juggle salaries, dividends and PAYE and often forget the liabilities until the quarter-end. A proper cash forecast forces you to list personal drawings, PAYE, VAT and corporation tax as ordinary outgoings. When you map these on a weekly view you can make deliberate choices — delay a draw one week, bring a dividend forward, or keep a tighter rein on supplier credit — instead of panicking when an unexpected bill lands.

Trades are seasonal and weather-dependent. Brickies and roofers get run-offs in dry weather and quiet pockets when the forecast turns wet. Painters and decorators often end up waiting for other trades or moving dates around. If you’re optimistic about continuous work you’ll run into predictable cash squeezes. A realistic 13-week forecast includes slower weeks and gaps between jobs. When you plan for those, you keep a buffer, avoid emergency borrowing and stop cancelling jobs because you can’t afford materials. That buffer is the difference between steady trading and living on the edge.

Finally, cash flow gives you choices. When you see your week-by-week position you decide when to buy plant, when to recruit or when to price up a low-margin job properly. It turns reactive ‘firefighting’ into planning. For a tradesperson aiming to grow from sole trader to a small team, knowing your cash position prevents overreach. You’ll spot the weeks where you can afford to hire a sub, when you can take on a large commercial contract, and when you should put the brakes on expansion. That kind of control is what keeps a business alive and growing.

Why Choose a 13-Week Forecast?

Thirteen weeks is the sweet spot. It’s long enough to spot patterns and plan actions, but short enough to stay accurate. Monthly or yearly forecasts smooth over the weeks where pain lands — the week VAT is due, the week your wages hit the bank, the week a big supplier invoice arrives. A 13-week rolling forecast gives you a clear view of the next quarter so you can act before those pinch points arrive. For trades, where jobs run days or weeks and payments follow completion by specific intervals, the week-by-week lens is far more useful than a monthly total.

Trades have short job cycles. A bathroom refit might take two weeks, and you might invoice at completion or on a staged basis. If you map the job week-by-week, you can see the exact week materials are needed and the week the payment should clear. That level of granularity highlights specific outgoings — a plasterboard delivery, a plant hire charge, or a van service — which can cause a one-week cash squeeze if not planned. Spotting this early lets you move orders or payments around to smooth the pressure without hurting the job.

A 13-week forecast builds a habit. You update it weekly and roll it forward so you always have the next quarter in view. That weekly discipline forces you to chase late payers, to flag customers who consistently pay slow, and to rearrange purchases when possible. Over time you’ll learn which weeks are always tight and can build a buffer into those weeks. Lenders and accountants like the 13-week format too — it shows immediate liquidity and practical planning, not a hopeful number for next winter.

Banks and funders prefer a working picture, not a future promise. If you go to your bank for a short-term overdraft or invoice finance, they want to see a realistic, updated 13-week forecast. It demonstrates you know where the pinch points are and what you’ll do about them. It’s much easier to get support when you present a plan that shows you’ll be cash-positive in the coming weeks with the right short-term fix. In short: the 13-week model keeps you honest, gives you time to act and makes it easier to get help when you need it.

What to Include in Your 13-Week Forecast

Start with your opening bank balance — that’s your working base. Then list every expected receipt by week: progress payments, final invoices, retention releases, VAT refunds and any odd one-offs like insurance claims. Don’t guess on payments; use past behaviour. If a trade customer habitually pays 21 days after invoice, put the money in three weeks after the invoice date. If a client historically pays late, stick to that late date in your forecast rather than hoping for an early payment. Realism beats optimism every time.

Next, add every outgoing you can think of, week by week. Materials, labour, subbies, plant hire, vehicle costs, fuels, insurances, rent, phone and office expenses, PAYE and NI, VAT and corporation tax, loan repayments and owner drawings. Include small but certain spends: van MOTs, tool replacement, safety equipment, and waste disposal. Those routine outgoings often line up and create a sharp week of pressure. When you list them explicitly you can see which weeks are busier and plan to move non-essential spend.

Don’t forget VAT. Trades often fall into the trap of spending the VAT element on day-to-day costs. If you’re on standard VAT, put VAT receipts and payments in their own line and plan for the quarter’s bill. Likewise, include PAYE and employer NI on the weeks wages are due. If you’re a director taking regular salary through payroll, make sure tax and pension contributions are shown. Tax and VAT are non-negotiable; failing to plan for them is the fastest route to a nasty surprise and potentially HMRC pressure.

Finally, include a contingency line. Call it buffer, emergency fund, or unexpected. Set aside a realistic weekly amount — even £100 or £200 per week builds into something useful over 13 weeks. Also list potential but not certain cash-ins like provisional extra work or expected asset sales in a separate ‘best-case’ column. You’ll then have three views: conservative, likely and optimistic. Make decisions from the conservative view; use the others for hopeful planning, not for paying the bills.

How to Build the Forecast (Step-by-step)

Use a simple spreadsheet. Create columns for each of the next 13 weeks and rows for opening balance, receipts by type, outgoings by type, VAT, PAYE, drawings and closing balance. The layout must be readable at a glance — you want to see the closing bank balance for each week. Colour code problem weeks red and healthy weeks green. Keep it simple to start. If spreadsheets scare you, a basic paper-based table works; the point is to force the weekly thinking, not to show off fancy software.

Populate the forecast from your bookkeeping. Pull last quarter’s bank transactions and invoices and map typical timings. If you invoice customers on completion and they usually pay in 14 days, put the cash in week two. If you have fixed monthly costs like rent or insurance, spread them to the week they’re paid. Use actual supplier payment dates rather than invoice dates where possible. If you know a van service is due in week six, put the cost in week six. Accuracy comes from using real behaviour, not hope.

Add scenarios. Once you’ve got a base case, add a worst-case line that removes optimistic receipts and increases a safety buffer. Also create a best-case where early payments or extra work lands. Label them clearly and make decisions from the worst-case scenario so you’re prepared. This level of planning stops you gambling on a hoped-for payment. In trades, things go wrong — customers delay, weather halts work, subcontractors call in sick. Plan for that, and you won’t be caught with your back to the wall.

Update weekly and roll forward. Every week, replace the week that just finished with a new week at the far end so you always have 13 weeks ahead. Adjust entries with actual receipts and payments. Chase any invoices that haven’t arrived. If a supplier payment changes, move it. Keep a short notes column beside each week explaining big movements — a van repair, a delayed invoice, or a staged payment received. The weekly update is the discipline that makes a forecast useful rather than a dusty spreadsheet in a folder.

Using the Forecast Weekly: Decisions to Keep Cash Flowing

Make the weekly update non-negotiable. Slot it into a fixed time — Monday morning or Friday afternoon — and treat it like payroll or tax deadlines. Use the update to decide actions: chase invoices, delay a non-essential purchase, move a supplier order to a later week, or ask a sub to defer labour for a week. The power of the forecast is in the choices you make with it. If a week shows a £3,000 dip, you can phone the biggest outstanding payer and ask for a part-payment rather than discover the problem when a supplier calls.

Communicate early with suppliers and customers. If you see a shortfall, phone your material merchant and arrange extended credit for that delivery week. Builders’ merchants frequently offer a small extension for customers who communicate. Likewise, if a client is slow to pay, ring them before the payment date and ask if everything is okay — sometimes an invoice was overlooked. Open, honest conversations often solve small problems before they become expensive. Don’t leave your suppliers guessing; they’re more likely to help if you’ve been straight with them.

Use short-term options sparingly and strategically. An arranged overdraft or a one-off invoice discount can cover a short blip, but both cost. Invoice finance or factoring gives immediate cash but eats margin — use it for clear, temporary gaps, not as a permanent crutch. A small business credit card can bridge a week but watch interest. Always weigh the cost of the borrowing against the risk of losing a job or paying late fees. If borrowing is needed, present your 13-week forecast to the lender — it shows you’ve planned how you’ll repay the facility.

Prioritise payments. When cash is tight, pay payroll, statutory liabilities and critical supplier bills first. Delay non-essential draws and discretionary spending. If a third-party trade owes you money, prioritise chasing that debt. Use the forecast to set payment priorities and a short-term action plan. The best tradespeople I’ve worked with aren’t necessarily the busiest — they’re the ones who manage their cash so they can always afford materials and labour when a job needs to start.

Common Mistakes and How to Avoid Them

Over-optimism kills cash flow. Tradespeople habitually assume invoices will be paid early or on time. The cure is to forecast using the worst realistic payment behaviour and treat earlier payments as a bonus. Keep a log of each customer’s actual payment days and use that in your forecast. If Customer A always pays in 28 days despite your 14-day terms, put the cash in at 28 days. Being realistic about your own customers avoids repeating the same mistake and stops you running short because you relied on a payment that never came.

Ignoring VAT and tax liabilities is the other classic error. VAT is not profit — it’s money held in trust for HMRC. Put VAT collected on invoices in the outgoing column for the quarter it’s due, not when you think you’ll spend it. The same applies to PAYE and employer NI. If you run payroll weekly or monthly, show the actual payment week. Separating tax and VAT into clear lines prevents accidental spending of money that must go to HMRC and saves you from interest and penalties.

Mixing personal and business funds is a false economy. Keep a clear line between drawings and business expenses. If you need money personally, plan the withdrawal and put it in the forecast as a cash outflow. For limited companies, treat dividends and director salary as scheduled outgoings. For sole traders, set a regular drawings figure so you see its effect on the business account week to week. Separating these keeps your business accounting honest and reveals the true cash available for operations.

Failing to use the forecast to act is the final mistake. A spreadsheet that collects dust is pointless. The forecast’s value comes when you use it to move orders, arrange short-term finance, or negotiate payment terms. Build the habit of taking at least one practical action from the forecast each week — chase an invoice, delay a non-essential purchase, or call a merchant to reschedule a delivery. That small weekly discipline prevents big shocks and keeps your trade business running on solid ground.

Common mistakes

• –Being overly optimistic with payment timelines, failing to account for habitual late payers.
• –Failing to update the forecast weekly, leading to outdated and potentially misleading figures.
• –Ignoring miscellaneous expenses which can add up and affect the cash flow projections significantly.
• –Not setting aside adequate tax reserves within the forecast, resulting in nasty surprises come tax time.
• –Lack of a cash buffer flag in the forecast, missing early warnings about potential cash shortages.
• –Avoidance of updating forecasts after real-world financial changes, causing discrepancies between predictions and reality.

Questions people ask

How do I start a 13-week forecast if I'm not good with numbers?

Start with a simple spreadsheet or notebook. List all known income and expenses by week. Don't overcomplicate—record real figures and adjust each week. You'll be surprised how quickly you get the hang of it.

What if I don't have regular income patterns?

For irregular income, base your estimates on past income trends. Use an average of past earnings as your baseline and adjust as actuals become clear. Forecasting irregular income involves more prudence, so be conservative in your estimates.

How much should my cash buffer be?

Aiming for at least three months of fixed expenses as a buffer is a good baseline. Consider your business's typical cash flow cycle, customer payment reliability, and personal risk appetite when determining your buffer size.

What if I'm wrong with my forecast?

Forecasts are not about being right 100% of the time but rather preparing for the unexpected. Adjust forecasts continually with real data, learning from any discrepancies to improve future forecasts.

Is there software specifically for cash-flow forecasting?

Yes, platforms like Xero and QuickBooks have forecasting tools built-in, which can simplify and automate parts of the process, helping keep track of incomings and outgoings efficiently.