The 9 costs that eat your GP and are not in your spreadsheet

A deal sheet usually has three lines you can count on: what you pay for the goods, what you get paid for them and the freight. Some add the haulage to the customer. What almost none of them capture are the small items that turn up around every container —a certificate, a port fee, a bank charge, a few extra days at the terminal— and that, one at a time, do not seem to deserve a row.

Together they do. In this article’s example, a container of quinoa with a GP of €3,800 on the sheet (9.5 % of sales), the nine missing items add up to €2,049: more than half the margin. The real GP ends up at €1,751, 4.4 %. Below are the nine, grouped into three families, with a way to estimate each one before you quote.

One container, with and without the nine

The example: a trader based in Spain buys 20 tonnes of quinoa FOB at origin for USD 37,400 (€34,000 with the euro at 1.10 dollars), imports it and sells it cleared and delivered to a European customer’s warehouse for €40,000. The example carries no import duty: if your product pays one, it is usually on the sheet already, because it is the first thing anyone asks. The amounts for the nine items are a constructed, rounded example, not a quotation; each one is explained below with its formula so you can redo it with your own rates.

None of the nine is a disaster. No vessel is lost and no customer fails to pay: these are the normal items of a normal shipment. Three of them do not even happen on every container, which is why they are budgeted differently. The rule holds for all of them: if an item shows up in your deals, even now and then, it deserves a row with an estimate, however small.

The ones you pay on every shipment

Four fixed items that appear on almost every container and get forgotten because they are small or because they arrive on a separate invoice.

1. Quality, weight and origin certificates

The buyer, or the letter of credit, usually asks for a quality and weight certificate issued by an independent inspector at loading; depending on the product and the destination, also a phytosanitary certificate and a certificate of origin. Each has its own fee per lot or per analysis, and if an analysis comes out off-spec it has to be repeated. How to estimate it: ask your inspector for the per-lot rate with the analyses your sales contract requires, and add the official certificates. It goes per shipment, not per tonne.

2. Port fees and charges

If you import, the destination terminal’s charges —container handling, the THC— and the port fees are yours; in Spanish ports, for example, the goods also pay the port authority’s T-3 cargo fee. If you export and sell FOB or CIF, the origin ones fall to you. Which side you pay is decided by the Incoterm of each contract, and it is the first thing to check. How to estimate it: ask your forwarder or customs agent for the breakdown per container —including their clearance fee, which is often missing too— and check it against the invoices every quarter.

3. Bank charges

An international transfer to the supplier does not cost only what your bank charges. Depending on the charge option on the order —OUR, SHA or BEN— the intermediary bank deducts its fee along the way and the supplier receives less, or the fee is billed to you afterwards. If you pay or get paid by documentary collection or letter of credit, add issuing, advising, confirmation and, if the documents have discrepancies, the discrepancy fee. How to estimate it: take what each deal cost you over the last few months from your statements, payment and collection included, and use it as a fixed amount per shipment.

4. Cargo insurance

If you buy FOB, the risk is yours from the moment the goods are on board, and no rule obliges you to insure them: which is exactly why sometimes nobody does. If you sell CIF, the Incoterms® 2020 rules require the seller to insure at least the contract price plus 10 %, with the cover of the Institute Cargo Clauses (C); CIP requires the broader Clauses (A) (ICC). How to estimate it: sum insured times your policy’s premium rate. In the example, 110 % of purchase plus freight (€35,800) at an illustrative premium of 0.15 %: about €59. It is the cheapest item on the list and the most expensive one not to have.

The ones that do not always happen

Three items do not show up on every container, so the sheet leaves them at zero. Zero is the wrong estimate: if something costs €600 one time in five, each container costs €120 on average. They are budgeted at their expected cost, the same way an insurer prices a premium.

Expected cost = Probability × Cost when it happens

Physical inspection:  20 % × €600 = €120 per container
Demurrage:            25 % × €300 =  €75 per container

5. Customs inspection

At Spanish customs, for example, a declaration goes through a green channel (released as is), orange (document check) or red (physical examination of the goods). The red channel, and for some foods the border health checks, cost money even when everything is in order: positioning the container in the inspection area, opening it, the agent’s attendance and the terminal days that run out in the meantime. How to estimate it: count in your history how many containers went through physical examination and what each one cost; that frequency times that cost is your line. In the example, 20 % × €600 = €120.

6. Quality claims

An analysis at destination showing one point more moisture than the contract ends in an agreed discount, and that discount comes out of your margin weeks after closing; the article on the margin you collect shows it on a specific container. How to estimate it: add up last year’s agreed claims and divide by what you invoiced. If it comes to 1 %, reserve 1 % of sales on every deal: €400 in the example. If one product or one origin claims much more than the rest, give it its own percentage.

7. Demurrage

