Distributors' weekly financial reports: Sales reaching 10 million to 30 million yuan marks the watershed between the "entry stage" and "maturity stage" for distributors. After sales exceed 10 million, distributors often encounter this situation: as business scale expands, personnel increase, links multiply, and markets deepen, original management experience no longer works, leading to confusion, low efficiency, and difficulty controlling many matters, suddenly feeling overwhelmed.
This passive situation mainly arises because after the management span widens, the corresponding management tools and methods do not keep up, causing information failure and leading to frequent problems in the distributor's decision-making system.
How to grasp relevant information from all dimensions of business management, regain confidence in controlling the market, avoid gradual decline in work efficiency, and solve the "shepherd-style" management state? Let's start with the information organization tables for distributor business scheduling.
Table 1: Monthly Performance Summary Table This table summarizes the monthly planned sales, actual sales, collections, completion progress, and ranking indicators for salespeople, departments, and systems. It allows intuitive comparative analysis to filter out problems and information. With this table, you can see the performance of departments, regions, and salespeople at a glance, and make horizontal comparisons, with overall sales data fully visible.
The table includes "historical advanced indicators" and "same period last year indicators" for easy comparison with historical performance to observe trends. The company should reward those with top monthly rankings. Our principle: differentiate by ranking, reward 50% of staff, with modest bonus amounts, mainly using ranking as motivation. This table can also be issued as a ten-day report and posted on the wall to remind and motivate salespeople promptly.
This table is the main basis for performance appraisal of salespeople and department heads.
Table 2: Monthly Performance Detail Table This table is set per salesperson, one for each, listing all customers' performance contributions served by the salesperson.
Based on this table, you can analyze and compare the performance contribution of each customer in each salesperson's area, delve into the market to identify the basic components of sales performance, and find market gaps and potential points. The rankings help identify key and potential customers among the salesperson's clients, guiding departments and salespeople to determine work priorities and directions.
The table includes "historical advanced indicators" and "same period last year indicators" for comparison with historical performance to judge this month's results.
Table 2 supplements and further explains Table 1.
Table 3: Monthly Sales Structure Summary Table Tables 1 and 2 analyze data from the sales amount path. Tables 3 and 4 go further, analyzing by product sales composition to find factors that constitute sales, identify directions for expanding sales, and clarify the sales contribution of each product brand. Based on the product sales weight and trends, you can judge the product's stage and consider the company's product mix strategy. At the same time, the sales amount composition of each system, department, and salesperson is summarized and listed, allowing you to see sales gaps caused by different sales compositions and achieve multi-dimensional analysis of salespeople's performance reasons.
Table 4: Monthly Sales Structure Detail Table This table is set per salesperson, one for each, listing all products sold by the salesperson's customers by brand. Based on this table, analyze the basic components of the salesperson's sales performance by product, find market gaps and potential points. This table helps diagnose the regional distribution patterns of products and determine the focus and direction of regional development. The table includes "historical advanced indicators" and "same period last year indicators" for comparison with historical performance to observe product promotion cycles.
Table 4 supplements and further explains Table 3, enabling multi-dimensional analysis of salespeople's performance reasons.
Table 5: Monthly Sales Outstanding Summary Table Sales outstanding is a difficult point in distributor management. Many distributors have several million yuan in outstanding receivables, of which more than half are not necessary for business but accumulated due to lax management. In principle, the initiative should be in the distributor's hands, and it should not be a problem. But in reality, most distributors suffer greatly because of lack of rigorous follow-up management: some sell on credit, but no one collects. When debts form, they just put the IOUs in a safe without dynamic management, leading to repeated accumulation. Only when funds stop moving do they start collecting, and the initiative falls into the hands of the owing customers. Table 5 is a dynamic management design by department, showing the beginning outstanding for each department, the new outstanding formed in the month, and the increase or decrease compared to the previous month. The increase or decrease amount is directly linked to the department head's assessment, prompting them to track outstanding management, and the distributor can see the process management of outstanding in time.
This table is a tool for the finance department to manage departmental outstanding and an information channel for the boss to understand capital occupation.
Table 6: Monthly Sales Outstanding Detail Table This table is a tool for department heads to track and manage the outstanding handled by salespeople. It is also a tool for assessing salespeople on outstanding.
Table 7: Monthly Customer Sales Outstanding Detail Table This table is a tool for salespeople to track and manage customer outstanding. It can evaluate the salesperson's management status based on the total column, and also monitor specific customers' outstanding situations. Each customer's new outstanding, overdue outstanding, and control targets are clear at a glance, facilitating process tracking.
The above 7 tables are for collecting sales management information for business scheduling.
The following 7 tables are designed for special business work assessment, research, and decision-making:
Table 8: Monthly Top 50 Customer Sales Performance Ranking Ranking customer sales performance helps identify the company's key customer list, compare differences between customers, and discover the tiered distribution of customer sales scale, providing valuable reference for company planning and market research.
Table 9: Monthly Top 50 Customer Sales Ranking for Key Products This table is used to check the sales progress of key products, observe customers' response to key products, and find directions for further layout of key products.
Table 10: Customer Input-Output Ratio Statistics Table This table is used to assess the promotional expenses invested and the effects produced by promotions. It evaluates the value generated by promotional work and can also evaluate salespeople's work ability based on the promotional benefits they organize.
Table 11: Special Promotion Activity Customer Performance Table This table is used to assess the performance of special activities, evaluate salespeople's execution ability, and their ability to mobilize customers.
Table 12: Customer Gross Profit Contribution Table Evaluate the value customers create for the company from the ultimate purpose.
Table 13: Salesperson Gross Profit Contribution Table Evaluate the value salespeople create for the company from the ultimate purpose.
Table 14: Overdue and Expired Product Return/Exchange Statistics Table Assess salespeople's situations of returning or exchanging overdue and expired products.
The above tables are the business tables that distributors with sales of 10 million to 30 million yuan should review at the end of the month.
Data Management Tools:
Table 15: Inventory Report (In-Stock-Sales) Actual sales = beginning inventory + purchases this month + expense-inventory this month - scrappage this month - expense payments this month - ending inventory this month
The purpose of this table is to directly show the actual sales status of each category from the manufacturer, and can be detailed to each SKU to track its sales status.
The reason for adding expense-inventory and expense payments is that most FMCG manufacturers pay terminal and distributor expenses in the form of goods compensation. Listing them separately clarifies the true actual sales and true sales revenue. (This article does not involve non-operating income.)
Scrappage is included because, first, scrappage is a hidden killer of distributor profits; second, product damage is not borne by the manufacturer but by the distributor.
Table 16: Sales Year-on-Year Comparison Table Year-on-year growth rate = (actual sales this year - actual sales last year) / actual sales last year * 100%
The year-on-year growth rate shows the year-on-year growth of each category or SKU. Why growth? Why stagnation? Why decline? Only by clarifying this can the distributor decide which items to invest heavily in, which items need no investment, and which items should be completely abandoned.
Table 17: Accounts Receivable Flow Table Actual sales amount this month = inventory amount at beginning of month + payment amount this month + expense reimbursement this month - scrappage cost this month - expense payments this month - inventory amount at end of month
Accounts receivable this month = actual sales amount this month + accounts receivable at beginning of month - actual collections this month
Accounts receivable are the lifeline of distributors. Without controlling them well, no development is possible. Of course, if distributor friends don't mind the extra work, they can do detailed year-on-year analysis of actual sales and accounts receivable for more direct insight. This shows whether receivables have been collected in time or are still in customers' hands, and whether receivables are continuously growing.
Table 18: Profit and Loss Statement
Table 19: Channel Efficiency Table Channel efficiency only has practical significance if it covers at least three consecutive months. Doing a full-year channel efficiency assessment is important. Accumulate current year data and compare with previous year data to truly see the input-output efficiency of each channel. Which channels must be invested in, which channels should reduce investment, and which channels should terminate cooperation are clear at a glance. If distributor friends want more detail, it is recommended to make a "Specific Customer Cost Efficiency Table" for expense investment.
Table 20: Specific Customer Cost Efficiency Table By using these tools well, distributors can easily and clearly grasp their operational status. Long-term adherence may truly achieve a thorough understanding and control.
For the above tables, if needed, reply with the keyword: "表格" to obtain them.
This platform will soon organize distributor friends who intend to transform to B2B platform e-commerce to visit and learn from B2B platforms.
Introduction to the enterprise model for inspection:
Organizational form
- Company visit
- Actual market case visit
- On-site explanation
- One-on-one communication
Each friend who signs up only needs to pay an organization fee of 200 yuan.
Interested distributor friends can long-press the QR code below to contact me to register.
When adding friends, please reply "报名" (register).
- END-
The best domestic FMCG distributor learning platform Focus on providing professional, practical, and applicable tutorials for enterprises and distributors Committed to helping Chinese FMCG distributors grow rapidly
The most professional and practical knowledge base in the FMCG industry Reply with the red number below to get corresponding content Reply with number 1 to view the complete knowledge base
| 001 Excellent article selection | 002 Distributor market operation | 003 Terminal visit management | 004 Sales supervisor skills | 005 Sales improvement techniques | 006 Channel expansion | 007 Managing distributors | 008 Distributor development | 009 Distributor internal operations management | 010 Team management | 011 Efficient distribution techniques | 012 Sales manager's eighteen skills | 013 KA operation methods and strategies | 014 First lesson for new salespeople | 015 Internet, brands | 016 Distributor B2B transformation |
[Long press QR code to follow]