Past Due Analysis Dashboard

View Document Details

Topic Revised: 2024 04 30 T12:44:10 UTC; April 30, 2024 at 12:44:10
Topic Created: 2024 04 26 T12:40:51 UTC; April 26, 2024 at 12:40:51
Help System Last Build: 2024 05 03 T11:59:15 UTC

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.

These are the iSeries and Commerce billing system icons.

Commerce and iSeries Dashboard

This dashboard supports both billing systems, Commerce Transact and iSeries.

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)

Key Performance Indicators

(KPIs) are measurable values that help gauge the success of your business. They provide insights into performance, progress, and the achievement of goals.

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

Chart

Charts are graphical representations of data. They visually depict trends, patterns, and relationships within datasets. They help users visualize data to understand trends and make informed decisions.

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

dashboard