Recommended Free Tools
Build a cash-flow forecast by mapping the dates money is expected to reach or leave your bank account—not the dates revenue is recorded. Start with a reconciled opening balance, add customer receipts on realistic collection dates, subtract payroll, suppliers, tax, finance and other payments when they are due, and roll the resulting closing balance into the next period. During a slowdown, maintain a rolling 13-week weekly view for immediate liquidity and a monthly view through the financial year for annual and quarterly bills.
What a cash-flow forecast tells you
A forecast is a time-phased plan of bank movements. It answers a practical question: will the business have enough cleared cash to pay each commitment when it falls due?
As an Amazon Associate I earn from qualifying purchases.
That is different from an accrual profit forecast. An invoice can increase reported sales while producing no cash until a customer pays. Conversely, a VAT payment, loan principal instalment or annual insurance premium can reduce the bank balance even though the accounting expense was recognised earlier.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →For each period, use this calculation:
Closing cash = opening cash + cash receipts − cash payments
#1 Best Overall
The closing figure becomes the next period’s opening figure. Add a minimum cash buffer and test whether closing cash stays above it. Business.gov.uk advises including all outgoing spend, incoming revenue and expected payment dates when creating a cash-flow forecast.
Use two linked views during a slowdown
Rolling 13-week liquidity view
A weekly, rolling 13-week forecast is a practical operating cadence for payroll, suppliers, debt service and other near-term decisions. Each week should show opening cash, expected receipts, payments, closing cash and the buffer test. When one week passes, replace it with a new week so the horizon always extends 13 weeks forward.
The 13-week cadence is an operating recommendation, not a statutory UK requirement. Its value is early warning: it identifies the first week in which cash falls below your chosen buffer while there is still time to change payment timing or spending.
Monthly financial-year view
Extend the same assumptions across the financial year in monthly columns. This catches lumpy outflows that a short weekly horizon can miss, including annual insurance, loan principal, tax and other quarterly or annual commitments. Reconcile the monthly view to the weekly view rather than maintaining two unrelated models.
Build the forecast step by step
1. Reconcile the opening cash balance
Begin with the actual cleared balances in every business bank account on the forecast start date. Reconcile the total to bank statements and investigate unreconciled items. Do not include an overdraft facility, an unconfirmed loan, a grant that has not been awarded or an expected relief as available cash.
Record restricted or ring-fenced money separately where it cannot be used for ordinary bills. Note the date and person responsible for each opening-balance adjustment.
2. Schedule customer receipts by likely arrival date
List expected receipts by customer or sales channel. Use the debtor ledger, order book and known payment behaviour, then place each receipt in the week or month when funds are likely to clear—not when an invoice is raised.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware match- Separate confirmed invoices from pipeline sales.
- Apply a late-payment assumption to customers with a history of paying after terms.
- Use realistic collection dates rather than contractual dates when evidence shows a regular delay.
- Keep new sales assumptions distinct from receipts already owed.
During a slowdown, a large order does not solve a liquidity problem unless its payment timing is credible. Review the aged-debtors report every week and replace estimates with payment confirmations as they arrive.
Rank #2
- Ideal for Gifting
- Ideal for a bookworm
- Compact for travelling
3. Add only credible other inflows
Include a grant, asset sale or borrowing only when it is confirmed and its receipt date is documented. Show the source and expected date beside the amount. Keep an unapproved facility or speculative sale in a separate sensitivity line, not in available cash.
4. List committed cash outflows
Enter payments in the period the bank account is expected to be debited. Include:
- Payroll, PAYE and National Insurance.
- Rent, utilities and other premises costs.
- Supplier invoices and recurring service bills.
- Lease payments and both interest and principal on loans.
- VAT and other taxes on the business’s actual HMRC payment dates.
Use the payment schedule, supplier statements, payroll calendar, finance agreements and HMRC account rather than relying on an averaged monthly expense.
5. Separate discretionary spending
Give hiring, marketing, travel, stock-building and capital expenditure their own rows. Mark the decision date and the person who can approve or pause each item. This makes it possible to test a spending freeze without accidentally removing payroll, tax or another committed payment.
6. Calculate closing cash and test the buffer
For every column, calculate opening cash plus receipts minus payments. Roll closing cash forward automatically. Add a buffer row and a clear pass/fail test. Your buffer can be a policy minimum set by the owners; the important control is to apply it consistently and identify the first breach week.
Rows your workbook should contain
| Section | Rows and timing rule |
|---|---|
| Opening cash | Reconciled cleared bank balances at the start of the period. |
| Customer receipts | By customer or channel, placed on expected collection dates with late-payment assumptions. |
| Other inflows | Confirmed grants, asset sales or committed borrowing only, with documented receipt dates. |
| Committed outflows | Payroll, PAYE/NIC, rent, utilities, suppliers, leases, loan interest and principal. |
| VAT and taxes | Actual HMRC payment dates for the business’s scheme. |
| Discretionary outflows | Hiring, marketing, stock, travel and capital expenditure shown separately. |
| Closing cash and buffer | Calculated closing balance and a buffer test in every period. |
Model three slowdown scenarios
Build the base case from the order book and debtor ledger, then stress the assumptions rather than applying one arbitrary percentage to every line. Write the assumption beside each number, assign an owner and set a review date.
| Scenario | Core assumptions to document | Decision output |
|---|---|---|
| Base case | Current order book, expected customer collection dates, existing supplier terms and committed payroll, tax and finance payments. | Normal operating cash path and buffer position. |
| Downside | Lower new sales, slower collections and supplier-price pressure, with fixed commitments unchanged unless a specific action is agreed. | First week or month the buffer is threatened and the size of the gap. |
| Severe case | The downside sales and collection shocks combined with supplier-cost pressure and all unavoidable commitments. | Whether immediate financing, payment negotiations or a material spending decision is required. |
Compare sales volume, average order value, debtor days, late receipts, supplier terms, input costs, payroll, VAT and tax dates, discretionary spend and the first buffer-breach week across the scenarios. A severe case should combine shocks; testing each shock in isolation can hide the effect of simultaneous pressure.
Put VAT and other HMRC payments on cash dates
HMRC states that VAT returns and payments are generally due one calendar month and seven days after the accounting period ends. Payment must clear HMRC’s account by the deadline, so allow for bank processing time rather than treating the submission date as the cash date.
Enter the VAT outflow in the week containing the business’s actual online-account deadline. Check the business’s VAT scheme and account because special schemes and payment-on-account arrangements can differ from the general rule. Apply the same discipline to PAYE, National Insurance and other taxes: use the dates on the relevant HMRC account or payment schedule.
Keep a note beside each tax line showing the period covered, the expected payment date and the source of the date. If a return has not yet been filed, use the best supported estimate and flag it for replacement when the liability is known.
Handle late-paying customers explicitly
A slowdown often appears first as a timing problem. A customer may still buy but pay later, extending debtor days and moving receipts beyond the week in which suppliers or payroll must be paid.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →- Age the debtor ledger weekly and identify the largest overdue balances.
- Assign an owner and next contact date to every material overdue invoice.
- Move a receipt to a later forecast period when the customer gives a credible revised date.
- Do not count a promised payment as cleared cash until bank evidence supports it.
- For new work, consider deposits or staged billing where the contract and customer relationship allow it.
The British Business Bank describes ready cash for suppliers and salaries as vital working capital and identifies weak control of customer and supplier payment terms as a working-capital problem. Payment terms are therefore a forecasting control, not just a sales or procurement detail.
Set up a workbook that is easy to update
Use one date row for the weekly horizon and a separate, linked monthly summary for the financial year. Keep raw inputs—bank balances, open invoices, supplier statements, payroll totals and HMRC dates—in clearly labelled tabs or schedules, then link them to the forecast rather than retyping figures. This creates an audit trail and reduces the risk of an old estimate surviving after the underlying invoice has changed.
Protect formula cells and identify input cells with a consistent format. Add columns for the assumption, owner, evidence and next review date. A receipt should show whether it comes from an issued invoice, an order still in the pipeline or a customer promise. A payment should show whether it is contractual, scheduled or discretionary. Use version dates so the team can distinguish the current forecast from an earlier scenario.
Set a single cut-off time for the weekly update. If several people contribute, one owner should approve the final version and circulate the buffer-breach week and required actions. Collaboration controls matter as much as arithmetic when sales, operations, payroll and finance are changing assumptions at the same time.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsCommon forecasting pitfalls
- Using invoice dates as cash dates. Revenue recognition does not prove that money has cleared the bank.
- Smoothing lumpy bills. Spread-out monthly averages hide the week when VAT, insurance, tax or loan principal is actually paid.
- Leaving principal out of finance payments. Interest is not the only bank movement; principal also reduces cash.
- Counting uncertain inflows. An unapproved loan, unawarded grant or hoped-for asset sale cannot fund a committed payment.
- Double-counting receipts. Do not include the same customer payment once from the debtor ledger and again from a sales pipeline.
- Mixing restricted and usable cash. Ring-fenced amounts may appear in the bank balance but cannot pay ordinary suppliers.
- Making one blanket slowdown adjustment. Sales volume, order value, collection speed and supplier prices can move differently.
- Failing to refresh the first danger week. A forecast that is not reconciled weekly quickly becomes a historical document instead of an early-warning tool.
What to do when the forecast breaches its buffer
Act while the gap is still projected. Rank responses by speed and reversibility so that a temporary timing problem does not trigger an unnecessarily permanent decision.
Rank #4
- Pause discretionary spend. Stop or defer non-essential marketing, travel, hiring, stock-building and capital purchases, subject to contracts and employment obligations.
- Invoice promptly and pursue overdue debt. Confirm delivery evidence, send invoices without delay and agree a documented payment date with customers.
- Request deposits or staged billing. For suitable new or continuing work, structure billing so cash arrives before all delivery costs are incurred.
- Negotiate supplier dates early. Ask for an agreed extension or instalment plan before the due date; record the revised commitment in the forecast.
- Prepare an evidence pack. Include the forecast, assumptions, aged debtors, committed payments, scenario comparison, buffer-breach week and the specific help requested.
- Contact lenders, HMRC or suppliers before a missed payment. Early, evidence-backed conversations preserve more options than an unexplained default. Confirm any arrangement in writing and update the model with its actual dates.
The Department for Business and Trade’s Commercial Payments Bill overview says, “The bill will tackle late payments between businesses and improve the flow of cash through supply chains.” Its 2026 overview reports a government estimate of £11 billion per year as the cost of late payments to the UK economy and 38 UK businesses every day associated with late-payment closures. Those are government-reported figures; check the bill’s current legislative status before relying on any proposed change to rights or obligations.
Distinguish a timing gap from a structural shortfall
A single buffer breach caused by a VAT or insurance payment may be a timing gap: the forecast can show cash returning above the buffer after a confirmed receipt. A repeated breach across the base case, or a severe case that never recovers, indicates a structural shortfall. That distinction affects the response. Move dates or request staged payments for a timing gap; review pricing, costs, capacity and financing for a structural problem.
Document the smallest action that closes the projected gap, then rerun every scenario. If deferring one capital purchase restores the buffer, do not assume a broad spending freeze is necessary. If no reversible action closes it, escalate the evidence pack to the owners, lender, adviser or HMRC early.
Free tools Windows power users keep installed
One-click scans. No signup required.
Control the forecast every week
A forecast is useful only when its estimates are replaced by evidence. Set a weekly review meeting with a named owner and a fixed cut-off time.
- Reconcile actual bank movements to the forecast.
- Replace estimated receipts with invoices, remittance advice or bank confirmations.
- Replace estimated payments with supplier statements, payroll totals, finance schedules and HMRC dates.
- Record the reason for every material variance, such as a late customer, an unplanned repair or a changed supplier term.
- Roll the completed week out and add a new week at the far end of the 13-week view.
- Review scenario assumptions and their owners on the stated review date.
Keep cash timing separate from accrual-accounting recognition. A management account can remain profitable while the bank balance falls, and a cash receipt can arrive before the related revenue is recognised.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Choosing a spreadsheet or forecasting system
A simple workbook can be sufficient if one person owns updates and the bank, debtor and payment data are reliable. As several people edit the model or the number of entities grows, controls around version history and approvals become more important.
| Capability | What to check |
|---|---|
| Granularity | Can it show weekly periods for 13 weeks and a linked monthly financial-year view? |
| Scenario support | Can base, downside and severe assumptions be changed without overwriting the base case? |
| VAT and tax dates | Can payments be entered on scheme-specific HMRC dates rather than averaged monthly? |
| Debtor ageing | Can customer receipts be imported or traced to aged invoices and revised collection dates? |
| Collaboration and audit trail | Can owners, review dates, approvals and changes to assumptions be seen? |
| Exportability | Can you export the forecast and supporting schedules for a lender, supplier or adviser? |
| Total cost | Assess subscription or licence cost alongside setup, data cleanup, training and maintenance time. |
A spreadsheet usually has the lowest direct cost, but it depends on disciplined manual updates and can become fragile when formulas, versions and contributors multiply. A dedicated forecasting system may reduce manual consolidation, but compare its subscription or licence cost with setup, data cleanup, training and ongoing maintenance. Whichever format you choose, it must preserve weekly detail, scheme-specific tax dates, debtor evidence and scenario separation.
Questions the forecast should answer before each review
- What is the first week in which closing cash falls below the buffer?
- Which receipt is most important to that week, and what evidence supports its date?
- Which payments are legally or contractually committed, and which can be moved?
- When are the next VAT, PAYE/NIC and other tax payments due?
- How much of the projected gap disappears if discretionary spend is paused?
- What specific request can be made to a customer, supplier, lender or HMRC now?
Answering these questions from one reconciled model turns a slowdown from a vague concern into a sequence of dated decisions.
Best Value
- It can be a gift option
- Comes with secure packaging
- Helpful in various ways
A short weekly review agenda
- Confirm the opening bank balance and reconcile the previous week’s closing figure.
- Review receipts due in the next two weeks, starting with the largest overdue or strategically important customers.
- Confirm payroll, supplier, finance, VAT and other tax payments against current statements and HMRC dates.
- Mark any discretionary item that can be paused, deferred or renegotiated without breaching an obligation.
- Rerun base, downside and severe cases and note the first buffer-breach week in each.
- Assign one owner and a dated next action for every material variance or projected gap.
Keep the meeting focused on decisions and evidence. The forecast should show what changed, why it changed and which action will change the next bank movement.
Frequently Asked Questions
How far ahead should a small UK business forecast cash?
Use a rolling 13-week weekly view for immediate liquidity, then link it to a monthly forecast covering the financial year. The weekly horizon exposes payroll, supplier, debt and tax pressure early; the monthly view captures annual insurance, loan principal and other lumpy bills.
Should VAT be forecast when the return is filed or when it is paid?
Forecast VAT as a cash outflow when payment must clear HMRC’s account. VAT returns and payments are generally due one calendar month and seven days after the accounting period ends, although schemes and payment-on-account arrangements can differ. Check the business’s HMRC account and allow for bank processing time.
Can I include a promised customer payment?
Include it on the date funds are credibly expected, using the debtor ledger and documented customer evidence. Do not treat a promise as cleared cash until bank evidence supports it; move the receipt to a later period when a revised date is more realistic.
What should I do first if the forecast shows a shortfall?
Rank actions by speed and reversibility: pause discretionary spending, invoice promptly, pursue overdue debt, request deposits or staged billing, negotiate supplier dates and contact lenders or HMRC before a missed payment. Take the forecast, assumptions, aged debtors and committed-payment schedule to each conversation.
Is a 13-week cash-flow forecast a UK legal requirement?
No. It is a practical operating cadence for managing near-term liquidity. Statutory obligations still apply to payroll, VAT and other taxes, so enter those payments on the actual dates shown by the relevant schedules and HMRC account.
The Bottom Line
A useful slowdown forecast is a reconciled, evidence-based schedule of when cash will clear the bank. Maintain weekly 13-week and monthly year views, model combined sales and collection shocks, place VAT and other taxes on their real payment dates, and act on the first buffer breach while options are still reversible.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
