Straight into the service manual page
WrenchQuarry
More

Backing 5% VAT out of a £483 price before a job is billed

WrenchQuarry Editorial Team · Published · 13 min read · How these guides are written

Divide a VAT-inclusive price by 1.05 to back out 5% VAT: the result is the net price, and the rest is VAT. The customer sees one total. Your job system, your margin report and your VAT figures all need a different number. Get the split wrong and either the business keeps less than it thinks, or the customer is billed a price that was never agreed.

Key takeaways

  • Divide the VAT-inclusive total by 1.05 to remove 5% VAT. Taking 5% off the total gives the wrong answer.
  • Check the rate before you divide, and use the standard rate unless the work is classed as reduced or zero-rated.
  • Choose one base for each document type and never change it midway.
  • Build the conversion into the quote sheet and check it in both directions.

This post walks through backing a VAT-inclusive price out to a net price. The worked case uses the 5% reduced rate and a total of £483, the same figure HM Revenue & Customs (HMRC) uses in its own example. You don't need to be an accountant to do the arithmetic. You do need one consistent method, a clear place for it in your quote sheet, and a habit of checking the rate before you divide.

This is a process guide, not tax advice for your business. Where a rule matters, the links point to the official source, and your accountant or HMRC can confirm how it applies to your jobs.

Why the figure on the quote needs care

Most field-service pricing starts from cost. You know the parts, the labour hours, the van time and the travel. You add a markup or a target margin, and then you arrive at a figure to put on the quote. The trouble starts when that figure is treated as the net price, when in fact it already includes VAT that the customer is paying on top of your work.

The mistake usually shows up in one of two ways. Sometimes the team quotes a VAT-inclusive total, but the job costing treats it as the net sale value, so the margin on the job report looks better than it really is. Other times the team enters a net figure, adds VAT afterwards, and then nobody checks whether the number on the invoice matches what was quoted. Both problems come from failing to separate the net figure from the gross figure.

The fix is not complicated. Decide which figure your system holds as the source of truth, label it in every document, and make the conversion a standard step rather than something done in someone's head on a busy afternoon.

The one sum you need

HMRC's guidance on charging VAT gives the method directly. To work out a price that excludes the reduced rate of VAT (5%), divide the price including VAT by 1.05. You can read the full guidance on the Charging VAT page on GOV.UK.

The reason this works is that 1.05 represents the full price including the 5% tax. Dividing by it removes the tax and leaves the net amount. Multiplying is the reverse: a net price times 1.05 gives the VAT-inclusive price. Keep both directions in mind, because the office will need each of them at different points.

Dividing by 1.05 is different from taking 5% off the total. The tax was calculated on the net price, so the calculation has to run back through the same base. That is the most common arithmetic slip in this exercise, and it is worth stating plainly in your training notes.

A worked example at £483

HMRC's example is a stairlift. The guidance describes a buyer who bought a stairlift where the total price including 5% VAT was £483. Take the same total and apply the method: divide £483 by 1.05. That gives the price excluding VAT: the £483 total less its £23 of VAT. HMRC's example works out the VAT in the same way. The guidance describes £23 as the difference between the two numbers, so the VAT portion is £23.

Now run the check the other way. Multiply the net figure by 1.05 and you should get £483 again. If your conversion does not return the original total when you reverse it, something has gone wrong in the sum or in the rounding. Build that check into your process, especially when the net figure has pence in it.

HMRC has a second example that is useful for the same reason. It describes selling a child's car seat for £200 and adding 5% VAT to get the price including VAT. Working forward means multiplying the £200 price by 1.05, and working back means dividing the VAT-inclusive price by 1.05 to return the £200. Two simple examples like this are worth keeping on the wall for new office staff, because they show the direction of the sum clearly.

The arithmetic is the same whichever rate applies, but the rate itself must be right before you divide.

Illustrative example: a net price of 200

