The Cash Up Summary report delivers valuable insights into cash-up counts, offering a detailed analysis of overages and shortages. This report provides a concise overview of the reconciliation between actual cash counts and expected values, aiding in the identification and management of discrepancies for effective financial control.
This report is available only to companies subscribed to the Revenue Management module.
For companies with multiple sites, the information provided is split by site if multiple sites are selected.
If required, this report can be created as a Saved Report and set up to send out periodically.
Report Filters
Access the Cash Up Summary report via: Reports & Analysis > Revenue Management > Cash Up Summary.
Select the required report parameter options from:
| Select Sites |
Select which sites and/or site groups to include in the report. |
| Date Range |
Select which date range to report on. The date can be based on either:
|
| View Type |
Select how to view the report output from:
|
Report Output
Depending on the View Type option selected, the Bank Deposit Analysis report has up to three sections:
Section 1: Consolidated Daily Summary
The Daily Summary section of the Cash Up summary report displays a daily breakdown of cash up totals and over/shorts, along with a graph representing any clear variances, displaying:
| Sales Date |
Displays the Sales Date that that the cash up data refers to. |
| Sales Date Gross |
Displays the gross sales received on the Sales Date shown. |
| Cash Up Gross |
Displays the gross sales received within the date range of cash ups that are assigned to the Sales Date shown. |
| Cash Up Expected |
Displays the expected payment totals, based on transactions received. |
| Cash Up Count |
Displays the payments totals counted by users within cash ups that are assigned to the Sales Date shown. |
| Cash Movements |
Displays any cash movements which could impact on the cash up count. |
| Over/Short |
Displays any variance between Cash Up Expected and Cash Up Count. |
Section 2: Site Summary
The Site Payments Summary section of the Cash Up Summary report displays consolidated cash up data per payment media type, as well as a gross SALES row for comparison, displaying:
| Media Type |
Displays the payment media type name. |
| Sales Date Gross |
Displays the gross sales received within the report date range. |
| Cash Up Gross |
Displays gross sales received in cash ups within the report date range. |
| Cash Up Expected |
Displays the expected payment totals, based on transactions received. |
| Cash Up Count |
Displays the payments totals counted by users in cash ups within the report date range. |
| Cash Movements |
Displays any cash movements which could impact on the cash up count. |
| Over/Short |
Displays any variance between Cash Up Expected and Cash Up Count. |
For companies using the Cash Up Day Notes feature, any recorded notes are shown here too.
Section 3: Site Daily Detail
The Site Daily Detail section of the Cash Up Summary report displays cash up data per payment media type for each day at the site shown, displaying:
| Sales Date |
Displays the Sales Date that that the cash up data refers to. |
| Media Type |
Displays the payment media type name. |
| Sales Date Gross |
Displays the gross sales received on the Sales Date shown. |
| Cash Up Gross |
Displays the gross sales received within the date range of cash ups that are assigned to the Sales Date shown. |
| Cash Up Expected |
Displays the expected payment totals, based on transactions received. |
| Cash Up Count |
Displays the payments totals counted by users within cash ups that are assigned to the Sales Date shown. |
| Cash Movements |
Displays any cash movements which could impact on the cash up count. |
| Over/Short |
Displays any variance between Cash Up Expected and Cash Up Count. |