Production and Income Report  

Production and Income reports can be for one day, one month, one year, or for a specific date range. You can also filter the report by provider or clinic.

In the Main Menu, click Reports. In the Production and Income section, click on a report to generate it. If you click Today, Yesterday, this Month, Last Month, or This Year, the report will automatically generate.

If you click More Options, this window will open.

Report Type: The date range values will change depending on the option selected.

Providers: Select the Providers to include in the report.

Clinics: Select the Clinics to include in the report. This option is only visible when Clinics is turned on in Show Features.

Today's Date: Automatically populated with today's date.

Date Range: Enter the range to report on, or click the arrows to quickly change values.

Show Insurance Writeoffs: Select to show write-offs based on insurance payment or procedure date. The default option is set in Reports Setup.

Click OK to generate the report.

• Production:  Work that has already been completed. 
• Scheduled:  Work for all scheduled Appointments that aren't complete.  Automatically subtracts write-off estimates from your total fees for production with anticipated PPO writeoffs.
• Adjustments:  Adjustments made to the account.
• Writeoff:  PPO Write-off amounts.  Should usually be shown by date of service, but can be shown by date of insurance payment. This option is set on the Production and Income Report window, or the default can be set in Report Setup.
• Total Prod:  The daily sum of Production Scheduled Adjustments - PPO Writeoffs.
• Pt Income:  The amount you have received from the patient (Payments).
• Ins Income:  The amount you have received from the insurance company (Claim Payments).
• Tot Income:  The daily sum of Pt Income Ins. Income.
• Total Production:  The sum of all Production Scheduled Adjustments - PPO Write-offs.
• Total Income:  The sum of all Pt Income Ins. Income.

If you are using the Clinics feature, daily production and income reports will only print in landscape mode for readability. 

The relationship between production, income, and adjustments
Every financial planner has different opinions about what is an acceptable relationship between production and income, and it also depends on your personal preferences.

The total production and income over the life of your practice will differ by the amount you have failed to collect (Accounts Receivable) minus the amount you have over collected (Accounts Payable). But because the period relative to service date is different for production and income (that is, some money collected in a month is related to production in a previous month) you should not expect your monthly production and income to be comparable for one particular month. This is discussed in more detail at Production and Income.

For the numbers to be true, production should only include fees billed which are actually expected to be paid. So if you give a senior a 10% discount, then you are actually reducing your production by that amount, because you never expect to be paid that 10%. Discounts are automatically subtracted from the production numbers above. Most adjustments will also affect production similarly, including any broken appointment charges, finance charges, referral discounts, writeoffs, and cash discounts.

But some adjustments affect income rather than production, specifially patient refund checks, because they do not change the amount expected to be received, but only affect the income. A refund check is the exact opposite of a patient payment, so enter it as a negative payment in order to correctly affect the income. If the patient had overpaid for previous work, and you wrote them a refund check for the difference, then it would only affect income, not production. But a patient refund check is sometimes associated with a balancing adjustment that does affect the production. For instance, you did a crown which broke in half a month later and the patient has moved out of state. So lets say you have decided to give them a full refund. Their current balance is 0. You would first enter a miscellaneous negative adjustment (production) for $800, taking their balance to -800. Then, you would enter a negative check payment (income) for a patient refund and write them a check, taking the balance back to zero. In this case, the adjustment affects production, and the negative payment affects income.

We understand that this can be confusing, so revisit this page periodically until you can understand fully how your accounts are organized. Also, see the Provider Income Transfer page for details on how to properly track Income split by provider. This is only necessary if you need to track income by provider. Most offices will not do this. They will instead track production by provider, which is easier.