Monthly Sales and Tax Summary Report [support thread]

I have not had the need to use local sales tax module. So I have no test bed setup.
In time I will most likely need to add that mod because you know the gov needs more money. So I will be working on it.

To bad you can't back bill the gov for all the add bookkeeping you need to do.
Say a 10% collection fee :D

I just wanted to say thank you. This is exactly what we needed!

Hi,

I don't know if I'm asking this in the correct topic. If not, I apologize and please direct me to the right topic. :oops:

I want to keep track of the product cost( the price I pay for) and the price I sell it for, so that I can keep track of Revenue. So, in addition to the sales reports, I was wondering if this module have revenue reports.

I had thought this is what the NET and GROSS prices are for while adding the products, but after some research it turns out they are for taxing products.

I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).

Thanks much in advance!
ITF :bigups:

Quote:

---

Originally Posted by IronTank

Hi,

I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).

Thanks much in advance!
ITF :bigups:

---

Because the data comes from the orders and orders_total tables for this mod there is no way that it could report on product cost.

I think you are looking for something more like this.
http://www.zen-cart.com/index.php?ma...roducts_id=278

Skip

Hi Skip,

that looks like what I need! Thanks so much for pointing it out to me! :bigups:


ITF

This module is THE BEST MODULE on the whole of the Zen Site........

Thanks for your time creating it....

I have 2 small sugestions to turn it from a GREAT MODULE to an EVEN GREATER MODULE....

2 more columns.....

number of orders (in the month)
Average order value (for that month)

this will help the site owner see visitor growth and trend growth too.

Will happily beta test on some very large sites that your script is running on and creating great reports.

Do you have a paypal link for donations?

Marc

marcps
Thank you for the compliment. My work load at this time does not allow me to do any enhancements. In time I will get back to this and add some of the items suggested.

Skip

Quote:

---

Originally Posted by skipwater

Because the data comes from the orders and orders_total tables for this mod there is no way that it could report on product cost.

I think you are looking for something more like this.
http://www.zen-cart.com/index.php?ma...roducts_id=278

Skip

---

I'm looking for the same as IronTank, adding a cost field.
I'll look into the link.

But, it is possible to add 'Payment Fees' on your Monthly Report?
(1) Basically, we would like a column for our Paypal fees listed.
(2) Can we select "Year" ? Right now 2008 & 2009 are listed.

Btw Skip... I agree with everyone else here, great mod.

-Jim

Quote:

---

Jim
But, it is possible to add 'Payment Fees' on your Monthly Report?
(1) Basically, we would like a column for our Paypal fees listed.
(2) Can we select "Year" ? Right now 2008 & 2009 are listed.

---

To my knowledge there is no where in ZC that Payment Fees are stored. So at this point I can't report them.

The years that you see/active are the available dates in your data base. As time passes the years will just be added to the list. I have not considered only showing one year at a time.

I use the report as a comparison against last years numbers with the detailed month information showing all past years month numbers.
This gives you a time line with plus or minus dollars per day on sales.

Skip

In the paypal table in the mc_fee field is where my paypal fees are stored on my ipn transactions