Net and Gross Prices in a VAT Price List: How to Recalculate Quickly

Price lists often need two values: net price before VAT and gross price including VAT. When this is done manually, it is easy to confuse which amount is the base for the calculation.

A VAT calculator helps you move both ways: add VAT on top of a net price or extract VAT from a tax-inclusive price. This is useful for quotes, catalogs, spreadsheets, and customer negotiations.

When recalculation is useful

1. A supplier gives a net price and the customer needs the final total.
2. An old price list has VAT-inclusive prices and you need net values.
3. You compare offers that use different price formats.
4. The applicable rate changes for a document or transaction.
5. A sales team prepares a quote with a clear tax breakdown.

From net price to gross price

1. Enter the price before tax.
2. Choose Add VAT.
3. Select the rate used in your quote or document.
4. Get the VAT amount and gross total.
5. Move the result into your price list or proposal.

From gross price to net price

1. Enter the tax-inclusive price.
2. Choose Remove VAT.
3. Select the applicable rate.
4. Compare the net amount and tax amount.
5. Check rounding before importing many rows.

Price list tips

Name columns clearly: ?Net price?, ?VAT?, and ?Gross price?. Avoid using only ?price? when the document contains tax calculations.

If items use different rates, add a rate column. This makes the price list easier to audit and easier for customers to understand.

Quick example

A manager receives a purchase price of 50,000 excluding VAT and prepares a customer price list. In the calculator, they choose Add VAT, enter the net amount, and select the rate from the quote. The result goes into the Gross price column.

As a control check, they reverse the calculation: enter the gross price and choose Remove VAT. If the net amount matches the original number, the price list formula is likely correct.

FAQ

Should I show net or gross prices?

That depends on your contract, jurisdiction, and audience. For clarity, many price lists show both amounts and the rate.

Can I recalculate many rows?

The calculator is best for checks and individual calculations. For bulk price lists, use spreadsheet formulas and verify sample rows with the calculator.

Why should the rate be visible?

Without the rate, it is hard to understand how the final price was calculated or compare it with another offer.