Using Foreign Currency Amortization
Foreign currency amortization is available only in NetSuite U.K. editions.
Use the same process to work with foreign currency amortization that you use to amortize expenses in a single currency. The basic amortization process involves these steps:
-
Create templates. For information, see Creating Amortization Templates . .
-
Associate amortization templates with item and expense records. See Configuration for Amortization and Associating Amortization Templates with Expenses.
-
Generate amortization schedules. Amortization Schedules.
-
Create amortization journal entries. See Generating Amortization Journal Entries. .
-
View amortization reports. See Amortization Reports.
Although the general process is the same, each part of the process has additional elements specific to foreign currency amortization.
Amortization Templates
The Amortization Template displays the Use Transaction Currency check box. This check box controls whether the template calculates the amortization schedule amounts in a foreign currency or in the base currency. You must check this box when creating a foreign currency template to generate amortization schedules in a foreign currency. You cannot specify a currency when you create a template. The template always refers the transaction to determine the currency for amortization.
Use a naming convention for amortization templates so you can distinguish foreign currency amortization templates from standard amortization templates. For example, add the currency code to the template name, such as Even Periods - USD and Even Periods - Foreign.
If you associate a foreign currency template on a base currency transaction line, it creates an amortization schedule for the item using the base currency, which is a standard amortization schedule. This has the same result as if you use an amortization template where the Use Transaction Currency box is not checked. Depending on your business needs, you may be able to use foreign currency templates to amortize amounts for both foreign and base currency transactions.
If you check the Use Transaction Currency box for a template and populate the Initial Amount or Residual fields, the amortization schedule created from the template assumes or uses the currency of the transaction. For example, on a foreign currency amortization template, you enter 100 in the Initial Amount field. You associate the template on a transaction recorded in GBP. On the amortization schedule, the 100 represents 100 GBP.
Foreign Currency Amortization Schedules
The foreign currency amortization schedule displays the base currency and the foreign currency amortization amount information in the following fields. You can add these fields to your amortization searches, lists, and reports.
-
Foreign Currency – indicates if the schedule is a foreign currency schedule
-
Currency – indicates the currency used in the schedule to calculate amounts. This is the transaction currency.
-
Base Amount – the amortization amount converted to the base currency (the foreign currency amount for the period multiplied by the transaction exchange rate)
-
Amount – the amount to be recognized for a line of the schedule
-
Total Amortized – shows the cumulative amount already recognized on the schedule to date
The currency of the transaction determines the currency for the amortization schedule amounts. The transaction currency becomes the amortization schedule currency. Amounts to be amortized are shown in the Amount column. The base amount shows the foreign currency amount for period multiplied by the transaction exchange rate on the transaction.
The total amortization amount in the Base Amount column may be slightly different from the total base currency amount on the related transaction due to rounding. You may want to journal out these rounding differences periodically.
Foreign Currency Amortization Journals
Create foreign currency amortization journals the same way you create standard amortization journals. Foreign currency journals use the exchange rate on the transaction to determine the foreign currency journal amounts.
NetSuite segregates journals by currency type. You will have, at a minimum, one journal per currency per currency exchange rate. For example, you have four amortization schedules:
-
Schedule 1 using USD, your base currency
-
Schedule 2 using GBP and transaction exchange rate 2.1
-
Schedule 3 using GBP and transaction exchange rate 2.2
-
Schedule 4 using EUR and transaction exchange rate 1.1
NetSuite creates four amortization journals, one for each amortization schedule.
If Schedule 2 and Schedule 3 in the example use the same exchange rate, then NetSuite creates only three amortization journals.
Foreign Currency Amortization Reports
You must customize the standard amortization reports to display foreign currency amortization information. The amortization reports are:
-
Amortization Forecast Summary
-
Amortization Forecast Detail
-
Deferred/Capitalized Expense
To customize amortization reports for foreign currency amortization:
-
Go to the amortization report and click Customize.
-
On the Report Builder (or Financial Report Builder), click Edit Columns.
-
In the Add Fields pane, select Amount (Foreign Currency) and Schedule Currency.
-
In the Report Preview pane, leave the default heading or enter a new heading for each column. Reorder columns as needed.
-
Click Save.
Foreign Currency Amortization Forecast Reports
The Amortization Forecast reports display the forecasted value of the amounts to be amortized or the amounts that have already been amortized based on the related amortization schedules. When it is customized for foreign currency, the Amortization Forecast reports display the foreign currency amortization amounts and currency in addition to the amortization amount in the base currency.
An Amortization Forecast report displays amortization amounts for all currencies. When the report has amounts in more than one currency, the total amortized amount is not a meaningful number. Filter the report by currency to view accurate amortization total amounts.
Foreign Currency Deferred/Capitalized Expense Report
The Deferred/Capitalized Expense report displays the total amortized and deferred expenses for a set of transactions over a period and the recognized portion of those expenses, if any. When it is customized for foreign currency, the report shows the base amount and foreign currency amounts for Amortized Expense, Deferred/Capitalized Expense, and Total. The report does not include any revaluation related to the original transactions or related journals.
-
Amortized Expense Amount – the amortized expense amounts converted to the base currency for the transaction or transaction line.
-
Amortized Expense Amount (Foreign Currency) – the amortized amount in the foreign currency related to the amortization journals for the transaction or transaction line. For base currency transactions with standard amortization schedules, the amounts in this column are the same as the Amortized Expense Amount column. The sum of this column does not tie to the general ledger because there may be more than one foreign currency.
-
Deferred/Capitalized Expense Amount – the capitalized expense amounts in the base currency for all amortization journals related to the transaction or transaction line. The total of this column ties to the Balance Sheet for the appropriate period.
-
Deferred/Capitalized Expense Amount (Foreign Currency) – the capitalized expense amounts in the foreign currency related to the amortization journal for that transaction or transaction line. For base currency transactions with standard amortization schedules, the amounts in this column are the same as the amounts in the Deferred/Capitalized Expense Amount column. The sum of this column does not tie to the general ledger because there may be more than one foreign currency.
-
Total Amount – total of amortized and capitalized amounts in the base currency.
-
Total Amount (Foreign Currency) – total of amortized and capitalized amounts in the foreign currency.