Monthly Sales and Tax Summary Report
|
This report displays a summary of monthly or daily totals: gross income (order totals) subtotals of all orders in the selected period nontaxed sales subtotals taxed sales subtotals tax collected shipping/handling charges low order fees (if present) gift vouchers (or other addl order total component, if present) Data is reported as of order purchase date. If an order status is chosen, the report summarizes orders with that status. The capability to "drill down" on any month to report the daily summary for that month. Report rows are initially shown in newest to oldest, top to bottom, but this order may be inverted by clicking the "Invert" control button. A popup display that lists the various types (and their subtotals) comprising the tax values in the report rows. Columns that summarize nontaxed and taxed order subtotals. The taxed column summarizes subtotals for orders in which tax was charged. The nontaxed column is the subtotal for the row less the taxed column value. A popup help display window on how to use. |
 Zen Cart® Versions |
v1.5.7 |
 Original Author |
skipwater |
| Last Updated by |
lat9 - 19 May 2022 |
 Downloads |
12,785 |
Version History
| Monthly Sales and Tax Summary Report - Version: v2.0.4 | |||||||||||||
| This release corrects the dates' sorting by gathering the dates using 2-digit months and days; see GitHub issue #9. | |||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v2.0.3 | |||||||||||||
|
This release contains changes to correct the following GitHub issues: #7: Correct strict MySQL 5.7 fatal error #8: Correct PHP notices for missing totals in a given timeframe. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v2.0.2 | |||||||||||||
| This release contains the (previously missing) /YOUR_ADMIN/includes/modules/sms/tpl_stats_monthly_sales_taxes.php and modifies its data-gathering so that a report's generation doesn't take 'centuries'! | |||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v2.0.1 | |||||||||||||
|
Many changes needed to support now-current PHP versions and strict MySQL installations! - Remove use of to-be-deprecated `strftime`. - Modify SQL queries to support strict MySQL installations; correcting fields missing from `GROUP BY`. - Correcting various PHP notices, deprecations and warnings. - Use Bootstrap modals for popup displays. Replaces v2.0.0. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.5.4 | |||||||||||||
| Versioning update | |||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.5.3 | |||||||||||||
|
- Bug fix shipping $$ - Recovered YOY ability in monthly screens from the old module - Added ability to limit reports to one or more zones - Fixed CSV export - Added license to package - Tested Zen 1.5.1 & 1.5.3 & PHP 5.4.30 |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.5.1 | |||||||||||||
| Added 1.3.9 compatibility. | |||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v1.5.0 | |||||||||||||
|
Functions properly running PHP 5.4 and later, Zen Cart v1.5.3 and later: - Converted to use $db for SQL actions, as preventative measure for PHP 5.5 deprecation of mysql_* functions - Converted explicit <input type="hidden" ...> to zen_draw_hidden_field calls - Converted explicit <form ...> to zen_draw_form calls - Corrected PHP warning on CSV download (file name issue) - Converted use of $_SERVER variables to zen-cart functions - Moved all language phrases to the language file - Converted to use Zen Cart rounding function - Added formatting strings for title of popup tax details title - Added configuration switch to control whether or not S/H charges are added into the store's taxed/untaxed totals - PHP 5.4-ready (remove/change ereg* calls) - Use DEFAULT_CURRENCY decimal places for number_format - Added separate columns for Gift Vouchers and Coupons; non-core Order Totals summed in "Other" column |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.4 | |||||||||||||
|
Use with Zen Cart 1.50.RC1/2 or higher. This report displays a summary of monthly or daily totals: gross income (order totals) subtotals of all orders in the selected period nontaxed sales subtotals taxed sales subtotals tax collected shipping/handling charges low order fees (if present) gift vouchers (or other addl order total component, if present) |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.3 | |||||||||||||
|
Updated compatibility issue with the drop down status menu. Thanks to barco57 for the drop down status fix. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: 1.2 | |||||||||||||
|
Fixed PHP 5.0 issues Thanks to nosnappyname for PHP 5.0 fixes. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v1.1 | |||||||||||||
| Fixed bad menu link. | |||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v1 | |||||||||||||
|
This report displays a summary of monthly or daily totals: gross income (order totals) subtotals of all orders in the selected period nontaxed sales subtotals taxed sales subtotals tax collected shipping/handling charges low order fees (if present) gift vouchers (or other addl order total component, if present) The data comes from the orders and orders_total tables, therefore this report works with Zen Cart 1.3.8a but may work with other 1.3x versions but not tested. Data is reported as of order purchase date. If an order status is chosen, the report summarizes orders with that status. The capability to "drill down" on any month to report the daily summary for that month. Report rows are initially shown in newest to oldest, top to bottom, but this order may be inverted by clicking the "Invert" control button. A popup display that lists the various types (and their subtotals) comprising the tax values in the report rows. Columns that summarize nontaxed and taxed order subtotals. The taxed column summarizes subtotals for orders in which tax was charged. The nontaxed column is the subtotal for the row less the taxed column value. A popup help display window on how to use. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v1 | |||||||||||||
|
This report displays a summary of monthly or daily totals: gross income (order totals) subtotals of all orders in the selected period nontaxed sales subtotals taxed sales subtotals tax collected shipping/handling charges low order fees (if present) gift vouchers (or other addl order total component, if present) The data comes from the orders and orders_total tables, therefore this report works with Zen Cart 1.3.8a but may work with other 1.3x versions but not tested. Data is reported as of order purchase date. If an order status is chosen, the report summarizes orders with that status. The capability to "drill down" on any month to report the daily summary for that month. Report rows are initially shown in newest to oldest, top to bottom, but this order may be inverted by clicking the "Invert" control button. A popup display that lists the various types (and their subtotals) comprising the tax values in the report rows. Columns that summarize nontaxed and taxed order subtotals. The taxed column summarizes subtotals for orders in which tax was charged. The nontaxed column is the subtotal for the row less the taxed column value. |
|||||||||||||
|
|||||||||||||
| Monthly Sales and Tax Summary Report - Version: v1 | |||||||||||||
|
This report displays a summary of monthly or daily totals: gross income (order totals) subtotals of all orders in the selected period nontaxed sales subtotals taxed sales subtotals tax collected shipping/handling charges low order fees (if present) gift vouchers (or other addl order total component, if present) The data comes from the orders and orders_total tables, therefore this report works with Zen Cart 1.3.8a but may work with other 1.3x versions but not tested. Data is reported as of order purchase date. If an order status is chosen, the report summarizes orders with that status. The capability to "drill down" on any month to report the daily summary for that month. Report rows are initially shown in newest to oldest, top to bottom, but this order may be inverted by clicking the "Invert" control button. A popup display that lists the various types (and their subtotals) comprising the tax values in the report rows. Columns that summarize nontaxed and taxed order subtotals. The taxed column summarizes subtotals for orders in which tax was charged. The nontaxed column is the subtotal for the row less the taxed column value. A popup help display window on how to use. |
|||||||||||||
|
|||||||||||||
Date Added
File Size
Encapsulated?
