The Deposit Report is used to track and reconcile all payment deposits. It consolidates the total amounts collected across different types of payment deposits received, such as cash, card, and cheque. This report shows how much money has been deposited in the bank, with real-time data that can be filtered by payment category or type.
Use Cases
- Track and reconcile total payments received across various payment categories.
- Identify and categorise payment types (e.g., cash, card, cheque) to simplify deposit tracking.
- Review detailed receipt entries by date range to ensure accurate accounting.
- Quickly identify discrepancies in deposit amounts.
Let's get started!
- Navigate to the System Menu > select Operational Reports under Insights.
- Click the + icon on the left or the Generate Report button on the right for the chosen report.
Explore below to learn more about the desired views, filter criteria, and results.
Let's explore the filters :
| No | Filters | Description |
| 1 | Date As* |
Decide whether to include receipts in the report that have payment date/transaction date within the selected date range. Only receipts with the transaction date within the selected date range will appear when the Date As option is set to the transaction date. Only receipts with the payment date within the selected date range will appear when the Date As option is set to the payment date. |
| 2 | View by* |
Select this option to view your report either by Payment Category or Payment Type. When you choose to view this report by payment category/payment type you will be able to see all receipts that have been added under each payment category/payment type under a consolidated view and the details about each receipt. *By default, the payment category will be selected. |
| 3 | Date Range* |
Choose to focus the report on payments dated within the selected date range. *By default, the date range will be for the current day. |
| 4 | Location* |
Choose to focus the report based on payments entered at the selected location(s). *By default, the location will be the user’s default location. |
5 |
Receipt Clinician |
Choose to focus the report based on the receipt clinician you want to view in the report. |
| 6 | Payment Category | Choose to focus the report based on the payment category you want to see in the report. |
| 7 | Payment Type | Choose to focus the report based on the payment type you want to see in the report. |
| 8 | Patient | Choose to focus the report on selected patients. |
| 9 | Columns* |
Choose the columns required in the report. *By default, all columns are selected. |
Once you have selected the desired filters, click on the Generate button to generate your on-screen report or Download Report As button to download your report.
Click here to learn how to save and manage your saved filter criteria in operational reports.
Generation/Download Criteria
- Due to data volume, reports with more than 5 Treatment Locations or a date range exceeding 14 days will not be generated on-screen.
- Reports meeting these criteria will be accessible in the Scheduled Downloads section.
Result
Now, let's take a look at the results of the Deposit Report.
- Payment Category: The payment category associated with the receipt.
- Count: The total number of receipts associated with this payment type/category.
- Total: The sum of collections from all paying entities, including patients, insurance carriers and collection agencies through receipts of this payment type.
- Payment Date: The date on which the payment was made.
- Trans. (Transaction) Date: The date the receipt was created in the system.
- Source: The name of the patient, insurance carrier, or collection agency that made the payment.
- Receipt #: The system-assigned number used to identify the receipt that has been entered into the system.
- Location: The short name of the location associated with the receipt.
- Created By: The name of the user who created the receipt.
- Receipt Clinician: The clinician associated with the receipt.
- Payment Category: The payment category associated with the receipt.
- Payment Type: The payment type associated with the receipt.
- Ref No.: The reference number for the payment (if applicable).
-
Unapplied: The amount of the receipt that remains as unapplied credits. Click the
arrow next to Unapplied to sort the values in ascending or descending order (lowest to highest or highest to lowest).
- Last Updated By: The name of the user who last updated the receipt.
Check out this GIF for a quick overview.
If users in your practice cannot use this report, please ensure that the relevant permissions are enabled. To enable Permissions for the Deposit Report:
- Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Select the Generate Deposit Report under Operational Reports to enable the relevant permissions.
- Click Save.
- On the Confirm Action modal that appears, click Yes to proceed.
- A toast notification appears on the top right stating, 'Profile updated successfully'.
Practices can use this comprehensive guide to efficiently generate reports, explore various use cases, and apply the necessary filter criteria to generate the desired report. Following this guide will help you create reports quickly, understand the different views available, and customise reports to meet specific needs.