Skip to main content

AP Aging Balance Historical

The data model captures various aspects of overdue amounts in transaction currency and home currency. It includes measures such as total amount due, current amount due, total overdue amount, and overdue amounts distributed across different aging bucket ranges in both transaction currency and home currency. The model also provides insights into historical overdue balance trends for trade and non-trade creditors in both currencies.

Benefits of This Data Model​

  • Improved Analysis: Provides detailed insights into historical overdue balance trends for both trade and non-trade creditors in transaction and home currencies, enhancing the ability to analyze and understand payment patterns.
  • Enhanced Decision-Making: Allows for better decision-making based on overdue amounts in different aging bucket ranges, enabling proactive measures to be taken to manage outstanding payments effectively.
  • Efficient Vendor Management: Facilitates efficient vendor management through the ability to track overdue amounts in transaction and home currencies, leading to improved vendor relationships and better cash flow management.

Key Performance Indicators (KPIs)​

  • Transaction Currency Amount Due: This measure represents the total amount due in the transaction currency.
  • Transaction Currency Current Amount: The current amount due in the transaction currency.
  • Transaction Currency Overdue Total: Total amount overdue in the transaction currency.
  • Overdue Aging TC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: Amount overdue in the transaction currency for a specific aging bucket range.
  • Overdue Aging TC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: Amount overdue in the transaction currency for another specific aging bucket range.
  • Overdue Aging TC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: Amount overdue in the transaction currency for a different aging bucket range.
  • Overdue Aging TC @@APBUCKET04_MIN-@@APBUCKET04_MAX Days: Amount overdue in the transaction currency for yet another aging bucket range.
  • Overdue Aging TC @@APBUCKET05+ Days: Amount overdue in the transaction currency for accounts with the highest aging.
  • Home Currency Amount Due: The total amount due in the home currency.
  • Home Currency Current Amount: Current amount due in the home currency.
  • Home Currency Overdue Total: Total amount overdue in the home currency.
  • Overdue Aging HC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: Amount overdue in the home currency for a specific aging bucket range.
  • Overdue Aging HC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: Amount overdue in the home currency for another specific aging bucket range.
  • Overdue Aging HC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: Amount overdue in the home currency for a different aging bucket range.
  • Overdue Aging HC @@APBUCKET04_MIN-@@APBUCKET04_MAX Days: Amount overdue in the home currency for yet another aging bucket range.
  • Overdue Aging HC @@APBUCKET05+ Days: Amount overdue in the home currency for accounts with the highest aging.

Available Visualizations​

View NameDescription
Historical Overdue Balance TCAnalyzes total overdue balance trends across time for trade creditors.
Historical Overdue Balance HCExamines historical overdue balance patterns for non-trade creditors.