Learn how to upload exchange rates to Zuora Revenue by navigating through file upload options, downloading and updating templates, and ensuring data accuracy.

1. Navigate to File Upload > Custom .
2. To download and update the exchange rate template, complete the following steps:
   1. Hover your mouse over the Monthly Exchange Rate Upload template line and click the Download Template icon to download the template file.
   2. Open the template file, and fill in the following information:
      • From Currency: Enter the appropriate functional currency. All functional currencies should have been already created and uploaded in Zuora Revenue.
      • To Currency: To Currency:Use this field to enter a currency type from the already uploaded functional currencies in the system. If the reporting currency is updated as USD in the system, then To Currency must be updated as USD.
      • Start Date: Specify the start date of the month.
      • End Date: Specify the end date of the month.
      • Exchange Rate: Specify the exchange rate that is used to convert the home currency into the transaction currency for the set duration.
      • Exchange Rate type: Specify the exchange rate type. The valid values include Period Average and Period End. Period End rates are used for the balance sheet account, and Period Average rates are used for the Profit/Loss accounts.

      Note:

      • The start date and end date must be set according to the calendar setup. Zuora Revenue will use the calendar's end date every month to determine the respective exchange rate from the uploaded exchange rates.
      • Ensure that all field details that you enter in the upload file contain no typos because the system will not do any no validation against the input. If erroneous data are in the uploaded file, the system cannot derive the reporting currency fields correctly.
      • This CSV file is provided as an example for your reference
      • Ensure that all field details that you enter in the upload file contain no typos because the system will not do any no validation against the input. If erroneous data are in the uploaded file, the system cannot derive the reporting currency fields correctly.

      .
   3. Save your changes in the file. The exchange rate template file is updated.
3. To upload the exchange rate template file to the list, complete the following steps:
   1. Hover your mouse over the Monthly Exchange Rate Upload template line and click the Upload icon .
   2. Choose the local file that you just updated and then click Upload .