My Local Shops logoMy Local Shops.in
How to Calculate Actual Landed Cost Per Piece After Charges, Short Delivery and Claims
Trade Manager

How to Calculate Actual Landed Cost Per Piece After Charges, Short Delivery and Claims

See how a wholesaler can calculate the recoverable cost of each sellable piece after purchase value, freight, other charges, damaged goods and short delivery.

Actual landed cost per piece is the amount a wholesaler must recover from every sellable unit after including the purchase value and applicable costs needed to bring the goods into the business. When fewer pieces are sellable than were ordered, dividing by the ordered quantity understates the real cost and can make the owner sell at a loss.

The practical formula is:

Actual landed cost per sellable piece = Total landed cost allocated to the item ÷ Sellable quantity actually received

This guide explains how Trade Manager applies that principle, what happens to missing or damaged pieces, how claims should be treated, and how the owner can turn the result into a selling-price target.

At a glance

QuestionAnswer
What belongs in landed cost?Purchase value plus applicable freight, delivery, commission, duty and other recorded costs
Which quantity is used before receiving?Ordered quantity, because the actual sellable quantity is not known yet
Which quantity is used after receiving?Sellable quantity actually recorded across the trade's consignments
Are damaged but sellable pieces included?Yes, if the owner deliberately classifies them as sellable
Are completely non-sellable pieces included in the divisor?No. Their cost must still be recovered from the pieces that can be sold
Are missing pieces included in the divisor?No. They did not become inventory
Does raising a claim immediately reduce landed cost?No. A claim is a follow-up record, not money or replacement stock already received
Does unpaid supplier credit reduce product cost?No. An unpaid purchase amount is still part of the cost of the goods
Can Trade Manager suggest a selling price?Yes. The owner can add a target markup and receive a whole-rupee selling suggestion

The common calculation that causes wholesalers to sell below cost

Suppose a wholesaler orders 100 shirts at ₹100 each and pays another ₹100 in applicable charges.

Before receiving, the simple calculation appears to be:

CalculationAmount
Purchase value: 100 × ₹100₹10,000
Other applicable charges₹100
Total landed cost₹10,100
Cost divided by 100 ordered pieces₹101 per piece

But only 80 shirts are received in sellable condition. The business cannot recover ₹10,100 by pricing against 100 pieces because 20 pieces are not available for sale.

The actual recoverable cost becomes:

CalculationAmount
Total landed cost₹10,100
Sellable quantity actually received80 pieces
Actual landed cost: ₹10,100 ÷ 80₹126.25 per sellable piece

If the owner treats ₹101 as the cost, every sold shirt appears to have ₹25.25 more profit than it really has. Across 80 pieces, that error hides ₹2,020 of purchase and trade cost.

This is why the strongest part of Trade Manager is not only knowing where a purchase has reached. After receiving, it helps the owner understand what each available piece must recover.

How Trade Manager calculates landed cost

Step 1: Record every purchased item separately

Each item keeps its ordered quantity and purchase rate. The basic item value is:

Ordered quantity × Purchase rate

If the trade has several products at different values, they should not be combined into one unnamed quantity. The value of each item later determines its proportionate share of common trade costs.

Step 2: Convert a foreign purchase into rupees

For a domestic INR trade, no currency conversion is needed.

For a foreign-currency trade, Trade Manager needs a defined exchange-rate source:

  • actual recorded payment rates when payments have been made;
  • an expected rate when the order is still unpaid; or
  • an older saved rate for legacy records.

The calculation does not intentionally treat one unit of foreign currency as one rupee. If a usable rate is missing, the owner is prompted to provide one before relying on the costing.

When a payment agent's charged rate is higher than the market rate recorded for that payment, the difference can be recognised as agent commission rather than being hidden inside the goods' exchange value.

Step 3: Add the applicable trade costs

Depending on the purchase, total landed cost can include:

  • international cargo charges from every consignment;
  • local-delivery charges from every consignment;
  • payment-agent commission;
  • importer commission;
  • customs or Basic Customs Duty;
  • Social Welfare Surcharge;
  • anti-dumping duty;
  • IGST entered by the owner; and
  • other custom costs that genuinely belong to the trade.

The total used by Trade Manager is:

Purchase value in INR + International transport + Local delivery + Applicable commissions and duties + Other recorded costs

Not every field applies to every purchase. A domestic order may only need the purchase value and local transport. An import may involve several additional lines.

IGST and its availability as input-tax credit can have accounting consequences specific to the business. Record the factual amount, but ask the business's CA how it should be treated for tax and financial reporting. Trade Manager organises the input; it does not replace professional tax advice.

Step 4: Allocate shared cost across different items

When one trade contains multiple item types, Trade Manager allocates the total landed cost according to each item's share of the purchase value—not merely by how many pieces it has.

Consider this order:

ItemQuantityRateItem valueShare of purchase value
Basic shirts60₹100₹6,00042.86%
Premium shirts40₹200₹8,00057.14%
Total100₹14,000100%

If common trade costs are ₹1,400, allocating them by item value gives approximately:

  • Basic shirts: ₹600 of common cost
  • Premium shirts: ₹800 of common cost

Giving both item types the same cost per piece would make the cheaper and more expensive products subsidise each other incorrectly.

Step 5: Record sellable, non-sellable and missing quantities

Receiving is where estimated per-piece cost becomes actual per-sellable-piece cost.

For each item, the owner records:

  • Sellable: the piece can enter inventory and be sold, even if the owner later chooses a discounted price for a minor defect.
  • Non-sellable: the piece physically arrived but is a complete write-off and will not enter inventory.
  • Missing: the piece did not arrive.

Trade Manager sums sellable quantity across all consignments belonging to the trade. A split order therefore does not use only the first or last shipment's quantity.

Step 6: Re-divide the item's fixed landed cost over sellable pieces

Once receiving exists, the item's allocated landed cost is divided by the sellable quantity.

Using the opening example:

Purchase value                         ₹10,000
Applicable additional charges            ₹100
Total landed cost                     ₹10,100
Sellable quantity received                  80
Actual landed cost per sellable piece   ₹126.25

The cost of the missing and completely non-sellable units does not vanish. Until the business genuinely receives a recovery, the available pieces carry the amount that still needs to be recovered.

Step 7: Add a target markup for selling guidance

The owner can enter a desired markup on cost. If the target is 20%:

Actual cost per sellable piece   ₹126.25
20% markup                         ₹25.25
Unrounded selling target          ₹151.50
Suggested whole-rupee price       ₹152

Trade Manager rounds the suggested selling price up to the next whole rupee. It does not round ₹151.50 down to ₹151 and quietly place the result below the selected target.

For 80 pieces sold at ₹152:

ResultAmount
Expected sales₹12,160
Total landed cost₹10,100
Expected profit₹2,060
Effective markup after whole-rupee roundingApproximately 20.4%

The suggested price is a business target, not a mandatory invoice price. The owner can still decide the market price, retailer-specific rate or discount.

What happens when a claim is raised?

A missing or damaged-goods claim and a landed-cost calculation answer different questions:

RecordQuestion answered
ReceivingWhat physically arrived, and how much is sellable?
ClaimFrom whom is the owner seeking recovery, for what issue and with what status?
CostingWhat recorded cost must currently be recovered through the sellable quantity?

Merely raising a ₹2,000 claim does not mean ₹2,000 has been recovered. Trade Manager therefore does not silently subtract the claimed amount from landed cost when the claim status is still open.

If the supplier later sends replacement pieces

Record the additional actual receipt in the relevant trade or consignment context. When the sellable quantity increases, the same applicable landed cost is spread over the larger sellable quantity.

In the opening example, if all 20 missing shirts later arrive sellable:

₹10,100 ÷ 100 = ₹101 per piece

If a claim is rejected or written off

The available sellable pieces continue carrying the unrecovered cost. The claim status explains why the loss was not recovered.

If a claim is settled with money

The claim record should show the commercial resolution. A monetary settlement does not automatically rewrite the original supplier payment, receipt quantity or landed-cost inputs merely because the claim status changed. Review the final accounting treatment with the CA and do not subtract an amount before it is genuinely recovered.

This separation is deliberate: changing costing automatically on the basis of an open or loosely marked claim could understate product cost.

Why unpaid supplier credit is still part of cost

Suppose the ₹10,000 goods order has only ₹6,000 paid and ₹4,000 remains due to the supplier. The product did not become cheaper because the payment is pending.

Trade Manager treats the unpaid amount as an outstanding purchase obligation while retaining the full order value in landed cost. It can show the paid and credit portions of the item cost, but the total per-piece cost still reflects everything the business owes for those goods.

Otherwise an owner could sell the stock cheaply, then discover that the remaining supplier payment consumes the expected profit.

Complete clothing-wholesale example

A wholesaler orders 300 printed shirts from a domestic supplier:

DetailValue
Ordered quantity300 pieces
Purchase rate₹200 per piece
Purchase value₹60,000
Local transport₹2,000
Loading and handling₹1,000
Total landed cost₹63,000

The supplier dispatches the order in two consignments.

