nordpool icon indicating copy to clipboard operation
nordpool copied to clipboard

VAT is added to a negative price

Open kimiseppanen opened this issue 2 years ago • 11 comments

VAT should be ignored when the price is negative because you are not paying taxes on negative prices (Atleast in Finland).

At the moment the price is displaying -0,43 cents but it should be -0,35 cents. -0,35 + 24% VAT = -0,43

kimiseppanen avatar May 27 '23 21:05 kimiseppanen

VAT should be ignored when the price is negative because you are not paying taxes on negative prices (Atleast in Finland).

At the moment the price is displaying -0,43 cents but it should be -0,35 cents. -0,35 + 24% VAT = -0,43

Same for Sweden! VAT shouldn't be added when the price is negative.

Bo1jo avatar May 28 '23 13:05 Bo1jo

In NL VAT has to be added to a negative price. (Price*1.21)

StSaens avatar May 28 '23 16:05 StSaens

Hellowlol avatar Jun 03 '23 15:06 Hellowlol

In my opinion you need to fully drop automatic vat calculation and ask people to use template instead.

yozik04 avatar Jun 03 '23 19:06 yozik04

In my opinion you need to fully drop automatic vat calculation and ask people to use template instead.

Agree, my price is spot price + 0,05 SEK and VAT should only be excluded if that goes below zero.

Better to add VAT as additional cost and add some examples in the documentation.

JonasEnstrom80 avatar Jul 15 '23 15:07 JonasEnstrom80

Any new commer want to take this one. https://github.com/custom-components/nordpool/blob/master/custom_components/nordpool/sensor.py#L294C1-L294C1

Hellowlol avatar Sep 11 '23 19:09 Hellowlol

In my logic you can't omit VAT from negative prices.

If you omit VAT from negative prices the total VAT will be wrong. The VAT is added to the total sum you pay, so lets say your consumption was 5€ without VAT and you got 1€ back from the negative prices the VAT is added to 4€ so the price would be 4,96€ with VAT. If you add VAT to 5€ you get 6,2€ and you substract the 1€ you get 5,2€ which I do not believe is the case, you have to substract the 1,24€ with VAT to get the right answer. Example was calculated with VAT 24%.

Please correct me if I'm wrong.

veista avatar Oct 10 '23 21:10 veista

I agree with @veista This is how it is at least done in Finland. All consumption is calculated VAT0% and to the sum of all VAT is added. so now when we had -50c/kWh negative prices in Finland for 9 hours all made money when using electricity and if I had from before used let's say 20€ worth VAT0% and now earned 5€ by using while price was negative I would end up with 15€ VAT0% to which 24% VAT would be added and the sum would be 18,60€

jseppeli avatar Nov 24 '23 22:11 jseppeli

Code vise the calculation would need to be something like this (I'm not a programmer) IF spotprice > 0 THEN price = spotprice+VAT ELSE price = spotprice

jseppeli avatar Nov 24 '23 22:11 jseppeli

Code vise the calculation would need to be something like this (I'm not a programmer) IF spotprice > 0 THEN price = spotprice+VAT ELSE price = spotprice

I think it is the same here in Sweden. You forgot addtional costs (if any are defined) though

cost = (spotprice + additional_cost) * VAT if spotprice + additional_cost > 0 else: spotprice + additional_cost

bj00rn avatar Jan 11 '24 13:01 bj00rn

It is not that simple in Finland either: VAT is not necessarily calculated hourly but from the total of the invoice (month). Only if the invoice total is negative then VAT is 0. Interpretation varies between companies so this is something that should be configurable or done by templates.

mikak avatar May 13 '24 07:05 mikak