Skip to main content

How-to Guide - Operation Reports - EM - Cash Management

Introduction

The Enactor application generates numerous types of reports to support different business purposes. This guide covers the Cash Management reports that are accessed through the Estate Manager or the Store Server.

The purpose of this guide is to describe each of the Cash Management reports, including how to navigate to them, the available filter criteria, and the report output columns.


Overview

The following Cash Management reports are covered by this guide:

  1. Banking Transactions - Safe banking and currency purchase transactions
  2. Cash On Hand - Cash declared by each terminal, broken down by tender type
  3. Cash Up Summary - Summary of cash-up session values per terminal or safe
  4. Income Expense Transactions - Income and expenses recorded in cash management sessions
  5. Outlay Transactions - Outlay transactions including balanced, unbalanced, and expenses without outlay
  6. Overview Report - Terminal and safe status summary with cash drawer and cashup data
  7. Tender Bag Collection - Bags selected and sent to bank
  8. Terminal Discrepancies - Discrepancy values recorded during terminal cashup or finalise
  9. Safe Discrepancies - Discrepancy values recorded during safe cashup or finalise

Navigate to the Cash Management reports using the Search or the path: Reports > Cash Management Reports

Prerequisite

To generate Cash Management reports, the basic cash management configurations must be in place. For guidance on these configurations, refer to the How-to Guide on the Day in the Life of Cash Management. These configurations must be active to start the cash management functions that generate data for the reports.


Cash Management Reports

Banking Transactions Report

The Banking Transactions Report is a report related to safe operations that provides an overall summary of banking transactions conducted from a safe within a selected date period. This report focuses on Cash Management function data such as Banking and Currency Purchase.

Navigate to the Banking Transaction Report using the Search or the path: Reports > Cash Management Reports > Banking Transaction Report

Prerequisite: To populate the data in the Banking Transaction report, the first step is to create a cash management session in the Safe where Banking and Currency Purchase transactions have been performed.

Filter

There are the following filters that help to filter the reporting data.

Banking Transactions filter screen with Location, Safe, Date From, and Date To fields.

Set the filter criteria to generate the Banking Transactions report. Select a Location and Safe, then set the Date From and Date To range. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
SafeDropdown list selection of defined Safes at the Location specified in the previous field. If no Location is specified all Safes are shown.
Date FromThe From Date which the report needs to be Generated From.
Date ToThe To Date which the report needs to be Generated To.

The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Banking Transactions report summary showing operations, tenders, values, and totals for the selected safe and date range.

The report summary displays all banking transactions for the selected criteria. The Operation column shows either Purchase (Currency Purchase) or Bank (Banking). Totals are shown per safe and per location.
Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
SafeThe selected defined Safes at the Location specified in the Filter Criteria screen will be displayed. If no Safes is specified all Safes associated with the locations are shown.
OperationThe Cash Management operation type that was taken place. This would be either a Currency Purchase or Banking. The Currency Purchase is indicated as Purchase, and the Banking action is indicated as Bank in the report summary.
UserThe User ID who has done the Cash Management transaction.
Date/TimeThe date and time at which the operation was performed.
Banking BagWhen the Banking cash management transaction is associated with a Banking Bag then the Bag id will be displayed.
Banking SlipWhen a Banking function is done for the reference purpose the user is required to add the Banking slip details. The Slip details will be presented in the report.
Bag NumberWhen the cash management transaction is associated with a Bag then the Bag id will be displayed.
TenderThe Type of Tender that was used in the cash management transaction.
ValueThe value of the Tender.
Base ValueThe total value of the tender in base currency for the specified criteria. This is mostly used when there are any foreign currencies associated with the Cash Management function.
Safe TotalThe grand totals for the safe are shown at the bottom of the page.
Location TotalThe grand totals for the location are shown at the bottom of the page.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Banking Transactions Report.


Cash On Hand Report

