Analysis on receivables of data Analysis Platform project of Chemical enterprise

The project is mainly aimed at the needs of chemical transfer, sales, receivables, procurement of three modules to carry out a comprehensive statistical analysis, the purpose is through the analysis of historical data, to find valuable information to assist leaders in decision-making, to give the salesman real-time reminders. This paper mainly analyzes the Receivables module.

Review

Receivable data module mainly from the region, aging, the Department of these dimensions of the comparative analysis of the situation of accounts receivable, to facilitate real-time understanding of non-return funds, remind the relevant personnel to collect money.

Data Center Implementation tool: Sail Soft Finereport

comprehensive analysis of receivables

The report provides a number of interactive features by analyzing the amounts receivable from a comprehensive perspective, in order to facilitate an intuitive view of accounts receivable:

Click on an area on the map, the "Aging Analysis chart" in the upper right corner shows the aging distribution of the region, the lower right corner of the "Accounts receivable comparison chart" shows the respective departments in the region of the receivable comparison;

With the 1th, click on the "Aging Analysis Comparison Chart", the map, "the Department of Accounts receivable comparison Chart" will show the corresponding aging receivables is how many, the region of the aging distribution, the Department of the Aging receivables compared

Click on the lower right corner of the "Department of Receivables comparison Chart" effect with the above two points, here no longer repeat;

"Different levels of users may see different numbers."

In addition to the above interactive effect, click on the upper right corner, the bottom right corner of the two bars, the upper right corner of the logo, you can switch the column chart into a pie chart, the pie chart can be combined with the mouse drag series:

"Different levels of users may see different numbers."

In addition, click on the map, you can drill down to the area of the receivable details: (This sample according to the ERP statistical report >> General report >> statistical Analysis Report >> Receivables Aging Analysis)

"The number of rows that different levels of users see may be different"

Click on the upper right corner of the aging distribution comparison chart, you can drill down to see the aging of the camp payment details (this form in accordance with the ERP statistical report >> General report >> statistical Analysis Report >> Receivables Aging Analysis):

"The number of rows that different levels of users see may be different"

Click on the lower right corner of the "Department of Accounts receivable comparison chart", you can drill down to view the department's receivables details (this form in accordance with the ERP statistical report >> General report >> statistical Analysis Report >> Receivables Aging Analysis):

"The number of rows that different levels of users see may be different"

Comparative analysis of payback and aging period

Back to the rate of the same period of comparative analysis, the current year to present, the monthly return rate and the same period of the previous year compared analysis;

Compared with the previous year, the comparison and analysis of aged accounts receivable were compared with the same period, and the growth rate of each aged receivable was higher than that of the same period.

"Different levels of users may see different numbers."

Receivables Statistics

The number of receivables that are counted within 3 months of age, the number of clients, the age of 3-6 months of receivables, the number of clients, the age of 6 months in receivables, and how many customers.

Use green (normal), yellow (more dangerous, need to focus on sales department manager), Red (danger, need attention of legal department, of course, Sales department manager also need attention) dashboard display:

"Different levels of users may see different numbers."

Click on any of the instrument panel, can drill to the corresponding details, if it is the clerk, out of the detail page will be more than a column selection box, the salesman can choose which customers, transfer it to the law, of course, non-salesman words, is unable to perform transfer operations. This page, according to the customer summary, a customer line, the total amount of the statistics of an aging, this page click the total amount, you can continue to drill down, to see a customer account receivable details (that is, the total amount of the one should collection of the details)

"Users at different levels may see a different number of rows, and only salespeople can manipulate the leftmost column"

Legal-Receivables causes analysis

Legal staff on the transfer from the clerk and eligible systems automatically turn over the aging of the cause analysis, Dunning State maintenance:

"The number of rows that different levels of users see may be different"

Receivables Enquiry

The purpose of this query report is to facilitate query of receivables details. Of course, people of different roles can only view data that is relevant to them:

"Different levels of users can check the range, the number of rows detected is different"

Receivables AlertA receivable alert is a receivable that reminds the person concerned that the aging is too long. The effect is that the system automatically weekly (frequency allows adjustment changes) the aging of the receivable information in the message body to send to the salesperson, Sales department manager, legal staff, corporate leaders.

All receivables are sent to the salesperson, as well as the corresponding aging of the funds;

Sent to the department manager is the Department of all aged more than 3 months of receivable and aging, in a reminder;

Sent to the legal service is the company all aged more than 6 months of receivables and aging, in a reminder;

Send to the leader is the company all the receivables, the aging of more than 3 months, the aging of more than 6 months of how much, as a reminder.

Analysis on receivables of data Analysis Platform project of Chemical enterprise