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