The Cash On Hand report provides information on the cash declared by each terminal associated with a specific location. This report offers a detailed breakdown by tender types used, providing a clear picture of the cash holdings for that location.

Navigate to the Cash On Hand Report using the Search or the path: Reports > Cash Management Reports > Cash On Hand Report

Prerequisite: To populate the data in the Cash On Hand report there should be a cash management session created in the terminal and once all the transactions are done the terminal user needs to mark the session as Cash Up. To do this the Cashup and Empty, Cash Up and Leave, or Cashup and closing float functions can be used.

Filter

There are the following filters that help to filter the reporting data.

Cash On Hand filter screen with Location and Date fields.

Set the filter criteria for the Cash On Hand report. Select a Location and the Date at which information is required. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
DateThe date and time at which the information is required. It defaults to the current date and time.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Cash On Hand report summary showing terminals, tender types, and cash values for the selected location.

The report summary displays all terminals at the selected location with declared cash values broken down by tender type. Total and Grand Total values are shown at the bottom.
Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
TerminalThe Terminal ID that is associated to the Location. The terminals which have performed Cash Up functions within the date criteria will be displayed.
Tender TypesThe list of applicable tender types for the selected location will be presented. The tender values will be the values which were declared while doing a Cashup.
TotalTotal value against each terminal.
Grand TotalThe Grand Total value against all terminal and tender types.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Cash On Hand Report.


CashUp Summary Report

The CashUp Summary report is a standard report used to obtain a summary of the cashup values in the Terminal or Safe. This report provides details of the cash-up summary, indicating the value of each cash management function that occurred within the cash-up session. The report summarises functions such as Opening Float, Float request, Takings, Float, Pickup, and Closing Float. After the cash-up is completed on the selected Terminal or Safe, any discrepancies will also be displayed in the report.

Navigate to the Cashup Summary Report using the Search or the path: Reports > Cash Management Reports > Cashup Summary Report

Prerequisite: To generate the CashUp Summary report, the first step is to perform a cash-up session in a Safe or Terminal. This can be done using functions such as Cashup and Empty, Cash Up and Leave, Cashup and closing float, Cashup, or Cashup and Banking.

Filter

There are the following filters that help to filter the reporting data.

CashUp Summary filter screen with Location, Terminal Type, Terminal, and Date fields.

Set the filter criteria for the CashUp Summary report. Select a Location, Terminal Type, and Terminal, then set the Date. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Terminal TypeSince this report is common throughout the Safe and Terminal cash management the type must be selected. The terminal type has the value Terminal, Paypoint, Safe and Cashier. This is declared in the Location maintenance for each location to ease the process.
TerminalAccording to the above fields selection the respective Terminal / Paypoint / Safe / Cashier is displayed which is associated to the selected location.
DateThe date and time at which the information is required to. It defaults to the current date and time.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

CashUp Summary report showing tender values for Opening Float, Takings, Pickup, Float, Closing Float, Expected, Declared, and Discrepancy.

The report summary displays the cash-up session values for the selected terminal. Each column represents a cash management function. The Discrepancy column shows the difference between Expected and Declared values.
Report Column CriteriaDescription
TenderThe Tender type which the Cash Management functions has been done with will be displayed.
Opening FloatIf there are any Opening float functions that have been done within the session that have been cash up then the Tender in which the Opening Float was done and the value will be displayed. This will be a Positive value since money has been added to the Terminal.
Float RequestIf there are any Float Request functions that have been done with in the session that has been cash up then the Tender which the Float Request was done and the value will be displayed.
TakingsThe Sale amount which has been received within the cashup session will be displayed in the column. This will have the accumulative value of the total sales - Return Value.
PickupIf any Pick up functions have been done within the session that have been cash up then the Tender in which the Pickup was done and the value will be displayed. This will be a Negative value since money has been taken from the Terminal and added to the Safe.
FloatIf any float functions have been done within the session that have been cash up then the Tender in which the Opening Float was done and the value will be displayed. This will be a Positive value since money has been added to the Terminal.
Closing FloatIf any Closing float functions have been done within the session that have been cash up then the Tender in which the Closing Float was done and the value will be displayed.
ExpectedThe expected total value (systematic value) of the tender has been done on sales return and other cash flow functions.
DeclaredThe total amount that has been recorded by the user.
DiscrepancyThe inconsistency between the Expected value and the Declared value (Declared value - Expected value). This can be either a positive or a negative value according to the values given while doing the Cash up or Finalise.
Grand Total against FunctionsThe total value against each Functions will be displayed.
TotalThe total value against each Tender type will be displayed.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the CashUp Summary Report.


