Skip to main content

AR Aging Historical

The data model encompasses measures reflecting the total due, current, and overdue amounts in both home currency (HC) and transaction currency (TC) from customers. It includes segmented views of overdue amounts based on specific day ranges and those exceeding maximum days for both currencies. Two distinct views, AR Historical Aging HC and AR Historical Aging TC, offer historical perspectives on accounts receivable aging categorized by healthcare providers and customer types, respectively.

Benefits of This Data Model​

  • Enhanced Financial Analysis: The data model allows for a detailed analysis of accounts receivable aging trends, providing insights into overdue amounts in both home currency and transaction currency based on specific day ranges.
  • Improved Customer Segmentation: By utilizing dimensions such as Customer Code, Customer Country, Customer State, and Customer City, businesses can segment and analyze accounts receivable data based on customer demographics, facilitating targeted marketing strategies.
  • Historical Performance Tracking: The inclusion of historical aging views offers a comprehensive historical perspective on accounts receivable aging by healthcare providers and customer types, enabling businesses to track performance over time and make informed decisions.
  • Efficient Adjustments Monitoring: Dimensions related to adjusted documents and adjustment types provide transparency and visibility into any account adjustments made, facilitating accurate monitoring of financial adjustments within the system.

Key Performance Indicators (KPIs)​

  • Due Amount HC: The total amount that is due from customers in the home currency.
  • Current Amount HC: The total amount that is currently due from customers in the home currency.
  • Overdue Total HC: The total amount that is overdue from customers in the home currency.
  • Overdue HC @@ARBUCKET01_MIN-@@ARBUCKET01_MAX Days: The total amount that is overdue within a specific range of days in the home currency.
  • Overdue HC @@ARBUCKET02_MIN-@@ARBUCKET02_MAX Days: The total amount that is overdue within another specific range of days in the home currency.
  • Overdue HC @@ARBUCKET03_MIN-@@ARBUCKET03_MAX Days: The total amount that is overdue within yet another specific range of days in the home currency.
  • Overdue HC @@ARBUCKET04+ Days: The total amount that is overdue for more than the maximum days specified in the home currency.
  • AR Amount HC: The total amount in accounts receivable in the home currency.
  • Due Amount TC: The total amount that is due from customers in the transaction currency.
  • Current Amount TC: The total amount that is currently due from customers in the transaction currency.
  • Overdue Total TC: The total amount that is overdue from customers in the transaction currency.
  • Overdue TC @@ARBUCKET01_MIN-@@ARBUCKET01_MAX Days: The total amount that is overdue within a specific range of days in the transaction currency.
  • Overdue TC @@ARBUCKET02_MIN-@@ARBUCKET02_MAX Days: The total amount that is overdue within another specific range of days in the transaction currency.
  • Overdue TC @@ARBUCKET03_MIN-@@ARBUCKET03_MAX Days: The total amount that is overdue within yet another specific range of days in the transaction currency.
  • Overdue TC @@ARBUCKET04+ Days: The total amount that is overdue for more than the maximum days specified in the transaction currency.

Available Visualizations​

View NameDescription
AR Historical Aging HCProvides a historical view of accounts receivable aging by healthcare providers.
AR Historical Aging TCShows the historical aging trends of accounts receivable by type of customer.