In Standard Reports, in the Monthly section, click Outstanding Insurance Claims.

This report is useful for tracking claims that have been sent, but not received. From here users can also update tracking status for many claims at once or delegate staff to follow-up on claims.

Filters

Use filters to update the claims or preauthorizations listed in the grid. If a user changes filter criteria, click Refresh to update list of results.

• Days Old (min/max): Filter by claim age. The age of the claim depends on the date type selected in the Date Range Applied to filter. Leave both fields blank to show all claims.
• Date Range (from/to): Filter by a date range. Use the Date Range Applies to filter to select which date type to use.
• Date Range Applies to: Select what date type to use when filtering the report.
  • Date Sent: Date the claim was last sent.
  • Date Sent Orig: Date the claim was originally sent.
  • Date of Service: Date of service of procedures on claim.
• Preauth Options: Select option for displaying Preauthorization.
  • Including Preauths: Include preauthorizations.
  • Excluding Preauths: Do not include preauthorizations.
  • Only Show Preauths: Only show preauthorizations.
• Ignore Custom Tracking: Do not consider or show claim tracking status in report results (Edit Claim - Status History Tab). If ignored, the days suppressed values as a result of the status will be ignored. If custom tracking status does show in the report (this box unchecked), the report will print in landscape mode.
• Treat Provs: Filter the report by treating provider. Click the dropdown and highlight the providers to include. Press Ctrl+click to select multiple providers.
• Clinics: Filter by Clinics. Click the dropdown and highlight the clinics to include. Press Ctrl+click to select multiple clinics. Select All to include all clinics, including those that are hidden.
• For User: Only list outstanding claims assigned to a specific user for follow-up. Use the dropdown or click [...] to select from a pick list of users.
  • Select All: Select all users, including those marked hidden.
  • Select None: Select no users. Claims filtered in the list are unassigned.
  • Mine: View outstanding claims assigned to the logged-on user
• Last Claim Custom Tracking Status: Filter by last recorded claim tracking status. Click the dropdown to select an option. Custom track statuses are attached to claims in the Edit Claim Window, Status Tab.
• Carrier: Filter by insurance carrier. Enter the carrier name.
• Last Error Definition: Filter by claim error code. Error codes are attached to claims in the Edit Claim - Status History Tab.

Claims

The grid displays all claims and preauthorizations matching the filter criteria.

Click a column title to sort results in ascending or descending order. To view a claim, double-click it. The following columns show by default.

• Carrier Name: The insurance carrier.
• Phone: The insurance carrier's phone number.
• Type: The type of insurance (primary, secondary, etc).
• User: The user assigned to follow-up on the claim.
• PatName: Patient name. To show patient numbers with names, in Report Setup: Misc Settings, select the Show PatNum: Aging, OutstandingIns, ProcsNotBilled option.
• Clinic: The clinic on the claim. Only shows if Clinics are enabled.
• DateService: Date of service on the claim. A date of 01/01/0001 indicates there is no date of service and indicates this is a preauthorization.
• DateSent: Last date the claim was sent. Differs from DateSentOrig if claim has been re-sent. If claim has been re-sent multiple times, this reflects the most recent date the claim was re-sent.
• DateSentOrig: Date the claim was originally sent. If the claim has never been re-sent, this will be the same as DateSent.
• Track Stat: The last claim tracking status entered. This column won't populate results if Ignore Custom Tracking is checked.
• Date Stat: The date the track status was entered. This column won't populate results if Ignore Custom Tracking is checked.
• Error: The Claim Error code, if one exists. This column won't populate results if Ignore Custom Tracking is checked.
• Amount: The total fee billed to each carrier. This is not the amount that will be paid, so do not use it to determine outstanding insurance payment amounts. This may also differ from the amount billed to the patient's account if the preference Claims Show UCR, fee not billed fee is enabled in the Other Ins Info tab of an insurance plan.

The following fields do not show up by default. They can be added to the report in Display Fields.

• GroupNum: Group number for the subscriber.
• GroupName: Group name for the subscriber.
• SubName: Subscriber name.
• SubDOB: Subscriber date of birth.
• SubID: Subscriber ID.
• PatDOB: The date of birth of the patient on the outstanding claim.

Total: Shows the total fee billed to insurance (i.e. Amount) for all claims in the grid.

Right-click options: Right-click on a claim row to select one of the following options:

• Go to Account: Jump to the patient's Account module without closing the report window.
• Assign to Me: Assign the claim to the logged-on user.
• Assign to User: Assign the claim to any user.

View Carrier/Plan and Patient/Subscriber Info

Click a row in the Claims grid to view information for the selected row.

Assign Claims to Users

This tool is useful for delegating responsibility for outstanding claims to specific staff members.

1. Highlight the claim(s) to assign.
2. Right-click,
   • select Assign to Me to assign claims to the logged-on user
   • Select Assign to User to assign claims to other users.
3. If assigning claims to another user, choose the user from the list.

Alternatively:

1. Highlight the claim(s) to assign.
2. Click Assign User.
3. Choose user to assign claims to from the list.

To remove claim assignment:

1. Highlight the claim(s) to unassign.
2. Click Assign User.
3. Click Assign None.

Claims can also be reassigned to a different user by following the steps to assign a claim. The claim assignment will be removed from the original user and assigned only to the new user.

Update Claim Tracking Status

Use this tool to change the Track Status and/or Error Code of all claims currently in the grid. The tool is only enabled for users who have the Update Custom Tracking security permission. See Definitions: Claim Custom Tracking for additional information.

1. Change report filter criteria as needed.
2. Click Update Custom Tracking.
   
3. Click the dropdown to select a status.
4. Add a note if desired.
5. Click Update. The Track Status, Error Code and Date Status for all claims will update.

Print the Report

To print the report directly to the printer, click Print.

Export the Report

To export the report as a .txt or .xls file:

1. Click Export.
2. Select the location to save the file, and the file type. The default is the OpenDentalExports folder as set in Data Path Setup.
3. Click Save.