Convert currency for invoices

We need to issue the invoice to a Madrid customer in euros while our books stay in USD. Convert the invoice line items to EUR at today’s rate, include the conversion math on the invoice, and make sure the total in USD is stored for accounting. Send the converted invoice to Elena at Grupo Sol on Friday and confirm the accounting entry will pick up the USD amount before sending.

Before I send this euro invoice to the customer, make the conversion transparent so procurement can approve: show the original USD subtotal, the exchange rate used, the fee (if any), the resulting EUR line totals, and a clear EUR grand total at the top. Flag any rounding differences larger than €0.50 and note if the accounting system will record a currency gain/loss.

I created a $12,400 invoice for Elena at Grupo Sol but she needs to be billed in euros and our accounting must keep USD. I’m worried about choosing a rate that creates reconciliation noise and about who absorbs FX fees. What is the likely best practice here — which exchange rate source, whether to show both currencies on the invoice, and who should we assign to cover any small rounding difference? Also what checks catch a missed USD accounting line before sending?

We keep spending hours converting invoices for non‑USD customers and reconciling small FX variances. It costs developer time and annoys finance when GBP or EUR totals don’t match. What habit or small process change will stop this recurring work — one that doesn’t require engineering to rewrite billing? Suggest a default exchange rate source, where to display both currencies, and a simple owner for rounding discrepancies so invoices go out without extra reviews.