Exported Reports Display Unexpected Currency Totals

If your organization has Multiple Currencies enabled, be aware of the following when you total Currency fields within any Exported Report files:

When a report contains Currency fields, the total of the amounts displayed in the source report display the converted value of the selected currency.

Excel does not convert these currencies, so it sums the values in the designated cells. As a result, the total generated in Excel is different than the total displayed on the report when multiple currencies are involved. 
 

Example

In the "Opportunities" report below, each Opportunity has a value of 10,000, but each has a different currency associated.

Salesforce reports are designed to account for the currencies when totaling, so they accurately show the sum as 10,083.86 USD. There is a standard field created called Amount (Converted), which displays the value of the Opportunity amount, converted to the appropriate currency. When the "Amount (Converted)" field is summarized, the total reflects the converted amount of the default currency of the chosen currency (see the "Grand Total").

Note: The "Amount" field displays the same total as the "Amount (Converted)" field. This is by design as Salesforce does not sum values from different currencies without conversion.

Source Salesforce UI Report

However, when you view the exported report, the raw data will only reflect the purchased amount in the customer's currency. The conversion can only be viewed if the "Amount (Converted)" field is added to your report and summed in Excel after it has been exported.

Exported Report