AP Reports

The data model includes measures such as Vendor Credit Limit, Transaction Amount, Transaction Paid Amount, Transaction Due Amount, Transaction Overdue Amount, and various time-bucketed transaction amounts. Views comprise AP Aging Reports in both base and transaction currencies, as well as a comparison of Vendor Credit to Credit Limit in the base currency. Additionally, there are custom reporting amounts and base transaction details. This model facilitates tracking payables, analyzing credit limits, and monitoring overdue payments across different currencies and time frames efficiently.

Benefits of This Data Model

• Efficient Tracking: The data model allows for the efficient tracking of payables, enabling better management of outstanding balances across different currencies and time frames.
• Credit Limit Analysis: Facilitates in-depth analysis of vendor credit limits compared to credit balances, helping to ensure vendors operate within their specified limits in the base currency.
• Overdue Payment Monitoring: Provides comprehensive tools for monitoring overdue payments, allowing for timely actions to be taken to avoid potential financial risks.
• Accurate Reporting: Enhances reporting accuracy by offering both base and transaction currency AP aging reports, ensuring precise insights into outstanding balances while excluding credit card transactions for more detailed analysis.

Key Performance Indicators (KPIs)

• Vendor Credit Limit: The maximum credit amount a vendor is allowed to have with the company.
• Transaction Amount: The total amount of a transaction.
• Transaction Paid Amount: The amount that has been paid for a transaction.
• Transaction Due Amount: The amount that is still due to be paid for a transaction.
• Transaction Overdue Amount: The amount that is past its due date for a transaction.
• Transaction Current Amount: The current amount of a transaction that is not overdue.
• Transaction 1-30 Days: The amount of transactions that are due between 1 and 30 days.
• Transaction 31-60 Days: The amount of transactions that are due between 31 and 60 days.
• Transaction 61-90 Days: The amount of transactions that are due between 61 and 90 days.
• Transaction 91+ Days: The amount of transactions that are due more than 90 days.
• Reporting Amount (You Reporting Currency): The reported amount in a specific currency for financial reporting purposes.
• Reporting Paid Amount (You Reporting Currency): The amount that has been paid in a specific currency for financial reporting purposes.
• Reporting Due Amount (You Reporting Currency): The amount that is due to be paid in a specific currency for financial reporting purposes.
• Reporting Current Amount (You Reporting Currency): The current amount in a specific currency for financial reporting purposes that is not overdue.
• Reporting 1-30 Days (You Reporting Currency): The amount that is due between 1 and 30 days in a specific currency for financial reporting purposes.
• Reporting 31-60 Days (You Reporting Currency): The amount that is due between 31 and 60 days in a specific currency for financial reporting purposes.
• Reporting 61-90 Days (You Reporting Currency): The amount that is due between 61 and 90 days in a specific currency for financial reporting purposes.
• Reporting 91+ Days (You Reporting Currency): The amount that is due more than 90 days in a specific currency for financial reporting purposes.
• Base Amount: The base amount of a transaction.
• Base Paid Amount: The amount that has been paid for a base transaction.
• Base Due Amount: The amount that is still due to be paid for a base transaction.
• Base Overdue Amount: The amount that is past its due date for a base transaction.
• Base Current Amount: The current amount of a base transaction that is not overdue.
• Base 1-30 Days: The amount of base transactions that are due between 1 and 30 days.
• Base 31-60 Days: The amount of base transactions that are due between 31 and 60 days.
• Base 61-90 Days: The amount of base transactions that are due between 61 and 90 days.
• Base 91+ Days: The amount of base transactions that are due more than 90 days.

Available Visualizations

View Name	Description
AP Aging Report (Base Currency)	Provides a summary of outstanding accounts payable balances in base currency.
AP Aging Report (Base Currency - Exclude Credit Card Transactions)	Similar to base currency report, but excludes credit card transactions for accurate analysis.
Vendor Credit vs Credit Limit (Base Currency)	Compares vendor credit balances to their credit limits in base currency.
AP Aging Report (Tansaction Currency)	Summary of outstanding accounts payable balances in transaction currency.
AP Aging Report (Transaction Currency - Exclude Credit Card Transactions)	Like transaction currency report, excluding credit card transactions for precise insights.