Monthly Sales and Tax Summary Report

Average Rating: 5
Description
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.
+ Download Latest

Forum Support Thread

Submit An Updated Version


Github Repository
Zen Cart® Versions v1.5.7
Original Author skipwater
Last Updated by lat9 - 19 May 2022
Downloads 12,711

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.   + Download
Zen Cart® Versions v1.5.7
Date Added 19 May 2022
Author lat9
File Size 28.8 KB
PHP 5.3 Safe? No
Downloads 109
 
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.
  + Download
Zen Cart® Versions v1.5.7
Date Added 13 Apr 2022
Author lat9
File Size 28.8 KB
PHP 5.3 Safe? No
Downloads 35
 
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'!   + Download
Zen Cart® Versions v1.5.7
Date Added 9 Jan 2022
Author lat9
File Size 28.7 KB
PHP 5.3 Safe? No
Downloads 68
 
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.
  + Download
Zen Cart® Versions v1.5.7
Date Added 28 Dec 2021
Author lat9
File Size 21.7 KB
PHP 5.3 Safe? No
Downloads 26
 
Monthly Sales and Tax Summary Report   -   Version: 1.5.4
Versioning update   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 4 Dec 2016
Author mprough
File Size 22.7 KB
PHP 5.3 Safe? Yes
Downloads 891
 
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
  + Download
Zen Cart® Versions v1.3.8, v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3
Date Added 20 Oct 2014
Author mprough
File Size 23.2 KB
PHP 5.3 Safe? Yes
Downloads 1,069
 
Monthly Sales and Tax Summary Report   -   Version: 1.5.1
Added 1.3.9 compatibility.   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3
Date Added 16 Aug 2014
Author swguy
File Size 19.0 KB
PHP 5.3 Safe? Yes
Downloads 293
 
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
  + Download
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.2, v1.5.3
Date Added 23 Jul 2014
Author lat9
File Size 17.6 KB
PHP 5.3 Safe? Yes
Downloads 135
 
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)
  + Download
Zen Cart® Versions v1.5.0
Date Added 25 Nov 2011
Author skipwater
File Size 14.2 KB
PHP 5.3 Safe? Yes
Downloads 2,356
 
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.
  + Download
Zen Cart® Versions v1.3.8
Date Added 31 Aug 2008
Author skipwater
File Size 14.4 KB
PHP 5.3 Safe? Unknown
Downloads 6,301
 
Monthly Sales and Tax Summary Report   -   Version: 1.2
Fixed PHP 5.0 issues
Thanks to nosnappyname for PHP 5.0 fixes.
  + Download
Zen Cart® Versions v1.3.8
Date Added 14 Aug 2008
Author skipwater
File Size 14.1 KB
PHP 5.3 Safe? Unknown
Downloads 321
 
Monthly Sales and Tax Summary Report   -   Version: v1.1
Fixed bad menu link.   + Download
Zen Cart® Versions v1.3.8
Date Added 30 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 573
 
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.
  + Download
Zen Cart® Versions v1.3.8
Date Added 26 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 193
 
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.
  + Download
Zen Cart® Versions v1.3.8
Date Added 26 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 152
 
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.
  + Download
Zen Cart® Versions
Date Added 24 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 189
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR