The
Receivable Collections Analysis by Type report dynamically identifies seven reporting periods:
- 0-60, 61-120, 121-180, 181-240, 241-300, 301-360, >361.
The >181 category rolls-up everything older than one year and only lists the net receivables amount.
The net receivables amount is balances to the total AR. The ‘Total Net’ value matches the Accounts Receivable total on the other standard AR reports.
You can choose to include or to exclude unapplied transactions. If unapplied transactions are included, then add the unapplied amount to the Net field under >181.
To access the report in NextGen® Enterprise PM, select the Reports menu and select Accounts Receivable, then select Receivable Analysis, and then select By Type.
From the Report Filter window, select the Info button to view the following information about the report:
Logic:
- Results are based on the Process Date of the charges.
- All transactions captured within the process date parameters set in Filter 1 are reported in the same month as their associated charges; allowing for a net collection calculation.
- Charges report against the current primary payer/financial class on the encounter.
- Transactions report against the actual payer/financial class of the transaction.
- The Section column allows you to separate encounters that are currently in a Bad Debt status from active accounts receivable.
- The Rendering physician and the Location Filters are based on the rendering/location on the actual charge, not on the encounter
Filtering Info:
- When using this report to evaluate bad debt balances, Unapplied credits should be excluded in Filter 1.
Common Uses:
- Evaluate and compare charges and associated transactions by month.
- Review net collections against the associated charges.
- Review transactions by third party vs. patient.
Balances to the Following Reports:
- To balance reports, all process date filters must be set exactly the same.
- The total outstanding A/R from this report should balance to the total outstanding A/R from:
- The Monthly Changes in A/R reports
- The Insurance Aging Analysis report if all charge statuses are selected
- The Aging Analysis reports if all charge statuses are selected
