Building Pro-Forma Financial Statements

Struggling to turn your business vision into credible financial numbers? Pro-forma financial statements are the backbone of any solid business plan, investment pitch, or cashflow strategy in the UK. This guide takes you through every step of building pro-forma income statements, balance sheets, and cashflow forecasts—explaining what they mean, why they matter, and exactly how to build them using UK-specific figures, rules, and best practice. Whether you're a first-time founder or an experienced owner looking to sharpen your forecasts, you'll find everything you need to build professional, investor-ready pro-forma statements that stand up to scrutiny.

Pro-forma financial statements are forward-looking versions of your business’s key financial reports. Unlike your actual (historic) accounts, pro-formas project what your income, balance sheet, and cashflow might look like over a future period—typically 12, 24, or 36 months. They’re essential for planning, raising finance, and understanding how your decisions might play out in real financial terms.

In the UK, pro-formas are a standard requirement for most business loan applications, investment pitches, and grant submissions. Banks, the British Business Bank, and most angel investors will expect to see at least three years of detailed financial projections. These statements provide a structured, credible way to communicate your business model, growth assumptions, and financial discipline.

Beyond external stakeholders, pro-forma statements are a vital internal tool. They help you spot cashflow gaps before they become a crisis, test the impact of hiring or expansion plans, and set realistic sales and cost targets. For new businesses, they’re usually based on a mix of market research, industry benchmarks, and well-reasoned assumptions—so transparency and logic are crucial.

• Required for most UK business loans, grants, and equity investment applications
• Used to set budgets and targets for your team
• Helps identify cashflow pinch points and funding needs
• Provides a reality check on business ideas and growth plans
• Supports negotiations with suppliers and lenders

There are three main pro-forma statements every UK small business owner should know: the Income Statement (sometimes called the Profit & Loss or P&L), the Balance Sheet, and the Cashflow Statement. Each serves a different purpose and together they give a rounded picture of future business health.

The pro-forma Income Statement projects your revenues, costs, and profits over a period—usually monthly for the first year, then annually. It helps you understand profitability, breakeven points, and how changes in sales or costs could affect your bottom line. In the UK context, it must account for VAT (if registered), employer National Insurance, and corporation tax.

The pro-forma Balance Sheet shows your business’s financial position at a specific point in the future—what you own (assets), what you owe (liabilities), and your net worth (equity). This is crucial for lenders and investors, who want to see that your business will remain solvent and able to meet its obligations under different scenarios.

The pro-forma Cashflow Statement is arguably the most important for UK small firms, given that cashflow shortfalls are a leading cause of business failure. It tracks the actual movement of cash in and out of your business, highlighting when you might run short and need to arrange an overdraft or alternative finance.

Building credible pro-forma statements starts with gathering accurate, UK-relevant data. For established businesses, your own historic accounts are the best starting point. For new ventures, you’ll need to blend market research, ONS/industry statistics, and real supplier quotes.

Key data to gather includes realistic sales volumes, average prices, typical payment terms, direct and indirect costs, staff salaries (including employer NI and pensions), and capital expenditure. For costs, always factor in the full cost to the business, not just headline rates—remembering to include National Living Wage rates, employer pension contributions, and statutory costs like business rates or insurance.

Use UK benchmarks wherever possible. Websites like the Federation of Small Businesses (FSB), British Business Bank, and ONS publish sector-specific data. Trade associations often provide average profit margins, overhead ratios, or cost-per-employee figures. For VAT, use the current threshold (£85,000 turnover) and the standard rate (20%) unless your business qualifies for a reduced or zero rate.

• Historic accounts and management information (if trading)
• ONS market size and average turnover data
• Quotes from UK suppliers and service providers
• Current HMRC tax rates and National Insurance thresholds
• Industry reports and trade association statistics
• Competitor pricing (from public filings or mystery shopping)

The income statement is often the starting point for pro-forma modelling. It forecasts your sales, costs, and profit for each period—usually monthly for year one. To be credible in the UK, you must show clear, evidence-backed assumptions, account for VAT if registered, and include all relevant taxes.

Start with sales. Break down your revenue by product or service line, showing unit sales and average prices. Factor in seasonality—many UK businesses see a dip in August and spikes around Christmas or the tax year end. If VAT registered, show figures both net and gross of VAT for clarity.

