Three multi-currency costing mistakes that quietly cost exporters lakhs
FX math is where margin disappears between quote and invoice. Here are three places it goes, and how to keep it from going there.
Margin in a garment export business is thin. Five percent on a small order. Eight on a good one. Ten if everything goes right.
Foreign exchange has the unique ability to remove margin without anyone noticing it has done so. By the time the invoice clears and the bank statement lands, the merchandiser who quoted the style has moved on to next season’s costings. Nobody traces the missing rupees back to a Tuesday afternoon when the dollar was 83.42 and we quoted 83.20.
Here are three places where it happens.
Mistake 1. Quoting at the spot rate
The single most common mistake in the merchandising team. Open the costing, copy the morning’s exchange rate into the FX cell, divide cost by rate, get the dollar quote. Send.
The problem is that the rate you quoted at is not the rate you will be paid at. Lead times are 45 to 90 days. The dollar moves over 45 to 90 days. If your quote was at 83.42 and the invoice clears at 82.80, you have lost ₹62 per piece on a $100 style. Multiply by 2,000 pieces.
The fix. Quote at the spot rate plus a buffer. Industry-normal is 4 to 6%. It is not a markup. It is a hedge against your own quote. If the dollar holds, the buffer becomes extra margin. If the dollar drops, you have not bled.
If your costing tool does not have a buffer % field next to the FX rate, you are leaving margin on the table by design.
Mistake 2. One rate, all styles
A more subtle one. Many spreadsheets store the exchange rate in a single cell, the “FX” tab. That cell is referenced by every style. When you update the rate for a new quote, every previously-quoted style now shows a different cost in the dashboard.
This is fine when the spreadsheet is a single quote. It is a disaster when it is the year’s costings, because:
- Last week’s quote to Buyer A is now valued at this week’s rate.
- The dashboard’s “average cost per piece” drifts as the dollar drifts.
- Margin reports become meaningless.
The fix. Store the FX rate on each style, as of the moment that style was quoted. A new style picks up today’s rate. An old style stays at the rate it was quoted at. Your dashboard now reflects what you actually committed to.
Mistake 3. Forgetting per-buyer currency memory
Some buyers want their quote in dollars. Some in euros. Some in pounds. A few unusual ones in francs or rupees, depending on the brand’s parent company.
When a new merchandiser quotes a style and forgets which currency that particular buyer prefers, the wrong default fires. The buyer sees a number in EUR when they were expecting USD. The deal slows down. The merchandiser apologises, requotes, the dollar has moved 0.4% in the meantime.
The fix. Store the preferred currency on the buyer record. When the merchandiser picks Maison Olive from the buyer dropdown on a new costing, EUR pre-fills. The default cannot be wrong, because it is the only default that exists.
What this looks like in software
In TextileCost, three things are baked in by default:
- Every style stores its own FX rate at the time it was quoted. The dashboard shows the historical, not the live.
- Every style has an editable buffer % field next to the rate. The default is 5%. You can change it per style.
- Every buyer in the buyer master has a default currency. Picking the buyer picks the currency.
These three together close around 80% of the FX leak we used to see in spreadsheet costings.
The other 20% is the merchandiser updating quotes too late, which no software can fix. But the three above? Those are software problems, and they have software answers.
If your FX is currently a single cell in a single tab in a single spreadsheet, that is the place to look first. Even before you decide what tool to use next.
TextileCost is one option. There are others. The principle is the same regardless.