Actual receiving

Quantity typeConsignment 1Consignment 2Total
Sellable170115285
Non-sellable325
Missing7310
Accounted for180120300

The actual cost per sellable shirt is:

₹63,000 ÷ 285 = ₹221.05 per sellable shirt

At a target markup of 25%:

₹221.05 × 1.25 = ₹276.31, rounded upward to a suggested ₹277 per shirt

If the owner had divided by all 300 ordered pieces, the apparent cost would have been only ₹210. That would understate the recoverable cost of every available piece by ₹11.05.

The owner can raise claims for the missing or damaged quantities while keeping the current sellable-stock decision grounded in the 285 pieces actually available.

What the owner enters and what the system calculates

Owner-entered facts

  • item quantity and rate;
  • transaction currency;
  • payments and applicable exchange-rate inputs;
  • transport charges for each consignment;
  • commissions, duties, IGST and custom costs that apply;
  • sellable, non-sellable and missing quantities;
  • claim party, type, amount and status; and
  • desired profit markup.

System-calculated results

  • purchase value in rupees;
  • supplier amount paid and remaining;
  • total landed cost;
  • each item's share of landed cost;
  • per-piece purchase, extra-cost and final landed-cost breakdown;
  • paid and unpaid portions of item cost;
  • suggested selling price per piece;
  • expected total selling value; and
  • expected profit and effective markup after price rounding.

What the owner should review before trusting the result

  1. Are all purchased items and rates correct?
  2. Is the exchange rate valid for a foreign trade?
  3. Are charges from every consignment included?
  4. Has the same charge accidentally been entered twice?
  5. Are duties and commissions recorded in rupees correctly?
  6. Is each received piece classified as sellable, non-sellable or missing?
  7. Are later replacement pieces reflected in receiving?
  8. Is a claimed amount being mistaken for money already recovered?
  9. Does the selected target markup match the owner's commercial plan?

The app makes the arithmetic consistent, but the result remains only as truthful as the recorded business facts.

Common mistakes

Dividing by ordered quantity after a short receipt

This treats unavailable pieces as if they can generate sales. Use the actual sellable quantity after receiving.

Dividing by all physically received pieces

A completely non-sellable piece was physically delivered, but it cannot recover normal sales revenue. Do not include it in sellable quantity.

Removing cost as soon as a claim is raised

A claim is not a refund. Keep unrecovered cost in the current calculation until the business outcome genuinely changes.

Ignoring unpaid supplier balance

Pending payment is still an obligation and part of the goods' cost.

Adding only the largest expense

Small freight, handling, commission and local-delivery amounts can become meaningful across a trade. Include applicable costs before deciding the selling target.

Allocating common expenses only by piece count

When item values differ, equal per-piece allocation can distort both products. Trade Manager allocates at trade level according to purchase-value share.

Treating suggested price as guaranteed market profit

The suggested price is based on recorded cost and target markup. Actual profit still depends on the price achieved, discounts, later expenses and whether every sellable piece is sold.

Frequently asked questions

What is landed cost per piece?

It is the allocated purchase and applicable trade cost divided by the quantity that can actually be sold.

Should missing pieces be included when calculating cost per piece?

No. Missing pieces are not sellable inventory. Until a genuine recovery occurs, their unrecovered cost remains part of what the available pieces must recover.

Should damaged pieces be included?

Include a damaged piece only if the owner still classifies it as sellable. A completely non-sellable piece is excluded from the sellable divisor.

Does Trade Manager calculate cost before goods arrive?

Yes, it can show an estimate using ordered quantity. After receiving is recorded, it uses actual sellable quantity for the received-cost view.

Are all shipment charges included when an order arrives in parts?

Yes. International and local charges recorded across the trade's consignments contribute to the total costing.

Does a claim reduce landed cost automatically?

No. Raising a claim does not prove recovery. Replacement receipt or an actual monetary settlement must be treated according to what genuinely happened.

Why is the selling suggestion rounded upward?

Rounding upward to a whole rupee prevents the displayed suggestion from falling below the target markup because of normal decimal rounding.

Can the calculated selling price be changed during billing?

Yes. It is guidance for the owner. The actual SKU selling price and invoice rate can reflect the business's current commercial decision.

Know the cost before deciding the selling price

Purchase rate is only the starting point. The amount a wholesaler must recover depends on the complete trade cost and the number of pieces that can genuinely be sold.

Download Trade Manager to track purchases and costing, read the complete Trade Manager guide, or see how received goods move into inventory and billing.

#landed cost calculator#actual cost per piece#short delivery#damaged goods#trade claims#wholesale selling price