! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.

Go to Index or search here

Product and Service Line Profitability: How MSMEs Can Find Which Parts of the Business Actually Make Money

Article ID : Art_6.12.2 Read Time : ⏱ 12-16 min
Published on : 11-Jun-2026 • 06:00 IST

⬟ Intro :

A small MSME hardware distributor in Jaipur, Rajasthan had Rs. 3.8 crore revenue and Rs. 19 lakh net profit. The business was growing and the owner was satisfied. The CA ran a product-line profitability analysis across seven categories. Three categories (power tools, electrical fittings, plumbing hardware) generated Rs. 61 lakh gross profit on Rs. 1.6 crore revenue (38% margin). Four categories (general hardware, fasteners, abrasives, safety equipment) generated Rs. 12 lakh on Rs. 2.2 crore revenue (5.5% margin). The owner had been spending equal sales effort across all seven. The four low-margin categories consumed 58% of revenue but contributed only 16% of gross profit. The net profit of Rs. 19 lakh was an average that hid a large performance gap between the two groups.

Overall profit averages the performance of all products or service lines. Within that average, some lines generate excellent returns, others break even, and some may actually lose money once direct costs are properly allocated. An owner managing by the overall profit number makes decisions without knowing which parts of the business drive that profit and which dilute it. Sales effort, marketing spend, and working capital are all allocated across lines without knowing which allocation produces the best return. Segment-level profitability reporting makes each product or service line's performance visible, creating a basis for decisions about where to grow, where to improve pricing, and where to reduce.

This article covers what product and service line profitability analysis involves, how to build a simple segment profitability report, how to allocate shared costs fairly, and how to use the results to make specific improvements to the revenue mix.

⬟ What Is Product and Service Line Profitability Analysis :

Product and service line profitability analysis calculates the profit or loss generated by each distinct product category or service type separately from the overall business result. It works in two layers. The first is gross margin by product line: revenue minus the direct cost of the specific product or service. This identifies which lines generate the most gross margin rupees and the highest gross margin percentage. The second layer adds allocated overhead to produce a net contribution by line. Overhead costs that cannot be directly assigned (rent, management salaries, administration) are allocated using a basis such as revenue percentage, floor space, or number of transactions. The second layer shows which lines generate profit after their share of overhead and which are marginally profitable or unprofitable at the net level. For most MSMEs, the gross margin layer is the most actionable starting point, requiring only revenue and direct cost for each line, usually available in the accounting records.

A small MSME textile trader in Surat, Gujarat carries three product lines: cotton fabric, synthetic fabric, and blended fabric. Total revenue Rs. 4.2 crore, total gross profit Rs. 63 lakh (15% margin). Segment analysis: Cotton fabric: Rs. 1.4 crore revenue, Rs. 28 lakh gross profit (20%). Synthetic fabric: Rs. 1.8 crore revenue, Rs. 23 lakh gross profit (12.8%). Blended fabric: Rs. 1.0 crore revenue, Rs. 12 lakh gross profit (12%). The overall 15% margin is an average. Cotton fabric, the smallest revenue line, generates the highest margin and nearly half the total gross profit. Synthetic fabric generates the largest revenue but the lowest margin. The analysis gives a clear direction: grow cotton fabric, review synthetic fabric pricing, investigate whether blended fabric's margin can be improved or effort reduced.

⬟ Why Segment-Level Profitability Changes Business Decisions for the Better :

Knowing profitability at the segment level delivers four specific benefits. The first is directing sales effort to the most profitable lines. When gross margin by product line is known, sales effort can be directed to the highest-margin lines rather than the highest revenue. An extra Rs. 10 lakh in a 20% margin product generates Rs. 2 lakh in gross profit. The same effort at 6% margin generates Rs. 60,000. The second is identifying pricing improvement opportunities. Lines with margins consistently below the business's cost structure are candidates for price increases. Without segment data, the owner does not know which lines have pricing headroom. The third is making exit decisions about unprofitable lines. A line generating negative gross margin or marginal contribution is consuming working capital and management attention without adequate return. Segment data provides the basis for an exit decision rather than carrying the line by habit. The fourth is improving capital allocation. Stock investment and marketing spend are most efficient in the highest-margin lines. A business with segment margin data can carry deeper inventory in profitable lines and thinner inventory in low-margin ones.

