Monthly Sales and Tax Summary Report [support thread]

[KenHaynes]

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.

[skipwater]

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

[KenHaynes]

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.

[psr racing]

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?

[skipwater]

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

[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/uniquep.../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!

[skipwater]

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/uniquep.../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

[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!

[skipwater]

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

[miffy22]

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/uniquep.../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.