Setting Aging Analysis Parameters

When users first open the Aging Analysis, they will see at the top of the screen a list of parameters to use for the report. After making selections from the below, they will choose the Run Report option underneath the parameters to run the report:

  1. Report Options: These parameters allow users to make changes to the underlying functionality of the report.



    1. Patient Aging By: Here the user can select which date to use as the foundation for the patient aging.  
      1. Aging Date (Default): The aging date is the date the first statement was sent to the patient for the claim in question. If comparing against MGMA standards, we would recommend viewing patient A/R by Aging Date.
      2. Date of Service: This is the date the service was performed.
    2. Insurance Aging By: Here the user can select which date to use as the foundation for the patient aging.
      1. Date of Service (Default): The aging date is the date the first statement was sent to the patient for the claim in question. If comparing against MGMA standards, we would recommend viewing patient A/R by Aging Date.
      2. Aging Date: This is the date the claim was first sent to the Aging Payer. 
    3. Include Non-Completed Zero Balances: Allows users to include zero balances if they are not at the 'Completed' claim level. This can be used if certain statuses contain claims that need to be worked even if they have zero balances (for instance, if we know a takeback is imminent and want to continue to discuss the claim with the payer). 
    4. Credits: This can be used to include or exclude claims with credits.
      1. Credits Only: This option will show only credits on the report's results, excluding receivables. 
      2. Exclude Credits (Default): This will exclude credit balances from the report's results. If comparing KPI against MGMA standards, or when working only receivable balances, we would recommend excluding credits from the results. 
      3. Include Credits: This will include both credits and receivables on the report's results.
    5. Do Not Bill: This can be used to include or exclude Do Not Bill balances from the report. These are balances that are in a hold status -- either because the procedure codes were marked as Do Not Bill on the claim entry screen or because the claim level is Statement but the claim status won't be sent to the patient. 
      1. Do Not Bill Only: This option will show only Do Not Bill items on the report's results. This version of the report can be used to view items that are not being billed, to either write them off or modify their status.
      2. Exclude Do Not Bill: This option will exclude Do Not Bill lines and claims from the report's results. 
      3. Include Do Not Bill: This option will show all receivables on the report's results, including Do Not Bill lines and claims. 
    6. Claims with Future Followup Dates: Allows the user to include or exclude claims with future follow-up dates, for the purpose of finding items that are currently in a state of needing to be worked. 
    7. Group: This allows the user to select what the grouping on the report will be. The field selected here is what the returned information on the report will be grouped by.
    8. Sub-Group: This allows the user to select an optional additional grouping on the report. 
    9. Tertiary Group: This allows the user to select an optional third grouping on the report. 
    10. Report By: This allows the user to select what the grouping on the report will be. The field selected here is what the returned information on the report will be grouped by.
      1. Aging Type: The aging categorization from the following options: 
        1. Unsubmitted: The claim level is not 'Statement,' but a claim has not yet been sent to a payer. 
        2. Insurance: The claim level is not 'Statement,' and a claim has been sent to at least one payer. 
        3. Patient: The claim level is 'Statement,' indicating that this balance is with the patient. 
        4. Incomplete: The claim level is 'Completed,' but there is a non-zero balance. 
      2. Aging Payer: The payer at the highest level that had a claim sent (i.e., the primary payer if the only claim sent was to the primary payer).
      3. Aging Financial Class: The financial class of the Aging Payer. 
      4. Claim Level: The level of the claim, indicating whether the claim is with the Primary, Secondary, Tertiary payers, with the patient (the Statement level), or Completed. 
      5. Claim Owner: The user set to be the Claim Owner. 
      6. Claim Primary Payer: The primary payer on the claim. This can be used instead of Aging Payer if you would like a single biller to be responsible for a given claim through its full insurance lifecycle. 
      7. Claim Primary Financial Class: The financial class of the primary payer on the claim. This can be used instead of Aging Financial Class if you would like a single biller to be responsible for a given claim through its full insurance lifecycle. 
      8. Claim Status: The Claim Status on the claim.
      9. Location: The Service Location on the claim.
      10. Rendering Provider: The Rendering Provider on the claim.

  2. Report Filters: This area allows users to include or exclude certain values of each of the below fields. For instance, it will allow a user to only view Blue Cross Blue Shield claims, or to see only one Rendering Provider's receivables. To select more than one item, either hold CTRL and click on additional items, or to select a consecutive list, hold SHIFT and click the end of the series.



    1. Aging Bucket: This filter allows the user to only see a certain set of Aging Buckets if desired. 
    2. Aging Type: This filter allows the user to only see certain aging types if desired, out of the following: 
      1. Unsubmitted: The claim level is not 'Statement,' but a claim has not yet been sent to a payer. 
      2. Insurance: The claim level is not 'Statement,' and a claim has been sent to at least one payer. 
      3. Patient: The claim level is 'Statement,' indicating that this balance is with the patient. 
      4. Incomplete: The claim level is 'Completed,' but there is a non-zero balance.
    3. Aging Financial Class: This field filters on the financial class of the payer the claim is currently with (the payer at the current Claim Level). 
    4. Service Location: This field filters on the service location on the claim. 
    5. Rendering Provider: This field filters on the rendering provider on the claim. 
    6. Claim Owner: This field filters on the Owner on the claim. 
    7. Claim Status: This field filters on the claim's status. 
    8. Claim Level: This field filters on the claim's level. 
    9. Patient Last Name: This field allows the user to filter on part of the patient's last name.