Skip to main content

Accounts Payable

This Accounts Payable (AP) Dashboard provides a comprehensive overview of outstanding payables, overdue amounts, supplier payment performance, and trends in invoice payments. It helps track overdue debts, identify payment bottlenecks, and optimize cash flow management.

Key Metrics at a Glance:​

  • Due Amount (%): Displays the percentage of total due payables.
  • Base Amount: Total outstanding payable balance.
  • Base Paid Amount: Amount of payables already settled.
  • Base Due Amount: Amount currently due for payment.
  • Base Current Amount: Amount of accounts payable that are not overdue.
  • Base Overdue Amount: Amount of payables past their due date.

Visual Components:​

  • Top 10 Vendors by Overdue Amount: Identifies vendors with the highest overdue payables.
  • Purchase, Paid, and Overdue by Period: A combined bar and area chart showing purchase trends, payments made, and overdue amounts over time.
  • AP Aging Trend (Bill Count): Tracks the number of overdue invoices across different aging categories (1-30 days, 31-60 days, 61-90 days, and 91+ days).
  • Average Age at Payment: Displays the average duration taken to clear invoices.

Benefits of this Dashboard:​

  • Better Cash Flow Management: Helps ensure timely payments and avoid liquidity issues.
  • Improved Supplier Relationships: Identifies overdue payments that could harm supplier partnerships.
  • Risk Mitigation: Alerts management about high overdue amounts to prevent financial instability.
  • Data-Driven Decision-Making: Supports strategic financial planning with real-time AP insights.
  • Payment Performance Analysis: Tracks trends in payment delays and helps improve efficiency.

Filtering​

You can filter the dashboards using these filtering panels:

  • Company
  • Year
  • Location
  • Vendor
  • Vendor Type