Receivables Module

Do you want to know where your money is? Receivables module shows your customer’s buying and paying habits. Users can easily analyze receivables debit/credit relations, balance and various rotation coefficients through different dimension attributes, as well as overview of due and overdue accounts.

Analyze payables, receivables and various rotation coefficients

• Advanced measures – average account measures, invoice open days, due days, etc.
• Analysis of specific invoices and group of invoices.
• Daily snapshots stored in the data warehouse.
• Account analysis through different customer attributes.

Do You Want to Know Where Your Money Is? Get better inside by analyzing receivable structure. We can observe that, over years, our receivable Overdue has grown much faster than Before Due. The best analytical view of these two measures is Stacked Area Chart (standard MS Excel functionality). It shows relative share of both measures regardless of the total receivable balance.

Receivables Overview Current Year The best way to compare growth is to index measures to the first date that we compare to (standard MS Excel 2010 functionality). This dashboard show that receivable balance grew faster than sales due to longer receivable turnover. Check dependences as you calculate indexes: Receivable Balance = Sales x Turnover (Days).

Receivables Table Receivables table provide a information about Receivables Balance, % of Total Balance, Sales, % of Total Sales, Customer Net Change, % of Total Net Change, Average Payment Terms, Average Open Days Receivables, Average Due Days Receivables and Receivables Turnover in days.

Receivable Due Overdue Structure Receivable Before Due and Overdue structure for current year.

Analyze Your Customers by Payment Habits Find them, track them like a hawk and improve your financial position. Top 30 customers by receivable balance analysis, provides information about before due, overdue and total receivables for each customer in a current year.

Worst Customers by Overdue Worst 30 customers by Overdue provide information about customers debt in range under 90 days, debt over 90 to 180 days, over 180 days and total receivables for current year. These customers present 80% of our overdue balance and are the reason why our receivable balance grows faster than sales. We group these customers and create a Set: "Bad customers (by payment habit)". This is simple and standard Excel functionality.

Receivables Structure Over Years Receivables structure over years provides information for Before Due and Overdue receivables over the years in percentages and numbers with conditional formatting.

Receivables Customers Over Years Receivables customers over years provides information for receivables, percentages receivables and grand total receivables over the years with conditional formatting. You can see that the first seven costumers represents a 40% share of the total receivables in 2011.