How ShopWired calculates VAT
Definitions
- NET is the cost of a product or delivery rate without VAT
- VAT is the amount of VAT charged for a product or delivery rate
- GROSS is the total price paid by the customer
Price storage
Price storage
- ShopWired stores all prices exclusive of VAT, irrespective of whether you have opted to enter prices excluding or including VAT
- Prices are stored to 4 decimal places (e.g. £0.0001)
- When entering prices into ShopWired including VAT, ShopWired calculates the NET price by dividing the entered price by
1 + the VAT rate(e.g.1 + 20% = 1.20for the UK)
VAT calculation methods
ShopWired provides two separate methods for how VAT is calculated on visitor shopping baskets and resulting orders. Line item and single unit VAT calculations are described in HMRC's VAT guide VAT Notice 700 section 17.
- VAT can be calculated on the total quantity of a line item in a basket/order:
- This method of VAT calculation is described by HMRC at section 17.5.1 of VAT Notice 700
- Once the VAT is calculated on a line item, the amount of VAT is added up for each line item (including delivery charges) to arrive at the VAT total
- VAT can be calculated on a single unit of a line item in a basket/order:
- This method of VAT calculation is the current default on ShopWired (for new and existing accounts)
- This method is described by HMRC at section 17.5.2 of VAT Notice 700
- Once the VAT is calculated on a single unit, the amount of VAT is added up for the total quantity of items in a line item and then the subtotal of VAT for each line item is added up (including delivery charges) to arrive at the VAT total
To select how VAT is calculated for your ShopWired account:
- Navigate to Settings > VAT
- Locate the VAT calculation method setting
- Select either
calculate VAT per line item(for method 17.5.1) orcalculate VAT per unit(for method 17.5.2)
Calculating VAT on a line item
Calculating VAT on a line item
When you have selected to calculate VAT on a line item, the calculation depends on whether your account is set to enter prices excluding or including VAT. This price-entry setting is separate from ShopWired's internal storage of prices excluding VAT.
Prices entered excluding VAT
ShopWired calculates the NET line item total first, rather than rounding a GROSS single unit price before multiplying by the quantity:
- The NET unit price is multiplied by the quantity to calculate the NET price of the line item, e.g.
£0.33 x 1200 = £396.00 - The VAT amount is calculated by multiplying the NET line item total by the VAT rate, e.g.
£396.00 x 0.2 = £79.20- This VAT amount is rounded to the nearest 1p (2 decimal places)
- The VAT is added to the NET line item total to calculate the GROSS price, e.g.
£396.00 + £79.20 = £475.20
Prices entered including VAT
ShopWired calculates the GROSS single unit price first to preserve the entered VAT-inclusive selling price:
- ShopWired first calculates the GROSS price of a single unit of a line item by multiplying the stored NET price by 1 + the VAT rate, e.g.
£100 x 1.2 = £120.00- This amount is rounded to the nearest 1p (2 decimal places)
- The GROSS price of a single unit is then multiplied by the quantity of the line item to calculate the GROSS price of the line item, e.g.
£120.00 x 3 = £360.00 - The VAT amount of the line item is calculated using the line item GROSS by dividing the GROSS by 1 + the VAT rate and then multiplying the resulting figure by the VAT rate, e.g.
£360 ÷ 1.2 x 0.2 = £60.00- This amount is rounded to the nearest 1p (2 decimal places)
- The NET price of the line item is calculated by subtracting the VAT from the GROSS, e.g.
£360.00 - £60.00 = £300.00
For example, a price entered as £0.40 including VAT at 20%, with a quantity of 1200, gives a GROSS line item total of £480.00, a NET total of £400.00 and VAT of £80.00. This is a different price-entry basis from entering £0.33 excluding VAT.
Approximate unit values and basket VAT
For either price-entry setting, approximate amounts for the single unit are calculated by dividing the line item values by the quantity. Using the £360.00 GROSS example above:
- The single unit GROSS is
£360.00 ÷ 3 = £120.00 - The single unit NET is
£300.00 ÷ 3 = £100.00 - The single unit VAT is
£60.00 ÷ 3 = £20.00 - Each approximate single unit value is rounded to 4 decimal places (£0.0001)
The total amount of VAT on a basket/order is calculated by adding up the VAT amount for each line item.
Calculating VAT on a single unit
Calculating VAT on a single unit
When you have selected to calculate VAT on a single unit, ShopWired performs the following calculations in the following order:
- ShopWired first calculates the GROSS price of a single unit of a line item by multiplying the stored NET price by 1 + the VAT rate, e.g.
£100 x 1.2 = £120.00- This amount is rounded to the nearest 1p (2 decimal places)
- The VAT amount of a single unit is calculated by multiplying the stored NET price by the VAT rate, e.g.
£100 x 0.2 = £20.00- This amount is rounded to the nearest 1p (2 decimal places)
- The NET price of a single unit is recalculated by subtracting the VAT amount from the GROSS, e.g.
£120.00 - £20.00 = £100.00- As a result of rounding, the (new) calculated NET price may be different to the originally stored NET price
- Amounts for the line item total are calculated by multiplying the single unit values by the quantity, e.g.:
- The line item GROSS is
£120.00 x 3 = £360.00 - The line item NET is
£100.00 x 3 = £300.00 - The line item VAT is
£20.00 x 3 = £60.00
- The line item GROSS is
The effects of rounding
The effects of rounding
ShopWired rounds VAT to the nearest penny at the following stages:
- For line item calculation, VAT on the line item is rounded to the nearest £0.01
- For single unit calculation, VAT on a single unit is rounded to the nearest £0.01
These are ShopWired's rounding choices, not the only options permitted by HMRC. VAT Notice 700 describes permitted rounding options for line item and single unit calculations, with separate guidance for retailers in section 17.6. It does not require precisely nearest-penny rounding for each method.
When a basket/order contains "larger" single unit pricing and/or "lower" quantities, the effects of rounding are negligible or non-existent, but as single unit prices get lower and quantities get higher, the effects of rounding become more noticeable.
In the line item rows below, single unit values are approximate and rounded independently to 2 decimal places. They may not add up or multiply back to the line item totals; use the line item totals for the amounts charged.
| Calculation method | Single unit GROSS | Single unit NET | Single unit VAT | Line item GROSS | Line item NET | Line item VAT |
|---|---|---|---|---|---|---|
| For a product costing £7.95 (including VAT) with a quantity ordered of 10 | ||||||
| Line item | £7.95 | £6.63 | £1.33 | £79.50 | £66.25 | £13.25 |
| Single unit | £7.95 | £6.62 | £1.33 | £79.50 | £66.20 | £13.30 |
| For a product costing £3.95 (including VAT) with a quantity ordered of 100 | ||||||
| Line item | £3.95 | £3.29 | £0.66 | £395.00 | £329.17 | £65.83 |
| Single unit | £3.95 | £3.29 | £0.66 | £395.00 | £329.00 | £66.00 |
Line item approximate values
Line item approximate values
When VAT is calculated on a line item, ShopWired calculates approximate values for the NET price and the amount of VAT of a single unit of each line item.
These amounts are stored by ShopWired to 4 decimal places but in certain places within your ShopWired account (such as the page where you view detailed order information) or where order information is downloaded (such as the orders CSV) the amounts are shown to 2 decimal places.
As a result, the NET price or the amount of VAT for a single unit when multiplied by the quantity will not always equal the line item values. .