Skip to main content

AR Aging Balance Historical

The data model comprises measures such as Transaction Currency Amount Due, Transaction Currency Current Amount, Transaction Currency Overdue Total, and various Overdue Balance measures across aging ranges. Additionally, it includes Home Currency Amount Due, Home Currency Current Amount, Home Currency Overdue Total, and corresponding Overdue Aging measures in both transaction currency and home currency views, offering insights into overdue balances historically and based on aging periods for each customer.

Benefits of This Data Model​

  • Comprehensive Customer Insights: The data model allows for a detailed analysis of overdue balances historically and based on aging periods for each customer, providing valuable insights into customer payment behavior.
  • Multi-Currency Analysis: By incorporating both transaction currency and home currency views, the data model enables a comprehensive analysis of overdue balances in different currencies, facilitating better decision-making for international businesses.
  • Performance Tracking: With measures such as Transaction Currency Amount Due and Home Currency Current Amount, the data model offers the ability to track performance metrics related to overdue balances over time, helping in monitoring financial health and identifying trends.
  • Tailored Aging Analysis: Through the inclusion of Overdue Balance measures across aging ranges and Overdue Aging measures in both transaction currency and home currency views, the data model supports customized analysis of overdue balances based on specific aging categories, aiding in targeted collections strategies.

Key Performance Indicators (KPIs)​

  • Transaction Currency Amount Due: The total amount due in the transaction currency.
  • Transaction Currency Current Amount: The total current amount in the transaction currency.
  • Transaction Currency Overdue Total: The total overdue amount in the transaction currency.
  • Overdue Balance TC @@ARBUCKET01_MIN-@@ARBUCKET01_MAX Days: The total overdue balance in the transaction currency for a specific aging range.
  • Overdue Balance TC @@ARBUCKET02_MIN-@@ARBUCKET02_MAX Days: The total overdue balance in the transaction currency for a different aging range.
  • Overdue Balance TC @@ARBUCKET03_MIN-@@ARBUCKET03_MAX Days: The total overdue balance in the transaction currency for another aging range.
  • Overdue Balance TC @@ARBUCKET04_MIN-@@ARBUCKET04_MAX Days: The total overdue balance in the transaction currency for yet another aging range.
  • Overdue Balance TC @@ARBUCKET05+ Days: The total overdue balance in the transaction currency for accounts aged over a certain number of days.
  • Home Currency Amount Due: The total amount due in the home currency.
  • Home Currency Current Amount: The total current amount in the home currency.
  • Home Currency Overdue Total: The total overdue amount in the home currency.
  • Overdue Aging HC @@ARBUCKET01_MIN-@@ARBUCKET01_MAX Days: The total overdue aging balance in the home currency for a specific aging range.
  • Overdue Aging HC @@ARBUCKET02_MIN-@@ARBUCKET02_MAX Days: The total overdue aging balance in the home currency for a different aging range.
  • Overdue Aging HC @@ARBUCKET03_MIN-@@ARBUCKET03_MAX Days: The total overdue aging balance in the home currency for another aging range.
  • Overdue Aging HC @@ARBUCKET04_MIN-@@ARBUCKET04_MAX Days: The total overdue aging balance in the home currency for yet another aging range.
  • Overdue Aging HC @@ARBUCKET05+ Days: The total overdue aging balance in the home currency for accounts aged over a certain number of days.

Available Visualizations​

View NameDescription
Historical Overdue Balance TCDisplays total overdue balance historically for each customer
Historical Overdue Balance HCShows historical overdue balance per time period for each customer