An export trader we worked with sold custom furniture fittings to clients in Australia, Germany, and the United Arab Emirates. He invoiced in three currencies, got paid at unpredictable times, and did all his pricing in his head. One deal looked great on paper, then the exchange rate moved, and suddenly a “winning” order was barely breaking even. He knew it was happening but couldn’t prove it.
Why every order’s profit was a mystery until it was too late
The problem wasn’t that he was bad with numbers. It was that his numbers lived in disconnected places. The freight quote sat in one email, the supplier cost sat in another spreadsheet, and the customer’s currency sat somewhere in his memory. By the time the payment landed—sometimes 90 days after shipment—nobody could clearly say which orders had actually made money.
ERPNext Consulting took a practical, vendor-agnostic approach to this mess. We didn’t overcomplicate it. The goal was to have every order capture a few key numbers at the moment of creation: the supplier cost in the original currency, the customer price in the customer’s currency, the agreed exchange rate, and the estimated freight cost. Then the system converts everything into a base currency for reporting.
How exporting became routine instead of a gamble
Here’s the structure that made the difference for this trader:
- Every sales order asks for the customer’s currency and the agreed exchange rate at that moment, so the expected profit is calculated instantly in his home currency
- Freight costs are attached to each order as a line item instead of hidden in a vague “shipping” bucket, so the true landed cost is visible
- At the end of each month, a simple one-page report shows every open order, its expected profit at the original rate, and the current value of that profit if the rate has moved
Within one quarter, he could finally see which products and which markets made sense. Turns out, one of his “best” customers in Australia was actually producing the thinnest margins after currency conversion and freight. He didn’t fire them. He just changed the pricing structure and the currency clause in the contract. That one renegotiation added roughly 4% to his overall profit margin.
The part about timing that most exporters get wrong
I’ll share a specific habit that paid off. The trader used to let invoices sit unpaid for as long as the customer wanted. After the rollout, we set a rule: any invoice past 60 days gets a gentle but firm reminder, and any repeat customer with a history of late payment gets a slightly less favorable credit term. It sounds like simple business sense, but having it recorded in the system meant it actually happened. The average payment time dropped from 74 days to 51 days.
The deeper lesson is that currency risk doesn’t need to be a mystery. You don’t need a Wall Street background. You need to know, on the day you accept the order, exactly what profit you expect in your own currency. If that number moves later because of exchange rates, at least you know it and can respond.
If you’re selling across borders and your profit per order shifts wildly from month to month, sit down and write out how you currently calculate your expected profit. If the words “I just estimate it” appear anywhere in that process, an honest look at your last ten orders will probably surprise you. That’s your starting point. And it’s exactly the kind of starting point where ERPNext Consulting can make a real difference.