Take a net price of 200 at the 5% rate. Multiply it by 1.05 to get the VAT-inclusive price, then divide that price by 1.05 to return to 200. The difference between the two totals is the VAT. Use the same two steps on every line of the quote sheet, so each net figure can be reversed to its original.

Check the rate before you divide

This is where many firms go wrong. The sum is easy. Choosing the wrong divisor is the expensive error. HMRC's guidance says to use the standard rate unless the goods or services you sell are classed as reduced or zero-rated. In other words, the standard rate is the default, and the reduced rate is an exception you must be able to justify.

So before anyone types 1.05 into a spreadsheet, ask a simple question about each line on the quote: is this line at the standard rate, the reduced rate, or the zero rate? A quote for a mixed job may have several lines at different rates. A single divisor for the whole total will be wrong if the lines are not all at the same rate.

Build a short list of your common job types and record the rate applied to each, with the reasoning and a link to the source you used. Review the list when HMRC guidance changes or when you add a new type of work. A written record also helps when a customer or a surveyor asks why a particular line shows the amount it does.

If a job type is not on your list and you are not sure of the rate, do not guess. Mark the line for review, hold the figure, and check the guidance or ask your accountant. A delayed quote costs less than a wrong one that is paid and then has to be corrected.

Who has to charge VAT in the first place

Before you back VAT out of anything, it helps to be clear about why the VAT is there. HMRC's guidance states that as a VAT-registered business, you must charge VAT on the goods and services you sell unless they are exempt. This is the starting point for the whole exercise. If you are registered, the VAT is part of the price your customer pays and part of what you account for.

For a field-service business, this means the office should not treat the VAT-inclusive total as a number that can be reshaped to suit the margin. The VAT figure is set by the rate that applies to the work, and the VAT is calculated from the net price at that rate.

Markup, margin and where VAT sits in job costing

Field-service pricing is often built on markup, and office teams mix markup up with margin all the time. ConstructionOnline puts the point directly in its help article on the subject: to ensure your jobs are always priced for profit, make sure your entire team understands the difference between markup and margin. The article is worth reading in full.

The VAT question adds a second layer. If your figures are built on cost plus markup, you need to know whether the markup is applied to a net cost to reach a net price, and then VAT is added on top. Or whether a VAT-inclusive target has been set and the net figure is backed out of it. Those two routes give different answers, and mixing them is an easy way to lose money without noticing.

Buildxact's help centre explains the same tension from the software side. It notes that because Buildxact works on a markup model, the charge-out rate has to be entered as cost plus markup rather than just typed straight in. That is a reminder that the software and the arithmetic must agree. Whichever system you use, the question to ask is the same: which number is the base, and which number does the customer see? You can read the article at Buildxact's charge-out rate and markup page.

A practical rule follows from this. For example, the quote might be built from net cost and markup, with VAT shown separately at the end. The job costing might hold net sale value only; Job costing setup for field service: 5 key settings covers the settings. The invoice would then show net, VAT and gross, with the VAT calculated from the net and checked against the quote. Service invoice tax rows: 3 mistakes to catch lists the common errors. Whatever you choose, write it down.

Build the conversion into the quote sheet

The most reliable way to avoid errors is to stop asking people to do the sum by hand. Put the conversion into the quote sheet so it runs every time, and so the same logic appears on every document.

A simple layout works well. Show the net price for each line, with the fields explained in Enter 3 fields on each equipment estimate line item. Show the VAT rate applied to that line, with the rate name rather than just a number, so a reader can see whether it is the standard or the reduced rate. Show the VAT amount for each line, and then the total net, total VAT and total gross. If a line is at a different rate from the rest, it should appear on its own row with its own rate, not be buried in a single total.

If your starting point is a VAT-inclusive total, as in the £483 example, build a second block that works the other way. Enter the gross figure, divide by the rate divisor, and show the net and VAT amounts. Then include a check row that multiplies the net back to the gross. If the check does not match, the sheet should flag it and stop the quote from being issued.

