Running the Account Aging Report

The Account Aging report lists all accounts with aged balances exceeding a specified amount. It also shows the date and amount of the last payment, the total balance, the insurance amount, and the current, 30-, 60-, and 90-day aging amounts. Use this report to identify overdue accounts.

By default, this report excludes accounts with user codes C, I, or L; inactive accounts; accounts with $0.00 balances; and accounts with credit balances.
If you do not select the Show Details Of Individual Accounts checkbox, this part of the report prints balance mismatch information only. If you run this report for a specific provider, the summary does not include budget plan amounts.
If you have future transactions posted in your system, the account will show as having a balance mismatch. True balance mismatches display a status box in the Account Transactions window.
This report does not include dangling transactions.
You should not compare the receivables total from the Account Aging report with the receivables number on the daysheet. The defaults for the Account Aging report exclude a number of accounts, while the daysheet does not exclude any accounts.
To reconcile the Account Aging report with other accounting reports, you must not exclude any user codes, and you must include accounts with credit balances when you set up the report.
The Outstanding Insurance Breakdown section of the report shows the dollar total and aging of insurance balances. The dollar total equals the insurance balance for accounts included in the report. This is not the same calculation as for outstanding claims, and this total will not match any other report.

The Accounts Receivable is also shown as a percentage for each of the aging categories—current, 30-, 60-, 90-, credits, amounts not on budget plans, and amounts transferred to budget plans.

The Outstanding Insurance Breakdown section includes a total of the outstanding income for the practice. This is calculated by adding the total outstanding insurance and the total amount due of each account and then subtracting any prepayments that have been made.

The Accounts Receivable section includes a total of all the debit account balances (without credit balances factored in).

You can see that your debit balances match your total outstanding income. Both of these amounts are displayed in blue.
The Accounts Receivable section is calculated as follows:

NET PRODUCTIONS = Productions (100.00+) + Charges (61.00-95.89, 97.00-97.89, 99.00-99.89) +/-Production Adjustments (40.00-60.89)

NET COLLECTIONS = Cash (1.00-1.89) + Checks (2.00-10.89) + Credit Cards (11.00-20.89) +/-Collection Adjustments (21.00-39.98, 96.00-96.89, 98.00-98.89)

NET PRODUCTIONS - NET COLLECTIONS = ACCOUNTS RECEIVABLE

Your receivables total is the amount awaiting or requiring payment (the difference between the services performed and the amount collected or adjusted off for these services). The Total (Net 30) field displays the total of all productions, charges, and adjustments to productions you expect to collect within the next 30 days (excluding budget plan amounts, listed in the On Budget Plans field).

The Accounts Receivable is also shown as a percentage for each of the aging categories—current, 30-, 60-, 90-, credits, amounts not on budget plans, and amounts transferred to budget plans.

For Practice

Acct ID and Account Name—Account ID number and name of guarantor one.
Balance—Total account balance when run for the practice.
Ins Amt—The account's insurance balance.
Amt Due—The amount due on the account.
Prepay—Any amounts prepaid against expected insurance.
Current—Portion of the balance that is current.
30 Days, 60 Days, 90 Days—Portion of the balance that is outstanding 30, 60, or 90 days.
Date LP—Date of last payment (codes 1.00-20.89). The LAST PAYMENT field in the Account Information window is updated for personal payments (codes 1.00, 3.00-20.89).
Amount LP—Amount of last payment (codes 1.00-20.89).
Bdgt Pln/CC Plan—Total of account budget plan/credit card payment plan balance.

For Individual Provider

Acct ID and Account Name—Account ID number and name of guarantor one.
Balance—Portion of the account balance due the individual provider.
Ins Amt—The account's insurance balance.
Amt Due—The amount due on the account.
Prepay—Any amounts prepaid against expected insurance.
Current—Portion of balance current with the individual provider.
30 Days, 60 Days, 90 Days—Portion of the balance outstanding 30, 60, or 90 days with the individual provider.
Date LP—Date of last personal payment posted for the individual provider (codes 1.00-20.89). The LAST PAYMENT field in the Account Information window is updated for personal payments (codes 1.00, 3.00-
20.89).
Amount LP—Amount of last payment (codes 1.00-20.89).
Bdgt Pln/CC Plan—Total of account budget plan/credit card payment plan balance.