Skip to main content

AR and AP

The AR and AP (Accounts Receivable and Accounts Payable) Dashboard provides insights into outstanding receivables and payables, overdue balances, cash flow trends, and overall financial performance. This dashboard helps organizations manage liquidity, track overdue amounts, and optimize financial operations.

Key Metrics at a Glance:​

  • Aging Receivable: Breakdown of outstanding customer payments by aging periods (e.g., current, 1-30 days, 31-60 days, etc.).
  • Receivable Overdue vs Total:
    • Overdue Total HC: The total overdue receivables.
    • Due Amount HC: The total amount due from customers.
  • Payable Overdue vs Total:
    • Overdue Total HC: The total overdue payables.
    • Amount Due HC: The total amount due to vendors.
  • Aging Payable: Breakdown of outstanding vendor payments by aging periods.

Visual Components:​

  • Top 10 Customers AR Due: A bar chart displaying the top customers with outstanding receivables categorized by aging periods.
  • Cash Flow - Rolling 12 Months: A bar and line chart tracking cash inflows and outflows over the past 12 months.
  • Top 10 Vendors AP Due: A bar chart highlighting vendors with the highest outstanding payables.
  • Income and Expenses: A bar and line chart comparing monthly income, expenses, and profit trends.

Benefits of this Dashboard:​

  • Improved Cash Flow Management: Helps monitor and optimize cash inflows and outflows.
  • Better Receivable Collection: Identifies overdue receivables to prioritize collection efforts.
  • Vendor Payment Tracking: Monitors outstanding payables to manage supplier relationships efficiently.
  • Financial Performance Analysis: Tracks revenue, expenses, and profit trends over time.
  • Liquidity Optimization: Helps businesses maintain a healthy cash position by balancing receivables and payables.

Filtering​

You can filter the dashboards using these filtering panels:

  • Date
  • Ledger