Uploading Currency Exchange Rates

Currency Exchange Rates can be manually entered in Mosaic or uploaded from external tools to ensure accurate budgeting and tracking of project financials. This allows for comprehensive management of costs and Progress across Portfolios and Phases, especially when working with multiple currencies.

👍

Download the Sample File

Before uploading, download the import template to ensure a smooth upload process.

To upload currency exchange rate:

1. Confirm either Mosaic Support or your Customer Success Manager have enabled the currency exchange rate upload tool on your account. To request this tool be added to your account, reach out to our team via [email protected]

2. Next, fill out the currency exchange rate information on the template csv file download here

Here is an overview of the details needed for each column:

❗️

Please Note:

End Month column is optional. When provided, it limits how far the exchange rate should carry forward — but only if the months after the End Month already have rates defined.

If no rate exists after the End Month, the exchange rate will continue to carry over until a new rate is defined.

Example:

For Source Currency = USD, Destination Currency = AZN, Month = 2025-05, and End Month = 2025-09. The rate applies only from May through September, since those months already have values.

For Source Currency = USD, Destination Currency = AFN, Month = 2025-05, and End Month = 2025-09. The May rate will carry over through December.

3. Export your completed currency exchange rate import file to the .csv format. Date fields work best in .csv formats.

4. Navigate to Org Settings > Import page, and click on the + Upload button. Select Currency Exchange Rates as the Data to import. De-select the Automatic Field Mapping option to prevent columns from automatically mapping, thereby avoiding potential improper data imports.

   

5. Select the file you would like to import using the file selector or drag and drop the file here.

6. After the file is uploaded, the system attempts to automatically map the required information. Mapped columns can be adjusted by selecting a different option from the dropdown. To exclude a column from the import, select Don’t import to unmap it. Auto-population of data into the system fields may take a few moments to complete.

   

❗️

Red Highlighted Rows

Red highlighted rows indicate errors, which might be due to missing required fields, no matching values on Mosaic, or a typo. The number of errors is displayed next to the corresponding column name. Selecting a column shows all rows, with error rows highlighted in red and an error message displayed directly on the affected row. Please confirm if there is a typo, or if the value does not exist on Mosaic.

To view only rows with errors, select the Errors button at the top of the table.

If this is a typo, you can update the value in the uploader in the right side.

7. Once all errors are fixed, click Continue on the top to the Review & Edit step. If all data looks good, click Continue to the Import step.

8. Click Confirm Import in the Import step to submit data.

   

Note: You should see this message when it's successfully uploaded

9. Once the upload is complete, the import will appear in the Processing section. Allow time for the import to finish.

10. Thats it! Once the file processing is completed, it will show in the Completed section. Please allow up to 24 hours for exchange rates to finish populating on Mosaic.