Post by milezteg » Fri Oct 18, 2013 2:17 pm

My issue is pretty simple. In Canada we collect 3 taxes (PST, GST, HST) depending what province you live in. I know how to add this to OC to collect the tax from the customer. My issue is I need an easy way to show me the amounts collected for each tax (PST, GST, HST) every month. Otherwise it will take hours to calculate this manually.

Do you think I could get this information with a SQL query? I've searched the extensions for weeks and don't find anything that will handle this! How do you guys figure out every month how much tax you've collected when you have multiple tax types?

User avatar
New member

Posts

Joined
Wed Nov 28, 2012 11:00 am

Post by milezteg » Sat Oct 19, 2013 6:14 am

RE: http://docs.opencart.com/display/opencart/Tax+report

So nobody has a solution for getting totals for multiple taxes with the built-in Tax Porting page? Even after searching these forums and Google I can find no solution to this. Surprising as many countries countries multiple taxes. I've searched but does anyone know of an extension where they can export this data to excel to calculate manually? Someone out there must have faced this problem.

User avatar
New member

Posts

Joined
Wed Nov 28, 2012 11:00 am

Post by Johnathan » Sat Oct 19, 2013 11:14 pm

You could do this with an SQL query, based on the title of the tax. All of the line items for an order are recorded into the "order_total" table, and include the title of each tax. (The "code" is also recorded, but this is "tax" for every tax line item, so it's not helpful for separating them.) You'd have to understand MySQL to create the appropriate query, but it would be something like this:

Code: Select all

SELECT SUM(value) AS total FROM order_total WHERE title = 'VAT (17.5%)';
You'd then have to LEFT JOIN that with the "order" table so you could pull appropriate dates. I'd imagine that there is a reporting extension available in the extension store, if you take a look there, although I don't know of any that specifically do this.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by milezteg » Sun Oct 20, 2013 6:26 am

Thanks John, at least I know it's possible. I am mystified as to why there seems to be no extension that does this, but moreso that OC doesn't do this with its own built in tax report page. If anyone has a solution or workaround for their own multi-tax situation, please chime in.

User avatar
New member

Posts

Joined
Wed Nov 28, 2012 11:00 am

Post by milezteg » Sat Nov 02, 2013 5:55 pm

Damn another fruitless search of the extension store and still cannot find a way to export reports for multiple taxes. What are all the other Canadian vendors doing, or those with multiple taxes? Anyone?

User avatar
New member

Posts

Joined
Wed Nov 28, 2012 11:00 am
Who is online

Users browsing this forum: Google [Bot] and 56 guests