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.