<< Click to Display Table of Contents >> Navigation:  Report Dashboard > Billed But Unpaid Claims (By Ins) - Report Writer > Description and Usage

The Billed but Unpaid Claims (by Ins) report within the Report Writer application provides a listing by insurance of all outstanding insurance claims. Financial Classes that do not have any unpaid claims or claims that meet the report’s criteria are excluded. The report lists insurance, patient account number, patient name, billed date, billed amount, aging, subscriber name, contract number and group information.

 

The aging selections are Current, Over 30, Over 60 and Over 90 days. The last page of the report lists the Insurance Summary with an aging breakdown of total dollars for each insurance company in each aging column followed by a breakdown of total expected pay for each insurance company.

 

The Billed but Unpaid Claims (By Ins) report should be printed and worked on a weekly basis. This report is helpful in showing which insurance is outstanding and how much payment is expected.

 

The Report Writer application allows the user to filter, sort and manipulate this report so that he may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.  

 

 

Billed but Unpaid Claims (by Insurance) - Report Writer

 

 

 

Billed but Unpaid Claims (by Insurance) - Insurance Summary - Report Writer

 

 

 

 

Listed below is an explanation of each column.

 

•P-S (Primary-Secondary): Indicates whether this is the Primary or Secondary claim. Pulls from Policy Information.

 

•Serv To Dt: Pulls the ending service date of the claim.

 

•Account (Number): Pulls from the Registration and ADT Screen.

 

•Patient Name: Pulls from the Full Name field in the Patient tab on the Registration and ADT screen.

 

•Serv (Service Code): Pulls from the Patient tab on the Registration and ADT screen.

 

•Billed Dt: Pulls from the Detail Charges screen.

 

•Billed Amt: Pulls from the Detail Charges screen.

 

•Ins Age: Pulls as Current if the billed date is less than 30 days old. Pulls as Over 30 if the billed date is over 30 but less than 60 days old. Pulls as Over 60 if the billed date is over 60 but less than 90 days old. Pulls as Over 90 if the over 90 days old.

 

•Subscriber: Pulls from the Policy Information.

 

•Contract #(Number): Pulls from the Policy Information.

 

•Group #(Number): Pulls from the Policy Information.