1

I'm sure this has been asked before, but I could not find an answer when I searched. Lets say I have an invoice with 3 line items shown below (All excluding tax)

SomeItemOne - Cost:£2.45 | Qty:1  
SomeItemTwo - Cost:£22.45 | Qty:5  
SomeItemThree - Cost:£68.99 | Qty:4

And the tax (VAT = 20%) is calculated based on individual unit price (See link).

So based on the above I would have the following to work out the tax

SomeItemOne: £2.45 + £0.49(20%) x 1 = £2.94  
SomeItemTwo: £22.45 + £4.49(20%) x 5 = £134.70  
SomeItemThree: £68.99 + £13.80(20%) x 4 = £331.16

Which gives me the following

Subtotal: £390.66
Tax: £78.14
Total: £468.80

Now I need to be able to offer % discounts off the entire order. Currently I have a 10% discount I need to apply, which would be discount before tax (As I obviously cannot discount tax).

How would I go about doing this? As the tax is calculated per unit? And there are many line items with varying qty?

YodasMyDad
  • 155
  • 5

2 Answers2

1

If you’re discounting the total price, then you’re discounting the tax by the same amount. The tax is calculated on what you actually charge, not on the headline price before discounts are applied. Just apply the discount to each line item and then calculate the tax as normal on the discounted price. Or if you don’t want to calculate the discount for each line item separately then just add a new line item for the discount, with a negative price and negative tax.

Mike Scott
  • 23,853
  • 2
  • 66
  • 80
1

That is not how VAT usually works.

To my knowledge (IANAL, but have coded quite a few systems to handle VAT)

  • VAT is always to be calculated on the total sum of an invoice (if you have different rates, you have to calculate one sum for every rate)

  • VAT is always rounded up.

Example:

This is simple: So let´s say you have an item that costs just 7 cent´s. That makes 1.4 cent rounded to 2 cents of VAT.

Now you have a customer ordering 100 of these for $7. The total VAT is $1.40

You give a 10% discount to $6.30, VAT is $1.26. -> Tax per piece would be 1.26 cent

But this: Customer changes his order to 103 for $7.21. Tax would be $1.45 (1.442 rounded up)

You give discount again $6.49. VAT is $1.30. Now if you calculate $6.49 / 103 pcs * 20% you get tax per piece of 1.26019417475728 cent

If you calculate $1.30 tax/ 103 pcs you get tax per piece of 1.26621359223301 cent

Makes for a total difference of 0.2 cents already for the 103 pieces. So what is correct, 20% on the individual rebated price or the 1.26621359223301 cent out of the $1.30?

Answer: Neither, VAT is a transaction fee - it is added to the value of the transaction (the invoice) not the item.

You can try to calculate back the per-item VAT then as a statistical value, but it may not be exactly 20% anymore. Don´t get that mixed up or you will acquire a lot of rounding errors down the road.

As per comments, example of a groceries bill taxed 7% and plastic bag taxed 19%: enter image description here

Notice how the 0.95... cents of tax for the plastic bag are rounded up to a full cent, and this full cent is owed by the supermarket. Also note that in this example item prices are given including tax, so the supermarket has to deal with some fluctuations in net prices. In a B-to-B invoice this would be the other way around

Daniel
  • 5,326
  • 1
  • 20
  • 20