The Receivables Breakdown Report allows offices to see changes in accounts receivable throughout a calendar month.

In Standard Reports, in the Monthly section, click Receivables Breakdown.

This report is a breakdown, by date, of outstanding patient balances.

Providers: Select the treating providers to include.

• Practice is the default option. It includes all providers and unearned paysplits.
• Provider selection is only an option if the logged-on user has the Production and Income, View All Providers permission. Select one or more providers to view.
• If all providers are selected manually, unearned paysplits are not included. To include unearned in the Ending A/R, select Practice instead.

Show Insurance Write-offs: Select when write-offs should be applied. See Show Insurance Write-offs for more details.

• Use insurance payment date: Apply write-offs on the date the insurance claim is received.
• Use procedure date: Apply write-offs on the day the procedure is completed.

Up to the following date: Select the end date for the report. The start date is always the first day of the same month (e.g., if the end date of August 26 is selected, the start date is August 1).

Report Preview

After setting report filters, click OK to generate a print preview of the report. Below is an example of the report and descriptions of each column of the report.

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

• Production: Total amount of completed procedures.
• The following columns only appear when the Pay Plan charge logic preference is set to Age Credits and Debits.
• PayPlanProd: Production applied to patient accounts to offset payment plan charges.
• Prod-PPProd: Production after PayPlanProd is subtracted.
• PayPlanCharges: Payment plan Charges Due.
• Adjustments: Total combined positive and negative Adjustments.
  • Adjustments attached to procedures are counted on the report as of (procedure date) noted on the Adjustment. If adjustments are not attached to procedures, they are counted on the report as of the Adjustment Date.
• Write-off: PPO and capitation insurance write-offs.
• Payment: Amount received from patient payments.
• InsPayment: Amount received from insurance payments. Determined amounts entered for Insurance Paid on Claim Procedures ( claimprocs ). May include unfinalized payments.
• Daily A/R: Net change in account receivables.
• Ending A/R: Total account receivables.

Matching Receivables Breakdown and Aging of A/R Totals

To get the Aging of Accounts Receivable (A/R) Report Total to match the Receivables Breakdown, Ending A/R Total, run each report for all providers and select the options below.

Receivables Breakdown Report:

• Provider: Practice
• Show Insurance Write-offs: Select Using insurance payment date.
• Dates: Same as Aging of A/R Report.

Aging of A/R Report:

• Date: Same as Receivables Breakdown report.
• Age of Account: Any Balance
• Negative Balances:- Check Include negative balances. - Do NOT check Only show negative balances.
• Exclusions: Do NOT check any of the exclusions.
• Billing Types: All
• Providers: All

Additional Information:
The reports cannot be matched if any of the following is true:

• There are payment plans.
• Historical data (i.e., payments/payment splits, adjustments, or procedures) has been edited.
• Reports are run for a specific provider.

The Aging of A/R report includes all entries associated with any patient who has the selected provider as their primary provider at the time of the work. The Receivable Breakdown includes only the entries where the selected provider was the provider on the procedure/claim/adjustment/write-off. These totals are very different.