All Collections
Sales Imports & Mapping
How to Change the Exchange Rate on Imported Lines
How to Change the Exchange Rate on Imported Lines

Applies to digital statements, physical statements, and publishing income.

Sara avatar
Written by Sara
Updated over a week ago
  1. If you have mistakenly imported a file with the incorrect exchange rate, you have two options:

    1. Deactivate and delete the sales lines and then re-import the file with the correct exchange rate.

    2. Use the Currency Converter tool.

  2. The Currency Converter can be used on Import Data.

    1. If the lines that need correcting have been mapping & activated, you will need to Deactivate them before proceeding.

  3. Navigate to the appropriate sales container. Click Search/Edit to open the Import Data window.

  4. Scroll to the bottom right. Click on Currency Converter.

  5. If you originally imported the file with no exchange rate (or an Import Currency Rate of 1.0000), you simply need to enter the correct exchange rate here and apply to all lines.

  6. The Import Currency Rate in the statement container will update accordingly.

  7. If you originally imported the file with an incorrect exchange rate other than 1.000, you have two options.

  8. Example: A file was mistakenly imported with an exchange rate of 1.023. Our target exchange rate is 0.997.

    1. To fix the exchange rate by only using the Currency Converter tool once, divide the target exchange rate by the imported exchange rate.

      1. Divide 0.997/1.023 = 0.97458456. Apply 0.97458456 to all imported lines.

      2. The Import Currency Rate in the statement container should now read 0.997.

    2. First, we'll run the Currency Converter to get the Import Currency Rate back to 1.000. Then we'll run it a second time to get it to the new, correct exchange rate.

      1. Divide 1/1.023 = 0.97751711. Apply 0.97751711 to all imported lines.

      2. The Import Currency Rate in the statement container should now read 1.000.

      3. Apply the correct exchange rate of 0.997 to all imported lines.

      4. The Import Currency Rate in the statement container should now read 0.997.

Did this answer your question?