Production and Income Reports

There are several Production and Income reports. Each summarizes information differently based on report type.

  • Large offices may want to set up a Report Server to run Production and Income Reports. This can be useful to prevent lockups and slowness in a live database.
  • To control user access to Production and Income reports, see Report Setup: Security Permissions. To control whether a user can run this report for other providers, see Edit Group Permission.

  1. In the Main Menu, click Reports, Standard.
  2. In the Production and Income section, click on a report.
    • Today or Yesterday will generate a Daily report using default options.
    • This Month or Last Month will generate a Monthly report using default options.
    • This Year will generate an Annual report for the current year (Jan. 1 - Dec. 31) using default options.
    • More Options will open the report window so you can customize report options.

  3. Report Type: Select the report type. Date range values will automatically change to match.
  4. Providers: Select the providers to include, or check All to include all providers, including hidden providers that have claim payments for the report period. Unearned will include payments with an unearned type (pay splits not associated to a provider, such as prepayments).
    • Provider selection is only an option if the logged-on user has the Production and Income, View All Providers permission.
    • Versions 16.4 and earlier will have an Include Unearned checkbox. This checkbox works similar to the Unearned provider in that it includes/excludes payments with an unearned type.
  5. Include Unearned: Select this box to include unearned income.
    Note: This should either always be selected when running Production and Income, or never selected.
  6. Clinics: Select the clinics to include, or check All to include all clinics. Clinic is determined by the clinic of the procedure (place of service).
    • Show Clinic Info: Only an option when Daily is the Report Type. Set the default in Report Setup: Misc Settings.

      Checked: The clinic will show for each transaction, clinic totals will show at the bottom of the report, and the report will print in landscape mode.

      Unchecked: Clinic information will not show and the report will print in portrait mode.

    • Show Clinic Breakdown: Select how data is grouped. Set the default in Report Setup - Misc Settings.
      • Checked: Report will group by clinic.
      • Unchecked: Report will group by date and intermingle clinics.
  7. Date Range: Select the report date range. Today's Date is automatically populated with today's date for reference. The default date range is based on the report type. To change, manually enter the From / To dates, or click the arrows to quickly change values.
    • Today/This Month/This Year: Reset dates to match current day, month, year.
    • Right/Left arrows: Move back or forward one day/month/year at a time.
  8. Show Insurance Write-offs: Select when to apply insurance write-offs to production amounts. See Show Insurance Writeoffs for more details. Set the default in Report Setup - Misc Settings.
    • Using insurance payment date: Apply the write-off when the insurance payment is entered.
    • Using procedure date: Apply the write-off on the date of service.
    • Use initial claim date for write-off estimates, ins pay date for write-off adjustments: Check to include write-off estimates and changes in write-offs in the report. The report will display and print in landscape orientation. See the example report below for descriptions of each write-off column.
  9. Click OK to generate the report.

For a description of Toolbar buttons, see Complex Report System.

Example of monthly report type:

Production: Work that has already been completed. Production from Capitation ( HMO / DMO ) Insurance Plan is not included.

Sched: (Monthly only) Work for all scheduled appointments that aren't complete. Does not include work for Capitation insurance plans. Write-offs are only included if, in Misc Settings, Monthly P&I scheduled production subtracts PPO write-offs.

Adj: Adjustments made to the account.

Write-off Est: The write-off estimate amount in the ClaimSnapshot. (Family Module Preferences)

Write-off: Write-off amounts for PPO insurance plans. Capitation write-offs are not included.

Write-off Adj: The change in write-off amounts. Write-off estimate amount (Write-off Est column) minus the actual write-off amount. Amount must be more than zero to show.

Total Prod: The daily sum of Production + Scheduled + Adjustments - Write-offs.

Pt Income: The amount you have received from 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 - Write-offs.

Total Income: The sum of all Pt Income + Ins Income.

Production and income amounts may not match Aging of A/R amounts.