What is the Private Performance Year to Date Report?
Monitors revenue from all private invoices against targets for year to date together with any private invoices adjustments raised in the reporting period.
📝 Please note: Invoice adjustments of type 'Bad Debt' are not included in this report.
How to run the Private Performance Year to Date Report?
Go to Financial on the navigation menu on the left and select Private Performance Year to Date from the dropdown.
Work through the filters to ensure you are reporting on the correct parameters.
Select the reporting period by choosing your Start Date and End Date from the calendar icon.
Select the Practice/Practices.
Select the Providers.
Set the Reporting Level.
Click Create Report to run the data.
Viewing your Invoiced Private Performance Year to Date Report
This report shows some fields related to dividing the year into weekly sub-periods, so this report would typically be run with the report end date being the most recent week ending date (a week is currently assumed to end on a Sunday).
🚨 Important to remember: The income targets featured in the report are inputted by MPC users under Practice Admin Manager > Practice Set Up > Financial Target Management.
Annual Target: The relevant target amount for this row level, for the whole year period. Currently not shown at the practice payor or provider levels.
Actual YTD: The achieved actual income total for the YTD period (from the report start date to end date) for this row level;
Target YTD: The pro-rated Annual Target amount for the YTD period, which uses a simple factor based on the number of days in the YTD period, divided by the number of days in the whole year, i.e. Annual Target x daysInYTD / daysInYear;
Surplus Shortfall: The difference Actual YTD - Target YTD. A surplus (actual is above target) is shown in green, and a shortfall (actual below target) is shown in red.
Weekly Target: A measure which takes into account the annual target, as well as any current surplus/shortfall. It is calculated as:
(Annual Target - Actual YTD) * daysInWeek / daysRemaining
where daysIn Week = 7 and daysRemaining is the number of days from the report end date to the year end date. It is an indication of the weekly income amount that is needed to achieve the annual target;Last Week: The actual income amount achieved for the most recent week period, up to and including the report end date. The 'Last Week' value is compared to the 'Weekly Target' value, and is coloured green if on/above it, red otherwise.
Projected % for year: An estimate of the percentage of the annual target that would be achieved by the year end date. This uses a simple pro-rata calculation, which is to calculate:
Forecast Year End = Actual YTD + Actual YTD * daysRemaining / daysInYear
- i.e. assuming that the average daily run rate achieved in the YTD period will be maintained until the year end date, and then calculate the percentage as Forecast Year End / Annual Target.
If multiple practices are selected, they are ordered to show the practices with the lowest 'Projected % for year' value first.
What does the reporting parameters mean?
Date range: Defines the reporting period, should be the YTD period being considered.
Practices: allows selection of all or specific practices within the practice group;
Reporting Level:
Practice: This will show one row for each practice.
Group Payor: Shows the results by practice and group level payor.
Practice Payor: Shows the results by practice, group level payor and practice level payor.
Provider: Shows the results by practice, group level payor, practice level payor and provider.
To download a copy of your report you can use the Export Data button to download a CSV spreadsheet.
You can use the Print button in the top right as needed.
To set up automation of the report you can use the Schedule Report button.