Receivables Dashboard

The Receivables tab in Zoho ERP provides a comprehensive overview of an organisation’s outstanding customer payments. It enables businesses to track invoices, monitor overdue receivables, and analyse cash inflows efficiently. By presenting key receivables data through visual indicators such as charts, summaries, and aging analysis, the dashboard helps finance teams assess the organisation’s collection performance.

Scenario: Patricia Boyle, the Customer Relationship Manager, wants to analyse customer subscriptions and the average recurring revenue in order to build a strategic plan to reach out to potential customers. Her primary need is to monitor the outstanding receivables from customer subscriptions. In this scenario, the Receivables dashboard can be used to provide a clear overview of the organisation’s receivables summary.

The dashboard offers real-time insights into total receivables, overdue amounts, and net revenue. This allows users to identify potential collection risks, improve cash flow management, and take timely follow-up actions. Overall, the Receivables dashboard serves as an effective tool for strengthening credit control and enhancing financial decision-making within the enterprise. Each panel in the dashboard showcases the output of the respective module transactions. Let us see each panel in detail:

Note: The output of the receivables dashboard is displayed for the current year by default. The Filter By option can be used to filter the output in the dashboard for the specified time.

Overdue Invoices

The Overdue Invoices displays the total number of invoices that have passed their due date but remain unpaid. This metric helps users quickly identify pending payments that require immediate follow-up. By tracking overdue invoices, businesses can spot collection delays, assess payment risks, and prioritise actions to improve cash flow and reduce outstanding receivables.

Open Invoices

The Open Invoices section displays the count of all open invoices that have been issued but are not yet fully paid. This includes both invoices that are still within the due date and those that are overdue. Monitoring open invoices helps businesses track expected incoming payments, identify outstanding customer balances, and manage cash flow more effectively.

Collection Effective Index

The Collection Effective Index (CEI) measures how efficiently a business collects its receivables within a specific period. It compares the amount collected against the amount that was actually collectible, providing a clear indicator of the effectiveness of the organisation’s collection process. A higher CEI reflects stronger collection performance, while a lower CEI suggests delays or inefficiencies in recovering outstanding payments.

Day Sales Outstanding

Days Sales Outstanding (DSO) is a financial metric that measures the average number of days a company takes to collect payment after issuing an invoice. It helps determine how efficiently the organisation manages its receivables. A lower DSO indicates faster collection and healthier cash flow, while a higher DSO may point to delays in customer payments or inefficiencies in the billing and collection process.

Total Sales

The Total Sales panel displays the revenue generated from invoice payments. Total sales are calculated based on the income received through these payments. By default, the organisation’s total sales are shown on a monthly basis. Users can view total sales for a specific period by selecting the desired time frame.

Receivables Summary

The Receivables Summary panel exhibits the total amount that your customer owes for both current and overdue invoices. This panel provides a high-level snapshot of the organisation’s outstanding customer balances and overall receivables health. It consolidates key metrics including total receivables, current vs. overdue amounts, and aging distribution in a chart view, which is easy to interpret. This enables finance teams to assess collection performance and identify potential risks.

Invoice Summary

The Invoice Summary panel provides a visual comparison between the total Invoiced Amount and the total Collected Amount for a selected period. By displaying both values side by side, it becomes easier to identify gaps between what has been invoiced and what has been received, enabling better cash flow management and faster identification of collection delays.

Top Overdues

The Top Overdues panel displays the overdue invoice count and amount by customer, helping users identify which customers have the highest outstanding dues. It also highlights the highest overdue invoice, allowing businesses to prioritise follow-ups and improve collection efficiency.

Active Subscriptions

The number of active (Live) subscriptions at the end of a period is consolidated in the Active Subscriptions panel. This panel provides a real-time view of the total number of active customer subscriptions, enabling the users to understand its recurring revenue base and subscription stability. The count of active subscriptions links to the Active Subscriptions report, users can have a deeper insight using the report view.

Net MRR

The Net Monthly Recurring Revenue (MRR) panel provides a real-time view of the predictable revenue earned each month from active subscriptions. As a key metric for subscription-based businesses, MRR helps the organisation understand the stability and growth trajectory of its recurring revenue stream.

This panel summarises the recurring revenue that your business earns every month. It is derived from recurring components of subscriptions like plans and addons. It provides users with an overview of the summarised amount of the monthly recurring revenues.

Churn Rate

The Churn Rate panel provides the percentage of subscriptions that were cancelled in a particular period. This panel enhances the visibility into the percentage of customers or subscriptions lost during a specific period, offering its insight on the impact of future receivables.

Within the receivables dashboard, the Churn Rate panel connects customer attrition directly to financial outcomes. A rising churn rate may signal issues such as declining customer satisfaction, pricing concerns, service gaps, or competitive pressure factors that can reduce future invoicing and weaken collection potential. Conversely, a declining churn rate indicates improved customer retention and greater predictability in cash inflows.

This panel enables finance and operations teams to monitor churn behaviour in real time, analyse its causes, and take proactive steps to enhance customer retention and maintain a healthy receivables pipeline.

LTV

The LTV (Lifetime Value) is a metric that estimates the total revenue a business can expect to earn from a customer over the entire duration of their relationship. It helps organisations understand how valuable each customer is and supports better decision-making in areas such as marketing, customer retention, and product development. A higher LTV indicates that customers stay longer and generate more recurring revenue, while a lower LTV may suggest churn issues or low spending behaviour.

Subscription Summary

The Subscription Summary panel displays key subscription activities, such as, signups, activations, cancellations, and reactivations. This visual representation helps users track subscription trends over time, identify fluctuations in customer behaviour, and assess the overall health of the subscription lifecycle. By monitoring these metrics together, businesses can quickly spot growth patterns, churn risks, and opportunities to improve customer retention.

MRR Growth

The MRR Growth panel provides a detailed breakdown of monthly changes in Monthly Recurring Revenue (MRR). It visualises key components such as new subscriptions, expansions, reactivations, contractions, and churn. By displaying these elements, the chart helps users understand what factors contribute to overall MRR growth or decline each month. This insight allows businesses to monitor revenue trends, identify areas of strength or concern, and make informed decisions to improve recurring revenue performance.

Time to Get Paid

The Time to Get Paid panel provides a visual summary of how long customers take to pay their invoices. It categorises payment timelines, such as within 0–15 days, 16–30 days, 31–45 days, and above 45 days, showing the proportion of payments received in each range. This helps businesses quickly identify payment patterns, assess customer payment behaviour, and pinpoint delays in collections. By understanding how long it typically takes to receive payments, organisations can improve cash flow planning and strengthen their receivables management.

Refunds

The Refunds panel displays the total refunded amount along with the number of transactions processed during the year. This provides a quick overview of how much revenue was returned to customers. Monitoring this panel helps organisations identify refund trends, evaluate customer satisfaction levels, and assess the financial impact of returned payments.

Write Off

The Write-Off panel displays the percentage of invoices that have been written off during a selected period. This metric helps users understand the portion of receivables that could not be collected and had to be accounted as losses. By tracking the write-off percentage, organisations can assess credit risk, identify collection issues, and take corrective actions to improve receivables management.

Voided Invoices

The Voided Invoices panel displays the total count of invoices that have been voided along with their corresponding amounts. This helps users track cancelled billing transactions and understand the financial impact of voided invoices. Monitoring this panel allows organisations to review billing accuracy, identify recurring issues, and maintain clean and accurate financial records.