Skip to main content

AP Aging Balance Comparison

The data model captures total amount due and overdue amounts in both transaction currency and home currency, segmented by predefined aging bucket ranges. It includes comparisons of overdue balances by transaction code and customer hierarchy for trend analysis and performance evaluation. The model also incorporates geographical data such as country, state/province, and city to provide additional context.

Benefits of This Data Model​

  • Improved Trend Analysis: The data model allows for in-depth trend analysis of overdue balances by transaction code and customer hierarchy for better performance evaluation.
  • Enhanced Geographic Context: By incorporating geographical data such as country, state/province, and city, the model provides valuable context for understanding overdue balances.
  • Segmented Aging Analysis: The model segments overdue amounts into predefined aging bucket ranges, enabling a detailed analysis of overdue balances based on aging categories.
  • Comprehensive Performance Evaluation: The comparisons provided within the model offer a comprehensive view of overdue balances across different dimensions like transaction code, customer hierarchy, and aging categories.

Key Performance Indicators (KPIs)​

  • Transaction Currency Amount Due: Total amount due in the transaction currency.
  • Transaction Currency Current Amount: Total current amount due in the transaction currency.
  • Transaction Currency Overdue Total: Total overdue amount in the transaction currency.
  • Overdue Aging TC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: Total amount overdue in the specified aging bucket range in the transaction currency.
  • Overdue Aging TC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: Total amount overdue in the specified aging bucket range in the transaction currency.
  • Overdue Aging TC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: Total amount overdue in the specified aging bucket range in the transaction currency.
  • Overdue Aging TC @@APBUCKET04_MIN-@@APBUCKET04_MAX Days: Total amount overdue in the specified aging bucket range in the transaction currency.
  • Overdue Aging TC @@APBUCKET05+ Days: Total amount overdue beyond a specified number of days in the transaction currency.
  • Home Currency Amount Due: Total amount due in the home currency.
  • Home Currency Current Amount: Total current amount due in the home currency.
  • Home Currency Overdue Total: Total overdue amount in the home currency.
  • Overdue Aging HC @@APBUCKET01_MIN-@@APBUCKET01_MAX Days: Total amount overdue in the specified aging bucket range in the home currency.
  • Overdue Aging HC @@APBUCKET02_MIN-@@APBUCKET02_MAX Days: Total amount overdue in the specified aging bucket range in the home currency.
  • Overdue Aging HC @@APBUCKET03_MIN-@@APBUCKET03_MAX Days: Total amount overdue in the specified aging bucket range in the home currency.
  • Overdue Aging HC @@APBUCKET04_MIN-@@APBUCKET04_MAX Days: Total amount overdue in the specified aging bucket range in the home currency.
  • Overdue Aging HC @@APBUCKET05+ Days: Total amount overdue beyond a specified number of days in the home currency.
  • Country: Country associated with the data.
  • State/Province: State or province associated with the data.
  • City: City associated with the data.

Available Visualizations​

View NameDescription
Overdue Balance Comparison TCCompares overdue balances by transaction code for trend analysis.
Overdue Balance Comparison HCCompares overdue balances by customer hierarchy for performance evaluation.
Overdue Balance Comparison HCAnalyzes overdue balances by customer hierarchy to identify trends and outliers.