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.

Forum Support Thread

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

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.  
Zen Cart® Versions v1.5.7
Date Added 19 May 2022
Author lat9
File Size 28.8 KB
PHP 5.3 Safe? No
Downloads 32
 
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.
 
Zen Cart® Versions v1.5.7
Date Added 13 Apr 2022
Author lat9
File Size 28.8 KB
PHP 5.3 Safe? No
Downloads 25
 
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'!  
Zen Cart® Versions v1.5.7
Date Added 9 Jan 2022
Author lat9
File Size 28.7 KB
PHP 5.3 Safe? No
Downloads 54
 
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.
 
Zen Cart® Versions v1.5.7
Date Added 28 Dec 2021
Author lat9
File Size 21.7 KB
PHP 5.3 Safe? No
Downloads 20
 
Monthly Sales and Tax Summary Report   -   Version: 1.5.4
Versioning update  
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 871
 
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
 
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,062
 
Monthly Sales and Tax Summary Report   -   Version: 1.5.1
Added 1.3.9 compatibility.  
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 278
 
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
 
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 125
 
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)
 
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,347
 
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.
 
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,289
 
Monthly Sales and Tax Summary Report   -   Version: 1.2
Fixed PHP 5.0 issues
Thanks to nosnappyname for PHP 5.0 fixes.
 
Zen Cart® Versions v1.3.8
Date Added 14 Aug 2008
Author skipwater
File Size 14.1 KB
PHP 5.3 Safe? Unknown
Downloads 311
 
Monthly Sales and Tax Summary Report   -   Version: v1.1
Fixed bad menu link.  
Zen Cart® Versions v1.3.8
Date Added 30 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 560
 
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.
 
Zen Cart® Versions v1.3.8
Date Added 26 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 178
 
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.
 
Zen Cart® Versions v1.3.8
Date Added 26 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 138
 
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.
 
Zen Cart® Versions
Date Added 24 Jun 2008
Author skipwater
File Size 13.9 KB
PHP 5.3 Safe? Unknown
Downloads 180
 


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