The Revenue Reconciliation Report is used to maintain a single source of truth for tracking the movement of money easily across different locations within a practice. This report helps minimise the effort required to determine where each transaction is tagged, making it especially useful for practices with a centralised billing location. Additionally, the report consolidates transactions across locations at the end of specified reporting periods.
Let's explore how to generate a revenue reconciliation report. Perform the steps below.
Use Cases
- Analyse the movement of money across locations of a practice.
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.
Report Generation
- Select the desired Filter Criteria. Check below for a description of filters.
| No. | Filters | Description |
| 1 | Date Range (Max 1 Year) | Select the date range based on adjustment codes completed within the intended period. The user can select a maximum of up to 6 months. *By default, the date range will be for the current day. |
| 2 | Source Location | Choose the source location from which funds are mapped across all other locations. *By default, the location will be the user’s default location. |
| Note: You can select the Save Filter option to use the same filters next time. |
- Click Generate Report.
- To download your report, click Download Report As > select the required output option, such as PDF, EXCEL or CSV.
| Note: Reports with a date range exceeding 3 Months cannot be generated on the screen. The max date range is 6 months. For larger data, you will have to download the report. |
Results
Once generated, the report will be displayed as shown below.
If you need to change the filter criteria, click Edit Filter Criteria. You can Download the report in PDF, CSV, or Excel format.
Let's explore the information provided in the report:
- Location(s): The destination locations across which money has been transferred with respect to the source location.
- Modified Net Revenue (MNR) Debits: The total amount to be received at the source location from the destination location.
- Applied Payments: Amount applied to the source location but collected at another location.
- Receipt Location Updates: Receipts whose locations were updated to the source location from the original collection location.
- Total MNR Debits: Sum of the Applied payments and Receipt location updates as a part of the MNR debits.
- Modified Net Revenue (MNR) Credits: The total amount to be sent to the destination location from the source location.
- Applied Payments: Amount collected at the source location but applied to a particular destination location.
- Receipt Location updates: Receipts whose locations were updated from the source location to a specific destination location.
- Total MNR Credits: Sum of applied payments and receipt location updates as a part of MNR credits.
- Total Modified Net Revenue (MNR): The Total Modified Net Revenue is the sum of MNR debits and MNR credits across all destination locations for a particular source location. This gives a much more accurate idea of how much the actual net collection is at a location.
| Note: The report does not include destination locations that do not have any MNR data (both debits and credits) associated with the Source location. Rows corresponding to these locations will not be included in the report. To view reports meeting these criteria, check out the Scheduled Downloads section. |
Permissions
If users in your practice cannot use this report, please ensure that the relevant permissions are enabled.
To enable Permissions for the Revenue Reconciliation Report:
- Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Permissions for the intended profile.
- Select Insights.
- Check the Generate Revenue Reconciliation 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 guide to quickly generate a Revenue Reconciliation Report and extract data to track transactions and movement of funds across locations.