List your cost of goods sold (COGS) or direct costs next. This should include the actual cost to deliver each sale, such as materials, stock, and direct labour. For staff, be sure to include employer National Insurance (currently 13.8% above the secondary threshold), as well as 3% minimum employer pension contributions under auto-enrolment.

Next, detail your operating expenses—rent, utilities, insurance, marketing, admin, and so on. Use real UK figures and don’t forget business rates (unless exempt), insurance premium tax, and other statutory costs. Depreciation and amortisation should be included for assets, using UK capital allowance rules where relevant.

Finally, account for interest on any projected loans, and estimate corporation tax at the current main rate (25% for profits above £250,000, with marginal relief below this). For smaller profits, use the small profits rate (19%), but make sure to check HMRC for the latest thresholds and bands.

The pro-forma balance sheet is a snapshot of your business’s assets, liabilities, and equity at a future date—usually at the end of each forecast year. It’s essential for understanding whether your business will remain solvent and able to meet its obligations, especially if you’re seeking loans or investment.

Start by projecting your assets. This includes cash (from your cashflow forecast), stock on hand, trade debtors (unpaid customer invoices), and any property, plant, or equipment. In the UK, remember to depreciate assets each year, and to include only the net book value (cost less accumulated depreciation).

Next, list your liabilities. This should cover trade creditors (unpaid supplier bills), outstanding VAT, PAYE/NIC due to HMRC, any bank loans, overdrafts, or asset finance. Be specific about repayment schedules and interest accrued, aligning with UK lending standards.

Equity represents the net worth of your business—share capital, retained profits, and any new investment. For limited companies, show share capital separately from retained earnings. For sole traders, this will be the owner’s capital account.

The balance sheet must balance: Assets = Liabilities + Equity. If your numbers don’t match, revisit your assumptions—especially around working capital (stock, debtors, creditors) and cash balances. UK lenders will scrutinise your balance sheet for over-optimistic debtor or stock figures and under-estimated liabilities.

• Project stock and debtor days using UK averages (e.g. 30-60 days for B2B)
• Depreciate assets using straight-line or reducing-balance methods
• Include all current and non-current liabilities (loans, taxes, leases)
• Keep equity entries clear—especially for new investment or directors’ loans
• Cross-check cash balances with your cashflow forecast

The pro-forma cashflow statement tracks actual cash movement in and out of your business. This is crucial for UK SMEs, as cashflow shortfalls rather than lack of profit are the main reason businesses fail. Your cashflow should be forecast monthly at a minimum, and should reconcile with your balance sheet cash at each period end.

Start with cash receipts—actual money expected to hit your bank account each month. For B2B, build in typical UK payment terms (often 30 days, but can be 60+ for large corporates). For VAT-registered businesses, remember that you collect VAT on sales but pay it out to HMRC quarterly, so your cash inflows are net of VAT unless you use the Flat Rate Scheme.

List all cash outflows by category: supplier payments (factoring in your agreed payment terms), staff wages (include PAYE, NI, and pensions paid to HMRC), rent, rates, utilities, loan repayments, asset purchases, and tax payments. Remember to include the timing of VAT and corporation tax payments—VAT is usually due one month and seven days after quarter end, corporation tax nine months after year end.

Finally, add any new funding—bank loans, overdraft drawdowns, or equity investment. This gives you a running cash balance each month. If your forecast shows negative cash, you’ll need to plan for an overdraft or alternative funding in advance.

• Model cash receipts based on your customers’ payment behaviour
• Schedule VAT payments based on your VAT quarters and payment method
• Include PAYE/NIC remittances to HMRC on the 22nd of each month (if paying electronically)
• Factor in loan repayments and interest as per your loan agreement
• Don’t forget seasonality—many UK businesses see cash dips around tax and VAT deadlines

Once you’ve built your pro-forma statements, you must stress test your assumptions. UK investors and lenders are sceptical of single-line forecasts—they want to see how your numbers change if things go wrong (or better than expected). This is where sensitivity and scenario analysis come in.

Start by identifying your key drivers—typically sales volume, average price, gross margin, debtor days, and overheads. Model what happens if sales are 20% lower than forecast, or if customers pay 30 days late. For costs, consider inflation (currently running above 4% in early 2024), and what would happen if energy or wage bills spike.

