VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: fabioweb on April 04, 2017, 22:48:14 PM

Title: Tax Calculation
Post by: fabioweb 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!

Title: Re: Tax Calculation
Post by: jjk 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.
Title: Re: Tax Calculation
Post by: fabioweb on April 04, 2017, 23:11:39 PM
Thank you i did. However VAT is still added to base price and not included..
Title: Re: Tax Calculation
Post by: jjk 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.
Title: Re: Tax Calculation
Post by: Jörgen on April 04, 2017, 23:59:15 PM
Quote from: jjk 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.

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
Title: Re: Tax Calculation
Post by: Milbo on April 05, 2017, 09:30:54 AM
Quote from: jjk 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.

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!
Title: Re: Tax Calculation
Post by: jjk 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.
Title: Re: Tax Calculation
Post by: K&K media production on April 05, 2017, 09:55:07 AM
QuoteThank 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.


QuoteI 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".
Title: Re: Tax Calculation
Post by: Jörgen 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
Title: Re: Tax Calculation
Post by: jjk 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.
Title: Re: Tax Calculation
Post by: fabioweb on April 09, 2017, 21:41:28 PM
As you can see.. Tax affecting add 22% to base price.. It still not included
Title: Re: Tax Calculation
Post by: jjk on April 09, 2017, 22:37:36 PM
Please read again:
Quote from: K&K media production on April 05, 2017, 09:55:07 AM
This is right, base price is the net price without vat tax. Final price is your price with vat.

;)
Title: Re: Tax Calculation
Post by: fabioweb 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

Title: Re: Tax Calculation
Post by: AH 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.
Title: Re: Tax Calculation
Post by: jjk 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?
Title: Re: Tax Calculation
Post by: K&K media production on April 11, 2017, 14:28:33 PM
Or if you want that vm calculates the cost price on the fly, I've a plugin for this.

With this Plugin this is the workaround:

configured product cost price: 10
configured product final price: 10
configured vat rule: 22%

prices on frontend for your customer:

cost price: 8,20
vat 22%: 1,80
final price: 10