Author Topic: final Price, Rounding and Tax price [solved]  (Read 347 times)

sohopros

  • Jr. Member
  • **
  • Posts: 63
final Price, Rounding and Tax price [solved]
« on: February 01, 2019, 19:23:03 pm »
Hi,

1. product price is 1.11 euro.
2. User buy 21 Products.
3. Tax is 21%
 Calculations:
1.11 * 21 = 23.31 . Price without Tax
23.31 * 0.21 = 4.90. Tax Price.
23.31 + 4.90 = 28.21 euro. Final Price.

Setting on the Back -end:

1. If user buy 21 or more quatity price is 1.11
2. Final Price is 1.34. BUT 1.11 * 1.21 (tax) is 1.3431. But Virtuemart Round this price to 1.34!
3. In the shopping Card Virtuemart USE FINLA Price to calculate Tax and Order Price.
Calcumations:

1.34*21 = 28.14  (Order Price)
1.11*21 = 23.31 ( Product Price withiut tax)
28.14-23.31 = 4.83 Tax Price.

See attached screenshots.

Can the calculations of the TAxes be made in the Card? Not from Final Price. OR Can the final price be rounded not for 2 decimals after the coma, but more?


Please advise,
Sandra

sohopros

  • Jr. Member
  • **
  • Posts: 63
Re: final Price, Rounding and Tax price
« Reply #1 on: February 06, 2019, 18:36:19 pm »
Any advise on it?

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3408
  • using Matomo instead of Google Analytics
Re: final Price, Rounding and Tax price
« Reply #2 on: February 06, 2019, 23:29:03 pm »
Why do you want to change that? The VAT calculation with rounded 2 decimals is correct and accepted in all EU countries. This is what the vast majority of businesses do. If you change that, the numbers will look weird to many customers.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

sohopros

  • Jr. Member
  • **
  • Posts: 63
Re: final Price, Rounding and Tax price
« Reply #3 on: February 07, 2019, 20:50:30 pm »
I want to have the correct total amount.

Virtuemart calculates final price: 28.14

But the correct Final Price is 28.21.

In my example, the difference is not big, but in the real world, the difference is huge.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2842
  • VirtueMart Version: 3.4
Re: final Price, Rounding and Tax price
« Reply #4 on: February 08, 2019, 11:04:46 am »
show your rounding settings in the configuration page

what type of tax are you applying to products
regards
A

Joomla 3.9.1
php 7.1

sohopros

  • Jr. Member
  • **
  • Posts: 63
Re: final Price, Rounding and Tax price
« Reply #5 on: February 13, 2019, 00:41:20 am »
Added Price roundings

We use VatTax

Thanks

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2842
  • VirtueMart Version: 3.4
Re: final Price, Rounding and Tax price
« Reply #6 on: February 13, 2019, 10:35:26 am »
Thank you for the information.

My advice (as it is the settings I have used since day 1 for VAT Tax by product ) Do not round to 2 when using VAT tax - set ALL roundings to -1

Also set "Round only display"
regards
A

Joomla 3.9.1
php 7.1

sohopros

  • Jr. Member
  • **
  • Posts: 63
Re: final Price, Rounding and Tax price
« Reply #7 on: February 13, 2019, 18:29:23 pm »
Perfect! Thanks, it worked.

Sandra

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2842
  • VirtueMart Version: 3.4
Re: final Price, Rounding and Tax price
« Reply #8 on: February 13, 2019, 20:04:53 pm »
Glad it worked for you  :)
regards
A

Joomla 3.9.1
php 7.1