Aged Creditors

The data model encompasses information on amounts owed to creditors categorized by due periods, currency, and overdue durations. It includes measures such as Base Amount, Base Due in X Days, Base Overdue by X Days, Currency Amount, Currency Due in X Days, and Currency Overdue by X Days. Key views offer insights into outstanding invoices by due date and currency, top creditors based on outstanding balance, and analysis of outstanding balance by supplier category.

Benefits of This Data Model

• Enhanced creditor management: The data model allows for detailed tracking of amounts owed to creditors based on due periods, currency, and overdue durations, enabling improved creditor management strategies.
• Improved financial analysis: By providing insights into outstanding invoices by due date and currency, top creditors based on outstanding balance, and analysis of outstanding balance by supplier category, the data model facilitates enhanced financial analysis for better decision-making.
• Streamlined supplier evaluation: Through the analysis of outstanding balance based on supplier category, the data model supports streamlined supplier evaluation processes, helping in identifying strengths and weaknesses in the supplier base.
• Efficient cash flow management: With measures like Base Due in X Days and Currency Overdue by X Days, the data model aids in effective cash flow management by providing a clear picture of when payments are due and identifying overdue amounts promptly.

Key Performance Indicators (KPIs)

• Base Amount: The total amount of money owed to creditors.
• Base Due in 1 - 30 Days: The amount of money due to creditors within 1 to 30 days.
• Base Due in 31 - 60 Days: The amount of money due to creditors within 31 to 60 days.
• Base Due in 61 - 90 Days: The amount of money due to creditors within 61 to 90 days.
• Base Due in 91 - 120 Days: The amount of money due to creditors within 91 to 120 days.
• Base Due in 120+ Days: The amount of money due to creditors after 120 days.
• Base Open Amount: The total unpaid amount currently open with creditors.
• Base Open Cash: The total open amount that is payable in cash to creditors.
• Base Open Non-Cash: The total open amount that is payable through non-cash means to creditors.
• Base Overdue by 0 - 30 Days: The amount that is overdue to creditors by 0 to 30 days.
• Base Overdue by 31 - 60 Days: The amount that is overdue to creditors by 31 to 60 days.
• Base Overdue by 61 - 90 Days: The amount that is overdue to creditors by 61 to 90 days.
• Base Overdue by 91 - 120 Days: The amount that is overdue to creditors by 91 to 120 days.
• Base Overdue by 120+ Days: The amount that is seriously overdue to creditors by more than 120 days.
• Currency Amount: The total amount owed to creditors in different currencies.
• Currency Due in 1 - 30 Days: The amount due to creditors in different currencies within 1 to 30 days.
• Currency Due in 31 - 60 Days: The amount due to creditors in different currencies within 31 to 60 days.
• Currency Due in 61 - 90 Days: The amount due to creditors in different currencies within 61 to 90 days.
• Currency Due in 91 - 120 Days: The amount due to creditors in different currencies within 91 to 120 days.
• Currency Due in 120+ Days: The amount due to creditors in different currencies after 120 days.
• Currency Open Amount: The total unpaid amount currently open with creditors in different currencies.
• Currency Open Cash: The open amount payable in cash to creditors in different currencies.
• Currency Open Non Cash: The open amount payable through non-cash means to creditors in different currencies.
• Currency Overdue by 0 - 30 Days: The amount that is overdue to creditors in different currencies by 0 to 30 days.
• Currency Overdue by 31 - 60 Days: The amount that is overdue to creditors in different currencies by 31 to 60 days.
• Currency Overdue by 61 - 90 Days: The amount that is overdue to creditors in different currencies by 61 to 90 days.
• Currency Overdue by 91 - 120 Days: The amount that is overdue to creditors in different currencies by 91 to 120 days.
• Currency Overdue by 120+ Days: The amount that is seriously overdue to creditors in different currencies by more than 120 days.
• Days Overdue: The number of days by which the payment to creditors is overdue.

Available Visualizations

View Name	Description
Outstanding Supplier Invoices by Due Date (Base)	Provides insights into outstanding invoices by due date
Outstanding Supplier Invoices by Due Date (Currency)	Offers insights on outstanding invoices by currency
Top 20 Creditors (Outstanding Balance)	Displays top 20 creditors based on outstanding balance
Top 20 Creditors (Oldest Outstanding Items)	Shows top 20 creditors with the oldest outstanding items
Outstanding Balance by Supplier Category	Analyzes outstanding balance based on supplier category
Outstanding Balance by Supplier Category (Dashboard)	Dashboard view of outstanding balance by supplier category