A small MSME electrical goods distributor in Chennai, Tamil Nadu found that its industrial lighting line (22% of revenue) generated 8% gross margin while its LED retrofit line (18% of revenue) generated 31% gross margin. Equal stock and sales visits had been allocated to both. After the analysis, sales leads were directed to LED retrofit and stock was rebalanced: industrial lighting reduced 30%, LED retrofit increased 40%. Within two quarters, gross profit increased by Rs. 4.2 lakh on similar total revenue. A medium MSME IT services company in Pune, Maharashtra tracked profitability across three service types: AMC (42% gross margin), project implementation (22%), and training (8%). The CA recommended increasing training prices by 25% or discontinuing the service, as training generated only Rs. 3.8 lakh gross profit on Rs. 47 lakh revenue while consuming significant trainer time. Training prices were raised. Two customers left. The remaining training revenue at the higher rate generated more gross profit with less resource consumption.

For small MSME owners, product line profitability analysis is often the most revealing financial exercise they can do, showing clearly that financial performance is not uniform and that targeted actions on specific lines can improve total profitability without growing overall revenue. For chartered accountants advising MSMEs, building a basic segment profitability template in Tally or Excel takes two to four hours and gives the client a reusable framework for quarterly or annual review. For management teams in medium MSMEs, segment profitability creates an objective basis for resource allocation discussions that would otherwise be decided by habit or internal politics.

⬟ How Most MSMEs Currently Track Product-Level Financial Performance :

Most small and medium MSMEs track total revenue and total profit at the business level. Product-level revenue may be visible through the invoicing system, but costs are rarely tracked by product line. The most common gap is overhead allocation. The owner knows purchase cost but does not allocate shared overhead across lines. Gross margin by product is often available; net contribution after shared costs is unknown. Decisions about which lines to push, price up, or de-emphasise are typically made on revenue size or customer demand rather than contribution to profit. Many MSMEs carry low-profit lines for years because no one has calculated that they consume resources disproportionate to their financial contribution.

⬟ How Segment Profitability Reporting Is Becoming More Accessible for MSMEs :

Modern accounting software including Tally Prime, QuickBooks, and Zoho Books increasingly supports cost centre and project-level tracking that makes segment profitability easier to implement. Tally Prime's cost centre feature allows overhead allocation across product lines in the accounting entries, producing a segment P&L within the existing system. E-commerce and business intelligence tools are providing SKU-level profitability data automatically, including landed cost, platform fees, and return rates. This level of detail is raising the standard for product profitability analysis across both online and offline MSMEs. ERP adoption in medium MSMEs provides structured product and service line tracking as a default feature, making segment reporting a byproduct of normal operations rather than a separate analytical exercise.

⬟ How to Build a Basic Segment Profitability Report in Four Steps :

Building a segment profitability report follows four steps. Identify the segments. Define the product lines, service types, or customer segments to track. The right level is five to ten segments that are both meaningful (each has a distinct cost and revenue profile) and practical (data is collectible without excessive effort). Assign direct revenues and costs. For each segment, record revenue and direct cost: purchase cost for trading, materials and direct labour for manufacturing, direct staff and resources for services. This produces the gross margin and gross margin percentage for each segment. Allocate shared overhead. Costs that cannot be directly assigned (rent, management salaries, logistics, administration) are allocated using a consistent basis. Revenue percentage is simplest and most common for trading and distribution MSMEs. The allocated overhead is subtracted from gross margin to produce the net contribution. Rank segments by contribution margin percentage. Present a table showing gross margin, allocated overhead, net contribution, and net margin percentage. Identify the top two and bottom two performers and determine what action is appropriate for each.

● Step-by-Step Process

Pull the last twelve months of sales from the accounting system sorted by product line or service type to get segment revenue. Identify direct cost for each segment: purchase price for trading, bill of materials for manufacturing, or direct resource cost for services. Calculate gross margin and gross margin percentage per segment. List all overhead costs not directly assigned to a specific line: rent, salaries excluding direct sales staff, utilities, transport, administration. Total these costs. Allocate overhead to each segment using revenue percentage (simplest method for trading and distribution). Subtract allocated overhead from gross margin to get net contribution per segment. Build a summary table: segment name, revenue, gross margin %, allocated overhead, net contribution, net margin %. Sort by net margin percentage. Identify the top two and bottom two segments. For the top two, assess how to grow volume without deteriorating margin. For the bottom two, determine whether pricing, cost, or a reduction in effort would improve the contribution.

● Tools & Resources

Tally Prime's cost centre and cost category features allow segment profitability tracking within the existing accounting setup. QuickBooks and Zoho Books support class-based tracking that serves a similar function. For businesses not ready to implement segment tracking in their accounting software, a simple Excel or Google Sheets template with the segment revenue, direct cost, allocated overhead, and net contribution columns achieves the same result using data exported from the accounting system. The CA can build both the Excel template and the Tally cost centre configuration in two to four hours.

