// Filename: docs/concepts/accounts-receivable-dashboard.concept.md

The Accounts Receivable KPI Dashboard

1. Purpose

The Accounts Receivable (AR) KPI Dashboard serves as the central command center for managing the company's incoming cash flow and credit health. Its primary purpose is to transform raw financial data into actionable business insights, enabling quick and informed decision-making.

This dashboard provides a single source of truth for two critical business functions:

1. Collections & Credit Management: Monitoring how effectively and efficiently the company collects money owed by its customers.
2. Sales Commission Analytics: Tracking the commissions earned by the sales team, which represents a key financial liability and a primary driver of sales performance.

2. Audience and Roles

This dashboard is designed to serve multiple roles within the organization:

• Finance Managers & Controllers: Use the dashboard to monitor overall financial health, forecast cash flow, identify credit risks, and analyze the financial impact of sales commissions.
• Accounts Receivable Clerks: Use the "Receivables Health" tab for daily operations, prioritizing collections efforts, and identifying customers who require immediate attention.
• Sales Managers: Use the "Commission Analytics" tab to track team and individual performance, understand commission liabilities, and ensure timely and accurate payouts.
• Executives (CEO/CFO): Use the high-level KPIs on both tabs to get a quick, strategic overview of the company's financial performance and sales efficiency.

3. Dashboard Layout: Two Functions, Two Views

The dashboard is organized into two distinct tabs to provide a focused view for different business needs.

• Receivables Health: This tab focuses on the core "health" of your accounts receivable. It answers the question: "Are we collecting the money we are owed in a timely and effective manner?"
• Commission Analytics: This tab focuses on the performance and financial liability of the sales commission program. It answers the question: "How much do we owe our sales team, and how is the program performing?"

4. Explaining the KPIs: Receivables Health Tab

This section explains each metric and visualization on the Receivables Health tab.

Days Sales Outstanding (DSO)

• What it Measures: The average number of days it takes for the company to receive payment after a sale has been made.
• Why it's Important: DSO is a direct measure of your cash flow efficiency. A low DSO means you are collecting cash quickly. A high or rising DSO can signal problems with your collections process.
• How to Interpret it:
  • Lower is Better: A lower DSO is almost always preferable.
  • Trend (▲/▼): The trend arrow shows whether your DSO is improving (decreasing) or worsening (increasing) compared to the previous period.
• How it's Calculated:

  (Total Outstanding AR at End of Period / Total Credit Sales in Period) * Number of Days in Period

Collection Effectiveness Index (CEI)

• What it Measures: A percentage that shows how effective your AR team is at collecting money that was available to be collected during a specific period.
• Why it's Important: This KPI isolates the performance of your collections team from factors like fluctuating sales. It helps you understand if your team is successfully collecting on both current and past-due invoices.
• How to Interpret it:
  • Higher is Better: A score closer to 100% indicates a highly effective collections process. A consistently low score may indicate a need for process improvement or staff training.
• How it's Calculated:

  (Beginning AR + Credit Sales in Period - Ending AR) 
  -------------------------------------------------------------------------  * 100
  (Beginning AR + Credit Sales in Period - Ending Current Receivables)

  • Beginning AR: Total money owed at the start of the period.
  • Ending AR: Total money owed at the end of the period.
  • Ending Current Receivables: Total money owed for invoices that are not yet past due at the end of the period.

AR Turnover Ratio

• What it Measures: How many times your company converts its accounts receivable into cash during a given period (usually a year).
• Why it's Important: This is a measure of asset efficiency. A high turnover ratio indicates that the company is efficient at collecting its debts and has high-quality customers who pay quickly.
• How to Interpret it:
  • Higher is Better: A higher ratio means receivables are being converted to cash more frequently.
• How it's Calculated:

  Net Credit Sales in Period / Average Accounts Receivable in Period

  • Average Accounts Receivable: (Beginning AR Balance + Ending AR Balance) / 2

Customers Over Credit Limit

• What it Measures: The simple count of customers whose current outstanding balance is higher than their pre-approved credit limit.
• Why it's Important: This is a critical, real-time risk indicator. Each customer over their limit represents a heightened risk of default. It may also indicate a need to halt further credit sales to these customers.
• How to Interpret it:
  • Zero is the Goal: An ideal number is zero. This KPI is clickable to drill down to the specific list of customers.
• How it's Calculated: A direct count of all customers where Current Balance > Credit Limit.

Visualizations

• Aging Analysis: This chart breaks down your total overdue receivables into time-based buckets (e.g., 31-60 days). Its purpose is to help you prioritize collections, as older debts are at a higher risk of becoming uncollectible.
• Sales vs. Collections Trend: This chart compares the value of new invoices created (Sales) against the value of payments received (Collections) over time. It provides a powerful visual for identifying cash flow gaps. If the sales line is consistently higher than the collections line, it means your receivables are growing, and your cash position may be weakening.

5. Explaining the KPIs: Commission Analytics Tab

This section explains each metric and visualization on the Commission Analytics tab.

Total Accrued Commissions

• What it Measures: The total amount of commission that has been earned by salespeople but has not yet been paid out.
• Why it's Important: This is a key current liability on your balance sheet. The finance team needs this number for accurate financial reporting and cash flow forecasting.
• How to Interpret it: This is a snapshot of a liability. A very high number may indicate a delay in processing commission payments.
• How it's Calculated:

  Sum of "Commission Amount" for all commission transactions where "Is Settled" is false.

Commissions Paid (Month-to-Date)

• What it Measures: The total cash that has been paid out for commissions in the current calendar month.
• Why it's Important: This tracks the actual cash outflow related to commissions, which is essential for short-term cash management.
• How to Interpret it: This is a cumulative total for the current month. It helps answer the question, "How much have we spent on commissions this month so far?"
• How it's Calculated:

  Sum of "Commission Amount" for all commission transactions where "Is Settled" is true and "Settlement Date" is in the current month.

Average Commission Rate

• What it Measures: The effective commission rate across all sales, calculated as a percentage.
• Why it's Important: This KPI shows the true "cost of sales" from a commission perspective. It helps finance and sales leadership understand if the commission program is staying within budget.
• How to Interpret it: Compare this rate to your budgeted or target commission rate. A rising trend could indicate that more high-commission products are being sold.
• How it's Calculated:

  (Total Commissions Earned in Period / Total Sales in Period) * 100

Visualizations

• Top Sales Reps by Accrued Commission: This bar chart ranks salespeople by their total unpaid commission balance, helping managers identify top performers and anticipate large payouts.
• Commissions Accrued vs. Paid Trend: This chart visualizes the flow of commission liability. It compares the amount of new commission being earned (Accrued) each month to the amount being paid out (Paid). A large, growing gap can signal a bottleneck in the payment process.
• Commission Distribution by Group: This pie chart shows what percentage of the total commissions is generated by each sales group (e.g., "Premium Sales," "Retail Sales"). It is a high-level tool for assessing team performance