VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: coxi on March 08, 2016, 19:32:52 PM

Title: Tax reporting
Post by: coxi on March 08, 2016, 19:32:52 PM
Hi,
I'm in France. My customer is in Québec, Canada. He will sell all around the world downloads of mp3 conferences.
All items sold outside Canada are free of tax.
All items sold inside Canada have a 5% federal tax.
Each province (13) has an unique local tax rate (from 0% to 10%).
Virtuemart make it possible to assign tax to each customer regardless of the delivery address. It work fine.

But now, my customer ask me to sort monthly a report of all the saless...
Saless outside Canada.
Sales inside Canada whitout tax.
Federal tax for all purchases into canada.
Province taxes (x13) for all purchases into canada and separate amount for each province).
Ability to sort by day, by week, by month, by year.
Export to CSV ? XLS ? Other ?

Is there a plugin or a component to do such a work ? Virutemart only offer a display for with/without taxes, without separated sales...

Any idea ? Regards. Alain
Title: Re: Tax reporting
Post by: GJC Web Design on March 08, 2016, 21:02:07 PM
I have to do this for my on line sales in Europe..  I just use a simple DB query to gather all the info

But this could be built into say a Joomla admin module (have done this e.g. for VM shipping exports) to produce a csv...
click the button and it spits out a csv .. could have date parameters etc
Title: Re: Tax reporting
Post by: reinhold on March 08, 2016, 21:41:00 PM
I am not aware of a full-fledged tax-reporting component for VirtueMart. However, as a programming tutorial for VM extensions I have build a very simple tax view, which you can use as a starting point to develop what your customer wants:
http://open-tools.net/documentation/tutorial-extending-vm-with-custom-views.html

It will be quite some work to implement everything your customer wants, but at least a simple list of all charged taxes is really simple to implement.

Best regards,
Reinhold
Title: Re: Tax reporting
Post by: coxi on March 10, 2016, 16:43:29 PM
Ok. Thank you very much. I think I will find enough to do what my customer is waiting for.
Best regards.
Alain