Income Expense Transactions

The Income Expense Transactions report can be generated for either a Safe or a Terminal. This report details the income and expenses recorded in cash management sessions.

Navigate to the Income Expense Report using the Search or the path: Reports > Cash Management Reports > Income Expense Report

Prerequisite: To generate this report, Cash Management sessions need to include functions for both Income and Expenses. These functions can be done on either a Terminal or a Safe.

Filter

There are the following filters that help to filter the reporting data.

Income Expense Transactions filter screen with Location, User, Safe/Terminal, Reason, and Date Range fields.

Set the filter criteria for the Income Expense Transactions report. Select a Location, User, Safe / Terminal, Reason, and Date Range. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
UserDropdown list selection of defined Users at the Location specified in the previous field. If no Location is specified all Users configured are shown.
Safe / TerminalDropdown selection from a list of all Safes and Terminals at the Location specified in a previous field. If no Location is specified all Safes and Terminals configured are shown.
ReasonDropdown list selection of defined Income and Expense Reasons.
Date RangeThe start and end period in which the reports needs to be generated.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Income Expense Transactions report showing operations, users, reasons, tender types, and values.

The report summary displays income and expense transactions. The Operation column shows either Terminal Expense or Terminal Income. Totals are shown per terminal/safe and per location.
Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
Terminal / SafeThe Defined Terminal / Safe on the filter criteria.
OperationThis value will be either Terminal Expense or Terminal Income according to the action taken placed in the cash management session for the selected Terminal or Safe.
UserThe Store user who has done the Income or the Expenses in the terminal or safe.
Auth UserThe name of the User who authorised the action if applicable.
ReasonsThe reason for the Income or the Expense transactions.
Date/TimeThe date and time at which the action was performed.
TenderThe type of tender used for the Income or the Expenses transactions.
ValueThe Total value of the tender used for the Income or the Expenses transactions.
Grand Total for TerminalThe Accumulated total value of the income/expense transaction for the terminal/safe. The Income will be a positive value whereas the expense will be a negative value.
Grand Total for LocationThe Accumulated total value of the income/expense transaction for the location. The Income will be a positive value whereas the expense will be a negative value.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Income Expense Transactions Report.


Outlay Transactions Report

The Outlay Transactions report summarises the outlay transactions that have been selected from either the Safe or a terminal. Outlay transactions involve withdrawing money from the Safe or terminal before expenses are encountered. Subsequently, expenses must be recorded, and this process allows for the return of change to the original outlay. For more detailed information about outlays, refer to the How-to Guide on Outlays.

The report is divided into three sections:

  • Unbalanced Outlays - Records related to outlay expenses that are unbalanced in the cash management session. This includes cases where the expenses did not return any change or where there are discrepancies between the expenses and the change returned in the transactions.
  • Balanced Outlays - If there are records related to balanced outlay expenses in the cash management session, a record will be added to this section. This section will include a record where the expenses and the changes that have been submitted are tallied and matched.
  • Expenses without Outlay - If there are expenses that have not been recorded as outlay expenses, they will be listed in this section.

Navigate to the Outlay Transactions Report using the Search or the path: Reports > Cash Management Reports > Outlay Transactions Report

Prerequisite: To generate this report, the cash management session must include balanced and unbalanced outlays, as well as expenses that do not have any corresponding outlay records.

Filter

