Most cash flow forecast templates are either too complex to use without an accountant or built for a US business context - with tax rows that mean nothing to a UK founder. This guide gives you a simple 12-month cash flow forecast template structured for the UK, and walks you through how to fill it in correctly depending on whether you run a service business, a product business, or a retainer-based model.
What a Cash Flow Forecast Template Should Include
A cash flow forecast is not a profit and loss statement. It tracks when money actually moves in and out of your bank account - not when you invoice or when a cost is incurred. That timing difference is the whole point.
For an early-stage business, the right template is a simple 12-month rolling spreadsheet. One column per month. Rows for cash coming in, rows for cash going out, and a running bank balance at the bottom. That is all you need to start.
12 monthly columns across the top (January to December, or rolling from your start month)
An opening bank balance row at the top of each month
A cash inflows section - one row per income source
A cash outflows section - one row per expense category
A net cash row (inflows minus outflows)
A closing bank balance row (opening balance plus net cash)
Keep it to one sheet. The closing balance of one month feeds directly into the opening balance of the next. That chain of figures is what makes it a forecast rather than a list of transactions.
How to Structure Your Template: The Rows That Matter
The instinctive approach is to copy your profit and loss categories into the template. That usually produces a forecast that is too granular on costs and too vague on timing. The rows that matter are the ones where cash timing creates a real problem.
For income, start with one row per revenue stream - not one row per client. Group them by how and when you get paid, because that determines when the cash arrives.
For outgoings, the categories that matter most for cash flow purposes are:
Fixed monthly costs: rent, business rates (if applicable), software subscriptions, insurance, phone.
Variable costs: materials, stock, freelancer payments, delivery
Payroll and PAYE: if you operate as a limited company, include your director's salary (and any dividends paid, shown separately) plus any employees' gross pay. If you are a sole trader or partner, your own 'drawings' are not a PAYE cost - account for your income tax and National Insurance through your Self Assessment row instead.
VAT: the quarterly payment to HMRC, not VAT on individual invoices
Corporation Tax: due nine months and one day after your accounting period ends
One-off costs: equipment, legal fees, website work
Exclude VAT from your income rows
If you are VAT-registered, your invoices include VAT that is not your money. Record income figures excluding VAT in your cash inflows, then add a separate row for the VAT payment in the quarter it is due. This is one of the most common errors in UK cash flow forecasts.
How to Fill In Your Forecast for a Service Business
Service businesses - consultants, agencies, tradespeople, freelancers - typically invoice after the work is done and wait 30 to 60 days for payment. That gap between doing the work and receiving the money is the key timing risk to model.
When filling in your income rows, do not record revenue in the month you do the work or raise the invoice. Record it in the month you expect the cash to land in your account.
Service Business: Income Timing Steps
Identify your payment terms
Check the payment terms on your standard invoice - typically 14, 30, or 60 days. This tells you when invoiced work becomes cash.
Shift income forward by that period
If you complete and invoice work in March on 30-day terms, the cash appears in April. Enter the amount in April's income row, not March's.
Account for late payers
If you know from experience that some clients pay late, add a further one-month buffer on those specific income rows. Be honest about your actual payment patterns, not the ideal ones.
Separate retainer income from project income
If you have any clients on a monthly retainer, give that a separate row. Predictable income deserves its own row because it anchors your forecast.
Illustrative example - based on a common UK founder scenario, not a specific documented case
A UK-based freelance copywriter invoices clients at the end of each month on 30-day terms. In her forecast, she enters expected project fees in the month after they are invoiced. In February, she knows she has £4,500 of confirmed work - so she enters £4,500 in March's income row. Her fixed costs of £800 per month go into each month as they fall. This gives her a clear view of months where income dips and costs remain constant.
How to Fill In Your Forecast for a Product Business
Product businesses face a different challenge: cash goes out before sales come in. You buy stock, manufacture goods, or pay for materials well before a customer pays you. The forecast has to capture that outflow timing accurately.
Income rows for a product business should reflect the actual payment method. Direct-to-consumer online sales are paid immediately - enter them in the month of sale. Wholesale or trade orders usually involve credit terms - shift those receipts forward by the agreed payment period.
On the outgoings side, the rows that need particular care are:
Stock purchases: enter in the month you pay the supplier, not the month you sell
Supplier payment terms: if your supplier gives you 30-day terms, push the cost forward by one month
Seasonal buying: if you pre-buy for Christmas or summer, those large stock payments need to show up in the forecast months in advance
Returns and refunds: include a realistic monthly figure if your product category has a meaningful return rate
Stock timing is the most common blind spot
A product business can show strong projected sales and still run out of cash, because the cost of buying stock arrives in the bank statement weeks before the sales revenue does. Always enter stock costs in the month payment leaves your account - not the month you receive the goods or sell them.
How to Fill In Your Forecast for a Retainer or Subscription Business
Retainer and subscription models are the most forecast-friendly business structure - income is largely predictable and arrives at consistent intervals. But there are still timing decisions to get right.
Most retainer payments are collected monthly in advance by direct debit or card. Enter the total monthly retainer income in the month it is collected. If you invoice at the start of the month and collect immediately, that income belongs in the current month.
Where subscription models get complicated is churn - clients cancelling - and onboarding lags for new clients. Build both into your forecast:
Add a churn row or reduce your active subscriber count each month by a realistic drop-off rate
When projecting new client growth, enter their first payment in the month they actually start, not the month you close the deal
If you offer a free trial or delay first billing, push that income forward by the trial length
The UK-Specific Rows Most Templates Get Wrong: VAT, PAYE, and Tax
This is where most generic templates - and a lot of adapted US templates - fall apart for UK founders. These three obligations are not monthly costs. They arrive in large, irregular lumps, and if they are not in your forecast, you will be caught off guard.
VAT
VAT is typically paid to HMRC quarterly. The payment deadline is one calendar month and seven days after the end of the VAT quarter (for example, a quarter ending 31 March is due by 7 May). Once you know your VAT quarters, enter the payment in your forecast on the 7th of the month following that one-month window. The amount to enter is your net VAT liability: output VAT charged minus input VAT reclaimed. If you are on the Flat Rate Scheme, use your sector's flat rate percentage (ranging from 4% to 14.5% depending on business type, or 16.5% if you are a 'limited cost trader') applied to your VAT-inclusive turnover. Check the current HMRC flat rate table at gov.uk to confirm the correct percentage for your sector.
PAYE
If you employ anyone - including yourself through a limited company - PAYE (Pay As You Earn) income tax and National Insurance contributions are due to HMRC by the 22nd of each month following the payroll month (or the 19th postal/cheque payments). Include a PAYE row in your outgoings and enter the employer and employee combined liability each month. This is separate from the gross salary cost.
Corporation Tax
Corporation Tax for companies that are not classified as 'large' (broadly, taxable profits below £1.5 million) is due nine months and one day after your accounting year end. That means it arrives as a single large payment - not a monthly cost. Identify the month it falls in and add a Corporation Tax row with your estimated liability. If you have no prior year to base this on, work from your forecast profit multiplied by the applicable Corporation Tax rate - 19% if profits are £50,000 or below (small profits rate), 25% if profits exceed £250,000 (main rate), or a blended marginal rate in between - then check the current HMRC rates as these thresholds can change.
Set money aside monthly, even if the bill is annual
For both VAT and Corporation Tax, consider adding a separate line in your outgoings showing a monthly transfer to a savings pot. The payment hits in a lump sum, but smoothing the cash impact across months makes it far less painful when the bill arrives.
How to Use Your Completed Template to Make Better Business Decisions
A completed cash flow forecast does not just tell you what your bank balance will be - it tells you when you need to act. The months where your closing balance drops below your target minimum are not problems to panic about - they are decisions to make in advance.
Look at your forecast and identify the three most useful pieces of information it surfaces:
Your lowest projected balance - and whether it goes below zero at any point. If it does, you have a defined problem with a defined timeline to fix it.
The months where large tax payments land. These are the months to avoid making other large cash commitments unless your balance comfortably absorbs both.
The gap between your income forecast and your actual performance month by month. Updating your forecast with real figures each month turns it from a static document into a live early-warning system.
Update the template at the end of each month. Replace the forecast figures with actuals for the month just finished, check where the variance came from, and push your projections forward one month. After three to four months, your forecast accuracy will improve substantially because you will have real payment pattern data from your own business to work with.
The forecast is only as useful as your willingness to update it
A 12-month cash flow forecast that is never updated after the first month is just a historical document. The practical value comes from treating it as a living tool - fifteen minutes at the end of each month comparing forecast to actual is enough to keep it useful and your decision-making grounded in real data.
Get Practical Guidance You Can Use This Week
Get Practical Guidance You Can Use This Week
Ready to cut through the noise? Join the BGE newsletter for practical guidance, tool recommendations, and real-world insights for UK founders and business owners - delivered weekly to your inbox. No fluff, no spam, unsubscribe any time.
BGE newsletter
