Monthly Sales and Tax Summary Report [support thread]

ceesdk:

hello, I am using v1.3.9h and uploaded the files to there
respective directories but "Admin->Reports>Monthly Sales" menu choice isn't there !

I have noticed you have being working on it the last days! so is there something what wents wrong ?

regards, Cees

Hi All,

I installed the mod today and have exactly the same issue. I can confirm that I have doubled-checked and re-checked that all the files are in their correct location. I even downloaded the mod again and re-installed it, but no joy.

Seems like an excellent mod though and I can't wait to get it working.

Ken.

KenHaynes:

Hi All,

I installed the mod today and have exactly the same issue. I can confirm that I have doubled-checked and re-checked that all the files are in their correct location. I even downloaded the mod again and re-installed it, but no joy.

Seems like an excellent mod though and I can't wait to get it working.

Ken.

Monthly Sales Tax Summary v1.4 is ONLY FOR Zen Cart 1.5 RC2
This is because 1.5 has a built in Admin Page Registration for 3rd Party Modules that is used.

**Monthly Sales Tax Summary v1.3 is FOR Zen Cart 1.3.x **

If you are running 1.3.x download v1.3

Skip

Thanks for the quick reply Skip.

It works a treat - great mod.

BTW Secret Squirrel, ah that takes me back. Remember Squiddly Diddly and Winsome Witch?

Thanks,
Ken.

I've been using this addon for a while now and rely on it for tax purposes. I've just realised that the total for 'Non taxed Sales' does not include the postage on those sales, which is also non taxed. The postage on most of my non taxed sales is very high as they are export sales so by not taking it into account I'm paying tax on money that I shouldnt be paying tax on. Is there a way to set things up so the postage on non taxed orders is included in the total of the 'Non Taxed Sales' column?

psr racing:

Is there a way to set things up so the postage on non taxed orders is included in the total of the 'Non Taxed Sales' column?

No: Postage / Shipping is not a sale of product, it needs to be listed separately as it is.

Skip

Hi,

I am using Zen cart 1.5, monthly sales tax report module v1.4.

Below are two images to illustrate the problem which I am encountering with this module.
https://picasaweb.google.com/uniquepartyideas/AllMyFavorite

We first noticed that our monthly gross income total is always off by a few cents compared to the report generated by Paypal. For tax purpose, we will need to have these two reports match exactly.

In investigating this problem, we found that although the monthly sales report uses the data from order table, however, when checking our order in daily details, the sum is actually not correct in the monthly sales report.

Is there a bug in this module? Could someone please help?

Thank you!

miffy22:

Hi,

I am using Zen cart 1.5, monthly sales tax report module v1.4.

Below are two images to illustrate the problem which I am encountering with this module.
https://picasaweb.google.com/uniquepartyideas/AllMyFavorite

We first noticed that our monthly gross income total is always off by a few cents compared to the report generated by Paypal. For tax purpose, we will need to have these two reports match exactly.

In investigating this problem, we found that although the monthly sales report uses the data from order table, however, when checking our order in daily details, the sum is actually not correct in the monthly sales report.

Is there a bug in this module? Could someone please help?

Thank you!

Look at the 'Taxes collected' value. It should be a link to the detailed report. In this report it will show a 3 digit cents.

example $0.105
if =< 0.005 round down
if => 0.006 round up.

Is that true to your examples?

Skip

Hi Skipwater,

Yes, I do have record of every order's tax collected with 3 digit cents.

So, for a particular order, when clicking on the link under tax collected, I have $18.609, and under invoice for the same order, the tax was rounded off to $18.61

What do I need to do in order to make sure the tax collected is the same as Paypal?

Thank you!

miffy22:

Hi Skipwater,

Yes, I do have record of every order's tax collected with 3 digit cents.

So, for a particular order, when clicking on the link under tax collected, I have $18.609, and under invoice for the same order, the tax was rounded off to $18.61

What do I need to do in order to make sure the tax collected is the same as Paypal?

Thank you!

Just need some more info:
Using phpMyAdmin or similar look at the orders_total table.
Look at columns title, text, value
title column = Sales Tax
text column = $0.10 (example)
value column = 0.096 (example)

The text column is what you see on the order page not the value.

Use Monthly Sales and Tax Summary Report and view the same record.
Did Monthly Sales and Tax Summary Report display the same info that is in the text column?

