Collections
The Collections statistics are calculated using the Active Patient Base by Last Visit.
The Active Patient Base by Last Visit is the total number of patients who have a Last Visit Date in the Family File that is within the previous number of months (from the Practice Advisor Setup dialog box) and who have a billing type that has been selected for the report (from the Practice Advisor Report dialog box).
Note: Collections is not filtered by dentists and hygienists—it is always calculated using all providers.
Aged Accounts Receivable
The report shows the practice’s aged accounts receivable.
The Aged Accounts Receivable is calculated the following way:
1. For each account, Production Transactions go into the aging brackets according to how far the Procedure Date of the transaction is from the As Of date for the A/R.
2. Next, Collections Transactions are read in chronological order according to Procedure Date and subtracted from the oldest aging bracket(s) that have a balance for the family.
If the family has a credit balance, the entire balance amount is in the Current bracket.
The A/R is the combined total of each family’s account balance.
Accounts Receivable
The report displays the following Accounts Receivable statistics:
• Current – The Current A/R is the combined total of each family’s current account balance. The percentage (%) in this box is the Current A/R divided by the A/R (multiplied by 100 and then rounded to the nearest whole number).
• 31-60 – The A/R 31-60 is the combined total of each family’s account balance aged 31-60 days. The percentage (%) in this box is the A/R 31-60 divided by the A/R (multiplied by 100 and then rounded to the nearest whole number).
• 61-90 – The A/R 61-90 is the combined total of each family’s account balance aged 61-90 days. The percentage (%) in this box is the A/R 61-90 divided by the A/R (multiplied by 100 and then rounded to the nearest whole number).
• Over 90 – The A/R Over 90 is the combined total of each family’s account balance aged Over 90 days. The percentage (%) in this box is the A/R Over 90 divided by the A/R (multiplied by 100 and then rounded to the nearest whole number).
• Balance – The A/R Balance is the A/R (the combined total of each family’s account balance). 100% will always appear in this box to indicate that the A/R Balance is used as the base for calculations.
A/R with Pending Insurance Claims
The A/R with Pending Claims is the dollar amount of the balances for pending claims.
The report displays the following A/R with Pending Insurance Claims statistics:
• Current – The Current A/R with Pending Claims is the combined total of each pending claim’s balance that is current. The percentage (%) in this box is the Current A/R with Pending Claims divided by the Current A/R (multiplied by 100 and then rounded to the nearest whole number).
• 31-60 – The A/R 31-60 with Pending Claims is the combined total of each pending claim’s balance that is aged 31-60 days. The percentage (%) in this box is the A/R 31-60 with Pending Claims divided by the A/R Balance (multiplied by 100 and then rounded to the nearest whole number).
• 61-90 – The A/R 61-90 with Pending Claims is the combined total of each pending claim’s balance aged 61-90 days. The percentage (%) in this box is the A/R 61-90 with Pending Claims divided by the A/R Balance (multiplied by 100 and then rounded to the nearest whole number).
• Over 90 – The A/R Over 90 with Pending Claims is the combined total of each pending claim’s balance that is aged Over 90 days. The percentage (%) in this box is the A/R Over 90 with Pending Claims divided by the A/R Balance (multiplied by 100 and then rounded to the nearest whole number).
• Balance – The A/R with Pending Claims Balance is the A/R Balance (the combined total of each pending claim’s balance). 100% will always appear in this box to indicate that the A/R with Pending Claims Balance is used as the base for calculations.
The following sections explain more about the Practice Advisor:
Practice Advisor - Introduction and Overview
Setup the Practice Advisor
Practice Advisor Report History
Choosing Options for the Practice Advisor Report
Interpreting the Practice Advisor Reports:
Production
Practice Totals
Dentist Totals
Hygienist Totals
Case Acceptance Tools
Collections
Practice Totals
Aged Accounts Receivable (this article)
New Patient Analysis
Continuing Care
CC Visits
CC Due
Schedule Management
Variance Calculations
Graphs
Dentist Detail
Hygienist Detail
Recommendation Footnotes
