Report Information
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.
Access the Bank Deposit Analysis report via: Reports & Analysis > Revenue Management > Bank Deposits > Analysis.
The output of the report can very depending on the selected report filter options.
If required, this report can be created as a Saved Report and set up to send out periodically.
Information on report filter options
The table below summarises report filter options available for this report.
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
Section 1 - Consolidated Daily Summary
The first section of the report displays a consolidated daily overview of cash up totals, cash movements and deposit reconciliations.
Additional information on this view
The table below summarises the data shown in each column of this report view.
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 - Consolidated Site Payments Summary
The second section of the report displays a consolidated overview of cash up totals, cash movements and deposit reconciliations per payment type.
Additional information on this view
The table below summarises the data shown in each column of this report view.
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 Payments Detail
The third section of the report breaks down the summaries seen in Section 1 and Section 2, and provides a daily breakdown of cash up totals, cash movements and deposit reconciliations per payment type..
Additional information on this view
The table below summarises the data shown in each column of this report view.
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.