Skip to main content

AR vs AP

The AR vs AP dashboard compares accounts receivable (AR) and accounts payable (AP) to show overdue exposure, outstanding balances, and cash flow context. It helps finance teams balance collections and payments to support liquidity planning.

Benefits of this dashboard​

  • Improve cash‑flow management: Provides visibility into incoming and outgoing cash balances.
  • Track overdue items: Helps prioritize receivables collection and manage outstanding payables.
  • Monitor financial health: Assesses how receivables compare to payables for liquidity planning.
  • Manage customer and vendor relationships: Identifies key accounts with overdue balances for follow‑up.
  • Enable data‑driven decisions: Supports strategic financial planning by comparing income, expenses, and due amounts.

Key metrics at a glance​

  • Aging Receivable: Distribution of outstanding customer invoices by aging bucket (for example, current, 30/60/90+ days).
  • Receivable Overdue vs Total: Comparison of total receivables and overdue balances to show the proportion at risk.
  • Payable Overdue vs Total: Comparison of total payables and overdue balances to show potential payment delay risk.
  • Aging Payable: Distribution of outstanding vendor invoices by aging bucket (for example, current, 30/60/90+ days).

Visual components​

TitleView typeDescription
Aging ReceivableVertical BarShows overdue receivables by aging period.
Receivable Overdue vs TotalGaugeShows total receivables and due amounts.
Payable Overdue vs TotalGaugeShows total payables and due amounts.
Aging PayableVertical BarShows overdue payables by aging period.
Top 10 Customer AR DueStacked BarLists the customers with the highest overdue balances.
Income and ExpensesVertical BarCompares revenue, expenses, and other income to support financial health review.
Top 10 Vendors AP DueStacked BarHighlights the vendors with the highest outstanding payables.

Filters​

You can filter the dashboard with these panels:

  • Customer
  • Vendor