Provider Payroll Report
Provider Payroll Report
Purpose:
Provide a method to simplify calculations of Provider Reimbursement that use a percentage of Productivity.
Setup:
Create Line Items for each Payer.
Each Line Item requires the following:
1) Provider
2) Location
3) Description (Optional)
4) Category - Base. Bonus or Fee
5) Type - % of providers revenue at location OR % of total revenue at location
6) Multiplier
Running the Report:
Select Date Range:
Choose Provider/Provider Group, Location/Location Group
Optionally, choose a Report Procedure Group of Services to exclude from the Payroll Calculation.
The Report:
The report operates by collecting all services in the system that match the selected providers and locations. Only those services in the selection are used to calculate totals.
NB: This means that if you are using Total Revenue at Location, you must choose ALL providers that perform procedures at that location.
Section 1 - Summary
Shows a summary of how the report was created.
Shows a summary chart by provider, including Charges, Payments, Credits, Debits, Payroll Base, Exclusions and Total Calculated Payroll.
Section 2 - Per Provider Payroll Summary and Line Items
Shows a table of Charges, Payments, Debits, Credits, Exclusions and Payable amount by Location.
Shows a table breaking down Payments, Credits and Debits by Entity (Pay Code Entity)
Shows a table of Line Items for Provider (ordered by location and category).
Payroll Payment Amount Formulas:
Total Payments by Location = SUM( payments )
Base Category Payment Amount = Total Payments by Location x Multiplier
Fee Category Payment Amount = Total Payments by Location x Multiplier (Subtracted from total)
Bonus Category Payment Amount = Total Payments by Location x Multiplier (Subtracted from total)
Common Usage:
1) Provider is reimbursed at 50% of Payments Collected on Procedures Performed at all Locations.
Add I line Item Per Location the provider works of Category 'Base' and Type '% of Providers Payments at Location' with a Multiplier of 0.5.
2) Provider is reimbursed at 50% of Payments but pays a 5% Facility Use Fee
Add I line Item Per Location the provider works of Category 'Base' and Type '% of Providers Payments at Location' with a Multiplier of 0.5.
Add I line Item Per Location the provider pays fee of Category 'Fee' and Type '% of Providers Payments at Location' with a Multiplier of 0.5.