Skip to main content

How To EM Tender Reports


Introduction

The Enactor application provides a range of Tender Reports to support operational insight into tender-related activities. These reports are accessed through the Estate Manager or Store Server and cover card transactions, credit note balances, gift card balances, and tender totals.

The purpose of this guide is to demonstrate how to navigate to, filter, and interpret each of the Tender Reports available in the Estate Manager.


Overview

The following Tender Reports are covered in this guide:

  1. Card Transactions Report - Details of card transactions including acquirer, card entry method, and values
  2. Credit Note Outstanding Balances - Summary of credit notes by status with outstanding balance totals
  3. Gift Card Outstanding Balances Report - Outstanding balances for gift cards by type and account
  4. Tender Totals Pie Chart Report - Graphical representation of tender usage with quantity and value breakdown
  5. Tender Totals Report - Comprehensive tender usage totals with optional card type, card entry, and user breakdowns

Navigate to the Tender Reports using the Search or the path: Reports > Tender Reports

info

To generate tender reports, the basic configurations must be in place. Different tender types must be configured and transactions must have been completed using those tenders.


Tender Reports

Card Transactions Report

The Card Transactions Report provides details regarding card transactions conducted within the Enactor application for associated locations in the Estate Manager. This report allows users to access a summary of these transactions and offers the option to retrieve specific card information for further insight.

Navigate to the Card Transactions Report using the Search or the path: Reports > Tender Reports > Card Transaction Report

info

The POS connected to the Estate Manager must have transactions completed using card tenders for this report to return data.

Filter Criteria

Use the filter criteria to narrow the reporting data before generating the report.

Card Transactions filter screen with Region set to 'United Kingdom', Location to 'UK Hertford', Terminal to 'pos5@0001-Hertford React(SCO)', and Acquirer to 'WorldPay Saas Test UK'.
Select the filter criteria for the Card Transactions report. Set Region, Location, and Terminal to narrow results to a specific POS. Use Min Value and Max Value to filter by transaction amount, and Date Range to specify the reporting period.
Filter CriteriaDescription
RegionDropdown list selection of defined Regions in the Enactor application.
LocationDropdown list selection of defined Locations in the selected Region. If no Region is specified, all Locations are shown.
TerminalDropdown selection from a list of all Terminals at the selected Location. If no Location is specified, all Terminals are shown.
AcquirerDropdown list selection of defined Acquirers.
UserDropdown list selection of defined Users at the selected Location. If no Location is specified, all Users are shown.
CustomerDropdown list selection of defined Customers.
Card NumberThe PAN of the card. Must be a numeric value between 9 and 22 digits.
Min Card Usage CountThe minimum number of times the card has been used.
Min ValueThe minimum card tender value in the transaction.
Max ValueThe maximum card tender value in the transaction.
Min Transaction NumberThe transaction number from which the information is required.
Max Transaction NumberThe transaction number to which the information is required.
Sales/ReturnsFilter by sale or return transactions. Sales Only retrieves sale transactions tendered by card. Returns Only retrieves returned transactions tendered by card. If no value is specified, both sales and returns are displayed.
Date RangeThe date range in which the transactions took place.

Press Back to return to the previous screen. Press Next to create a scheduled job to run the report.

Wait For Report

When a report is submitted, the system displays a progress screen indicating the report is in a queue. Several self-explanatory messages can appear at this point with options to Cancel, Don't Wait, or Refresh.

Wait For Report screen showing queue message with Cancel, Don't Wait, and Refresh buttons.

The Wait For Report screen displays the report queue status. Select Cancel to cancel the report job, Don't Wait to continue working while the report generates, or Refresh if the report is taking a long time to display.
ButtonDescription
CancelCancels the report job.
Don't WaitAllows the user to continue working. The report will be available from saved reports when complete.
RefreshRefreshes the report status if it seems to be taking a long time to display.

Report Summary

Once the report has been generated, the summary screen displays the filter criteria in the header and the transaction details below.