There are the following filters that help to filter the reporting data.

Outlay Transactions filter screen with Location, Date Range, and three Hide section toggle fields.

Set the filter criteria for the Outlay Transactions report. Use the Hide Unbalanced, Hide Balanced, and Hide Expenses without Outlay fields to control which report sections are displayed. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Date RangeThe start and end period in which the reports need to be generated.
Hide UnbalancedControls the Unbalanced section in the report. When set to No, the Unbalanced section will be displayed.
Hide BalancedControls the Balanced section in the report. When set to No, the Balanced section will be displayed.
Hide Expenses without OutlayControls the Expenses without Outlay section in the report. When set to No, the Expenses without Outlay section will be displayed.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Outlay Transactions report showing three sections: Unbalanced, Balanced, and Expense without Outlay with transaction details.

The report summary displays three sections. The Unbalanced section shows outlays where expenses did not match. The Balanced section shows matched outlay/expense records. The Expense without Outlay section shows standalone expenses.

Unbalanced Section (displayed when the Filter screen Hide Unbalanced field is selected as No):

Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
ReasonThe Outlay Reason which was selected when the Outlay request was created.
Outlay RecipientThe user who has performed the Outlay request will be displayed.
Outlay Date TimeThe Date and the time at which the outlay has been completed.
Outlay ValueThe Value of the Outlay Expense is done.

Balanced Section (displayed when the Filter screen Hide balanced field is selected as No):

Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
ReasonThe Outlay Reason which was selected when the Outlay request was created.
Outlay RecipientThe user who has performed the Outlay request will be displayed.
Outlay Date TimeThe Date and the time at which the outlay has been completed.
Outlay ValueThe Value of the Outlay Expense done.
Outlay Return Date TimeThe Date and time when the change was submitted.
ValueThe Value of the change for the Outlay Expense is done.

Expense without Outlay Section (displayed when the Filter screen Hide Expense without Outlay field is selected as No):

Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
ReasonThe Reason which was selected when the expense was created.
UserThe user details who have done the Expense transaction.
Date TimeThe Date and the time at which the Expense was done.
ValueThe Value of the Expense is done.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Outlay Transactions Report.


Overview Report

The Overview Report is a standard report for the Safe and Terminal. It provides a summary of the Safe or Terminal status based on the selected date in the criteria. It shows the amount in the Cash Drawer and whether there have been any cashup functions happening on the selected dates.

Navigate to the Overview Report using the Search or the path: Reports > Cash Management Reports > Overview Report

Prerequisite: To generate the Overview Report, Cash Management sessions must include specific functions that can be performed on either a Terminal or a Safe.

Filter

There are the following filters that help to filter the reporting data.

Overview Report filter screen with Location, Owner Type, Start Date Time, and End Date Time fields.

Set the filter criteria for the Overview Report. Select a Location, Owner Type, and the Start Date Time and End Date Time range. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Owner TypeThe Owner type can be either Safe, Terminal, or Paypoint. This value is the method of cash management declaration in location maintenance. If no values are selected, the report will include values for all owner types at the respective locations.
Start Date TimeThe From Date which the report needs to be Generated From.
End Date TimeThe To Date which the report needs to be Generated To.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Overview Report showing terminal and safe sections with drawer values, cashup amounts, and discrepancies.

The report is divided into two sections: one for Terminal-related data and one for Safe-related data. Each section shows the amount staying in the drawer or safe, amounts cashed up or banked, and any discrepancies.

The report is divided into two sections, one for Terminal-related data and the other for Safe-related data.

Terminal Section:

Report Column CriteriaDescription
TerminalThe Terminal associated with the selected locations will be listed.
TenderThe tender type which has been used in the cash management transactions has been listed.
Stay in DrawerThe total amount of the tender which is there currently on the drawer will be displayed.
CashUpThe Total amount which has been Cashup and sent the Safe will be displayed.
DiscrepancyIf there is a difference between the expected amount to be cashed up and the actual amount cashed up, the Discrepancy amount will be updated to reflect this difference.

