In the Main Menu, click Reports, Standard, Receivables Breakdown.
This report is a breakdown, by date, of outstanding patient balances.
Production: Total amount of completed procedures.
PayPlanCredit: Credits applied to patient accounts to offset payment plan charges. See Payment Plan Procedures and Credits.
Prod-PPCred: Production after PayPlanCredits are subtracted.
PayPlanCharges: Payment plan debits.
Adjustments: Total combined positive and negative Adjustments.
Writeoff: PPO and capitation insurance write-offs.
Payment: Amount received from patient payments.
InsPayment: Amount received from insurance payments.
Daily A/R: Net change in account receivables.
Ending A/R: Total account receivables.
- If the Account Module Preferences Pay Plan Logic is set to Aged Credits and Debits, this report will take into account payment plan amounts due. Otherwise it will not.
- To make the totals on this report match the Aging of A/R report total, see the bottom of this page.
- To control user access to this report, see Report Setup: Security Permissions.
To generate this report:
- In the main menu, click Reports, Standard.
- In the Monthly section, click Receivable Breakdown.
- Providers: Select the providers to include. Practice is the default option and the same as including all providers. Provider selection is only an option if the logged-on user has the Production and Income, View All Providers permission.
- Show Insurance Write-offs: Select when write-offs should be applied. See Show Insurance Writeoffs 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 month.
- Click OK to generate the report.
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.
Note: Reports will not match if you have payment plans.
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
The reports will not match if run for specific providers, even if there are no payment plans. 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 will be very different.