Provider Payroll Report

Provider Payroll Report

Purpose

Provide a method to simplify calculations of Provider Reimbursement that use a percentage of Productivity.

Usage

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 Forumlas

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.