Safe Section:

Report Column CriteriaDescription
SafeThe Safe associated to the selected locations will be listed.
TenderThe tender type which has been used in the cash management transactions are being listed.
Stay in DrawerThe total amount of the tender which is there currently in the drawer will be displayed.
CashUpThe Total amount which has been Cashup and sent to bank will be displayed.
DiscrepancyIf there is a difference between the expected amount to be cashed up and the actual amount cashed up, the Discrepancy amount will be updated to reflect this difference.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Overview Report.


Tender Bag Collection

The Tender Bag Collection report provides a summary of the bags that have been selected and sent to the bank. The data will be populated when the user uses the Bag functions to complete a Safe Banking function along with completing the Safe Bag Collection functionality. Compared to the other reports this is a printed report produced when the collection function was done.

Navigate to the Tender Bag Collection using the Search or the path: Reports > Cash Management Reports > Tender Bag Collection

Prerequisite: The location must be set up to handle Tender Bags. This setup will be done in Location Maintenance. To include a record in the report for Safe, the user must create banking bags and bank them using the Safe Banking function, then the Bag which has been Banked needs to go through the Safe Bag Collection Process as well.

Filter

There are the following filters that help to filter the reporting data.

Tender Bag Collection filter screen with Location, Safe, and Date Range fields.

Set the filter criteria for the Tender Bag Collection report. Select a Location, Safe, and Date Range. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
SafeDropdown selection from a list of all Safes at the Location specified in a previous field. If no Location is specified all Safes configured are shown.
Date RangeThe start and end period in which the reports need to be generated when the Cashup or finalised sessions are being performed.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Tender Bag Collection report showing bag numbers, collection dates, values, and signature fields.

The report summary shows each collected tender bag with its number, collection date, and value. The Signature and Second Signature fields are used to record the bag collection and authorisation.
Report Column CriteriaDescription
Tender Bag NumberThe Bag number was given when creating the Banking bag. This is the reference number that differentiates the Bags with each other.
Date Time CollectedThe Date and Time the Banking Bag has been collected and sent to the Bank.
ValueThe Amount which was held in the Banking Bag.
Additional BagThese are fields that the user can add additional information of the bags that has been sent to the bank. This field is something that is not prepopulated with data where it is a manual field.
SignatureThe signature field that will be used by the user to add the signature of the user who has collected the bag for banking from the store.
Second SignatureThe Second signature field will be used by an authorised user to add the signature of the user who has confirmed that the bag has been sent for banking from the store.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Tender Bag Collection Report.


Terminal Discrepancies

The Terminal Discrepancies report indicates the discrepancy values that have been recorded in each cashup session or on the finalised session on the selective terminals. This report is generated for the Terminal specifically since the session owner in this report will be listed according to the Location's Cash Management method whether it is a Pay point, Terminal, or a cashier.

Navigate to the Terminal Discrepancies Report using the Search or the path: Reports > Cash Management Reports > Terminal Discrepancies Report

Prerequisite: The records will be populated for the report when an open session has been marked as Cash up or a Cash up session to Finalise in the terminal with discrepancy values.

Filter

There are the following filters that help to filter the reporting data.

Terminal Discrepancies filter screen with Location, Date Range, Session Owner, Minimum Discrepancy Threshold, and Transaction Type fields.

Set the filter criteria for the Terminal Discrepancies report. Optionally set a Minimum Discrepancy Threshold to only show terminals with discrepancies above a specific value. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Date RangeThe start and end period in which the reports need to be generated when the Cashup or finalised sessions are being performed.
Session OwnerThis report is generated for the Terminal specifically since the session owner in this report will be listed according to the Location's cash Management method whether it is a Pay point, Terminal, or a cashier.
Minimum Discrepancy ThresholdIf there is a specific need to give a minimum value of discrepancy, then the user would be able to add the value in the filter criteria so that the report will be generated to the value above the Threshold.
Transaction TypeThis is the cash management transaction type that must be selected. The only cash management transaction type associated with discrepancy is when a terminal has been cashed up or the sessions have been finalised. The values in the criteria would be either Terminal Cashup and Empty or Terminal Finalised.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Terminal Discrepancies report showing terminals with date, tender type, expected, declared, and discrepancy values.

