Skip to main content

AP Aging Historical

The data model includes measures such as Amount Due, Current Amount, and Overdue Total in both home currency and transaction currency. It also captures overdue amounts within specified time buckets and for more extended periods. The model provides insights into accounts payable aging trends and payment statuses for healthcare and technology industries through the AP Historical Aging views.

Benefits of This Data Model​

  • Enhanced Accounts Payable Aging Analysis: The data model allows for in-depth analysis of accounts payable aging trends across different time periods and highlights overdue amounts within specified buckets, providing valuable insights into payment statuses for healthcare and technology industries.
  • Vendor Performance Tracking: Enables tracking and measuring vendor performance based on amounts due in both home currency and transaction currency, facilitating vendor evaluation and decision-making processes.
  • Segmented Subaccount Analysis: Offers the ability to analyze accounts payable data based on segmented subaccounts, providing a detailed breakdown of expenses and payments across various categories, enhancing financial transparency.
  • Multi-Currency Payment Monitoring: Facilitates monitoring of current amounts and overdue totals in both home currency and transaction currency, allowing for effective management of cross-border transactions and currency fluctuations.

Key Performance Indicators (KPIs)​

  • Amount Due HC: The total amount due in the home currency.
  • Current Amount HC: The current total amount due in the home currency.
  • Overdue Total HC: The total amount overdue in the home currency.
  • Overdue HC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: The total amount overdue in the home currency within the specified bucket of days.
  • Overdue HC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: The total amount overdue in the home currency within the specified bucket of days.
  • Overdue HC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: The total amount overdue in the home currency within the specified bucket of days.
  • Overdue HC @@APBUCKET04+ Days: The total amount overdue in the home currency for more than the specified number of days.
  • AP Amount HC: The total amount in the accounts payable in the home currency.
  • Amount Due TC: The total amount due in the transaction currency.
  • Current Amount TC: The current total amount due in the transaction currency.
  • Overdue Total TC: The total amount overdue in the transaction currency.
  • Overdue TC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: The total amount overdue in the transaction currency within the specified bucket of days.
  • Overdue TC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: The total amount overdue in the transaction currency within the specified bucket of days.
  • Overdue TC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: The total amount overdue in the transaction currency within the specified bucket of days.
  • Overdue TC @@APBUCKET04+ Days: The total amount overdue in the transaction currency for more than the specified number of days.

Available Visualizations​

View NameDescription
AP Historical Aging HCDisplays aging of accounts payable for healthcare industry, historical trends and payment statuses.
AP Historical Aging TCShows aging of accounts payable for technology companies, historical trends and payment statuses.