The Bank Deposit Analysis report offers a comprehensive insight into cash-up counts and over/shorts, providing a detailed reconciliation against bank deposits. This report serves as a valuable tool for financial oversight, offering a clear view of discrepancies and ensuring the accuracy of financial transactions, making it an essential resource for effective financial management.
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 Bank Deposit Analysis report via: Reports & Analysis > Revenue Management > Bank Deposits > Analysis.
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 include deposits for. |
| View Type |
Select whether to view the report as:
|
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 first section of the Bank Deposit Analysis report displays a daily summary of cash up totals alongside any deposits for reconciliation, displaying:
| Sales Date |
Displays the Sales Date being reported. |
| Payments |
Displays the total number of payments recorded in sales on the Sales Date shown. |
| Cash Up Over/Short |
Displays the total daily over/short from cash ups on the Sales Date shown. |
| Cash Up Counted |
Displays the value of payments counted in cash ups on the Sales Date shown. |
| Cash Movement Total |
Displays the value of any cash movements on the Sales Date shown in relation to cash counted from cash ups. |
| Cash Purchase Total |
Displays the value of any cash purchases, used to reconcile any petty cash declared in cash ups against cash purchase reasons on the Sales Date shown. |
| Bank Deposit Total |
Displays the total value of bank deposits linked to the Sales Date shown. |
| Bank Deposit Variance |
Displays any variance between payments counted and payments deposited for the Sales Date shown. |
Section 2: Site Summary
The second section of the Bank Deposit Analysis report displays consolidated deposits per payment media type, displaying:
| Media Type |
Displays the media type being reported. |
| Payments |
Displays the total value of payments recorded in transactions against the media type. |
| Cash Up Over/Short |
Displays the total daily over/short from cash ups against the media type. |
| Cash Up Counted |
Displays the value of the payment type counted in cash ups. |
| Cash Movement Total |
Displays the value of any cash movements in relation to cash ups. |
| Cash Purchase Total |
Displays the value of any cash purchases, used to reconcile petty cash declared in cash ups. |
| Bank Deposit Total |
Displays the total value of bank deposits against the media type. |
| Bank Deposit Variance |
Displays any variance between what was counted and deposited for the media type. |
Section 3: Site Details
The third section of the Bank Deposit Analysis report displays deposit reconciliation per payment media type for each day at the site shown, displaying the following:
| Sale Date |
Displays the Sales Date. |
| Media Type |
Displays the media type being reported. |
| Payments |
Displays the total value of payments recorded in transactions against the media type. |
| Cash Up Over/Short |
Displays the total daily over/short from cash ups against the media type. |
| Cash Up Counted |
Displays the value of the payment type counted in cash ups. |
| Cash Movement Total |
Displays the value of any cash movements in relation to cash ups. |
| Cash Purchase Total |
Displays the value of any cash purchases, used to reconcile petty cash declared in cash ups. |
| Bank Deposit Total |
Displays the total value of bank deposits against the media type. |
| Bank Deposit Variance |
Displays any variance between what was counted and deposited for the media type. |
Comments
0 comments
Article is closed for comments.