Staff Compensation Based On Collected Revenue

This calculation is used when a staff member is to be compensated based on a percentage of collected revenue (what was actually paid) rather than on a percentage of 'Billable Amounts' (what was charged). In order to perform this calculation you will need to compare the Detailed Sales Report (charged out by doctor) to the Receivables Report (overdue balances by doctor).

Printing the Detailed Sales Report

This report provides production values for each Provider over the chosen period.

Click on the Section menu and choose General Management.
Double click the Detailed Sales Report in the list (if it is not visible, you might need to log in as Administrator for access).
Choose Doctory & Category for the Type.
Enter the date range for the current month and choose OK.

Produce a Receivables Report listing Provider Breakdown.

Click on the Section Menu and choose General Management.
Double click the Receivables Report.
Choose Provider Breakdown for the type.

NOTE: The Receivables report is time sensitive, and is only a snapshot of the oustanding balances at the time it is printed. Therefore, it is imperative to print this report at the end of each month to capture the receiavables at that time.

Generate Commision Production

Compare the Current Receivables (this month) to Last Month's Receivables value and get the difference.

Example:
Receivables at the end of this Month (Current Month) for Dr. Smith: $1000.00
Receivables for Dr. Smith on last month's report: $500.00

Next, calculate the new Total Sales value and multiply by the commission rate.

Example:
Assuming Dr. Smith is paid a 15% commision on collected revenue.
The Detailed Sales report printed earlier shows a total sales of $10,000.00 for Dr. Smith.
In the Previous Step we determined Dr. Smith's total change in receivables for this month was $500.00
Since this shows an overall increase in Receivables, that amount is to be subtracted from Dr. Smith's overall sales.
10,000.00 in sales
- 500.00 increase in receivables
$9,500.00 in sales that Dr. Smith should be compensated for.

The Total Revenue received of $9,500.00 will now be multiplied by 15% to calculate the commission.