Welcome to Zuora Product Documentation

Explore our rich library of product information

Provider exchange rate date offset

Learn about the the Provider Exchange Rate Date Offset setting.

The Provider Exchange Rate Date Offset setting controls which date the system uses to look up the exchange rate when generating journal entries. When this setting is configured, the system retrieves the exchange rate from a date that is earlier than the transaction date by the specified number of days.

Offset calculation

The system calculates the exchange rate lookup date using the following formula:

Exchange Rate Lookup Date = Transaction Date − Provider Exchange Rate Date Offset

The following table shows how different offset values affect the rate lookup date:

Offset

Transaction date

Rate lookup date

Rate applied

0 (default)

January 15

January 15

Rate for Jan 15

1

January 15

January 14

Rate for Jan 14

2

January 15

January 13

Rate for Jan 13

Journal Entry rate discrepancies with the rate table

If you have configured a Provider Exchange Rate Date Offset greater than 0, the exchange rate applied to a journal entry will not match the rate in the FXCustomRate table for the transaction date. This is expected behavior.

This worked example demonstrates how the offset creates a rate discrepancy:

  • Transaction date: January 15

  • Provider Exchange Rate Date Offset: 1

  • FXCustomRate table contains:

    • January 14: 1.2566

    • January 15: 1.2536

Result: The journal entry uses the rate 1.2566 (from January 14), not 1.2536 (from January 15). This is because the system applied the offset and looked up the rate for January 14, not the transaction date.

Note:

If you observe a rate discrepancy between a journal entry and the FXCustomRate table, check your Provider Exchange Rate Date Offset setting before raising a support ticket. The discrepancy is likely expected behavior caused by the offset.