Skip to main content

Accounts Receivable

The Accounts Receivable (AR) Dashboard provides an overview of outstanding receivables, overdue amounts, customer payment behavior, and aging trends. This dashboard helps businesses monitor cash flow, track overdue invoices, and optimize collection strategies.

Key Metrics at a Glance:​

  • Base Amount: The total outstanding receivables.
  • Base Paid Amount: The amount of receivables that have been collected.
  • Base Due Amount: The total amount that is currently due.
  • Base Amount Overdue %: The percentage of receivables that are overdue.

Visual Components:​

  • Top 10 Overdue by Customer: Identifies the customers with the highest overdue balances.
  • Overdue by Aging Bucket: A pie chart categorizing overdue amounts into different aging periods (1-30 days, 31-60 days, 61-90 days, and 91+ days).
  • Overdue by Aging Category: A bar chart displaying overdue amounts across different months.
  • Overdue Amount Over Time: A combined bar and line chart tracking overdue amounts and overdue percentage trends over the months.

Benefits of this Dashboard:​

  • Enhanced Cash Flow Management: Helps track outstanding receivables and reduce overdue payments.
  • Customer Payment Behavior Analysis: Identifies customers with slow payment trends for better follow-up.
  • Aging Analysis for Risk Mitigation: Helps businesses assess overdue invoices and prioritize collection efforts.
  • Data-Driven Decision-Making: Supports proactive strategies to improve accounts receivable turnover.
  • Improved Financial Planning: Enables businesses to forecast cash flow based on outstanding and overdue invoices.

Filtering​

You can filter the dashboards using these filtering panels:

  • Company
  • Year
  • Location
  • Customer
  • Customer Type