Importing Data Into Accounting
      Back to home
      1. Help Center
      2. Lease Accounting
      3. Importing Data Into Accounting

      How do I import FX Rates?

      Instructions on how to use the Import templates in Occupier


      What is an FX rate?
      A Foreign Exchange Rate is utilized when a transaction and/or group of transactions occur in an exchange rate that differs from an entity's functional currency.

      Depending on the type of transaction, it will need to be converted to the entity's functional currency which can trigger other accounting impacts such as gain/loss on foreign exchange, among others. Occupier's Lease Accounting module assists customers with the conversion of lease accounting related balances (if applicable to your portfolio).

      Instructions for importing FX Rates

      To find the import tool and select the right import template, refer to the document titled "How Do I Import Data into Accounting?"

      This document will provide an overview of the import template guidelines for a successful import. 

      Using the import template, please populate the columns outlined below.

      iso_code_from column - In this column, you will need to populate the currency ISO code of the currency which you will be converting from. As an example if it is the United States Dollar you would enter USD. [Example list of currency codes].

      iso_code_to column - In this column, you will need to populate the currency ISO code of the currency which you will be converting to.  As an example if it is the Canadian Dollar you would enter CAD.  [Example list of currency codes].

      rate column - In this column, you will need to enter the rate in which you want to convert the currencies denoted in the ISO code from and ISO code to columns. This should be a number without any currency symbols (example 1.30).

      start_date column - This column will outline the start date in which this currency is applicable.  Note - this column must be in a YYYY-MM-DD format.

      end_date column - This column will outline the end date in which this currency is applicable. Note - this column must in a YYYY-MM-DD format.

      Note - To include a spot rate, you can simply leave the "end_date_column" field blank. If you want to add a monthly average rate for January 2022, set the start date as 2022/01/01 and the end date as 2022/01/31.