Skip to main content

Account Receivable

This Accounts Receivable (AR) Dashboard provides an overview of outstanding receivables, overdue amounts, customer payment performance, and trends in invoice collections. It helps track unpaid invoices, identify overdue customers, and optimize cash flow management.

Key metrics at a glance:​

  • Current Receivables by Age: Displays the total outstanding receivables that are not overdue.
  • Overdue Receivables by Age: Highlights overdue receivables, categorized by aging periods (e.g., 91+ days overdue).
  • Total Receivables Amount: Represents the total outstanding amount across all customers.
  • Average Days to Pay: The average number of days customers take to settle invoices.
  • Average Overdue Days: The average delay in overdue receivables.
  • Top 10 Current AR Amount by Customer: Identifies customers with the highest outstanding but not overdue receivables.
  • Top 10 Overdue AR Amount by Customer: Lists customers with the highest overdue amounts, helping prioritize collections.
  • Top 5 Payment Methods: Displays the most frequently used payment methods.
  • Average Payment Days by Month: Tracks trends in payment delays and invoice collections over time.

Benefits of this dashboard:​

  • Improved Cash Flow Management: Helps maintain a steady inflow of payments and reduce outstanding debts.
  • Customer Payment Insights: Identifies customers with delayed payments, allowing proactive follow-ups.
  • Risk Reduction: Highlights overdue amounts that could impact financial stability.
  • Data-Driven Decision-Making: Supports collection strategies with real-time AR insights.
  • Optimized Payment Terms: Helps refine credit policies and payment terms for different customers.

Filtering​

You can filter the dashboards using these filtering panels:

  • Year
  • Month
  • Company
  • Customer