Card Transactions report summary showing two Mastercard ICC transactions at Location 0001, Terminal 5, with values of 4.95 and 420.00 in GBP.
The report summary displays all card transactions matching the filter criteria. Each row shows the Location, Terminal, Acquirer, Card Entry Method, transaction number, date/time, customer details, value, and card information. Use the toolbar to Print, View PDF, Save XLS, or Save DOC.
Report ColumnDescription
LocationThe defined location from the filter criteria. If no location was selected, all locations associated with the Estate Manager are displayed.
TerminalThe terminal number where the card transaction took place.
AcquirerThe acquirer used to perform the card transaction.
Card Entry MethodThe card input method: ICC (contactless/chip), MSR (magnetic stripe/swiped), KEYED (manually keyed), CNP (cardholder not present), or COF (card on file).
Trans NumThe transaction number that included the card transaction.
Date/TimeThe date and time the card transaction was placed.
Customer IDThe customer ID associated with the card transaction. Blank if no customer is associated.
Customer SurnameThe customer surname associated with the card transaction. Blank if no customer is associated.
ValueThe value of the card transaction.
Foreign ValueThe value of the card transaction in a foreign currency.
Foreign CurrencyThe foreign currency ID for the card transaction.
Mangled Card NumberThe PAN of the card with only the last four digits displayed. All other digits are shown as asterisks.
Card TypeThe card type used in the transaction.
Merchant IDThe merchant ID used to authorise the card transaction.

This completes the Card Transactions Report.


Credit Note Outstanding Balances

The Credit Note Outstanding Balances report provides a summary of credit notes generated and tracked within the Enactor application for a specified date range. This report categorises information primarily by Credit Note Status and allows users to access specific credit note details using the serial number.

Navigate to the Credit Note Outstanding Balances Report using the Search or the path: Reports > Tender Reports > Credit Note Outstanding Balances Report

info

Credit notes must exist in the Enactor application for this report to return data. Credit notes can be created in the Credit Notes Maintenance screen in the Estate Manager or via the POS application.

Filter Criteria

Credit Note Outstanding Balances filter screen with Status set to 'Active' and date ranges from February 2022 to February 2025.
Select the filter criteria for the Credit Note Outstanding Balances report. Set Status to filter by credit note status (Active, Expired, Closed, or Voided). Use the date range fields to narrow results by expiry, creation, or closure dates.
Filter CriteriaDescription
StatusThe status of the credit note. Active - the credit note can be redeemed. Expired - the credit note has passed its expiry date and cannot be redeemed. Closed - the credit note has been fully redeemed. Voided - the credit note was partially redeemed but the transaction was not completed.
Start expiry dateThe expiry date from which the credit note information is required.
End expiry dateThe expiry date to which the credit note information is required.
Start date createdThe creation date from which the credit note information is required.
End date createdThe creation date to which the credit note information is required.
Start date closedThe closure date from which the credit note information is required.
End date closedThe closure date to which the credit note information is required.

Press Back to return to the previous screen. Press Next to create a scheduled job to run the report.

Wait For Report

When a report is submitted, the system displays a progress screen indicating the report is in a queue. Several self-explanatory messages can appear at this point with options to Cancel, Don't Wait, or Refresh.

Wait For Report screen showing queue message with Cancel, Don't Wait, and Refresh buttons.

The Wait For Report screen displays the report queue status. Select Cancel to cancel the report job, Don't Wait to continue working while the report generates, or Refresh if the report is taking a long time to display.
ButtonDescription
CancelCancels the report job.
Don't WaitAllows the user to continue working. The report will be available from saved reports when complete.
RefreshRefreshes the report status if it seems to be taking a long time to display.

Report Summary

Credit Note Outstanding Balances report summary showing seven Active credit notes with serial numbers, creation dates, expiry dates, and amounts totalling -1,575.99.
The report summary lists all credit notes matching the filter criteria, grouped by Status. Each row shows the Serial Number, Date Created, Date Closed, Expiry Date, and Amount. The Grand Total shows the overall outstanding balance.
Report ColumnDescription
StatusThe status of the credit notes displayed. If no status was selected in the filter, all statuses are shown.
Serial NumberThe unique serial number identifying the credit note.
Date CreatedThe creation date of the credit note.
Date ClosedThe closure date of the credit note.
Expiry DateThe expiry date of the credit note.
AmountThe amount value of the credit note.
Grand TotalThe total outstanding value held under credit notes. Expired or closed credit notes are reflected as negative values. Only active, non-expired, non-voided credit notes contribute a positive value to the total.

This completes the Credit Note Outstanding Balances report.


Gift Card Outstanding Balances Report