Rounding needs a decision too. Pick a rounding rule, write it into the sheet, and apply it consistently at line level or total level, whichever you choose. Mixing the two can leave a penny or two difference between the quote and the invoice. That difference is small, but it produces a dispute that takes far longer to resolve than it should.

Finally, lock the formula cells where you can. A spreadsheet that anyone can overwrite is a spreadsheet that will eventually be wrong. Protect the calculation columns and leave the input columns open, so the sum runs the same way every time.

Mistakes that cost money

Several errors come up again and again in field-service offices. The first is dividing the wrong figure. Someone takes the net total, divides by 1.05, and then adds VAT again. The net figure comes out too low, and the gross on the invoice falls short of the quoted total. The fix is to know which figure is the input and to label it on the sheet.

The second is the percentage shortcut. Taking 5% off a VAT-inclusive total is not the same as dividing by 1.05. Using the stairlift figure, the shortcut and the division give different answers, and the gap may look trivial on one quote. Across hundreds of jobs, though, it becomes a real distortion in your margin figures.

The third is using one rate for a mixed job. A quote with lines at different rates cannot be backed out with one divisor. Split the lines, apply the rate to each, and only then total the net and VAT amounts.

The fourth is letting the rate go stale. Rates and rules change, and a sheet built years ago may still carry an old assumption. Review your rate list and the sheet regularly, and record the date of each review so you can show when a rate was last checked.

The fifth is mixing up markup and margin in the job report. Teams sometimes agree a target margin in one meeting and enter a markup in the system, without anyone noticing that the two are different. Make the definitions part of onboarding, so new staff use the same language as the rest of the office.

The last mistake is the one that is hardest to see: no owner for the process. If nobody is responsible for the conversion, the sheet drifts, the rates fall out of date and the figures stop agreeing. Name a person who reviews the sheet on a set schedule and signs off changes.

When to check with HMRC or an adviser

A guide like this can get you most of the way, but some decisions belong with HMRC's published guidance or with a qualified adviser. If a job type does not clearly fall at the standard, reduced or zero rate, check the guidance before you price it. If you are unsure whether your business is registered in a way that affects the VAT on your invoices, confirm that with HMRC. If a customer disputes a VAT figure, your records should show the rate, the reasoning and the arithmetic, and an adviser can help you respond.

It is also worth having an accountant review your sheet once a year, or whenever the rules change. A short review can catch a formula error, an out-of-date rate or a mismatch between the quote and the job costing before it reaches a customer. The cost of that review is usually far smaller than the cost of correcting a batch of invoices.

When you do check, ask the specific question. Instead of asking whether a job is VAT-able, ask what rate applies to a named line of work and what evidence supports it. Specific questions get specific answers, and they leave a record you can file with the quote.

Summary

Backing VAT out of a VAT-inclusive price is a simple sum with a serious consequence. Divide the total by 1.05 to remove the 5% reduced-rate VAT. Using HMRC's stairlift figure of £483, dividing by 1.05 gives the net price and leaves £23 of VAT.

The sum is easy. The discipline around it is what matters. Be clear about whether your figures are built on markup or margin, and never mix the two. Put the conversion in the sheet, check it in both directions, and assign someone to keep the rates current.

Do those things and the number the customer sees, the number in your job costing and the number on your VAT records will tell the same story. That is the real goal: a quote that matches the invoice, and a margin report you can trust.

Today, take one recent quote with a VAT-inclusive total, divide it by 1.05, then multiply the result by 1.05 to confirm the original total comes back.

Frequently asked questions

Is dividing by 1.05 the same as taking 5% off?

No. Dividing by 1.05 removes the 5% VAT from a VAT-inclusive price, while taking 5% off the total gives the wrong net figure.

Which rate should I use?

Use the standard rate unless the goods or services you sell are classed as reduced or zero-rated, and check the rate before you divide.

How much VAT is in the £483 example?

The VAT is £23, the difference between the £483 total and the price excluding VAT.

Sources

More field guides