View Rent Schedule Values in Different Currency - Common Procedure

If your contract or equipment contract is marked as In Translation, three additional columns appear in the Fiscal Details view.

• Asset Translation Adjustment: The value of this field equals the current month's asset balance plus the current month's asset amortization expense minus the prior month's asset balance.

  Asset Translation Adjustment = Current Asset Balance + Current Asset Amortization Expense - Prior Month's Asset Balance

• Liability Translation Adjustment: The value of this field equals the current month's asset balance plus the difference between the current month's payment and interest, minus the prior month's asset balance.

  Liability Translation Adjustment = Current Asset Balance + (Current Month's Payment - Current Month's Interest) - Prior Month's Asset Balance

• Cumulative Translation Adjustment: The value of this field is the current month's liability translation adjustment minus the current month's asset translation adjustment.

  Cumulative Translation Adjustment = Current Month's Asset Translation Adjustment - Liability Translation Adjustment

If you perform these procedures prior to following the Export a Lease Accounting Schedule into Excel procedures, the translated values will appear in your exported spreadsheet.

To view converted currency values on a Rent Schedule page:

1. Navigate to one of the following nine pages.

   Use the links in the Navigation Pane on the leftmost side of the page.

   • Contract > Accounting Info > ASC 842 Rent Schedule

   • Contract > Accounting Info > IFRS 16 Rent Schedule

   • Contract > Accounting Info > GASB 87 Rent Schedule

   • Equipment Contract > Accounting Info > ASC 842 Rent Schedule

   • Equipment Contract > Accounting Info > ASC 842 Rent Schedule >ASC 842 Equipment Schedules Page

   • Equipment Contract > Accounting Info > GASB 87 Rent Schedule

   • Equipment Contract > Accounting Info > GASB 87 Rent Schedule >GASB 87 Equipment Schedules Page

   • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule

   • Equipment Contract > Accounting Info > IFRS 16 Rent Schedule >IFRS 16 Equipment Schedules Page

2. Select the schedule whose converted values you want to view from the Rent Schedule List.

   The schedule data appears on the page.

3. Select the Fiscal Details option above the lease accounting schedule table.

4. The Fiscal Details view of your lease accounting schedule appears.

5. Select the Calculate FX Impact check box.

   Several columns are added to the right side of the lease accounting schedule table. These columns contain the converted values of your lease accounting schedule.

   Additionally, the Translated Initial Balance and Translated Initial Liability Balance appear to the right of the Target Currency field. These fields display the converted values of your Translated Initial Balance and Translated Initial Liability Balance.

6. Select the currency whose conversion you want to view from the Target Currency field.

   The translation columns in the lease accounting schedule table update to show currency values in your target currency.

7. Scroll the page to the right to see the currency conversion columns.

   The conversion rates used appear in the Period Average Rate and Cash Rate columns.