How to Track Foreign Currency Quotes in Your CRM

Short answer

A foreign currency quote should be stored in your CRM with three facts: the quote currency, the exchange rate on the quote date and the local currency value at that rate. Forecasts and targets are then read at one fixed reporting rate. That way, when the rate moves, you can see whether the team actually sold more or only the currency changed.

What is a foreign currency quote, and why track it separately?

A foreign currency quote is an offer priced in a currency other than the one you report in, such as dollars or euros. It needs separate tracking because its value in your reporting currency changes every day between the quote and the payment.

Many B2B companies that sell machinery, spare parts, software or imported materials quote in dollars or euros and invoice in local currency. The salesperson sees one number when the quote goes out, and finance sees another when the cash comes in.

How do you record a foreign currency quote in your CRM?

Fill in the following fields for every deal quoted in a foreign currency. If one of them is missing, your forecast drifts with the exchange rate.

Quote currency: USD, EUR or local currency. A picklist, not free text.
Quote amount: The figure written on the offer to the customer.
Quote rate and date: The exchange rate used on the day the quote was prepared, and its source, such as your central bank's published rate.
Local value at quote date: Amount times quote rate. This field is never edited afterwards.
Invoice rate rule: Which day's rate the invoice will use: invoice date, payment date or a fixed rate.
Quote validity: How many days the price and the rate are guaranteed.

Most CRMs and ERPs already support multiple currencies. The real problem is rarely a missing field. It is the salesperson converting the quote in their head and typing a single local number.

Why does the sales forecast go wrong when the exchange rate moves?

The forecast goes wrong because two separate effects end up in one number: the sales effect and the currency effect.

Example calculation: your open deals add up to $500,000. At the start of the month, with an example rate of 40 to the dollar, the forecast reads 20 million in local currency. If the rate moves to 42 by month end, the forecast rises to 21 million without a single new deal closing. In the leadership meeting, that extra million gets read as "sales are going well".

The reverse happens too. If the rate falls, a team that worked hard looks like it is behind target. A forecast that swells and shrinks with the exchange rate cannot tell a sales manager which deals deserve attention.

Which exchange rate should you use in the sales forecast?

Use one reporting rate, fixed at the start of the period. Whatever rate the budget was built on, the forecast is read at that same rate.

In practice, two reports sit side by side:

Constant-rate forecast: Calculated at the budget rate. It shows how the sales team is performing.
Current-rate forecast: Calculated at today's rate. Finance uses it for cash planning.

The difference between the two is shown on its own line, labelled "currency effect". Now "we grew by a million this month" can be read as "200 thousand from sales, 800 thousand from the rate". We cover the cash side in Cash Flow Forecasting From CRM Data.

How should sales commission work on foreign currency deals?

Commission on foreign currency deals is calculated at the budget rate or the quote-date rate, not at the rate on the invoice date.

If commission follows the invoice rate, a salesperson earns more in a month when the currency rises, without doing anything different. When the currency falls, a good month pays less. Neither is fair, and both push salespeople to watch currency news instead of their deals.

How do you manage currency risk at the quote stage?

Currency risk at the quote stage is managed with two things: a validity period and an invoice rate rule. Keep both as CRM fields and they stop slipping through.

Keep quote validity short, for example 7 or 15 days, and flag expired quotes in your CRM.
On long projects, write the invoice rate into the contract and enter the same rule in the CRM field.
List expired foreign currency quotes that are still open in a separate weekly view. They carry prices set at an old rate.
Calculate discounts on the foreign currency amount. An extra discount given after conversion to local currency cuts your margin twice. More on this in How Discounting Erodes Your Margin.

A checklist for tracking foreign currency quotes

Does every open deal have its currency field filled in?
Are the quote rate and date recorded?
Is the local value calculated at the quote-date rate?
Does the forecast report show constant-rate and current-rate figures separately?
Is the commission rule written down, and does it match the number in the CRM?
Does someone review the list of expired foreign currency quotes every week?

If you can't answer "yes" to all six, part of your forecast is measuring the exchange rate, not your sales. For the rest of the forecast setup, see How to Forecast Sales From CRM Data.

Closync AI is a decision partner that connects to your CRM and ERP: it points out missing and inconsistent records, tells you which deals are at risk and turns your team's call notes into the right CRM fields.

FAQ

Is it enough to enter a foreign currency quote in local currency only?

No. If only the local figure is stored, the original quote is lost and the deal's value looks wrong as soon as the rate moves.

Which exchange rate source should we use?

Pick one source for the whole company, such as your central bank's published rate. What matters is that everyone uses the same one.

Should currency gains count toward a salesperson's target?

No. When targets and commission are measured at a fixed reporting rate, salespeople are judged on the work they actually control.

What if our CRM doesn't support multiple currencies?

Add three custom fields for currency, foreign amount and quote rate. The local value is then calculated automatically from them.

How do you show the currency effect in a report?

Put the constant-rate and current-rate forecasts side by side and show the difference on a "currency effect" line.

Last updated: 11 November 2026