Revenue Projection

The Revenue Projection report enables you to project income for future months. Potential revenue is calculated using existing contract information, such as monthly contract amounts, monthly charges, other financial data, and assumptions entered in the Revenue Projection window.

The report establishes amounts for each subsequent month by determining the average length of a contract. The average length of a contract is calculated by subtracting the initial fee from the contract amount and then dividing the resulting amount by the monthly contract charge, based on values entered in the Assumptions fields in the Revenue Projection window.

Only monthly contracts are considered in calculating default values in the Assumptions fields. Other contract types do not affect these fields.

To generate the Revenue Projection report:

From the main menu, select Reports > Financial > Revenue Projection. The Revenue Projection window is displayed.
In the Start and End date fields, type a date range for the report.
Select a location. The default is All Locations. To select a single location, click Single Location and select a location from the drop-down list.
Select a doctor. The default is All Doctors. To select a single doctor, click Single Doctor and select a doctor from the drop-down list.
Type values in the Assumptions fields, as needed. Click here to view detailed descriptions of these fields.
Click OK to print or preview the report, or to export the report data for use in another software application.

Click herehere to view how amounts are calculated.

Amounts in the Increase to Curr column are calculated by adding the values of the Monthly Contract Charge, Initial Fee, Amount of Other Charges per Month, and Amount of Visit Charges per Month fields in the Revenue Projection window.
Amounts in the Total field are calculated by adding the amounts shown in the Patient Total and Insurance Total columns.

Amounts in the Patient Total and Insurance Total columns are adjusted by the value of the % Collected per Month field in the Revenue Projection window.

Amounts in the Patient Total column are calculated by adding all patient total balances and adjusting this sum by the value of the % Collected per Month field, and then adding the sum of pending monthly contracts due to start in the specified month. Then, the sum of projected new monthly contracts is added by calculating the average monthly contract amount and multiplying that average by the value of the Number of New Starts per Month field.
Amounts in the Patient Current column are calculated by adding all patient current balances and adjusting this sum by the value of the % Collected per Month field, and then adding the sum of monthly contract charges due in the specified month. Then, the sum of monthly initial fees is added by calculating the average monthly contract charges and multiplying that average by the value of the Number of New Starts per Month field. The Increase To Curr amount is then added to calculate the amount in the Patient Current column.
Amounts in the Insurance Total column are calculated by adding all insurance total balances and adjusting this sum by the value of the % Collected per Month field, and then adding the sum of pending monthly insurance contracts due to start in the specified month. Then, the sum of projected new monthly insurance contracts is added by calculating the average monthly insurance contract amount and multiplying that average by the value of the Number of New Starts per Month field.
Amounts in the Insurance Current column are calculated by adding all insurance current balances and adjusting this sum by the value of the % Collected per Month field, and then adding the sum of monthly insurance contract charges due in the specified month.

The Revenue Projection report footer shows the values of any Assumptions fields on which the report is based.