Tax Time and Total Sales Tallies

[ErikMM]

I didn't see a dollar total tallies in the add-ons for 2.3.

 

Any suggestions for something that will give a calander year total for tax purposes, preferably one that can break down US, State, and other countires, as each has different tax rate requirements for filing? I can break out a caculator, but I'm guessing someone has built something I have not found.

[ErikMM]

if there is a way to just add states/countries and cities to the "Orders" in Admin then they easily copy to xcel, where they can be tallied...

 

so at the very least a way to add states/countries and cities to the "Orders" in Admin would be awesome

[♥bruyndoncx]

Here something in SQL to get you going

select distinct o.customers_country, os.orders_status_name, ot.title, sum(ot.value)
from orders o, orders_total ot, orders_status os
where o.orders_id = ot.orders_id
and o.date_purchased between '2012-01-01' and '2013-01-01 00:00:00'
and (ot.title like 'Sub%' or ot.title like 'EU Tax%')
and o.orders_status = os.orders_status_id
and os.orders_status_name in ('Delivered','Cancelled')
 group by o.customers_country, os.orders_status_name, ot.title

 

this reports total values for the order total modules i selected based on their names ( starting with sub and having EU tax in my case)

only reports delivered and cancelled orders, you can extend this with other values, or remove the line completely

if you want to add other address fields, you add them to the select clause and to the group by clause

 

Hope this helps

 

PS if you have direct database access, Heidi SQL comes highly recommended - much faster/easy to use compared to phpmyadmin

[ErikMM]

thanks