A UK software budget template with VAT, Corporation Tax and timing

What to take away

Building the UK software budget template: units and assumptions

Start with units, not totals. Every software line should carry a unit type: per seat, per site, per transaction, per gigabyte or per month. A licence that looks cheap per seat can become expensive once you add the paid identities, storage tiers and support bands that sit outside the headline price.

Set the budget in pounds sterling and keep three columns: net, VAT and gross. UK finance teams usually reclaim input VAT on business software, so the net figure drives the profit and loss account while the gross figure drives the bank account. If you cannot reclaim, the gross figure is your true cost.

Define the budget period. Most UK software contracts run on an annual term with monthly or quarterly billing, but renewal dates rarely align with your financial year. A software budget template should hold the accounting period, the contract period and the payment period as separate fields.

Decide the treatment of implementation, training and data migration. These are often one-off costs in year one and disappear later, which flatters the second year. Split them into a setup block so the run-rate is visible.

This is the same structure used in a software budget template built around units, tax, timing and an assumption sheet. The point is to make each assumption explicit and editable.

VAT rates and how to treat software subscriptions

VAT is the first tax to get right because it affects cash from the first invoice. The UK has a standard rate, a reduced rate and a zero rate, and the rate depends on what is supplied, not on what the buyer does with it.

The current standard rate is 20%, the reduced rate is 5% and the zero rate is 0%, as published by HMRC on the VAT rates page.

Most business software subscriptions are standard-rated services. The supplier charges VAT at 20%, you pay it, and if you are VAT-registered and the software is for business use, you reclaim it through your VAT return. The net cost is then the budget figure.

Place of supply matters. If you buy from a UK supplier, UK VAT applies. If you buy from an overseas supplier with no UK establishment, the reverse charge can apply, and you account for VAT yourself. That does not usually change the net cost, but it changes who remits the tax and when.

Some items are not standard-rated. Certain educational or charitable supplies can be reduced-rated or zero-rated, and some digital publications attract a reduced rate. Check the specific supply rather than assuming.

Watch the VAT registration threshold and the flat rate scheme. A growing business can move from not charging VAT to charging it, which changes the price your customers see and the input VAT you can reclaim. Budget the transition, not just the steady state.

Do not treat VAT as a cost if you can reclaim it. Do treat it as a cash timing issue, because you pay the supplier before you recover from HMRC.

Corporation Tax rates and payment timing

Corporation Tax is charged on company profits, and software spend reduces those profits through allowable deductions. The main rate is 25%, the small profits rate is 19%, and the lower and upper limits for Marginal Relief are £50,000 and £250,000, as set out by HMRC on the Corporation Tax rates page.

The statutory basis for the computation sits in the Corporation Tax Act 2009, which is where the rules on profits, deductions and reliefs originate. You do not need to read it to build a budget, but you do need to know that the tax follows the accounts with adjustments.

Payment timing is the part budgets get wrong. Small companies generally pay Corporation Tax nine months and one day after the end of the accounting period. Larger companies pay by quarterly instalments, starting earlier in the year. That means a profitable year can require cash before the year has ended.

The practical effect: a software contract signed in month two may reduce the tax charge for the year, but the cash saving arrives after the year end. If you are a quarterly instalment payer, the timing is different again, and the first instalment can fall before the accounts are finalised.

Budget the tax cash separately from the tax charge. Use a simple schedule: accounting period end, tax payment date, and the instalment pattern if it applies. Then map the software spend to the period in which it is incurred, not the period in which it is paid.

If the numbers are large, ask whether the software is capital or revenue in nature. Capital allowances can spread the tax relief over several years, which changes the cash profile even when the total deduction is the same.

Marginal Relief calculations for software spend

Marginal Relief sits between the small profits rate and the main rate. It applies when profits fall between the lower limit of £50,000 and the upper limit of £250,000. The marginal relief fraction is 3/200, and HMRC sets out the method on the Marginal Relief guidance page.

The calculation starts with the main rate of 25%. It then subtracts Marginal Relief. The relief is the upper limit minus augmented profits, multiplied by 3/200. For a company with no associated companies, the upper limit is £250,000.

Here is a worked table using those figures. Augmented profits equal taxable profits in this example.

For £150,000 of profit, tax at the main rate is £37,500. Marginal Relief is (£250,000 minus £150,000) multiplied by 3/200, which equals £1,500. Tax payable is £36,000, an effective rate of 24%.

