Download User Manual - EPOS 4 Excel

Transcript
143 | P a g e
=
βˆ‘ 𝑆𝑖 βˆ’ 𝐷£
βˆ‘ 𝑆𝑖
According to HMRC VAT rules for mixed VAT products the monetary discount of a sale must be
apportioned amongst the items in the sale in proportion to the original item prices. After this
apportionment we can calculate the VAT due on each item using the VAT fraction method detail
above.
Item price after the appropriate proportion of the monetary discount is applied:
𝑆𝑖 βˆ’ 𝐷£,𝑖 = 𝑆𝑖 βˆ’
𝑆𝑖
𝐷
𝑆 £
ie. the proportion of the monetary discount applicable to an individual item is:
𝐷£,𝑖 =
𝑆𝑖
𝐷
𝑆 £
Total price after monetary discount is the sum of the individual item prices less their portion of the
monetary discount:
𝑆 βˆ’ 𝐷£ = βˆ‘(𝑆𝑖 βˆ’ 𝐷£,𝑖 ) = βˆ‘(𝑆𝑖 βˆ’
𝑆𝑖
𝐷)
𝑆 £
= βˆ‘ 𝑆𝑖 × (1 βˆ’
𝐷£
)
𝑆
π‘†βˆ’π·£
)
𝑆
= βˆ‘ 𝑆𝑖 × (
(3)
But above we had
𝑆 βˆ’ 𝐷£ = 𝐷% × π‘† = βˆ‘ 𝑆𝑖 × π·%
(4)
Comparing (3) and (4) we again find that
𝐷% =
π‘†βˆ’π·£
𝑆
(5)
Therefore apportioning the monetary discount across the items of the sale in proportion to the
original item price is equivalent to considering a monetary discount as a percentage discount on
each individual item price using equation (5). If you multiply each item price by (5) the monetary
discount will be apportioned amongst the items correctly according to HMRC guidelines for mixed
VAT products. This means we find the actual price each item was effectively sold for. We can then
calculate the VAT due on the individual items using these altered item prices and the VAT fraction
method outlined above.
Combining monetary discounts and percentage discounts off the whole sale
When there is both a percentage discount off the sale AND a monetary discount off the sale, we take
the monetary discount off first before applying the percentage discount ie.
π‘ƒπ‘Ÿπ‘–π‘π‘’ π‘Žπ‘“π‘‘π‘’π‘Ÿ π‘‘π‘–π‘ π‘π‘œπ‘’π‘›π‘‘ = π‘Žπ‘π‘π‘™π‘¦ π‘π‘’π‘Ÿπ‘π‘’π‘›π‘‘π‘Žπ‘”π‘’ π‘‘π‘–π‘ π‘π‘œπ‘’π‘›π‘‘ × (π‘œπ‘Ÿπ‘–π‘”π‘–π‘›π‘Žπ‘™ π‘π‘Ÿπ‘–π‘π‘’ βˆ’ π‘šπ‘œπ‘›π‘’π‘‘π‘Žπ‘Ÿπ‘¦ π‘‘π‘–π‘ π‘π‘œπ‘’π‘›π‘‘)
Doing it this way works in the favour of the retailer rather than the customer.
If we write a monetary discount as an equivalent percentage then we get:
EPOS 4 Excel v1.7.3
Website: epos4excel.weebly.com
©Martin Stokley 2011-2015