Build at least three scenarios: base case (most likely), downside (pessimistic), and upside (optimistic). Lenders like the British Business Bank and most UK VCs expect to see sensitivity tables or charts showing the impact on profit and cash. This demonstrates that you understand your risk, and have a plan if reality doesn’t match your forecast.

Common UK pitfalls include underestimating the impact of late payments, failing to account for VAT payment timings, and assuming costs will rise only by CPI inflation. In reality, business rates, insurance, and minimum wage rates can jump by more than the general inflation rate, and Brexit-related supply chain issues have made costs less predictable.

• Test what happens if sales are 20% below target
• Model the effect of customers taking 60 days to pay instead of 30
• Allow for a 10% increase in key costs (energy, wages, rent)
• Check if you can still meet loan repayments on a downside scenario
• Show cashflow consequences of a late-paying major client

A professional-looking pro-forma isn’t just about the numbers. How you present your statements, and—crucially—how you document your assumptions, is what turns a spreadsheet into a credible business case. UK banks and investors expect to see clear, structured statements, with all key assumptions explained in footnotes or a separate narrative.

Label all rows and columns clearly, use consistent units (£000s or £), and always show period (month/year). For VAT, show both net and gross figures where relevant. Explain any unusual items—such as one-off grants, R&D tax credits, or asset sales—so they aren’t mistaken for recurring revenue.

Your assumptions should be listed in detail: for example, 'We assume sales will grow 10% per quarter, based on ONS sector average growth rates', or 'Wages increase in line with the National Living Wage, currently £11.44 per hour as of April 2026.' Where possible, cite sources (FSB, ONS, supplier quotes), and include a summary table of all key drivers and sensitivities.

Finally, make sure your pro-forma ties back to your business plan narrative. If your plan claims you’ll launch three new products, show the investment and expected sales in your statements. Consistency builds trust and increases your chances of getting backing.

• Use a clear, professional spreadsheet template (avoid hard-to-read formats)
• List all key assumptions and sources in a separate tab or document
• Show monthly figures for year one, annual for years two and three
• Include a summary of key ratios (gross margin, net margin, debtor days, cash coverage)
• Cross-check figures with your business plan and pitch deck

While pro-forma statements themselves are not statutory documents in the UK, they must still reflect legal and tax realities. If your business is regulated (FCA, CQC, etc.), ensure your forecasts take account of licensing fees, compliance costs, and sector-specific financial requirements.

Tax is a frequent source of error. Always use current HMRC rates for corporation tax (19% or 25% depending on profit), VAT (20% standard, with current threshold at £85,000), employer National Insurance (13.8% above secondary threshold), and employer pension costs (3% minimum under auto-enrolment). If you’re forecasting R&D tax credits or capital allowances, check eligibility and rates on GOV.UK.

If you plan to use your pro-forma for a formal funding application, remember that presenting misleading or knowingly inaccurate forecasts could breach the Fraud Act 2006. Use genuine, evidence-backed assumptions, and be ready to provide supporting documentation if requested by lenders, investors, or grant bodies.

• Apply the correct HMRC tax rates for each year of your forecast
• Include business rates, insurance premium tax, and employer costs
• Factor in regulatory fees/licensing for your sector (e.g. FCA, CQC, SEPA)
• Disclose any assumptions about grants, reliefs, or tax credits
• Never present optimistic forecasts as guaranteed outcomes

You don’t have to start from scratch. There are excellent UK-specific tools and templates available, many free or low-cost, designed to help SMEs produce professional-standard pro-forma statements. The British Business Bank, many local Growth Hubs, and high street banks offer spreadsheet templates that cover all three statements with UK tax and cashflow logic built in.

Accounting software like Xero, QuickBooks, and Sage now offer forecasting plugins or built-in pro-forma modules. These can import your real data and help you build forecasts based on actual historic trends. For more complex needs, business advisors (including ICAEW or ACCA-qualified accountants) can help you build robust models and challenge your assumptions.

If you’re applying for a Start Up Loan, Innovate UK grant, or other government-backed scheme, check their websites for required formats and templates—using the right structure speeds up your application process. Don’t be afraid to ask your accountant for help; their experience with UK tax, compliance, and lender expectations is invaluable.

• Download templates from the British Business Bank or your local Growth Hub
• Use accounting software forecasting modules for real-time integration
• Engage a UK accountant to review or build your pro-forma statements
• Check lender or grant provider websites for accepted formats
• Attend local FSB or chamber of commerce workshops on business planning