● Common Mistakes

Calculating only gross margin without allocating shared overhead is the most common limitation. A high gross margin line that consumes a disproportionate share of overhead may still have low net contribution. Running both layers produces the correct picture. Continuing to carry low-margin lines because of customer relationships is the second mistake. When a customer buys primarily in low-margin lines, the value of the relationship must be weighed against the margin it generates. Many MSMEs carry unprofitable lines for years without testing the relationship against the financial data. Calculating segment profitability once and not updating it is the third mistake. Product costs, pricing, and volume change. A segment profitable twelve months ago may not be today. The analysis should be updated at least annually and reviewed quarterly in businesses with significant seasonal or pricing variation.

● Challenges and Limitations

Overhead allocation involves judgment calls that affect results. A segment appearing marginally unprofitable under one method may appear slightly profitable under another. The goal is not perfectly precise accounts but a clear ranking of segments by contribution and identification of outliers. The allocation method should be consistent from period to period so trends are visible. Some product lines exist to support the sale of other lines: low-margin accessories or basic items that attract customers who then buy higher-margin products. These may show low profitability but contribute to overall performance through their role in driving other purchases. Collecting accurate segment cost data requires a minimum level of accounting structure. If the business does not track revenue or cost by product line, setting up that tracking in the accounting system is the prerequisite for any reliable analysis.

● Examples & Scenarios

A small MSME chemical distributor in Vadodara, Gujarat carried five categories with total gross margin of Rs. 48 lakh on Rs. 3.2 crore revenue (15%). Two categories (specialty chemicals and industrial solvents) generated Rs. 39 lakh gross profit on Rs. 1.1 crore revenue (35% margin). Three categories (commodity chemicals, packaging materials, safety consumables) generated Rs. 9 lakh on Rs. 2.1 crore revenue (4.3%). The owner stopped actively selling safety consumables (3.1% margin, same delivery effort as specialty chemicals) and redirected sales capacity. Total revenue fell by Rs. 38 lakh but gross profit increased by Rs. 4.2 lakh. A medium MSME garments manufacturer in Bengaluru, Karnataka found that export orders (42% gross margin) and institutional uniforms (38%) generated Rs. 61 lakh gross profit on Rs. 1.6 crore revenue, while three domestic retail categories generated Rs. 14 lakh on Rs. 2.1 crore (6.7%). The business progressively shifted capacity toward export and institutional, reducing domestic retail production by 40% over two years and improving total gross profit by Rs. 18 lakh on similar total revenue.

● Best Practices

Start with gross margin by segment before adding overhead allocation. The gross margin comparison immediately shows which lines generate the most profit per rupee of revenue. Add overhead allocation once the gross margin layer is working correctly. Review segment profitability at least annually and trigger a mid-year review when there is a significant change in input costs, customer mix, or pricing. The annual review confirms whether decisions based on the prior year's analysis are producing the expected result. Use segment profitability data to drive pricing reviews. A line with gross margin significantly below the target is almost always a candidate for a price increase, cost reduction, or exit. The data provides the objective basis for a pricing conversation with customers that would otherwise be difficult to have without supporting numbers.

⬟ Disclaimer :

This content is intended for informational and educational purposes only and does not constitute professional financial, accounting, or business advisory advice. The methods, examples, and guidelines in this article are general approaches to product and service line profitability analysis and may not be appropriate for all business types, accounting systems, or cost structures. Specific cost allocation methods and their impact on segment profitability vary by industry and business model. MSME owners should consult a qualified chartered accountant for guidance specific to their business.

⬟ How Desi Ustad Can Help You :

Choose one action from today's reading: take the last twelve months of revenue data, sort it by product line or service type, and identify the five or six main segments. Then ask the CA to pull the direct cost (purchase cost or cost of goods) for each segment and calculate the gross margin percentage. This calculation, done in two to three hours, will very likely reveal that two or three segments are generating the majority of the gross profit and that one or two segments are significantly below the average. That finding alone changes where the next sales conversation focuses.

Register your business with our online directory or join our bidding platform.

Frequently Asked Questions (FAQs)

Q1: What is the difference between gross margin and net contribution at the product line level?

A1: The distinction matters because a product line with a high gross margin may have a much lower net contribution once overhead is allocated. For example, a product line that requires a dedicated temperature-controlled storage area, specialised delivery vehicles, and a dedicated customer service contact will be allocated a large share of those overhead costs even if its gross margin percentage is attractive. The net contribution tells the owner the true cost of carrying that line. For most small MSMEs, the gross margin comparison across product lines is the most immediately actionable data point and should

