What is the Aged Patient Accounts Report by Trx Date? – Netalytics

Purpose

The purpose of this report is to show the amount of money owed to a clinic or program by patient based on how long ago the service was billed.

The report can be run with a through date in the past, present or future.
This report can be run by Status (Status:All includes status none)
This report can be run by Program (Program All - None - includes balances for transactions that do not have a program assigned None)
Columns with no values will appear on the report.
The transaction date can affect how the data is shown on this report!
- Data on this report will reflect the aging based on the transaction date however it can only appear on the report once the service has been invoiced.
- This is the only way for SMART to know the dollar amount associated with the service.
- This can sometimes lead to discrepancies with when the money appears if billing is delayed. For example:
  - Service X is conducted on August 2 and billed on September 1
  - The report is run on August 31. No representation of this service will be shown.
  - The report us run on September 2. At this point this service charge will be shown in the “current” column.
Totals
- Total for each selected status and then each selected program Totals. Currently when there is no program assigned, but the patient is in an Active Status, any balance they carry will show under Program None. Patients that have a status other than “Active” and are also not assigned to a program will not appear on this report.

Billing: Balance Due: Aged Patient Accounts by Trx Date

Column Header	Definition
Program	Program the transactions for the patient
Status	Episode Status for the patient
Patient Name	Patient Name
ID #	Chart #
Current	The amount of money owed by this patient for services billed in the last 30 days from the thru date.
31-60 Days	The amount of money owed by this patient for services billed 31 to 60 days from the thru date
61-120 Days	The amount of money owed by this patient for services billed 61 to 90 days from the thru date
121-150 Days	The amount of money owed by this patient for services billed 91 to 120 days from the thru date
151-180 Days	The amount of money owed by this patient for services billed 121 to 180 days from the thru date
181-270 Days	The amount of money owed by this patient for services billed 181 to 270 days from the thru date
271-365	The amount of money owed by this patient for services billed 271 to 365 days from the thru date
Over 365 Days	The amount of money owed by this patient for services billed over to 365 days from the thru date