This report is for successfully processed debit and credit items in the specific date range (order date, payment date or shipment date). It includes product cost, commission and royalty amounts and shows returned revenue information to determine the gross margin dollar amount and percentage.
| Gross Margin Report Column Definitions | |
| CC Ords | Number of orders that were paid with a credit card |
| TC Ords | Number of orders that were paid with a telecheck |
| CMO Ords | Number of orders that were paid with a paper check or money order |
| TOT Ords | Number of all orders regardless or payment method |
| Auto Enrolls | Number of orders that had an autoship spawning item |
| ORD Rev | Quantity * Unit Price for debit items |
| SHIP Rev | Shipping for debit items |
| TOT Rev | Quantity * Unit Price + Shipping + Tax for debit items |
| COG | Product unit cost for debit items |
| COM Amt | Gross commission amount for debit items |
| ROY Amt | Gross royalty amount for debit items |
| TOT Amt | COM Amt + ROY Amt |
| RET | Number of orders that have a successfully processed credit item |
| RET Amt | Quantity * Unit Price + Shipping + Tax for credit items |
| GROSS MARGIN | TOT Rev - COG - COM Amt - ROY Amt - RET Amt |
| %GROSS MARGIN | GROSS MARGIN / TOT Rev |
| FILTERS | |
| Date Type | Order date, shipment date, or payment date |
| Date Range | The date range of the order or payment batch create date or shipment batch create date |
| Client | Client of the source of the order |
| GROUPING | |
| Campaign | Campaign of the source of the order |
| Client | Client of the source of the order |
| DNIS | DNIS of the source order |
| Employee | Employee who took the order |
| Fiscal Week | Fiscal week of the specific date (order date, payment date or shipment date) |
| Media Type | Media type of the order |
| Order Date | Order Date of the order |
| Order ID | Order ID of the order |
| Payment Date | Payment batch create date of the items on the order |
| Shipment Date | Shipment batch create date of the items on the order |