Best Practices to Determine Individual Customer Profitability

March 7, 2018 – “We love our customers!” Every business owner says it. But all customers aren’t created equal, and it’s in your strategic interest to know which customers are really strengthening your bottom line and by how much.

Sorting out the data

If your business systems track individual customer purchases, and your accounting system has good cost accounting or decision support capabilities, determining individual customer profitability will be simple. If you have cost data for individual products, but not at the customer level, you can manually “marry” product-specific purchase history with the cost data to determine individual customer value. For example, if a customer purchased 10 units of Product 1 and five units of Product 2 last year, and Product 1 had a margin of $100 and Product 2 had a margin of $500, the total margin generated by the customer would be $3,500. Be sure to include data from enough years to even out normal fluctuations in purchases. Don’t maintain cost data? No worries; you can sort the good from the bad by reviewing customer purchase volume and average sale price. Often, such data can be supplemented by general knowledge of the relative profitability of different products. Be sure that sales are net of any returns.

Incorporating indirect costs

High marketing, handling, service or billing costs for individual customers or segments of customers can have a significant effect on their profitability even if they purchase high-margin products. If you use activity-based costing, your company will already have this information allocated accurately. If you don’t track individual customers, you can still generalize this analysis to customer segments or products. For instance, if a group of customers is served by the same distributor, you can estimate the resources used to support that channel and their associated costs. Or, you can have individual departments track employees’ time by customer or product for a specific period.

Knowing their value

There’s nothing wrong with loving your customers. But it’s even more important to know them and how much value they’re contributing to your profitability from operating period to operating period.

 

About the Author

Dopkins Assurance Services Group

Dopkins offers a full range of assurance services that can help improve your financial accuracy. From financial report preparation and audits of historical financial statements to preparation of an array of special attestation reports—we can help translate numbers into accurate management information so you can make knowledgeable decisions. For more information, contact Bart McGloin, CPA, CFE, CFF at bmcgloin@dopkins.com.

Careers

Whether you are evaluating career opportunities as an accountant, business consultant or IT professional, you'll want to know what differentiates Dopkins & Company from all the competition. Learn more today.

Learn More