Sales Tax Report

[5YearWinter]

I've been looking everywhere in the back end and do not see anything that can just simply give you the sales tax collected within a particular period.  We have to pay sales taxes on orders within our state and there does not appear to be a simply way of running a report with that.

 

I came across a module but am certainly not paying over $100 just for something that should be included in the cart.

 

Can someone please help?

[cjrhoads]

I think you got your answer, Mike.

 

No, there doesn't appear to be a way to get that information easily.

 

I could be wrong, but it appears that way to me after extensively reviewing the database schemas.

Just my opinion

CJ

[cjrhoads]

Well - easy is tough, but I have to add that I did find a way to get a query that would give me a sales report. (See the thread on Sales Reports to see the SQL of the query).    That means, Mike, that you could use a similar methodology to make a query that would give you the sales tax information that you need. (My non-profit doesn't pay sales tax, so I didn't include that info in my query - but you could easily do so).

Regards

CJ Rhoads

[cleaner]

Hi Guys,

 

I'd like to hear is there any update available to this topic?

In other words is there any easy way to have monthly sales report out (for account office)? 

 

If not, how have you done it?

 

rgd,

cleaner

[cjrhoads]

Hi, Cleaner.

 

I'm hoping someone else will answer as well, but I'm still doing what I started doing in July.  I created a query that gives me the sales, and I run it every month.  It seems to work pretty well.  I now have dozens of other queries that I run.  Once Prestashop posted the database schema (which wasn't available in July, but is now), it was easy to figure out which fields has the information I need so that I can simply write SQL queries for all my reports. 

 

Since I'm not really an SQL [spam-filter], what I actually have done is created an Access database structure that mirrors the Prestashop structure exactly (I used a software program called DBsync from DBConvert), and then I create my query using Access Queries (which I'm very good at).  Then I view the SQL of the query, and copy and paste it into the New SQL window under Advanced Parameters--SQL Manager.  Once it is set up, it is very easy to run each month. 

 

Anyone else find an easier way?

 

Hi Guys,

 

I'd like to hear is there any update available to this topic?

In other words is there any easy way to have monthly sales report out (for account office)? 

 

If not, how have you done it?

 

rgd,

cleaner