30/60/90 By Payer


Reports>Accounts Receivable>05.22 30/60/90 By Payer

How to Run the Report

This report will show the balance for each payer based on the Thru Date you indicate on the screen. For example, if you use the Thru date of the current day, the system will pull all balances remaining as of today.  If you use a Thru Date of 01/01/2014, the system will pull all balances remaining as of that date. So, all payments after that date will not be included, and all amounts billed will not be included.

Use Transaction Dates Only (This will match report 05.15)

The Balance Due on 05.23 will match the Ending Balance on 05.15 when same From/Thru dates are used.

From and Thru = The range of transaction dates to be used.

Follow next section for remainder of report options. 

Use Charges Year/Month (This is how this report used to work)

Thru= The Thru date is the cutoff date of transactions to be used.

Program(s) = Filter report by entering program number(s). Or leave blank to display all.

Year/Month For Current= This will determine the current month that will appear on the report.  For example, if you choose February, these months will appear on the report in the following order:  February, January, December, November, Older...

Put PPS Amount Billed Amounts in the Month the episode started, rather than in the month the RAP claim was created = If you would like this option, check the box.  If not, leave the box blank.

Print Payer Options:

All Payers - Results will include all payers.

PPS Payers Only - Results will include only PPS Payers.  This includes all payers marked as PPS = Yes (under Codes > Program Related Codes > Payer Codes).

Non-PPS Payers - Results will include only Payers where PPS = No (under Codes > Program Related Codes > Payer Codes).

Click on Print

How to Read the Report

Program / Payer fields= Program number/name and payer number/name related to the AR transaction. 

Older = This column will show total balances for the older months.  To find out what those months actually are you can revise the Year/Mo For Current

First Month/Second Month/Third Month/Fourth Month = The 4 months that appear on the report will show payer balances for each individual month.

Balance Due = Total balance due for that payer -- keep in mind this also reflects the transaction date used. 

Old % = This column will show what portion of the Older Balances represent the total outstanding balance for that payer.

Oldest = This column will show the month/year of the oldest outstanding balance.