The report summary displays discrepancy values for each terminal. The Discrepancy column shows the difference between Expected and Declared values (Declared - Expected). Terminals with no discrepancy or below the chosen threshold are noted at the bottom.
Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
TerminalThe session owner selected in the Filter screen will be displayed. Usually, the session owner is the same as the terminal ID. If a location is selected in the Filter screen but the session owner field is not specified, then all terminals associated with that location that have discrepancies during cashup or finalise will be listed.
Date TimeThe date and time at which the cashup or finalise was performed and had discrepancies.
TenderThe type of tender that has the discrepancies while the cashup or finalise was performed.
ExpectedThe expected total value (systematic value) of the tender has been done on sales return and other cash flow functions.
DeclaredThe total amount that has been recorded by the user.
DiscrepancyThe inconsistency between the Expected value and the Declared value (Declared value - Expected value). This can be either a positive or a negative value according to the values given while doing the Cash up or Finalise.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Terminal Discrepancies Report.


Safe Discrepancies

The Safe Discrepancies report is similar to the Terminal Discrepancies report. It indicates the discrepancy values that have been recorded in each cashup session or on the finalised session on the selective Safes. This report is generated for the Safes specifically that are configured according to the location.

Navigate to the Safe Discrepancies Report using the Search or the path: Reports > Cash Management Reports > Safe Discrepancies Report

Prerequisite: The records will be populated for the report when an open session has been marked as Cash up or a Cash up session to Finalise in the Safe with discrepancy values.

Filter

There are the following filters that help to filter the reporting data.

Safe Discrepancies filter screen with Location, Date Range, and Safe fields.

Set the filter criteria for the Safe Discrepancies report. Select a Location, Date Range, and Safe. Press Next to generate the report.
Filter CriteriaDescription
LocationDropdown list selection of defined Locations.
Date RangeThe start and end period in which the reports need to be generated when the Cashup or finalised sessions are being performed.
SafeDropdown selection from a list of all Safes at the Location specified in a previous field. If no Location is specified all Safes configured are shown.

The Reset button resets all the filters to their default value. The Back button returns the user to the previous screen. The Next button creates a Scheduled Job to run the report.

Summary

Once the report has been generated the following screen is displayed.

Safe Discrepancies report showing safes with date, tender type, expected, declared, and discrepancy values.

The report summary displays discrepancy values for the selected safe. The Discrepancy column shows the difference between Expected and Declared values. Totals are shown per cashup session date.
Report Column CriteriaDescription
LocationThe Defined location on the Filter Criteria. If the location was not selected in the Filter, then all the locations associated with the EM will be displayed.
SafeThe Safe selected in the Filter screen will be displayed. If a location is selected in the Filter screen but the Safe field is not specified, then all Safes associated with that location that have discrepancies during cashup or finalise will be listed.
Date TimeThe date and time at which the cashup or finalise was performed and had discrepancies for the Safe.
TenderThe type of tender that has the discrepancies while the cashup or finalise was performed.
ExpectedThe expected total value (systematic value) of the tender has been done on sales return and other cash flow functions.
DeclaredThe total amount that has been recorded by the user.
DiscrepancyThe inconsistency between the Expected value and the Declared value (Declared value - Expected value). This can be either a positive or a negative value according to the values given while doing the Cash up or Finalise.
TotalThe total value against the safe will be listed.

In addition to the report summary, other functions such as view and export are available. The options provide the reports to be Printed or to view the report in PDF and to export the report in XLS or DOC format.

The Back button returns the user to the previous screen.

This completes the Safe Discrepancies Report.