Days to Complete - Report

Overview

The Days to Complete Report provides a detailed view of the data behind the Claims: Days to Complete KPI. It shows how long claims are taking to complete in OneSpot and helps you spot trends by payer, identify workflow delays, and take proactive action to streamline your claims process.

By analyzing this report, your team can make data-driven decisions that improve payment timelines and boost overall operational efficiency.


What the Report Shows

  • Displays all claims marked as Completed based on the selected Date Range, Days to Complete, and Payer filter settings.

  • Only claims with one of the following statuses are included:

  • The Days to Complete value is calculated as: 

    • Complete Date – Claim Date = Days to Complete


Report Filtering Options

Customize your view using these filters:

  • Location: Available only if the upload-by-location feature is enabled for your account; filters claims by your assigned locations. Select All Locations to view all.
  • Date Range: Defaults to the last 90 days. Use the dropdown to select a different time range based on your reporting needs.
  • Days to Complete: All time brackets are selected by default. Choose one or more to focus on specific completion time ranges.
  • Payer: Defaults to All Payers. Select individual payers from the dropdown to narrow your results. Includes both active and inactive payers when "All Payers" is selected.

Note: Location options reflect the locations assigned to your user profile in Admin > Users. If a location is missing, ensure it has been correctly assigned.


Generating the Report

  • Adjust filters as needed and select Update.

  • Select Reset to return filters to default.


Understanding Report Results

The results grid will include the following information:

  • Claim Date
  • Days to Complete
  • Claim #
  • Payer
  • Patient
  • Total
  • Balance
  • Last Worked - Hovering over the 'Last Worked' column will display more information about the last worked action.

Tip: Select any row from the results grid to view the claim and its details.


Visual & Export Options

  • Show Chart: Toggle to see a dynamic graph reflecting your current filters.

  • Export Results: Download a spreadsheet (requires software such as Microsoft Excel, Google Sheets, or a compatible alternative such as Open Office).

    • Note: The exported report will include data only — the chart is not included in the export.