Product Costing Template for Marketplace Sellers

Selling products on Amazon India, Flipkart, Meesho, Myntra, or your own ecommerce website requires more than choosing a competitive selling price. To build a profitable business, you need to understand how much each product actually costs you to sell.

Many sellers calculate profit by subtracting the purchase price from the selling price. However, this approach can overlook packaging, shipping, marketplace fees, advertising, returns, discounts, and other business expenses.

For example, a product purchased for ₹300 and sold for ₹599 may appear to generate ₹299 in profit. But after accounting for marketplace charges, fulfilment expenses, advertising, and other costs, the actual contribution may be much lower.

A product costing template helps sellers organise these expenses, calculate the total cost per unit, estimate profit margins, and determine a suitable selling price.

In this guide, you will learn how to build a practical product costing template for marketplace selling, which costs to include, how to calculate profit, and how to use your numbers to make better pricing decisions.

What Is a Product Costing Template?

A product costing template is a spreadsheet or structured worksheet used to calculate the total cost of purchasing, manufacturing, preparing, and selling a product.

It combines the relevant cost components into one place so you can understand your product’s unit economics.

A useful template may include:

• Purchase or manufacturing cost.

• Packaging and labelling.

• Shipping and fulfilment.

• Marketplace fees.

• Payment processing charges, where applicable.

• Advertising expenses.

• Expected return-related costs.

• Discounts and promotional expenses.

• Applicable taxes and input tax credit treatment.

• Selling price, contribution profit, and profit margin.

The template should help you answer four important questions:

1. What does it cost to sell one unit?

2. What is the minimum selling price needed to cover the costs included in the calculation?

3. How much contribution profit remains at the current selling price?

4. Is the product profitable after accounting for the costs relevant to your business?

A spreadsheet can also help you compare multiple products and identify which items deserve a pricing review.

Why Marketplace Sellers Need a Product Costing Template

1. To Understand Actual Product Costs

A product’s purchase price is only one component of its total selling cost.

A product purchased for ₹250 may require ₹20 in packaging, ₹60 in shipping, and ₹80 in marketplace and other selling charges. If these expenses are not recorded, the seller may overestimate profitability.

A costing template brings these expenses together.

2. To Set Profitable Selling Prices

Before launching a product or participating in a marketplace sale, sellers need to know the lowest price they can reasonably accept.

A costing template helps establish a break-even reference point and a target contribution margin.

3. To Evaluate Discounts

Marketplace promotions can increase order volume, but discounts may also reduce profit per unit.

By entering a proposed discounted price into the template, sellers can estimate whether the offer leaves sufficient contribution to support the business.

4. To Compare Marketplace Performance

The same product may have different economics across different selling channels.

For example, fulfilment costs, marketplace fees, advertising expenses, and return rates may vary between Amazon India, Flipkart, and an independent website.

A costing template can help you compare those differences using channel-specific inputs.

5. To Identify Unprofitable Products

Some products generate strong sales but contribute very little profit after all relevant costs.

Reviewing product costs can help you identify items that need a supplier negotiation, pricing adjustment, packaging improvement, or a different marketing strategy.

Product Costing Template: Essential Columns

A practical product costing spreadsheet should contain the information needed to calculate costs and evaluate pricing.

For a growing business, you may also add monthly fixed overheads, inventory costs, tax treatment, target margin, and break-even quantity.

How to Calculate Product Cost Step by Step

Step 1: Calculate Purchase or Manufacturing Cost

Begin with the amount you pay to purchase or manufacture one unit.

For purchased products, use the appropriate landed cost where possible. This may include supplier charges, inbound freight, and other costs required to bring the inventory to its intended location.

For manufactured products, include relevant materials, direct labour, and production expenses according to your chosen costing method.

If eligible GST input tax credit is available, ensure the cost model does not incorrectly treat recoverable GST as a permanent product cost. Non-recoverable taxes and duties may need different treatment.

Step 2: Add Packaging Costs

Calculate the packaging materials used for one order.

For example:

These are illustrative figures.

If you ship several products in one package, allocate the packaging cost appropriately instead of charging the full amount to every item.

Step 3: Add Shipping and Fulfilment Costs

Include the shipping and fulfilment expenses that your business bears.

These may include forward shipping, marketplace fulfilment charges, storage charges allocated per unit, or other relevant expenses.

Use the actual rate applicable to your product’s category, dimensions, weight, fulfilment method, and selling channel.

Step 4: Add Marketplace Fees

Marketplace fees can include referral fees, closing fees, collection charges, fulfilment charges, or other applicable deductions.

Do not use a single assumed percentage for every marketplace or category. Refer to the current fee schedule and seller statements.

If a fee is calculated as a percentage of the selling price, model it separately from fixed per-order charges.

Step 5: Estimate Advertising Cost per Order

Advertising expenses should be included when you want to understand profitability after paid acquisition.

A simple calculation is:

[
\text{Ad Cost per Order}=
\frac{\text{Advertising Spend}}{\text{Attributed Orders}}
]

Suppose you spend ₹6,000 on advertising and attribute 120 orders to those campaigns.

[
₹6,000 \div 120=₹50
]

The estimated advertising cost is ₹50 per attributed order.

Attribution methods have limitations, so this figure should be interpreted consistently with your advertising platform’s reporting.

Step 6: Account for Returns and Other Variable Costs

Returned products may create reverse shipping expenses, handling costs, unrecovered fees, and inventory losses.

Estimate these costs using your historical data wherever possible.

Avoid counting costs twice. For example, if your return allowance already includes reverse shipping, do not add the same reverse shipping expense again elsewhere in the calculation.

Step 7: Calculate Total Variable Cost

Add the variable expenses that are attributable to a unit or order.

[
\begin{aligned}
\text{Total Variable Cost}={}&
\text{Product Cost}\
&+\text{Packaging}\
&+\text{Fulfilment}\
&+\text{Marketplace Fees}\
&+\text{Advertising}\
&+\text{Return Allowance}\
&+\text{Other Variable Costs}
\end{aligned}
]

Keep percentage-based charges separate if you need to calculate the selling price required to cover them.

Example: Product Costing for an Amazon India Seller

Imagine a seller lists a desk organiser at a selling price of ₹799, excluding GST for this simplified illustration.

The seller estimates the following costs per order:

The contribution profit is:

[
₹799-₹490=₹309
]

The contribution margin is:

[
\frac{₹309}{₹799}\times100\approx38.7%
]

Under these assumptions, the product generates ₹309 in contribution per order, or approximately 38.7% of the stated revenue.

These figures are illustrative and are not actual Amazon fee estimates. The calculation assumes that the stated revenue and costs use a consistent tax basis and that all listed expenses are relevant to the order.

Important: Contribution profit is not necessarily final net profit. Monthly salaries, rent, software, administration, income tax, and other overheads may still need to be accounted for.

How GST Should Be Handled in a Product Costing Template

GST needs careful treatment because the amount collected from a customer is not always the same as the seller’s revenue.

For a registered seller making a taxable sale, the model should distinguish between the taxable selling value, output GST, and any eligible input tax credit.

For example, suppose a product sells for ₹1,180 including GST at an assumed rate of 18%.

The illustrative breakdown is:

The 18% rate is used only for illustration; the actual rate depends on the product’s classification and applicable rules.

If the seller is entitled to input tax credit on eligible business purchases, recoverable GST should generally not be treated as a permanent cost in the same way as non-recoverable tax. The seller must still calculate output tax liability and eligible credits under the applicable GST provisions.

A costing template should therefore include separate fields for:

• Selling price excluding GST.

• GST charged to the customer.

• Selling price including GST.

• Product costs on a consistent GST basis.

• Eligible input tax credit, where relevant.

• Non-recoverable taxes or charges.

For tax compliance, verify the applicable GST treatment with a qualified GST practitioner or official guidance.

How to Calculate Profit Margin in Your Template

Two calculations are especially useful: contribution profit and contribution margin.

Contribution Profit

[
\text{Contribution Profit}=
\text{Net Sales Revenue}-\text{Variable Costs}
]

This shows how much remains from a sale after the variable costs included in the model.

Contribution Margin

[
\text{Contribution Margin (%)}=
\frac{\text{Contribution Profit}}{\text{Net Sales Revenue}}\times100
]

Suppose your net sales revenue is ₹1,000 and your relevant variable costs are ₹700.

Your contribution profit is ₹300, and your contribution margin is 30%.

This is different from markup. A 30% margin does not mean you added 30% to your cost.

For a complete business profitability analysis, deduct fixed operating expenses and other costs not included in the variable-cost calculation.

How to Set a Minimum Selling Price

A product costing template can help you establish a minimum selling price before launching a discount or changing your listing price.

If all costs are fixed amounts per unit and there are no percentage-based selling fees, the break-even price is approximately the total relevant unit cost.

However, marketplace fees often include charges calculated as a percentage of selling price.

If (C) represents other variable costs per unit and (r) represents percentage-based fees as a decimal, a simplified break-even formula is:

[
P=\frac{C}{1-r}
]

For a target contribution margin (m), the simplified formula becomes:

[
P=\frac{C}{1-r-m}
]

These formulas assume the relevant percentages apply to the same selling-price base and that other costs are fixed per unit. Actual marketplace fees, taxes, and pricing arrangements may require a more detailed calculation.

Example

Suppose other variable costs total ₹400, marketplace fees equal 10% of the selling price, and your target contribution margin is 20%.

[
P=\frac{₹400}{1-0.10-0.20}
]

[
P=\frac{₹400}{0.70}\approx₹571.43
]

Your required selling price is approximately ₹572 under these assumptions.

This is a planning estimate. Validate the actual fee base, tax treatment, and costs before setting your live price.

How to Use the Template to Evaluate Discounts

Before offering a discount, compare the current selling price with the proposed discounted price.

Suppose a product has ₹450 in variable costs and currently sells for ₹799.

The discount reduces contribution by ₹100 per unit, assuming costs remain unchanged.

