---
title: "Update Exchange Rates"
slug: "update-exchange-rates"
description: "Edit this template to update exchange rates and review impact to country price lists."
updated: 2022-12-13T00:05:51Z
published: 2022-12-13T00:05:51Z
canonical: "docs.zilliant.com/update-exchange-rates"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Update Exchange Rates template

## Objective

Use the recommendations in this template to update exchange rates and review impact to country price lists.

## Example flow

![Update Exchange Rates example flow](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/update_exchange_rates_QS_workflow.png?sv=2026-02-06&spr=https&st=2026-11-11T22%3A39%3A00Z&se=2026-11-11T23%3A39%3A00Z&sr=c&sp=r&sig=hT%2F1M%2FLnH9vQOgt%2FNs%2Bvcgg6LdUtksutXfjQvkHfuBY%3D)

## Edit data

1. Open the **Manage Exchange Rates** scenario workbook.  

When you created the scenario, this workbook was loaded with data from base and decision support workbooks.
2. Open the **Update Exchange Rates** worksheet.
3. In the **New Rate** column, update rate values. Update values manually or upsert data from a CSV file.
4. Update values in the **Start Date** column.

          Tip

          

Use information from the **Rate Change** column for additional decision support. Values shown in this column are calculated as follows:

```
CASE 
    WHEN COALESCE ({New Rate}, 0) = 0 THEN NULL 
    ELSE ({New Rate} - {Current Rate) / {Current Rate} 
END
```

1. Open the **Review Country List Prices** worksheet to review the **New Country List** value, which shows how the new rate affects country list prices.

          Note

          

By default, the **Review Country List Prices** worksheet is filtered to show only records with rate changes.

---

The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.

#### New Country List

```
{List Price} * {New Rate}
```

#### Price Change

```
CASE 
    WHEN COALESCE ({Country List}, 0) = 0 THEN NULL 
    ELSE ({New Country List} - {Country List}) / {Country List} 
END
```

---

## Publish data

1. In the **Update Exchange Rates** worksheet, select the **Publish** checkbox for records that represent updated and final data. This information will be published back to the base and master data workbooks.
2. From the **Actions** menu, select **Publish**.

The selected records are synchronized with the **Exchange Rates** waterfall element workbook.