Industry: Consumer Packaged Goods and Durable Goods
Trade spending or trade promotion is the amount a company pays to increase demand for its products, including—but not limited to—advertisements, coupons, preferential shelf displays, etc. The initial listing fee, slotting, is paid as an outright lump sum or a free product.
The accurate and timely calculation of trade promotion costs is a challenge for all consumer-packaged goods companies. Without an in-house capability to calculate and record this expense, it can result in unprofitable sales without management knowledge. Since companies can receive retailer deductions as late as 1-24 months after the date of an actual sale, companies must have visibility around trade promotion offers to the customers and what these sales represent in terms of trade promotion cost.
Table of Contents
Navigating Challenges in Trade Promotion Management for Small Businesses
A small company faces several challenges at the onset of tracking trade promotions.
1. Assigning TPM to the right individual:
Finding an employee who understands all aspects of the TPM process is difficult from a hiring perspective. A comprehensive TPM process’s key components are cross-functional lines between sales and finance.
The sales team manages the annual promotions planning and matches deductions with customer backup and syndicated data. Meanwhile, finance departments oversee the monthly accrual calculation process, cash application to record deductions and resolution of customer deductions in the enterprise resource planning (ERP) system. Most small companies tend to assign the task of understanding promotion plans and related costs to an existing team member (who works with the sales and finance teams while getting on-the-job training). In this situation, accuracy in managing promotions is often the first casualty.
2. Managing TPM either manually via Excel or a third-party system:
Although many choices are available, an adequate TPM system can cost tens of thousands of dollars to implement, with an additional ongoing cost of approximately $40,000 to $50,000 annually. The company must assign a well-trained and knowledgeable resource to manage a TPM system. For a small company, maintaining a TPM system poses issues regarding money and well-trained staff. For this reason, many companies with under $30-50 million in revenue manage trade promotions via a manual Excel process. Companies with over $30-50 million in revenue can also manage trade promotions via a manual Excel process by maintaining robust Excel promotion trackers for all key retailers and ensuring that deductions are resolved only after matching with pre-approved promotion plans and retailer’s documentation.
3. Ensuring a cross-functional TPM effort:
From a sales perspective, all promotion plans presented to retailers must be laid out upfront and consolidated as a trade promotions budget in the company’s annual operating plan. These plans are then executed carefully. The return on investment (ROI) also needs to be verified. Sales participation in calculating the ROI on these promotions is essential for effective spending. The finance team uses promotion plans to build monthly accruals and track the over-and under-spend. The finance team aids in maintaining oversight, ensuring the full expense is accounted for in a timely and accurate fashion, and bringing all overspending immediately to the management’s attention.
Read here to learn why big chain companies are reducing their commitment to national advertising and spending more on trade promotions.
Trade Promotion Tracking and Deduction Reconciliation
There are several key components for tracking trade promotions and reconciling deductions.
From a trade promotions point of view, the following is needed: (a) a promotion tracker by key retailers rolled up to the total company. This records monthly promotion plans for each key retailer, baseline sales, resulting lift, and cost (e.g., fixed fee, scans fee, advertisement fee, etc.). This tracker’s roll-up gives the trade promotion cost for each month and (b) a slotting tracker that calculates the total projected slotting cost by SKU and retailer. The objective is to ensure all revenue for shipments and corresponding costs relating to these shipments are recorded in the same period, as US GAAP requires.
To reconcile deductions received by the accounting department, the company requires (a) retailer promotion contracts, (b) deduction documentation from the retailer portal, (c) shipment data from the ERP system, and (d) syndicated data for movement and incremental lift on the shelf and average retail price-point movement. The sales team occasionally helps interpret this information.
In situations where the product is being distributed via a distributor, there is an added layer of cost known as the distributor administration fee. The distributor charges this lump sum cost for various dollar-value tiers of deductions. For a company with a revenue of $30 million annually, this could add up to hundreds of thousands of dollars.
Conclusion
In summary, the absence of trade promotion planning and deduction tracking can expose the company to unpleasant surprises and losses. For example, the sales team may offer promotions that may not be authorized by the management. Also, the retailers may send unauthorized deductions, which, if not challenged promptly (usually within 3 months of receiving such deductions, depending on the retailer policy), can result in significant loss to the company. Post-audit deductions charged up to 24 months after the shipment of products are another reason to maintain tracking of trade promotions. Monitoring logistics-related deductions (e.g., late delivery, shortages, etc.) is also a part of this process.
Contact Expertise Accelerated to help streamline the TPM process to prevent losses due to unauthorized deductions.
Haroon Jafree is the CEO of Expertise Accelerated (www.expertiseaccelerated.com). Haroon started his career in public accounting at Pricewaterhouse Coopers and later worked for over 20 years in the consumer-packaged goods industry, both at mid-management and C-suite levels. He has worked for companies ranging from startups to multibillion-dollar brands.
Expertise Accelerated serves consumer packaged goods and durable goods segments of the industry. Using the latest tools and technology, we augment onsite client resources with trained offshore teams.
At Expertise Accelerated, we aim to deliver savings to our clients from day one.