Set Up an Additional Reporting Currency

As companies operate in increasingly more countries/regions, it becomes more important that they're able to review and report financial data in more than one currency.

Note

In Business Central if you are looking for real time information about foreign exchange (FX) rates or historical rates, you will find it referred to as currency. In addition to this article, see also Update Currency Exchange Rates.

Your general ledger is set up to use your local currency (LCY), but you can set it up to also use another currency with a current exchange rate assigned. By designating a second currency as a so-called additional reporting currency, Business Central automatically records amounts in both LCY and this additional reporting currency on each G/L entry and other entries, such as GST entries.

Warning

The Additional Reporting Currency functionality shouldn't be used as a basis for financial statement translation unless you understand the limitations. It can't translate foreign subsidiary financial statements as part of a company consolidation. The additional reporting currency can only be used to prepare reports in another currency, as if that currency was the company's local currency.

For example, you have a large amount of accounts receivable in British pounds (GBP), and you have set up your additional reporting currency (ACY) to be GBP. In this scenario, amounts in the accounts receivable that use GBP will not be adjusted for currency exchange gains/losses in the ACY, only amounts in the accounts receivable that are in other currencies. That means that if you use ACY to report your financial statements, it might result in understated or overstated outstanding balances of accounts receivable.

Displaying Reports and Amounts in the Additional Reporting Currency

Using an additional reporting currency can assist the reporting process for a company in the following cases:

• Companies in non-EU countries/regions that have a high proportion of transactions with EU country/region companies. In this case, the non-EU company might also want to report in euro to make its financial reports more usable for EU trade partners.
• Companies that also wish to display reports in a more internationally traded currency than their own local currency.

Several financial reports are based on G/L entries. To display report data in the additional reporting currency, select the Show Amounts in Add. Reporting Currency checkbox on the Options FastTab for the relevant G/L report.

Adjusting Exchange Rates

Because exchange rates fluctuate constantly, additional currency equivalents in your system must be adjusted periodically. If these adjustments aren't done, amounts that converted from foreign (or additional) currencies and posted to the general ledger in LCY can be misleading. In addition, daily entries posted before a daily exchange rate is entered into application must be updated after the daily exchange rate information is entered. The Adjust Exchange Rates batch job is used to adjust the exchange rates of posted customer, vendor, and bank account entries. It can also update additional reporting currency amounts on G/L entries. For more information, see Update Currency Exchange Rates.

Setting Up an Additional Reporting Currency

To set up an additional reporting currency, you must follow these steps:

• Specify general ledger accounts for posting exchange rate adjustments.
• Specify the exchange rate adjustment method for all general ledger accounts.
• Specify the exchange rate adjustment method for GST entries.
• Activate the additional reporting currency.

To specify general ledger accounts for posting exchange rate adjustments

1. Choose the icon, enter Currencies, and then choose the related link.
2. On the Currencies page, fill in the following fields for the additional reporting currency.

Field	Description
Realized GL Gains Account	The general ledger account to which exchange rate gains for currency adjustments between LCY and the additional reporting currency are posted.
Realized GL Losses Account	The general ledger account to which exchange rate losses for currency adjustments between LCY and the additional reporting currency are posted.
Residual Gains Account	The general ledger account to which residual amounts that are gains are posted if you post in the general ledger application area in both LCY and an additional reporting currency.
Residual Losses Account	The general ledger account to which residual amounts that are losses are posted if you post in the general ledger application area in both LCY and an additional reporting currency.

Note

Residual amounts can occur when Business Central rounds debit and credit amounts that have been converted from LCY to an additional reporting currency.

For each general ledger account, you must specify how general ledger amounts for that account are adjusted for exchange rate fluctuations between LCY and the additional reporting currency.

To specify the exchange rate adjustment method for all general ledger accounts

1. Choose the icon, enter Chart of Accounts, and then choose the related link.

2. On the Chart of Accounts page, select the relevant account, and then choose the Edit action.

