--- updatedAt: 2026-07-01T18:12:55.000Z agentTools: siteIndex: https://docs.recurly.com/llms.txt projectIndex: https://docs.recurly.com/recurly-revrec/llms.txt --- # Derive exchange rate for external data Recurly RevRec automatically derives the correct currency exchange rate for contracts, invoices, and costs created outside Recurly, based on their creation date.

Recurly RevRec can derive the correct exchange rate for any contract, invoice, or cost created outside Recurly — based on its creation date. That means no more supplying manual rates when you import or reconcile multi-currency subscription data. Flag the lines you want, and the system fills in the historical rate that was in effect.

Part of Recurly RevRec — learn more

1Definition 2Key benefits 3Subscriptions 4Costs

# Definition

The Derive ExRate feature automatically retrieves the appropriate currency exchange rate — by contract date for subscriptions and by invoice date for invoices — so you don't need to upload rates manually for external data feeds. You can derive rates for uploaded cost lines too.

# Key benefits

Automated accuracy Each line uses the historical rate in effect on its creation date, for precise revenue recognition.

Streamlined imports Skip extra columns and manual effort — just flag Derive ExRate and let the system handle the rest.

Consistent reporting Keeps multi-currency analytics in sync without rate discrepancies or human error.

### How derivation is controlled RevRec derives exchange rates for subscriptions and invoices created outside of Recurly, and for uploaded cost lines — so you never have to upload exchange-rate files manually. The feature is controlled through two attribute labels: * **Contracts:** `Derive ExRates` (under contract attributes) * **Costs:** `Cost Derive ExRates` (under cost attributes)

# Derive exchange rates for subscriptions For subscriptions and order lines, enable derivation from Setup → Attribute Labels.

You can enable this feature in either of the following ways. ## Method 1: Set Derive ExRate in your upload file Use this method when you want to control derivation line by line in the file you upload.

Add a Derive ExRate column

Add a column named Derive ExRate to your upload file.

Flag each line

For each line where you want RevRec to derive the exchange rate, enter Yes or Y in the Derive ExRate column.

## Method 2: Configure a data rule Use this method when you want RevRec to derive exchange rates for all uploaded order lines by default.

Open Data Rule

Go to Transformation → Data Rule.

Create a new data rule

Enter a name and select Order Line as the object.

Set the attribute

Under Application Attributes, select Derive ExRate, and under Value, enter Yes.

Save the data rule

After you save, RevRec automatically populates Derive ExRate = Yes for all uploaded order lines.

### Behavior and defaults

If Derive ExRate is set to Yes or Y, you don't need to upload exchange rates for that line — RevRec derives them automatically.
After collection, the sales order line shows Derive ExRate = Y when derivation is enabled.
If the field isn't set, it defaults to N (or No).

# Derive exchange rates for costs For cost lines, enable derivation from Setup → Attribute Labels → Cost.

You can enable this feature in either of the following ways. ## Method 1: Set Cost Derive Ex Rates in your cost upload file Use this method when you want to control derivation line by line for costs.

Add a Cost Derive Ex Rates column

Add a column named Cost Derive Ex Rates to your cost upload file.

Flag each cost line

For each cost line where you want RevRec to derive the exchange rate, enter Yes or Y in the Cost Derive Ex Rates column.

## Method 2: Configure a data rule Use this method when you want RevRec to derive exchange rates for all uploaded cost lines by default.

Open Data Rule

Go to Transformation → Data Rule.

Create a new data rule

Enter a name and select Cost as the object.

Set the attribute

Under Application Attributes, select Cost Derive Ex Rates, and under Value, enter Yes.

Save the data rule

After you save, RevRec automatically populates Cost Derive Ex Rates = Yes for all uploaded cost lines.

### Behavior and defaults

If Cost Derive Ex Rates is set to Yes or Y, you don't need to upload exchange rates for that cost line — RevRec derives them automatically.
After collection, cost lines display the derive flag as Y when enabled.
If the field isn't set, it defaults to N (or No).

# Sibling pages * [Autobill for external data](https://docs.recurly.com/recurly-revrec/docs/autobill-for-external-data.md) * [Datasets](https://docs.recurly.com/recurly-revrec/docs/data-sets.md)