Past Due Analysis Dashboard

Summary

The Past Due Analysis dashboard is a systematic examination of financial accounts, invoices, and obligations that have exceeded their due dates without being settled.

It is a powerful analytical tool designed to assist you in comprehensively assessing and managing overdue items, outstanding amounts, and related trends within your financial records or business operations.

This dashboard provides valuable insights into financial obligations that have not been settled within the expected timeframes, allowing you to take informed actions to address outstanding matters.

When to Use

Use the Past Due Analysis dashboard as critical tool for managing overdue financial obligations, protecting your cash flow, and making informed decisions that contribute to the financial health and stability of your business.

Below are a few examples of using this dashboard.

• Debt Management

• Client and Customer Communication

• Risk Assessment

• Collections Strategy

• Financial Planning

• Customer Relationships

• Performance Tracking

• Cash Flow Optimization

Key Performance Indicators (KPIs)

This dashboard includes the following key metrics and charts.

• Current Past Due Count: Shows a total count of active members who are past due. This KPI is not affected by the date range.

• Members Past Due %: Shows the percentage of active members who are past due. This KPI is not affected by the selected date range. Calculation: (Count of Members Past Due / All Active Members) x 100.

• Current Past Due Amt: Shows the total dollar amount currently past due for active members. This KPI is not affected by the date range.

• Past Due Collected: Shows the total dollar amount of collected past due invoices for the selected date range.

• Past Due Collected %: Shows the percentage of past due revenue collected out of the total billed amount for the selected date range.

Charts

• Current Past Due by Age Range: Reflects the active member count and past due amount grouped by age range. This chart is not affected by the date range.

• Current Past Due by Membership Type: Shows the active members who are past due grouped by membership type. This chart is not affected by the date range.

• Past Due Collected by Age Range: Shows the total dollar amount of collected past due invoices grouped by invoice age for the selected date range.

• Transaction Details: Shows detailed information about past due transactions.

• Member Details: Shows detailed information about the active members who are past due.

Essential Definitions

Past Due

Refers to a financial or contractual obligation that has not been fulfilled within the agreed-upon or expected timeframe. In the context of invoices, an amount is considered past due if it remains unpaid after its due date has passed. Past due accounts may incur penalties, fees, or other consequences as outlined in the terms of the agreement.

Illustrations