Or if you want export 10-20 records of orders_total table zip them and pm me where I could retrieve the file from and I will look at it.

Skip

Hi Skip,

I uploaded views of my orders_total table and sales and tax summary report on the same link at:

https://picasaweb.google.com/uniquepartyideas/AllMyFavorite

Thank you so much for taking a look for me!!

P.S. You might notice that there is no order #388, it's only because this order was not charged with tax, so please ignore this.

miffy22

After looking and testing I can only suggest this as the issue:

PayPal applies tax to each line-item individually this in turn could change what the paypal report states. Because Monthly Sales and Tax Summary Report looks at it as one taxable order amount.

At this point I am unable to find away to match the two reports. In all fairness I could be missing something but dam I can't find it.

Skip

Hi Skip,

Thank you for spending time to look at this problem for me. Really appreciate your help!

Hope maybe this issue could be resolved eventually!!

Please post on this thread again if you do found the solution for it!

Again, thank you!!

Does the latest version of this work in the order Zen cart versions. I' haven't updated to 1.5 as yet and would love to use the latest version on v1.39

outeredge2:

Does the latest version of this work in the order Zen cart versions. I' haven't updated to 1.5 as yet and would love to use the latest version on v1.39

Version 1.3 is the same as version 1.4 the only difference is the admin menu setup for ZC 1.5.

Skip

newbie to this forum. Bear with me if this had been answered which is not found.

Zen Cart 1.5, snapshot of server info:

Server Host: sXXXX Database Host: XXXXX
Server OS: Linux 2.6.30.1-3.AM_PAE Database: MySQL 5.0.51a-24-log
Server Date: 05/02/2012 22:32:13 Database Date: 05/02/2012 22:32:13
Server Up Time: Unsupported HTTP Server: Apache/2.2.11
PHP Version: 5.3.9 (Zend: 2.3.0) PHP Memory Limit: 128M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 7M POST Max Size: 8M
Database Data Size: 9,098 kB Database Index Size: 4,021 kB

$Id: stats_monthly_sales.php, v 1.4 2011/11/24

Question:
1.Is there a way to configure the report that showing zero as value on the day of month when there is no sale ? I need to compile report from 2 sources of raw data that one report zero on day without sale, when sale report only on day that with sale.
2. Is there is way only report on current year? and date format in mm/dd/yyyy

Thank you in advance for any insight you can provide.

Question:
1.Is there a way to configure the report that showing zero as value on the day of month when there is no sale ? I need to compile report from 2 sources of raw data that one report zero on day without sale, when sale report only on day that with sale.
2. Is there is way only report on current year? and date format in mm/dd/yyyy

No there are no setting in the report to do what you want. But you could add them with some php code.

Skip

I am using the Optional Shipping Insurance Module with my cart. When I do use this monthly report module the numbers weren't adding up properly. What I find is that the report takes my coupons and also adds the shipping insurance to the Gift Voucher field. Really it would be ideal to have a seperate field showing the shipping insurance charges but otherwise if it just added the insurance charge to the regular shipping field that would work too. The shipping insurance is adding a field under orders_total called ot_insurance. Does anyone know how I could exclude that field from being added in with the vouchers and possible add that total to the shipping charge field?

spyderrobotics:

I am using the Optional Shipping Insurance Module with my cart. When I do use this monthly report module the numbers weren't adding up properly. What I find is that the report takes my coupons and also adds the shipping insurance to the Gift Voucher field. Really it would be ideal to have a seperate field showing the shipping insurance charges but otherwise if it just added the insurance charge to the regular shipping field that would work too. The shipping insurance is adding a field under orders_total called ot_insurance. Does anyone know how I could exclude that field from being added in with the vouchers and possible add that total to the shipping charge field?

When there is any non-standard items in orders i.e. ot_insurance it is placed in the Gift Voucher section.

Yes you could add it to shipping or make it's own section. You would just have to added all the new code. And there would be a lot of adding.

Skip

I have recently installed this add on into 1.3.8a and I get it directing to an error 404 page am i missing something

webmosa:

I have recently installed this add on into 1.3.8a and I get it directing to an error 404 page am i missing something

You must use Monthly Sales and Tax Summary Report - Version: 1.3 for any Zen Cart < v1.5

Skip