For budgeting, a large software commitment can push profits across the band. If the deduction moves you from the main rate into Marginal Relief, or from Marginal Relief into the small profits rate, the after-tax cost changes.

Work the effect in both directions. A software cost reduces profit by that amount, which reduces tax at the marginal rate. If your marginal rate is the small profits rate, the tax saving is smaller than if you were paying the main rate.

Do not model Marginal Relief as a single rate. Use the table above or build your own with your forecast profit levels. That keeps the budget honest when profit is volatile.

If your company has associated companies, the limits are divided, which can move you into Marginal Relief sooner. Check the associated company rules before you assume a rate.

Inflation and price indices for multi-year subscription timing

Multi-year software budgets need an inflation assumption, and the UK source for that is the Office for National Statistics. The ONS publishes the consumer prices index, the retail prices index and a range of producer and services price indices on its inflation and price indices hub.

Use the index that matches the contract. Many software contracts have a price review clause linked to CPI or RPI, so the index in the clause is the one to escalate. If the clause is silent, use a general measure and state the assumption.

Escalate the unit price, not the total. If you hold 200 seats at a given price, the renewal increase applies per seat. That makes the arithmetic simple and keeps the model auditable.

Timing matters as much as the rate. An annual increase applied on the renewal date has a different effect from one applied on the anniversary of the original contract. Put the uplift date in the model.

Run three cases: low, central and high. A single inflation number hides the range, and software vendors often apply increases above the published index. The central case is your budget; the high case is your contingency.

Remember that some costs are not indexed at all. One-off implementation and training are usually fixed at the point of purchase, so do not inflate them. Consumption-based charges are different again, because they move with usage rather than with a price index.

Worked figures: a UK software budget across one year

The example below uses a fictional UK company, a VAT-registered limited company with a December year end, buying a productivity suite for 120 seats. The figures are illustrative and rounded.

The net cost of £53,520 is the figure that reduces profit. The gross cost of £64,224 is what leaves the bank account.

Now apply Corporation Tax. Assume taxable profits before software of £400,000 and no other adjustments. The software deduction reduces taxable profit to £346,480. At the main rate, the tax saving is the deduction multiplied by that rate. Use the published rates rather than a remembered figure.

If profits were lower, say £60,000 before the deduction, the company would be in the small profits range and the tax saving would be smaller. If profits were in the Marginal Relief band, the saving would sit between the two. That is why the rate assumption belongs in the budget, not in a footnote.

For the cash profile, assume the software is billed monthly and the Corporation Tax is paid nine months and one day after the year end. The company pays the supplier through the year, reclaims VAT quarterly, and pays the tax in the following October. The tax benefit arrives after the software has been used for most of the year.

Add inflation for year two. Assume CPI of 3.5% and apply it to the per-seat and per-terabyte lines only. Leave the one-off lines flat. The year two net cost becomes £54,763. VAT at 20% is £10,953. The gross cost becomes £65,716. The run-rate rises, but the setup cost does not repeat.

This is the same logic set out in the full cost of productivity software guide, which follows cost from purchase through to exit. The budget should reflect the whole life, not just the first invoice.

Assumption sheet and decision gates

An assumption sheet is what turns a spreadsheet into a budget. It holds every number you guessed, so a reviewer can change one cell and see the effect. Keep it on one tab and reference it everywhere else.

Build it with these fields:

Use a three-tab structure. Tab one is Assumptions, holding the table above. Tab two is Budget, with these column headers: Line, Unit, Quantity, Net unit price, Net total, VAT rate, VAT amount, Gross total, Year 2 net, Year 2 VAT, Year 2 gross. Tab three is Tax, holding profit, tax charge, tax cash and payment dates.

Then set decision gates. A gate is a condition that forces a review rather than an automatic renewal. Examples: if seat count rises by more than a set percentage, renegotiate the band. If the supplier applies an uplift above the assumed index, reforecast. If profits move into a different tax band, revisit the after-tax cost.

Gates stop the budget from drifting. They also give you a reason to talk to procurement before the renewal date, not after.

Keep a separate line for hidden costs such as paid identities, seat bands and overage charges. These are the items that turn a clean budget into a surprise.

Finally, align the budget with your costs and pricing assumptions across the whole estate. Software is rarely bought in isolation, and the total commitment is what the board approves.

Common questions