Author Topic: Tax Calculation  (Read 5819 times)

fabioweb

  • Jr. Member
  • **
  • Posts: 141
Tax Calculation
« on: April 04, 2017, 22:48:14 pm »
Hello!
i'm using VM 3.2.1 with Joomla 3.6.5
I'm trying to show prices including taxes:

Final result on checkout should be:
119,00€ (included 26,18€)
instead of
119,00 + 22% = 153,18€

What i'm missing?
Thank you!


jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #1 on: April 04, 2017, 23:05:40 pm »
Use 'VAT tax per product'. The 'Tax per bill' options are primarily for the 'American' market, where they display the net price and show price including tax only in the cart view and on invoices.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

fabioweb

  • Jr. Member
  • **
  • Posts: 141
Re: Tax Calculation
« Reply #2 on: April 04, 2017, 23:11:39 pm »
Thank you i did. However VAT is still added to base price and not included..

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #3 on: April 04, 2017, 23:37:49 pm »
After configuration of your IVA 22% tax rule you need to select this tax rule from the 'Tax affecting' drop down list for each new product.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3939
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Tax Calculation
« Reply #4 on: April 04, 2017, 23:59:15 pm »
After configuration of your IVA 22% tax rule you need to select this tax rule from the 'Tax affecting' drop down list for each new product.

Shouldn´t default rules work in this case ? After choosing VAT per product ?

I use it that way and have assigned different countries for each VAT rule. I have not tried available for all in countries though.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10554
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Tax Calculation
« Reply #5 on: April 05, 2017, 09:30:54 am »
After configuration of your IVA 22% tax rule you need to select this tax rule from the 'Tax affecting' drop down list for each new product.

Jörg? You never should do this! It is an old legacy feature of vm1. In special beginner should always use the generic/standard stuff and not set a tax/discount.

Yepp Jörgen, you are completly right.

for the english people here Jörg ist not Jörgen!
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #6 on: April 05, 2017, 09:46:04 am »
@Jörgen and Milbo  :)
A 'normal' price and tax configuration would look similar to this: https://docs.virtuemart.net/tutorials/administration-configuration-vm-2/109-taxes-calculation-rules-case-1.html

I wonder how your approach works. If I apply default rules in the 'Tax Affecting' field, VAT is not added to the 'Base Price' in order to be included in the 'Final Price'. I've limited my VAT rule(s) to be applied for all EU countries. Also it doesn't make sense if you are selling products with different VAT rates.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

K&K media production

  • VirtueMart Developer Team
  • Global Moderator
  • Full Member
  • *
  • Posts: 838
  • VirtueMart Version: VM3 on J3
Re: Tax Calculation
« Reply #7 on: April 05, 2017, 09:55:07 am »
Quote
Thank you i did. However VAT is still added to base price and not included..

This is right, base price is the net price without vat tax. Final price is your price with vat.


Quote
I wonder how your approach works. If I apply default rules in the 'Tax Affecting' field, VAT is not added to the 'Base Price' in order to be included in the 'Final Price'. I've limited my VAT rule(s) to be applied for all EU countries. Also it doesn't make sense if you are selling products with different VAT rates.

Jörg Please check your rule configs. I've a shop with 2 vat rates for germany and EU for non-virtual goods, 2 vat rates for france for non-virtual goods and many more moss vat rates for all other european countries and virtual goods. All products have "apply generic rules".

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3939
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Tax Calculation
« Reply #8 on: April 05, 2017, 10:38:35 am »
I set up my tax rule like this and for multiple tax values. This will give 25 % for Sweden, Denmark and Croatia. I have set up similar rues with other VAT % and other countries. But if I would have to use multiple tax rules for the same country I would have to set up a category of VAT 25 %, VAT (12 %) and so on.


regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #9 on: April 05, 2017, 20:16:04 pm »
Ok - I missed the possibility to associate a tax rule with a tax category. Using tax categories might be easier to configure. I didn't test that with my 4 different tax rules which apply to EU countries yet. In the old example configuration I linked above, you have to assign a tax rule for every product. When using tax categories, you have to assign a tax category to every product in addition to a product category. Using tax categories is 'mandatory', if you are selling digital products in the EU, because you have to apply the VAT rate of the customer's country.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

fabioweb

  • Jr. Member
  • **
  • Posts: 141
Re: Tax Calculation
« Reply #10 on: April 09, 2017, 21:41:28 pm »
As you can see.. Tax affecting add 22% to base price.. It still not included

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #11 on: April 09, 2017, 22:37:36 pm »
Please read again:
This is right, base price is the net price without vat tax. Final price is your price with vat.

 ;)
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

fabioweb

  • Jr. Member
  • **
  • Posts: 141
Re: Tax Calculation
« Reply #12 on: April 09, 2017, 23:17:14 pm »
Yes :)
but i need that:
Cost Price: 178,00
Final Price: 178,00 (22% Tax Included) not 217.16


AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3514
  • VirtueMart Version: 4.0.12.10777
Re: Tax Calculation
« Reply #13 on: April 10, 2017, 09:57:41 am »
I do not know of a way of achieving what you require

Final price includes taxes applicable
Cost price does not.
Regards
A

Joomla 3.10.11
php 8.0

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3761
  • using Matomo instead of Google Analytics
Re: Tax Calculation
« Reply #14 on: April 10, 2017, 15:07:17 pm »
@fabioweb
Normally what you intend to do doesn't work because the cost price is the only price which is stored in the database. All other price and the tax values are calculated.
The only idea that comes into my mind is to a add your cost price and do NOT apply any (tax) calculation rule, so that cost price and final price are the same. Then you could create a Joomla language override for the language key COM_VIRTUEMART_PRODUCT_SALESPRICE which reads "22% tax included"

Just curious - why do you need cost price and final price to be the same?
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations