Shipment Profitability: Track Real Costs and Margin Variances

Measure each export shipment's real profit: budget vs actual costs by category, variance analysis, FX, break-even and target-margin prices, what-if tests.

Most exporters know the margin they quoted. Far fewer know the margin they actually made. Between the quotation and the moment the money is converted, freight rates change, a truck waits two days at the port, the buyer deducts a few broken cartons, the bank charges more than expected and the exchange rate moves. Each item is small; together they can halve the profit of a shipment without anyone noticing until the year-end accounts.

Tracking each shipment's real cost and profitability closes that gap. It means recording a budget for every cost when you quote, the actual amount when the invoice arrives, and explaining the differences. The result is not just a better view of the past: it is the most reliable input for your next price.

This lesson shows how to set up a shipment budget, collect actuals, analyse variances, compute break-even and target-margin prices, and test scenarios, with a worked example of a container of olive oil shipped from Algeria to Marseille.

Why the quoted margin is not the real margin

The margin in a quotation rests on assumptions: a freight rate, a raw material price, an exchange rate, a smooth port passage, a buyer who accepts the goods. Reality differs in predictable ways:

• Logistics surprises: surcharges, waiting time, demurrage and detention, extra handling.
• Product cost changes: raw material bought later and at a higher price than budgeted.
• Revenue deductions: quality claims, shortages, price adjustments settled by credit notes.
• Finance and bank costs: collection or letter of credit fees, correspondent bank charges, late payment.
• Exchange rates: the gap between the budget rate and the rate at conversion.

None of these will show up if you only compare total sales with total costs at the end of the year.

Step 1: Budget the shipment when you quote

Use the same categories for every shipment so that you can compare them. A practical set:

The estimates come from your export price build-up: this is the same table, kept alive after the quotation.

Step 2: Record the actuals as invoices arrive

For each category, record the amount on the supplier's invoice (forwarder, broker, haulier, bank, insurer, laboratory), the currency and the date. Record the actual revenue: the commercial invoice minus any credit note, plus any debit note, and the exchange rate at which the proceeds were actually converted.

Step 3: Analyse the variances

The shipment remains profitable, but it lost 3,231 EUR, or 18% of its planned margin. The breakdown says where:

Controllable or not?

Classify each variance, because the response differs:

• Controllable (internal): the demurrage caused by a certificate corrected late, the broken cartons (packaging or loading), buying oil after quoting instead of securing it. Fix the process.
• Partly controllable: the exchange effect (it could have been hedged, see currency risk) and freight surcharges (a clause passing new surcharges at cost, or a validity tied to the carrier's rate).
• External: a general market move. Price it into the next quotation.

Step 4: Turn actuals into prices for the next quote

The actual costs give you three numbers to carry forward.

• Cost per unit: 63,825 / 11,700 = 5.46 EUR per litre (budgeted 5.29). Tracking cost per kg or per unit by product and destination shows trends that totals hide.
• Break-even price: 5.46 EUR per litre. Any price below it loses money on this lane at current costs.
• Price for a 22% target margin: 63,825 / 0.78 / 11,700 = 6.99 EUR per litre, against 6.80 quoted.

The exporter now knows that its 6.80 EUR price no longer delivers the planned margin; either it raises the price, or it attacks the controllable variances (packaging, document timing, buying raw material when the order is confirmed).

Step 5: Test scenarios before you quote again

A what-if test shows how fragile the margin is. Starting from the updated costs (63,825 EUR) and the current price:

Freight matters less than it seems for this product; price and exchange rate matter most. The exporter decides to ask for 6.95 EUR per litre and to sell forward part of the expected euro proceeds.

A simple risk score per shipment

Alongside the margin, score each shipment's risk, for example from 1 (low) to 3 (high) on: payment method (advance, LC, D/P, open account), buyer history, country risk, perishability, exchange exposure and margin cushion over break-even. A shipment with a thin margin and a high risk score deserves a better price, better terms, or a second thought.

Close the loop: KPIs and routine

• Margin variance per shipment: actual margin minus budgeted margin, target within ±2 points.
• Cost per kg or per unit by lane: to spot drift in logistics costs.
• Share of incidents: demurrage, claims and rework as a percentage of revenue.
• Days to close a costing and days sales outstanding.

Review closed shipments every month with sales, logistics and finance together. Feed the lessons into your export business plan and your price lists.

Common mistakes

• Closing the costing before the last forwarder and bank invoices arrive.
• Recording costs in a lump sum instead of by category, so variances cannot be explained.
• Ignoring the exchange rate at conversion and measuring profit in the invoice currency only.
• Forgetting credit notes and claims when computing revenue.
• Allocating no cost to the time and money tied up in waiting for payment.
• Analysing variances but never changing the next quotation.

Putting it into practice

On Incoforms, each shipment has a costing that takes its revenue from the invoice or from recorded sales and lists every cost by category with an estimate and an actual, so variances appear as costs come in. It computes the product cost per kg or per unit, the break-even price, the price needed for your target margin and a risk score, and its what-if simulator tests changes in price, exchange rate, freight and costs.