A container that stays at the terminal beyond its free days pays demurrage per day, at a rate that rises in tiers. The cause is almost always a document or a payment that did not arrive on time, and often it is the inspection in point 5 itself that eats the free days. How to estimate it: with the illustrative tariff from the demurrage article —five free days and €60 a day from the sixth to the tenth— if one container in four leaves on day 10, each container carries 25 % × €300 = €75 on average. Better than budgeting it is seeing it coming: that article explains which dates to watch.

The ones about money and time

The last two never arrive on a logistics invoice. They come from the bank and from the calendar, which is why they slip off the sheet most easily.

8. Exchange-rate difference

If you buy in dollars and sell in euros, the exchange rate enters the deal in two places. The first is a certain cost: your bank does not sell you dollars at the published reference rate but with a spread. At 0.5 % on the €34,000 purchase that is €170, whatever the market does. How to estimate it: compare the rate on your last currency purchases with the reference rate for the same day; the average difference is your spread.

The second is the movement of the rate between fixing the price and paying. That is not an expected cost but a risk, and it is not budgeted as one more line: you measure how much the margin can take and decide whether to hedge it. It is explained in the FX gap article, and you can try it with your own figures in the FX risk calculator.

9. Working-capital financing cost

You pay the supplier at shipment and collect from the customer once the goods have arrived, been cleared and their payment term has expired: ninety days in the example. During that time the purchase money is tied up, and you pay for it in interest on your credit line or in what your cash stops earning.

Financing cost = Amount advanced × Annual rate × Days ÷ 360
               = €34,000 × 5 % × 90 ÷ 360 = €425

At 5 % a year and ninety days that is €425: the largest of the nine items in the example, and the one that never appears on a deal sheet. How to estimate it: use your credit line’s rate and the actual days between payment and collection on your last deals, not the contractual ones. A customer who pays ten days late does not change the price, but does change this number.

How to add them to your sheet without rebuilding it

You do not need a new system. An afternoon and your last ten closed deals are enough:

1. 1Add a row per item, even if it stays at zero. A row at zero says “I thought about it and it does not apply”; a row that does not exist says nobody thought about it.
2. 2Give each one its basis: per container, per tonne, per shipment, as a percentage of value or per day. A per-container fee charged per tonne gets multiplied by twenty without anyone noticing.
3. 3Give it its currency. Destination fees are in euros and freight is often in dollars; converting by hand inside each cell is the fastest way to get it wrong.
4. 4The ones that do not always happen, at their expected cost, with the frequency from your own history.
5. 5At settlement, write the real amount next to it without deleting the estimate. The difference tells you which estimates to correct next quarter.

Then divide the sum of the nine by the sales of those ten deals. That percentage is what your sheet was not showing you, and it is yours, not the example’s nor a market average. If it is larger than the gap between your sheet margin and the minimum at which you accept a deal, you have closed deals you did not want to close.

And they are not the only ones. Agents’ commissions, weight loss between origin and destination or a misclassified duty have the same effect. These nine are the ones most often forgotten, not the complete list.

What Granel does with this, and what it does not

In Granel a new deal starts with a template of twelve cost lines that already includes the certificate, port fees, insurance, customs inspection, bank charges and the claim reserve, plus freight, land transport, FOB charges, the B/L and the buying and selling commissions. Each line carries its currency and its basis —per container, per tonne or per shipment— and you can rename them or add the ones that are missing, such as demurrage or financing cost. At settlement each one keeps the real amount next to the estimate, and P&L is consolidated in your base currency with the ECB reference rate.

What Granel does not do is know your rates: you enter the amount of each line, or it comes in with your spreadsheet import. Nor does it compute the expected cost of an inspection or the working-capital financing cost: if you want them in GP, they go in as one more line with the amount you worked out. What changes is that the row exists on every deal from day one, and a line at zero is visible.

Frequently asked questions

What hidden costs come with importing or exporting a container?

The nine most often forgotten are: quality, weight and origin certificates; port fees and charges; bank charges; insurance; customs inspection; quality claims; demurrage; the bank’s FX spread; and the financing cost of the money you advance. Which ones fall to you depends on the Incoterm of your purchase and of your sale.

How do you budget a cost that does not always happen?

At its expected cost: how often it happens in your history multiplied by what it costs when it does. If a physical inspection costs €600 and hits one container in five, budget €120 on each one.

How do you calculate the financing cost of a trade deal?

Amount advanced times annual interest rate times the days between payment and collection, divided by 360. €34,000 at 5 % for 90 days is €425. Use the actual days from your last deals, not the contractual ones.

How much must be insured on a CIF sale?

Under the Incoterms® 2020 rules, the seller must insure at least the contract price plus 10 % (110 %), with the cover of the Institute Cargo Clauses (C), unless the contract asks for more. Under CIP the minimum cover is that of Clauses (A).