Q2: How do I allocate shared overhead costs fairly across different product lines?

A2: There is no single correct overhead allocation method. The goal is a method that is reasonable, consistent, and produces a result that fairly represents the real cost burden each segment places on the business. For a simple trading business with similar customers and similar logistics across all product lines, revenue percentage allocation is entirely appropriate. For a business where one product line requires specialised handling, cold storage, or dedicated staff while others do not, the revenue percentage method would unfairly burden the simple lines and subsidise the complex ones. In that case, allocating the specific

Q3: What should I do if I find that one of my product lines is losing money?

A3: The decision to exit a product line is often less straightforward than the financial analysis suggests. Key questions to answer before exiting include: will customers who currently buy the unprofitable line also buy other lines from the business, or will they shift entirely to a competitor? Will the fixed costs currently allocated to the exited line stay the same or reduce? If the overhead that was allocated to the exited line does not actually decrease when the line is removed, the business may save less than the analysis suggests because the remaining overhead must be

Q4: How does product line profitability analysis help with pricing decisions?

A4: Pricing decisions in MSMEs are often made defensively, based on what competitors charge or what customers are willing to pay, rather than from a clear understanding of the margin contribution required. Product line profitability analysis changes this by making the margin consequence of each price point visible. An owner who knows that a product line at its current price generates 8% gross margin can calculate exactly how much the price needs to increase to reach 15% gross margin, and can then evaluate whether the market would accept that increase. If some customers would accept the

Q5: Can product line profitability be tracked in Tally or other accounting software used by MSMEs?

A5: Implementing cost centre tracking in Tally typically requires: creating a cost centre for each product line or service type, activating cost centre tracking in the company configuration, and then ensuring that each sales invoice and purchase entry is tagged to the correct cost centre. The CA or Tally operator can set this up in a two to four-hour session. Once active, the cost centre wise profit and loss report in Tally shows revenue and direct cost by product line automatically from the transaction data, without any additional manual work per month. For the overhead allocation

Q6: How many product lines should I analyse separately?

A6: The practical test for whether to split or combine segments is: would knowing the separate profitability of these two sub-groups change any decision the business makes? If selling cotton fabric and polyester fabric at different margins to different customers would change the sales team's priorities or the pricing approach, they should be separate segments. If they are sold to the same customers, at similar prices, with similar costs, and managed identically, combining them is more practical. For a business starting segment analysis for the first time, beginning with five or six broad segments and refining

Q7: How often should product line profitability be reviewed?

A7: The timing of a segment profitability review matters because the review should drive action, not just observation. An annual review done as part of the year-end process can inform the next year's sales targets, pricing decisions, and inventory investment by product line. A mid-year review done in September or October can inform price adjustments or sales focus changes before the year-end without needing to wait for the annual analysis. Businesses in which one or two product lines are particularly sensitive to commodity price movements (steel, chemicals, food commodities) should track the margin on those specific

Q8: What does it mean if my highest-revenue product line has the lowest profit margin?

A8: The strategic response to a large-revenue, low-margin product line depends on the cause. If the margin is low because prices have not kept up with cost increases, a systematic price review is the first action. If the margin is low because the line is genuinely commoditised (many competitors, little differentiation), the business has three realistic options: accept the low margin because the volume drives other sales or operational efficiencies; attempt to differentiate the offering to justify a higher price; or reduce commitment to the line and redirect the freed capacity to higher-margin lines. The worst

Q9: How does service line profitability analysis differ from product line profitability analysis?

A9: For service businesses, a useful additional metric is revenue per billable hour or revenue per staff member by service type, which shows how efficiently the team is generating revenue across different service lines. A high-revenue service that requires a large number of senior staff hours may generate less profit than a lower-revenue service delivered by more junior staff or through a more standardised process. Service line profitability analysis in Indian service MSMEs often reveals that high-complexity, custom work (projects, bespoke consulting) generates lower effective margins per hour than recurring, standardised work (maintenance contracts, standard audits,

Q10: What is the first step an MSME should take to start tracking product line profitability?

A10: Most MSME accounting systems record revenue by product type or service category at the invoice level, meaning the revenue by segment is usually already available from the accounting records without any system changes. The direct cost matching is the part that requires the most care. For trading businesses, the purchase cost per unit or per product category is available from purchase invoices. Matching total revenue to total purchase cost by category over twelve months produces the gross margin by category. For manufacturing, the bill of materials cost per product must be established, which may require
Please submit any questions via the 'suggestions' window. We are committed to enhancing the user experience by remaining fair, transparent, and user-friendly.


© 2025 - Desi Ustad, All rights reserved.
! Advertisements !
! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.