A guide to the Daily Cash Report and its contents.
Overview
The Daily Cash Report identifies Receipts posted on accounts that are allocated to Charges posted on the same account.
The allocations are reported by General Ledger Account Code and include the total Suspense Receipt movement for allocation against Charges for 7 days following the selected date.
Report Details
Paid Charges are total amounts grouped by the General Ledger Account Code of the paid charge and are shown as a total per date range for a seven-day breakdown beginning on the date selected.
For any Receipts that were not allocated to a charge, eg, Deposits or overpayments, these are reported as Suspense Receipts.
Receipts stay in Suspense until the date a Charge is posted to the account and Receipt Allocation occurs.
In this report, Suspense is the total movement of money for the date reported and either increases or decreases the credit amount held.
Use Cases
- End of day banking review - Run the report at the end of the day to see which GL Acc Codes the money received was allocated to.
- Suspense monitoring - Track how much of the money received is sitting in Suspense (deposits and overpayments not yet allocated to charges) versus paying off posted charges.
- Debtor movement reconciliation - Compare against the Daily Charge Report for the same period: charges raised increase debtors, while the receipts on this report reduce them.
How to Access
In the side menu of RMS, go to Reports > Accounting > Daily Cash.
Guide
- Select the Date Range, Seven-Day Breakdown or Transaction Range option.
Click More Options for additional report settings (Optional). - Select Build.
Report Options
| Report Option | Type | Default | Description |
|---|---|---|---|
| Date Range | Radio + Date range | Not selected | Includes all receipt allocations with a date within the selected range. |
| Seven-Day Breakdown | Radio + Date | Selected | Shows a breakdown of allocations over seven days beginning on the selected date. |
| Transaction Range | Radio + Range | Not selected | Selects a range of transactions by number rather than by date. |
| More Options | Expander | Collapsed | Accesses additional report settings including Build Cash Comparison View, Specific Payment Method, Specific Card Type, Group By and Payment Method filters. Optional. |
| Property | Multi-select | Current property | Limits the report to the selected properties. Shown on multi-property (Enterprise) databases only. |
Column Headers
The columns below appear when the report is run with the default Seven-Day Breakdown option. The amount and tax pair repeats once for each of the seven days.
| Column | Description | Source / Calculation |
|---|---|---|
| Description | The name of the GL Acc Code the paid charge belongs to. Suspense Receipt movement is shown as its own row. | See Receipt allocation and Suspense |
| GL Code | The General Ledger Acc Code identifier for the row. | General Ledger Account Codes |
| Amt (per day) | The receipt amount allocated to charges on that GL Acc Code for that day, excluding tax. One column per day across the seven day window. | See Receipt allocation and Suspense |
| Tax (per day) | The tax portion of the allocated amount for that row on that day. | Calculated from the paid charge's tax |
| Total Amt / Total Tax | Sum of the daily Amt and Tax columns across all seven days for that row. A final Total row sums every row above. | Calculated |
Data Sources & Calculations
The following concepts govern the data shown in this report.
Receipt allocation and Suspense
Every amount on this report comes from receipts whose money pays off charges posted to the account, represented by the GL Acc Code of the paid charge. Receipts that cannot be allocated to charges, such as Deposits or overpayments, are entered into Suspense and stay there until the day a charge is placed against that credit. Suspense on this report is therefore the total movement of money for the period that either increases or decreases the credits held. For a total of all monies currently held in Suspense, refer to the Credits Total on the Debtors Ledger report.
Reduction in debtors
The cash reports indicate the reduction in debtors for the period: charges raise debtor balances, and the allocated receipts on this report pay them down. To see the charges side by GL Acc Code, refer to the Daily Charge Report. For a receipts total over a user-defined date range, refer to the Cash Transaction Report.
Related Reports
- Daily Charge Report - Charges raised by GL Acc Code for the same seven day window; the other side of the debtor movement.
- Cash Transaction Report - Receipts grouped by payment method over a user-defined date range.
- Debtors Ledger report - Outstanding balances and the Credits Total showing all monies currently held in Suspense.
- Cash Allocation Report - The individual receipt-to-charge allocations behind the totals on this report.
Comments
0 comments
Please sign in to leave a comment.