The Deposit Slip 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 check. This report helps the practice determine how much money has been deposited in their bank. This report shows real-time data and can be generated by either payment category or payment type.
Use Cases
- Track and reconcile total payments received across various payment categories.
- Identify and categorize payment types (e.g., cash, card, check) 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 a 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. *By default, the Payment Date option is selected. |
| 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 (Max 1 year)* |
Choose to focus the report on payments dated within the selected date range. *By default, the date range will be Today. |
| 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 Provider | Choose to focus the report based on the receipt provider you want to see 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 | Paying Entity | Choose to focus the report based on the paying entity you want to see, such as patient payments, insurance payments, or collection agency payments. |
| 9 | Patient | Choose to focus the report on selected patients. |
| 10 | Carrier | Choose to focus the report on selected insurance carriers. |
| 11 | Collection Agency | Choose to focus the report on selected collection agencies. |
| 12 | 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.
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.
Results
Now, let's take a look at the results of the Deposit Slip Report.
- Payment Category: The payment category associated with the receipt.
- Count: The total number of receipts associated with this payment type/category.
- Patient: The total amount collected from patients through receipts of this payment type/category.
- Insurance: The total amount collected from insurance through receipts of this payment type/category.
- Collection Agency: The total amount collected from collection agencies through receipts of 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/category.
- Paying Entity: The entity from which the payment was received (Patient, Insurance Carrier, or Collection Agency).
- Payment Date: The date on which the payment was made.
- Trans. Date: The date the receipt was created in the system.
- Deposit Date: The date the insurance payment was deposited into the office's account.
- 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 Provider: The provider 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).
- Deposit Amount: The total receipt amount. It does not include the transaction charge and can be calculated as Payment Amount - Transaction Charge.
- Transaction Charge: The transaction charge associated with the payment.
- Payment Amount: The total amount paid (including the transaction charge).
- Unapplied: The amount of the receipt that remains as unapplied credits.
- Last Updated By: The name of the user who last updated the receipt.
Click on the blue-colored entries to view more information on the corresponding entries.
To enable Permissions for the Deposit Slip Report:
- Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Select the Generate Deposit Slip Report option under Operational Reports to enable the permission.
- 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 customize reports to meet specific needs.
Click here to explore the complete list of permissions and their descriptions.