Description and Usage

<< Click to Display Table of Contents >>

Navigation:  Report Dashboard > Unbilled Insurance Report - Report Writer >

Description and Usage

Previous pageReturn to chapter overviewNext page

The Unbilled Insurance report provides a listing of all insurance claims that have not been billed. It will pull a reason code for not being billed as well as the comment listed on the Insurance Claim Status screen.

 

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

 

 

Unbilled Insurance Report - Report Writer

 

x_unbilled_ins

 

 

Unbilled Insurance Report (Grand Totals) - Report Writer

 

x_unbilled_summary

 

Listed below is an explanation of each column.

 

Name: Pulls the patient's name from the Full Name field in the Patient tab on the Registration and ADT screen.

 

Account #: Pulls the patient's account number from the Registration and ADT screen.

 

Admit Date: Pulls the patient's admit date from the Stay tab on the Registration and ADT screen.

 

Disch Date: Pulls the patient's discharge date from the Stay tab on the Registration and ADT screen.

 

Total Chgs: The total amount charged to the patient account.

 

Acct Bal: Pulls from the Patient Account Detail screen.

 

Exp Pay: Pulls from the Detail Charge screen for that claim.

 

Ins: This column lists the Insurance code of the claim that is set up in the Insurance Claims by Patient screen but is not at a Billed, Paid or Rejected status.

 

Claim Status: Pulls from the Insurance Claims by Patient screen.

 

Stay: Pulls the patient's stay type from the Patient tab on the Registration and ADT screen.

 

LOS: Pulls the patient's Length of Stay and is calculated as Discharge Date minus Admit Date. If the patient has not been discharged, it is calculated as Run-Date minus Admit Date.

 

Serv: Pulls the patient's service code from the Patient tab on the Registration and ADT screen.

 

Reason: The Reason Code is determined by the system. The codes are as follows:

A

Patient has not been admitted

D

Patient has not been discharged

G

Insurance has not been generated

I

Insurance has not been verified (Policy Information “Received” is blank

M

Medical Records has not coded or verified the account

R

Claim is Ready to Bill

U

P

Claim is Unchecked

Claim is Pending

 

Comments: Comments pull from the Insurance Claim Status screen.

 

Ins Totals: Totals are based on the number of days between discharge date and the date of the report.

 

Claims: The total number of accounts reported.

 

Charges: The total amount of the Total Charges column.

 

Balance: The total amount of the Account Balance column.

 

Exp Pay: The total amount of the Expected Pay column.