MI-BI: Financial Payment Details

 

Summary:

  • Compare payment activity for the past 4 months by payment entry date.
  • Use page slicers to filter data.
  • Date slicers apply filters only to that page; other slicers sync between pages.
  • Click MI-BI logo to reset to default settings.
  • Hover or click on specific charts and graphs for tooltips with summary information.
  • Cross-filterby clicking in charts to change the other visuals on the same page.
  • Charge/Payment details are available on the last page of the report, “Charge/Payment Details”, by right-clicking in the table/grid or within one of the charts and selecting “drillthrough”.
  • Right-click options include:
    • Drillthrough takes you to a page with standard slicers to filter data.
    • Show data displays details on the same page.
    • See records takes you to a new page without sorting or filter capabilities.

Payment Summary

 

 

  1. Use page slicers to filter by one or more attributes.
  2. Date range included in this report based on payment entry date.
  3. Total Payment amount posted within date range.
  4. Average number of Days to Post between service date and payment entry date.
  5. Total payments posted is categorized by Service Date (month) to show the dollar amount captured in relation to the service date.
  6. Visualize the proportion of Payments by Patient Type. Cross-filter by clicking a Patient Type to update the rest of the page.

Payment Trends

 

 

  1. Use the bookmark to toggle report by Payment Entry Date, Payment Date, or Service Date.
  2. Total Payment amount posted within date range.
  3. Compare payment posted by payment type.
  4. Review payment amount by entry date over time

Write-offs/Adjustments

 

 

  1. Total amount of Write-offs and Adjustments entered in the past four months.
  2. Average number of days to post write-offs and/or adjustments from the service date.
  3. Review proportion of payments by payment type and description. Cross-filter by clicking a payment type or description to update the rest of the page.

Payments by Payor

 

 

  1. Total amount of insurance payments.
  2. Average number of days to post insurance payments from service date.
  3. Review proportion of payments by Collection Class and Payer. Cross-filter by clicking a class or insurance carrier to update the rest of the page.

Payment Details

 

 

  1. Shows exam-level detail of the underlying data for the preceding reports. Most useful when the drill through feature is used to focus on a specific subset of data. Click on a column header to sort by any column.
  2. Use the arrow to return to the previous page.