If financial internal control is done well, it can not only directly help enterprises increase profits, but also monitor the development of enterprises in real time to know what is going on. Doing a good job in financial settlement helps to determine the decision-making direction in the management process, and makes reasonable adjustments in stages according to the actual business situation, which is conducive to the achievement of team goals and the maintenance of team combat effectiveness.
Financial monitoring mainly involves three aspects: profit management, inventory management and cash flow management. Profit management is mainly monitored through selling price, daily profit statement, monthly profit statement and refund rate.
①Selling price monitoring
Many sales staff often ignore whether the selling price of the product will bring profit when selling products, especially when clearing inventory, they will ignore the calculation of the platform delivery fee, and often find that the products clearing inventory may still be at a loss. In order to avoid this situation, products can be divided into three types, and different public experience sharing: selling price setting method-profitable, break-even, and return balance, so as to ensure that the selling price is reasonable and normal when selling products.
When there are not many SKUs, it is possible to monitor them in place, but if there are many SKUs, it is very easy to make mistakes. Usually, you can use a table to monitor the selling price every day.
The steps for setting the selling price are: first, you need to obtain the purchase cost of the test product, budget the first-leg freight, and then calculate the local FBA delivery fee based on the local delivery method of products of the same weight. Finally, according to the profit requirements, combined with the cost and various expense data, calculate the appropriate selling price. The selling price setting template can be used to calculate the selling price more conveniently.
② Daily profit monitoring table
The daily profit monitoring table is the most important table in the profit management of the enterprise. It can analyze every problem point in the operation, find out the problem in time and deal with it in time.
The steps for making the daily profit monitoring table are: update the SKU product cost and first-leg freight data, download the previous day’s transaction details data after the sale and mark the advertising expenses; match the exchange rate and the cost and expense of each order, calculate the order profit, summarize the order data of each site, and obtain the sales, gross profit and gross profit margin data of each site on the same day; according to the order cost and expense ratio, filter out abnormal products, and then analyze the reasons with relevant departments.
③ Monthly profit report
After daily profit monitoring, integrate it into a monthly report. As long as the data is done well every day, the monthly business management data can be quickly sorted out, and then handed over to the management to make management decisions in time to improve the management execution of the enterprise.
The steps for making a monthly profit report are: download the monthly sales report of each site and account in the sales background, match the updated product cost and expense table; calculate the monthly sales, gross profit, and gross profit margin of each site, summarize the monthly report of each site, and calculate the same-month growth rate; analyze the proportion of each expense, compare the growth rate horizontally and vertically to see if it is abnormal, and analyze the reasons.
④ Refund rate analysis
The analysis of the refund ratio is the easiest to ignore when monitoring product profits. Refund reason analysis can help optimize product research and development, optimize product quality, increase repurchase rate and conversion rate, and reduce losses caused by returns and destruction. If sellers do not pay attention to the refund rate for a long time, it will bring huge losses to the store.
The steps for calculating the refund rate are: calculate the SKU refund rate in real time based on the daily profit statement (calculated based on SKU refund data/sales data); and calculate the accurate monthly refund rate again based on the monthly profit statement (the calculation formula is refund amount/sales).