If the discount increases order volume, the additional sales may partly or fully offset the lower contribution per order. To assess this, compare the total contribution from each scenario rather than looking only at revenue.

For example, if the seller expects more orders at the discounted price, calculate:

[
\text{Total Contribution}=
\text{Contribution per Order}\times\text{Orders}
]

The more profitable option depends on the resulting contribution and any additional expenses created by the promotion.

Product Costing Template: Recommended Spreadsheet Formulas

If you build your template in Excel or Google Sheets, the following formulas provide a useful starting point.

These are conceptual formulas; replace the named fields with the actual cell references in your spreadsheet.

Use error handling for zero orders or zero revenue, and ensure that the formula does not count a percentage-based marketplace fee twice.

Common Product Costing Mistakes to Avoid

1. Ignoring Marketplace Fees

A product may appear profitable if you subtract only its purchase cost from the selling price.

Better approach: Use the current fee schedule and actual settlement statements to include the charges your business bears.

2. Mixing Prices With and Without GST

Subtracting costs recorded on one tax basis from revenue recorded on another can produce misleading results.

Better approach: Keep revenue, costs, output GST, and eligible input tax credit clearly separated.

3. Forgetting Advertising Expenses

Paid advertising can consume a significant portion of the contribution earned on an order.

Better approach: Track advertising cost per attributed order and review it alongside sales and contribution metrics.

4. Ignoring Returns and Refunds

Returned products can generate costs that are not visible in a simple purchase-cost calculation.

Better approach: Use actual return records to estimate return-related costs and avoid double-counting expenses.

5. Treating Contribution Profit as Net Profit

Contribution profit does not automatically include rent, salaries, software, administration, and every other overhead.

Better approach: Use the product costing template for unit economics, then prepare a broader profitability analysis for the business.

6. Using the Same Cost Assumptions for Every Marketplace

Different channels may have different fulfilment arrangements, fees, and return patterns.

Better approach: Maintain channel-specific costs for each SKU and review them when fee schedules or operational conditions change.

How Competitor Price Tracking Supports Product Costing

A product costing template tells you what a product costs to sell. Competitor price tracking helps you understand how that product’s selling price compares with relevant competing offers.

Combining the two can support better pricing decisions.

For example, your template may show that a product requires a selling price of ₹650 to achieve your target margin, while comparable competitors are offering similar products for ₹599.

Instead of immediately matching the lower price, investigate whether you can reduce costs, improve product differentiation, or justify the price through better features or service.

A competitor monitoring platform such as EcomTracker can be evaluated as part of this workflow. Check its current offering to confirm which marketplaces, product comparisons, reporting features, and monitoring frequencies are available.

Visit EcomTracker.in to review its current capabilities.

Frequently Asked Questions

1. What is a product costing template?

A product costing template is a spreadsheet or worksheet that records product purchase or manufacturing costs, packaging, fulfilment, marketplace fees, advertising, return expenses, and other relevant costs to estimate profitability.

2. What should a product costing template include?

At a minimum, include the SKU, marketplace, product cost, packaging, shipping, applicable fees, advertising, return allowance, selling price, contribution profit, and contribution margin. Include GST and fixed overheads in clearly separated fields where relevant.

3. Can I use the same template for Amazon and Flipkart?

You can use the same overall structure, but maintain separate fee and fulfilment inputs for each marketplace. Charges and operational costs may differ by category, product dimensions, fulfilment method, and seller programme.

4. How do I calculate profit per product?

Subtract the relevant variable costs from net sales revenue. For full business profitability, also account for fixed overheads and other expenses not included in the per-unit calculation.

5. Should GST be included in product cost?

It depends on the tax treatment. Eligible recoverable input tax credit should generally be separated from permanent product costs, while non-recoverable taxes may need to be included. Keep output GST separate from revenue when calculating profitability.

6. How often should I update my product costing template?

Review it whenever supplier costs, shipping charges, marketplace fees, advertising costs, return rates, or product specifications change. A regular monthly review is also useful for sellers with a significant product catalogue.

7. Can a product costing template help me avoid losses?

It can help you identify prices that do not cover the costs included in your model. However, the results depend on accurate data, complete cost categories, and consistent tax and fee assumptions.

8. Is a product costing template useful for small ecommerce businesses?

Yes. Even a small seller can benefit from tracking the true cost of each product. A simple spreadsheet with a few essential cost fields can be enough to reveal whether a product is contributing to the business or consuming its margin.

Conclusion

A product costing template helps marketplace sellers understand the economics behind every sale. By recording product costs, packaging, shipping, marketplace fees, advertising, returns, and other relevant expenses, you can calculate contribution profit and set more informed selling prices.

The most useful template is one that reflects your actual business model and is updated whenever costs change. Keep GST treatment consistent, avoid double-counting expenses, and separate contribution profit from final net profit.

Before launching a discount or matching a competitor, check whether the proposed selling price supports your target contribution margin. Combine accurate product costing with competitor price monitoring to make decisions that support sustainable ecommerce growth.

Next step: Create a product costing sheet for your best-selling SKUs, validate the inputs against recent invoices and marketplace statements, and review the results before your next major pricing change.