Sales Summary Report

The Sales Summary report enables you to generate and view various sales summary data on settled transactions by card type, clerk ID, province, device, or batch number. The data is presented as gross or net sales by merchant, chain, or superchain, if applicable. Data on the report can be grouped by day, month, or for a custom date range. This report lists funds processed in Canadian (CAD) and American (USD) currencies. 

Why use this report

Use this report to see the following:

• gross and net sales for a date range for selected accounts.

• number of purchases and refunds processed for a date range for selected accounts.

• dollar amount of purchases and refunds processed for a date range for selected accounts.

Available dates for the report

The report is able to be run for a date range of 31 days at a time. 

The Sum by all selected accounts flag

When selecting accounts (Superchain, Chain, or Merchant), the Sum by all selected accounts flag enables you to see a sum total of transactions and dollars for each card type for the selected accounts. Leaving it unchecked provides the ability to see the data in a more granular level. 

Note that when the Sum by all selected accounts box is checked:

• the “Card Type” filter is automatically selected and disabled. All other optional filters are disabled with this new filter. 

• the new views will be generated on the screen, however, the option to move, sort, or hide columns will not be available in this view. 

• the downloaded report will reflect the new totals generated on the screen in this view.

  Note:  You can choose to de-select this filter. When the Sum by all selected accounts box is left unchecked, the “Card Type” filer will be active again and merchants can generate all the other views. 
   

Grouping options

Grouping options are available at the bottom of the screen in the Group By section. The data can be grouped by:

• Date - Grouping the data by day means that you will see the data broken down day by day within the selected date range. 
• Month - Grouping the data by month means that you will see the data broken down by month within the selected date range. 
• Entire Data Range - Grouping the data for the entire date range means that you will see the aggregated totals for the selected date range. 

The checkboxes under the Optional heading enable additional columns to be visible in the data table. Leaving them unchecked means the column won't appear on the report output. 

• Card Type - breaks down the data by card type used in transactions. 

Note:  PetroTrak appears as an additional card type on the Sales Summary by Card Type report.

• Clerk ID - breaks down the data by Clerk ID used to process transactions. 
• Province - breaks down the data by province in which transactions were processed. 
• Device - breaks down the data by Moneris device on which transactions were processed. 
• Batch - breaks down the data by batch in which transactions were settled. 

Note: The Batch checkbox is dependent on the Device checkbox; if it is not checked, the Batch checkbox is greyed out. 

A note about data grouping

The Date, Month, or Entire Date Range grouping options will determine how many entries you see. The more options that are selected, the more data will be displayed on the results. The Daily, Monthly, or Entire Date Range views present summaries of sales for the selected grouping. 

Note:   The screenshot below shows the Sales Summary with the Sum by all selected accounts checkbox checked. 

How to run the report

1. From the main menu, under the Reports section, click Sales Summary. 
2. In the Sales Summary screen, under the Moneris Account section, select the accounts on which you would like to report. [note that if merchant is single, the account selector will not be visible - this will impact the grouping - merchant level can be more granular than by chain or super chain]
3. In the Date Range section, enter the date range on which you would like to report. 
4. In the Group By section, select your grouping options as described in the Grouping options section above. 
5. Click the Apply button. The report generates and appears on the screen. 
6. If necessary, you can customize the output by:

• filtering and sorting the data
• manage the columns
• export the data

Note:   If you checked the Sum by all selected accounts checkbox, the option to filter, sort, and/or move columns is disabled. The screenshot below is the Sales Summary report with the Sum by all selected accounts checkbox left unchecked. 

Available dates for the report

The report is able to be run for a date range of 366 days, up to two years in the past. 

Field and section description

Refer to the descriptions of all of the sections that are available for this report. 

Note:   Field names are listed alphabetically on this page only to assist you with quick lookup and identification. 

• Batch - This field displays the batch number to which the transactions belonged.
• Card Type - This field displays the card type associated with the processed transaction.  
• Clerk ID - This field displays the clerk ID entered by the clerk who performed the transaction. 
• Date - This field displays the date on which the transaction was processed.  
• Device - This field displays the 8-digit device ID (also known as terminal ID) on which the transaction was processed. 
• Merchant - This field displays the unique 13-digit Moneris merchant ID that processed the transaction. 
• Net Total - This field shows the net dollar total (before taxes) of the transaction.  
• Purchase Amount - This field displays the total dollar amount of the purchase transaction. 
• Purchase Count - This field shows the number of items purchased by the cardholder for the transaction. 
• Real Time Fund Amount - This field shows the amount leveraged in the Moneris Real Time Funds transaction. 
• Real Time Fund Count - This field shows the number (quantity) of Moneris Real Time Funds transactions within the specified date range. 
• Refund Amount - This field displays the total dollar amount of the refund transaction. 
• Refund Count - This field shows the number of items being refunded for the transaction.