I need someone to install a way to see daily/weekly/monthly sales report in my oscommerce. I want to be able to export the reports in excel file format on the fly.
In this report, I need the following details to show up:
shipping fees charged
sales taxes charged*
* This part is tricky as I abslolutely need the report to show both taxes separately (GST and PST )
I want this feature to be retroactive. I need to be able to produce reports for the past sales and not only from the point you install this.
Also, I would like someone to take a look at my tax settings. It doesnt work proprely as we always end up charging less tax than the customer should pay. The taxes have to be calculated on the shipping cost also.
+ taxes (if applicable)
You should have a good understanding of the canadian/provincial tax system. I think it's only a matter of adding tax to the sum of sale+shipping but I want to get it done right and get rid of this problem once and for all.