FX Cost Is the Line You Feel but Cannot See. Here’s How to Fix It in Microsoft Dynamics.
I ask finance leaders one question all the time.
“How much did foreign exchange actually cost you last quarter?”
Almost everyone knows the euro moved. Almost nobody knows exactly what that movement cost their business.
That's not because they're bad at finance. It's because most ERP systems show an estimate, not what actually happened.
After nearly 20 years working alongside Microsoft Dynamics partners and finance teams, I've learned something. It may start with a reporting problem. But once you solve reporting it shines a light on the bigger problem, actual FX costs. The next question is almost always, "Wait...we're paying how much?"
The good news? If you're running Microsoft Dynamics 365 Business Central or Finance & Supply Chain Management, you're already much closer than you think.
It really comes down to breaking it into two different jobs:
Seeing your FX costs accurately.
Lowering your FX costs strategically.
Dynamics does the first extremely well, especially with free tools available through Microsoft Marketplace. The second usually requires looking beyond your current bank.
How do I see my FX cost in Business Central?
Three simple steps make all the difference.
Connect a live exchange rate service. Business Central and Finance & Supply Chain Management both support automatic exchange-rate feeds such as FloatRates or the European Central Bank. Manual exchange rates go stale. Stale rates quietly distort every foreign currency balance you're reporting.
Run foreign currency revaluation regularly. Business Central calls this Adjust Exchange Rates. Finance & Supply Chain Management calls it Foreign Currency Revaluation. Schedule it so month-end becomes a whole lot less surprising.
Give every foreign vendor its native currency. Good news is you may have already set a default currency for your vendors but make sure you verify it is captured on each account. Because once live exchange rates are flowing into Dynamics, the vendor record becomes the foundation for meaningful FX reporting.
Everything above uses an indicative exchange rate, the best market reference available when the invoice was entered or approved. The actual settlement rate isn't known until payment is completed. Until the settlement data comes back into Dynamics, your FX gain/loss report is still an educated guess.
How do I lower FX costs in Dynamics 365?
CAPTURE. Write the actual settlement rate back into Dynamics automatically. Most organizations pay internationally through a bank portal, then manually reconcile everything back into the ERP. The missing piece isn't another report, but rather, it's getting the actual settlement data back into Dynamics automatically. Corpay Cross-Border's Microsoft-approved integrations allow international payments to be initiated directly from Dynamics and automatically writes settlement information back into D365 BC and F&SCM. [Insert screenshot: indicative rate vs. actual settlement rate]
LOCK the rate when the stakes are high. Imagine this. Your purchasing team just negotiated an incredible deal with a new supplier in Germany. Everyone celebrates. Ninety days later it's time to pay the invoice. The supplier didn't change the price. The exchange rate did. That's exactly where a forward contract can help protect the margin your purchasing team worked so hard to negotiate. By locking today's exchange rate for a future payment, you remove the uncertainty before it has a chance to impact your margins. Plus, D365 can be easily updated to reflect that committed rate so finance moves from scorekeeper to strategist. Score!
MANAGE your currency risk with a defined strategy. Not every international payment should be hedged. The right approach depends on your currency exposure, payment timing, cash flow, margins, and your organization's tolerance for risk.
That's why Corpay uses a disciplined four-step framework called C.A.S.E. to help clients:
Capture
foreign currency exposures.
Analyze
currency risk and risk appetite.
Strategize
a hedging policy aligned to business goals.
Execute
a dynamic strategy that evolves with changing market conditions.
The goal isn't to hedge every payment. It's to build a repeatable approach that helps finance teams reduce uncertainty and protect margins as their global business grows.
The mistake I see over and over again
Companies spend months perfecting their reporting, then settle millions of dollars in payments at exchange rates they never measure. Great dashboards. Wrong number. The answer isn't another report. It's bringing the real settlement rate into your ERP and reducing unnecessary exposure before market movement impacts your margins.
Frequently Asked Questions
Can Business Central automatically update exchange rates?
Yes. It supports automatic exchange-rate services including FloatRates and the European Central Bank.
Does Business Central calculate realized FX gain and loss?
Yes, but accuracy depends on the rates available inside the ERP. Writing actual settlement rates back into Dynamics provides a more accurate picture.
Can I hedge foreign currency while using Business Central?
Yes. Forward contracts and other FX risk management tools can reduce exposure while supporting predictable reporting.
Is my bank giving me the best exchange rate?
Maybe. The more important question is whether you're measuring what you actually paid and comparing available alternatives.
The short version
Dynamics is already very good at helping you see your FX exposure. But reducing FX costs requires one more step: capture the actual settlement details, reduce manual payment processes, and partner with specialists when the exposure justifies it.
After nearly two decades in the Microsoft ecosystem, I've learned that finance teams aren't looking for another platform. They're looking for fewer surprises, cleaner month-end closes, better visibility, lower costs, and one less spreadsheet sitting on someone's desktop.
If Microsoft Dynamics is already running your business, the next opportunity is helping it do one more thing exceptionally well.
Switch to Corpay
Discover how making the move to Corpay streamlines payments and strengthens your business.
Talk to an ExpertSmarter payments. Stronger growth. Keep business moving.
Corpay powers payments for 800,000+ businesses worldwide. Let’s build what’s next for yours.