The Gift Card Outstanding Balances report provides details regarding the outstanding balance of gift cards recorded in the Enactor application. This report is organised by the latest transactions made for gift cards and their cumulative totals. It provides an overall summary of gift card account balances within the chosen date range.

Navigate to the Gift Card Outstanding Balances Report using the Search or the path: Reports > Tender Reports > Gift Card Outstanding Balance Report

info

Gift cards must exist in the Enactor application and must have transactions (created, topped up, redeemed, or cancelled) for this report to return data. Gift card operations can be performed via the POS or Estate Manager.

Filter Criteria

Gift Card Outstanding Balances filter screen with Location set to 'UK Hertford', Gift Card Type set to 'Gift Card UK', and Last Transaction Date in February 2024.
Select the filter criteria for the Gift Card Outstanding Balances report. Set Location and Gift Card Type to narrow results, and use Last Transaction Date to specify the reporting period.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Gift Card TypeDropdown list selection of defined Gift Card Types.
Last Transaction DateThe date criteria for the last transaction made using the gift cards.

Press Back to return to the previous screen. Press Next to create a scheduled job to run the report.

Wait For Report

When a report is submitted, the system displays a progress screen indicating the report is in a queue. Several self-explanatory messages can appear at this point with options to Cancel, Don't Wait, or Refresh.

Wait For Report screen showing queue message with Cancel, Don't Wait, and Refresh buttons.

The Wait For Report screen displays the report queue status. Select Cancel to cancel the report job, Don't Wait to continue working while the report generates, or Refresh if the report is taking a long time to display.
ButtonDescription
CancelCancels the report job.
Don't WaitAllows the user to continue working. The report will be available from saved reports when complete.
RefreshRefreshes the report status if it seems to be taking a long time to display.

Report Summary

Gift Card Outstanding Balances report summary showing four GC_UK gift cards with account IDs and balances, one with a balance of 620.00.
The report summary lists all gift cards matching the filter criteria, grouped by Gift Card Type. Each row shows the Last Transaction date and time, Account ID, and current Account Balance.
Report ColumnDescription
Gift Card TypeThe gift card type from the filter criteria. If no type was selected, all gift card types are displayed.
Last TransactionThe date and time of the last transaction made with the gift card.
Account IDThe account ID of the gift card.
Account BalanceThe current account balance of the gift card.

This completes the Gift Card Outstanding Balances report.


Tender Totals Pie Chart Report

The Tender Totals Pie Chart report offers a graphical representation of tender transactions, providing users with an overview of the various tenders utilised. This report presents the total count of transactions for each tender type with a pie chart illustrating the distribution and a numerical summary below.

Navigate to the Tender Totals Pie Chart Report using the Search or the path: Reports > Tender Reports > Tender Totals Pie Chart Report

info

The POS must have completed transactions with various tender types for this report to return data.

Filter Criteria

Tender Totals Pie Chart filter screen with Region set to 'United Kingdom', Location to 'UK Hertford', Minimum Value to '1.00', and User to 'Hertford Manager, 000101'.
Select the filter criteria for the Tender Totals Pie Chart report. Set Region, Location, and Terminal to narrow results. Use Minimum Value to exclude low-value transactions and Date Range to specify the reporting period.
Filter CriteriaDescription
RegionDropdown list selection of defined Regions in the Enactor application.
LocationDropdown list selection of defined Locations in the selected Region. If no Region is specified, all Locations are shown.
TerminalDropdown selection from a list of all Terminals at the selected Location. If no Location is specified, all Terminals are shown.
Minimum ValueThe minimum value of the tender to be included in the report.
UserDropdown selection from a list of all Users at the selected Location. If no Location is specified, all Users are shown.
CustomerDropdown list selection of defined Customers.
Date RangeThe date range in which the transactions took place.

Press Back to return to the previous screen. Press Next to create a scheduled job to run the report.

Wait For Report

When a report is submitted, the system displays a progress screen indicating the report is in a queue. Several self-explanatory messages can appear at this point with options to Cancel, Don't Wait, or Refresh.

Wait For Report screen showing queue message with Cancel, Don't Wait, and Refresh buttons.

The Wait For Report screen displays the report queue status. Select Cancel to cancel the report job, Don't Wait to continue working while the report generates, or Refresh if the report is taking a long time to display.
ButtonDescription
CancelCancels the report job.
Don't WaitAllows the user to continue working. The report will be available from saved reports when complete.
RefreshRefreshes the report status if it seems to be taking a long time to display.

