Multi-currency sales and reporting.

Sales teams that work across borders quickly run into a reporting question. A deal in euros, an invoice in US dollars, and a subscription in Australian dollars each look like a number, but they are not the same kind of money. Adding them without thought produces a total that means nothing. Converting them carelessly produces a total that depends on the day the conversion was made. This article explains why amounts should keep their original currency, how to report across currencies, how exchange rates and timing affect the figures, how to forecast with several currencies, and the practical rules that keep the numbers honest.

Keep the original currency

The first rule is to record every amount in the currency in which it was agreed. A proposal signed for 50,000 euros is a fact about the deal. If the CRM stores only a dollar equivalent, the team loses the original figure, and the customer’s price cannot be checked against the contract. Storing the original currency is the foundation of every other calculation.

The original currency also helps people read the data correctly. A salesperson who sees a value in yen knows that the customer buys in yen, and can plan the commercial conversation accordingly. A finance colleague who checks an invoice against a contract can compare like with like, without a conversion step that might introduce an error.

Make the currency a required field on every deal and invoice. A default helps for the most common currency, but people must confirm the currency for each record. A value entered without a currency is a common source of large reporting errors, and it is difficult to correct after the fact.

Report totals per currency

When an organisation reports totals, the cleanest approach is to show each currency separately. A dashboard that lists the revenue in euros, dollars, and pounds tells the reader exactly what was earned in each market. Nobody has to guess how a conversion was done, and nobody is misled by a figure that mixes the values.

Separate totals do have a cost. A board may want one number, and separate figures can feel fragmented. The answer is not to combine the currencies silently, but to choose a reporting currency deliberately and to show the conversion method next to the figure. The reader then knows what the total represents.

Sorting follows the same logic. A list sorted by value across several currencies puts amounts in an order that means little, because a figure of 100 in one currency may be far larger than 200 in another. Sort within a currency, or convert first and say so.

Exchange rates and timing

When a single reporting currency is required, conversion is necessary. The rate used matters. A figure converted at the rate on the day the deal closed differs from the same figure converted at the rate on the day the report was run. Both can be correct, but they answer different questions. The team should decide which rule applies and apply it consistently.

Many organisations use a fixed rate for each period, such as the average rate for the quarter or the rate on the last day of the month. Others use the rate on the transaction date, which records the value at the moment of agreement. Each method has trade-offs. The transaction-date method reflects the commercial reality of the deal, while the period-average method smooths short-term movements in the forecast. Document the choice, because a change of method changes the historical figures.

Timing also affects payments. An invoice billed in one currency and paid in another can produce a gap between the billed value and the cash received. A bank may convert the payment at its own rate, which adds a difference that is not visible in the CRM. Finance teams should reconcile these differences regularly, so that sales figures and cash figures tell a consistent story.

Forecasting in several currencies

Forecasts are harder than reports, because they depend on uncertain future rates as well as uncertain deals. A common approach is to forecast each currency in its own terms, then convert the total at a rate the team has agreed for planning. This keeps the sales judgement separate from the currency assumption, so a change in the exchange rate does not hide a change in the pipeline.

Sensitivity is worth knowing. If a large share of the pipeline sits in one currency, a movement in that rate can shift the reported total significantly, even when the deals do not change. A simple check is to recalculate the forecast with a rate 5 or 10 percent higher and lower, and to show the range. This helps leaders understand which part of the number is about the market and which part is about the team.

Keep forecasts and actuals in the same currency structure. If the forecast is shown in dollars and the actuals are shown in euros, the variance report will confuse everyone. Choose one structure and maintain it, even if it takes extra work.

Practical rules for the team

Write down a few rules that everyone can follow. Record the original currency on every amount. Show totals per currency unless a single reporting currency has been chosen. State the conversion method beside any converted figure. Use the same method for each period, and document any change. Reconcile sales figures with finance figures each month.

Train people on the reason behind the rules. A salesperson who understands why the currency matters will take the time to enter it correctly. A manager who understands the conversion method will ask the right question when two reports disagree. Knowledge prevents the most expensive errors, which are usually small mistakes repeated across many records.

Review the currency setup each year. Check which currencies are active, which ones are rarely used, and whether any market has grown enough to need its own reporting line. A tidy setup makes the team’s numbers easier to read and easier to audit.

Summary

Each amount should keep the currency in which it was agreed. Reports should show totals per currency, or convert with a clearly stated method when one reporting currency is required. Exchange rates and timing change the figures, so the team should choose a rule, document it, and apply it consistently. Forecasts should separate the pipeline from the currency assumption, and the rules should be written down and taught. A team that handles currency carefully can compare markets fairly, explain its numbers to leaders, and trust the figures it shares.