The Production and Collection Report allows you to track your production and collection based on the monthly and annual levels. It includes information such as gross production, production adjustment, net production, gross patient collection, gross insurance collection, etc. This detailed analysis assists in identifying areas where the practice may be experiencing financial losses.
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.
Monthly View
The report provides valuable insights into the practice’s overall production and collections for the month. By aggregating daily transactions, they allow for the comparison of completed codes and added receipts, offering a complete view of financial performance. Perform the following steps to generate a production and collection report based on the monthly view.
Within the Production and Collection Report,
- Select the Filter Criteria as Create New or Select Existing.
- Select View as Monthly.
- Select the Month and the Year.
- Select the Date As either the Date of Service/Payment Date or the Transaction Date.
- Date of Service/Payment Date: The production will be shown by the Date of Service, and collection will be shown by the Payment Date.
- Transaction Date: Both Production and Collection will be shown based on the transaction date.
- Select the Location(s). You can generate a report for up to 10 locations at a time.
- Click Generate Report.
| Tip: You can save the filter criteria for easy reuse in the future. Click here to learn how to save and manage your saved filter criteria in operational reports. |
- Additionally, if you choose the Select Existing option, a Select Filter field will appear, allowing you to choose from any of the saved filters.
Once you generate the report, you will receive a detailed monthly breakdown of the annual production and collection for the practice.
Let's explore the columns in the report:
- Gross Production (Date Of Service): The amount of production generated from procedures completed on this day is calculated based on the (DOS) Date of Service or (Trans. Date) Transaction Date as selected.
- Scheduled Production: The total amount of production scheduled for the given date. This is based on codes linked to the appointment and frozen before the start of the day.
- Production Adjustments (Date Of Service): The amount of production adjustments made on this day is based on DOS or Trans. Date as selected.
- Net Production (Date Of Service): The amount of production generated from procedures completed on this day including production adjustments calculated based on DOS or Trans. Date as selected.
- Gross Patient Collection (Payment Date): The total amount from patient receipts and collection agency receipts based on the payment date or transaction date as selected. Exclusions: Refunds, Income Reduction, Transfer, Capitation, Membership credit, and Special Credits in receipts.
- Gross Insurance Collection (Payment Date): The total amount from insurance receipts, based on the payment date or transaction date as selected. Exclusions: Refunds, Income Reduction, Transfer, Capitation, Membership credit, and Special Credits in receipts.
- Gross Collection (Payment Date): The total amount from patient, insurance, and collection agency receipts based on the payment date or transaction date as selected. Exclusions: Refunds, Income Reduction, Transfer, Capitation, Membership credit, and Special Credits in receipts.
- Collection Adjustments (Trans. Date): The amount of collection adjustment made on this day based on Trans. Date.
- Refunds (Refund Date): The total amount of money that is refunded during the selected date range.
- Membership Credits (Date Of Service): The total amount of membership discount credits applied to the relevant procedure codes.
- Net Collection (Payment Date): Net Collection is calculated as: Gross Collection + Collection Adjustments − Refunds − Membership Credits. Exclusions: Income Reduction and Special Credits in receipts.
At the bottom of the grid, you will find the total production and collection for the entire year.
- Users can download files in PDF, CSV, and EXCEL by clicking the Download As option.
- Print the files by clicking the Print icon.
To enable Permissions for the Production and Collect Report, follow these steps.
Navigate to the System Menu > select Practice Settings > Administration > Profiles.
- Click Manage Profiles and select Manage Permissions for the intended user.
- Select Insights.
- Checkmark Generate Production and Collection Report under Operational Reports to enable the permission.
- Click Save.
| Note: Only users with the 'Generate Production and Collection Report' permission can generate the report. |
On the Confirm Action modal that appears, click Yes to proceed.
Practices can use this guide to access and generate production and collection reports within CareStack.