Report Summary

Tender Totals Pie Chart report showing a pie chart dominated by Cash (148 transactions, 68,438.11) with nine tender types and a grand total of 205 transactions worth 75,973.10.
The report summary shows a pie chart illustrating the distribution of tender types and a summary table below with quantity and value for each tender. Cash dominates with 148 transactions. Use the toolbar to Print, View PDF, Save XLS, or Save DOC.
Report ColumnDescription
TenderThe description of the tender type used to complete transactions.
QuantityThe number of times the tender was used for the specified criteria.
ValueThe total value of the tender in base currency for the specified criteria. A grand total is shown at the bottom of each column.

This completes the Tender Totals Pie Chart report.


Tender Totals Report

The Tender Totals report provides an overview of tenders used for transactions, offering users a comprehensive count of transactions for each tender type. This report includes optional breakdowns by card type, card entry method, and user.

Navigate to the Tender Totals Report using the Search or the path: Reports > Tender Reports > Tender Totals Report

info

The POS must have completed transactions with various tender types for this report to return data.

Filter Criteria

Tender Totals filter screen with Region set to 'United Kingdom', Location to 'UK Hertford', Terminal to 'pos1@0001-Hertford (PageDef)', and Show Card Types, Show Card Entry, and Show User all set to 'No'.
Select the filter criteria for the Tender Totals report. Set Region, Location, and Terminal to narrow results. Use Show Card Types, Show Card Entry, and Show User to include additional breakdown columns in the report output.
Filter CriteriaDescription
RegionDropdown list selection of defined Regions in the Enactor application.
LocationDropdown list selection of defined Locations in the selected Region. If no Region is specified, all Locations are shown.
TerminalDropdown selection from a list of all Terminals at the selected Location. If no Location is specified, all Terminals are shown.
Minimum ValueThe minimum value of the tender to be included in the report.
UserDropdown selection from a list of all Users at the selected Location. If no Location is specified, all Users are shown.
CustomerDropdown list selection of defined Customers.
Date RangeThe date range in which the transactions took place.
Show Card TypesWhen set to Yes, an additional column displays the card type details for card transactions. When set to No, card type details are hidden.
Show Card EntryWhen set to Yes, an additional column displays the card entry method for card transactions. When set to No, card entry details are hidden.
Show UserWhen set to Yes, an additional column displays the user details for each tender method. When set to No, user details are hidden.

Press Back to return to the previous screen. Press Next to create a scheduled job to run the report.

Wait For Report

When a report is submitted, the system displays a progress screen indicating the report is in a queue. Several self-explanatory messages can appear at this point with options to Cancel, Don't Wait, or Refresh.

Wait For Report screen showing queue message with Cancel, Don't Wait, and Refresh buttons.

The Wait For Report screen displays the report queue status. Select Cancel to cancel the report job, Don't Wait to continue working while the report generates, or Refresh if the report is taking a long time to display.
ButtonDescription
CancelCancels the report job.
Don't WaitAllows the user to continue working. The report will be available from saved reports when complete.
RefreshRefreshes the report status if it seems to be taking a long time to display.

Report Summary

Tender Totals report summary showing multiple users and tender types with Card Type, Card Entry, Quantity, Foreign Value, Rounding, and Value columns. Grand total is 978 transactions worth 663,108.83.
The report summary displays all tender transactions matching the filter criteria with optional User, Card Type, and Card Entry columns enabled. Each row shows the Quantity of transactions, Foreign Value (if applicable), Rounding, and total Value. Use the toolbar to Print, View PDF, Save XLS, or Save DOC.
Report ColumnDescription
UserThe user who completed the transactions (shown when Show User is enabled).
TenderThe description of the tender type used to complete transactions.
Card TypeThe card type used in the transaction (shown when Show Card Types is enabled).
Card EntryThe card entry method used in the transaction (shown when Show Card Entry is enabled).
QuantityThe number of times the tender was used for the specified criteria.
Currency IDThe currency identifier for foreign currency transactions.
Foreign ValueThe value of the transaction in a foreign currency.
RoundingAny rounding applied to the transaction value.
ValueThe total value of the tender in base currency for the specified criteria. A grand total is shown at the bottom of each column.

This completes the Tender Totals report.