3. On the GL Account Card page, select the relevant method in the Exchange Rate Adjustment field.

   If you post in an additional reporting currency, specify in the Exchange Rate Adjustment field how this general ledger account are adjusted for exchange-rate fluctuations between LCY and the additional reporting currency. The following table shows the options to choose from.

   Field	Decription
   No Adjustment	No exchange rate adjustment is made to the general ledger account. This is the default option. NOTE: This option should be selected if the exchange rate between the LCY and additional reporting currency is always fixed.
   Adjust Amount	The LCY amount is adjusted for any exchange rate gains or losses. Exchange rate gains or losses are posted to the general ledger account in the Amount field and to the accounts you specified for gains or losses in the Realized G/L Gains Account and Realized G/L Losses Account fields on the Currencies page.
   Adjust Additional-Currency Amount	The additional reporting currency is adjusted for any exchange rate gains or losses. Exchange rate gains or losses are posted to the general ledger account in the Additional-Currency Amount field and to the accounts you specified for gains or losses in the Realized G/L Gains Account and Realized G/L Losses Account fields on the Currencies page.

   Exchange rate gains and losses are posted when you run the Adjust Exchange Rates batch job. In that batch job, the adjustment exchange rate is identified on the Currency Exchange Rates page, and then the amounts in the Amount and Additional-Currency Amount fields on the general ledger entry are compared to determine whether there's an exchange rate gain or loss. The batch job uses the option that you select in the Exchange Rate Adjustment field to determine how to calculate and post exchange rate gains or losses for general ledger accounts.

4. Close the G/L Account Card page.

To specify exchange rate adjustment method for GST entries

1. Choose the icon, enter General Ledger Setup, and then choose the related link.

2. On the General Ledger Setup page, select the relevant method in the GST Exchange Rate Adjustment field.

3. If you post in an additional reporting currency, you can specify in the GST Exchange Rate Adjustment field how the accounts set up for GST posting on the GST Posting Setup page are adjusted for exchange-rate fluctuations between LCY and the additional reporting currency.

   When you run the Adjust Exchange Rates batch job, the adjustment exchange rate is identified on the Currency Exchange Rate page and then the amounts in the Amount and Additional-Currency Amount fields on the GST entry are compared to determine if there's an exchange rate gain or loss. The batch job uses the option that you select in this field to determine how to post exchange rate gains or losses for GST accounts.

   You have the same options as with general ledger entries but in this case the entries adjusted are the GST entries. The following table shows the options to choose from.

   Field	Description
   No Adjustment	No exchange rate adjustment is made to the general ledger account. This is the default option.
   Adjust Amount	The LCY amount is adjusted for any exchange rate gains or losses. Exchange rate gains or losses are posted to the general ledger account in the Amount field and to the accounts you specified for gains or losses in the Realized G/L Gains Account and Realized G/L Losses Account fields on the Currencies page.
   Adjust Additional-Currency Amount	The additional reporting currency is adjusted for any exchange rate gains or losses. Exchange rate gains or losses are posted to the general ledger account in the Additional-Currency Amount field and to the accounts you specified for gains or losses in the Realized G/L Gains Account and Realized G/L Losses Account fields on the Currencies page.

To activate the additional reporting currency

1. Choose the icon, enter General Ledger Setup, and then choose the related link.

2. On the General Ledger Setup page, choose the Additional Reporting Currency field to select the additional currency that you want to report in.

3. When you leave the field, Business Central displays a confirmation message describing the effects of activating the additional reporting currency.

4. Choose the Yes button to confirm that you want to activate the currency.

5. The Adjust Add. Reporting Currency batch job opens.

   This batch job converts LCY amounts on existing entries to the additional reporting currency. The batch job uses a default exchange rate copied from the exchange rate that is valid on the work date on the Currency Exchange Rates page. Residual amounts that occur on conversion of LCY to additional reporting currency are posted to the residual gains and losses accounts specified on the Currencies page. The posting date and document number for these entries are the same as for the original general ledger entry. After all these residual entries are posted, the batch job posts a rounding entry on the closing date of each closed year to the retained earnings account. This is to make sure that the ending balance of the income accounts for each closed year is 0 in both LCY and the additional reporting currency.

6. Fill in the fields as necessary. Hover over a field to read a short description.

7. Choose the OK button to run the batch job.

After you run the batch job, amounts on the following existing entries will be in both LCY and in the additional reporting currency:

• General ledger entries
• Item application entries
• GST entries
• Project ledger entries
• Value entries
• Production order lines
• Production order ledger entries

In addition, all future entries of the same type have amounts recorded in both LCY and the additional reporting currency.

Note

The Add. Reporting Currency field will only be activated after you choose the OK button in the Adjust Add. Reporting Currency batch job.

See Also

Update Currency Exchange Rates
Closing Years and Periods
Work with Business Central

Find free e-learning modules for Business Central here