Customizing Company Currencies In Sage Intacct

Keywords: Currencies, Transactions, Money, Invoices, Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Customize or edit a currency

The option of using multiple transaction currencies is separate from multiple base currencies. The base currency is the operating and reporting currency for an Intacct company or entity. For example, a UK entity operates in the base currency of GBP, while a US entity operates in the base currency of USD. You run reports for the UK entity in GBP and for the US entity in USD. You can choose to assign a different base currency to each entity in your multi-entity company. You do this by first enabling multi-base currencies and then enabling a separate base currency for each entity as needed.

Use the Currency and format setup page to:

  • Format the appearance of a currency, such as currency symbol and decimal separator.
  • View or edit details of an existing currency.
  • Add a new transaction currency.
  • Customize a transaction currency.

When you set the number format for a transaction currency, the number format affects all reports and externally facing documents created in Sage Intacct using the selected currency, such as invoices.

Before you begin

Before you add a transaction currency to your company, enable multiple transaction currencies in the General Ledger.

  • Go to Company > Admin.
  • Select Subscriptions, and scroll down to General Ledger.
  • Next to General Ledger, select Configure.
    The Configure General Ledger page is shown.
  • Under Multi-currency management, select Enable multi-currency subscription.
  • Save your changes.

Add or customize a currency

When you set the number format for a transaction currency, the number format affects all reports and externally facing documents created in Sage Intacct using the selected currency, such as invoices.

  • Go to Company > Setup > Multi-currency > Transaction currencies.
  • Select Add.
  • In the Currency section, select the Currency code dropdown and then select the currency that you want.
    The fields in the Format section show the format for the currency you selected. You can customize the format for the currency by selecting the Currency format dropdown and choosing Custom.
  • Select Save.

View or edit currency information

You can edit any currency details except for the Currency code, Currency name, and the ISO-4127 numeric code for the currency. Create a new currency if you want to edit these read-only details.

  • Go to Company > Setup > Multi-currency > Transaction currencies.
  • Find the currency and select View or Edit.
    The Currency and format setup page is shown.
  • View or edit the currency information as needed.
  • Select Save if you made any changes.

Enable multiple transaction currencies

The option of using multiple transaction currencies is separate from multiple base currencies. Sage Intacct supports the use of different currencies for all your transactions. You can enable support for multiple transaction currencies in General Ledger. Selecting the multi-currency subscription in General Ledger enables multi-currency support throughout your Intacct company. This includes all subscriptions, applications, and options for managing currencies and exchange rates.

Multi-currency support refers to the use of multiple currencies in transactions and exchange rates throughout your company. Multiple base currency support, in contrast, refers to support for enabling a separate operating and reporting currency for each entity in your company.

After you enable multi-currency, you cannot turn it off later.

  • Go to Company > Admin.
  • Select Subscriptions, and scroll down to General Ledger.
  • Next to General Ledger, select Configure.
    The Configure General Ledger page is shown.
  • Under Multi-currency management, select Enable multi-currency subscription.
  • Save your changes.

Set the base currency for your company

You can only change your company’s base currency before transactions are created in your company. Changing the base currency can have a major impact on your finances.

Base currencies in a multi-entity company

You can edit the base currency for an individual entity after enabling multiple base currencies in the Multi-Entity Management page and creating a new entity. If your multi-entity company has only one base currency, then the base currency setting remains on the Company Information page.

Change your base currency and currency format

If you have not created any transactions in your company yet, you can change your company’s base currency and currency format.

  • Go to Company > All > Setup > Configuration > Company.
  • On the Accounting tab, select the icon next to Base currency.
    The Currency and format setup page is displayed.
  • On the Currency and format setup page, select Edit.
  • To change your base currency, select Currency code, then select the currency you want to use.
    Sage Intacct fills in the Currency name and ISO-4127 numeric code for that currency, and resets the Currency format to the most common selection for that currency.
  • To change your currency format, select Currency format, then select a country.
    Sage Intacct sets format options to match the standard for that country. You can change individual format options to suit your needs.
  • To change individual format options, enter changes in the Currency unit through Alignment. Sage Intacct shows an example of your currency display in the Currency sample.
  • Select Save

Add, edit, and view transaction currencies

The option of using multiple transaction currencies is separate from multiple base currencies. Use the Transaction currencies list to view, edit, add, or delete the transaction currencies your company uses. The page lists currencies by currency code, name, and symbol.

The base currency is the operating and reporting currency for an Intacct company or entity. For example, a UK entity operates in the base currency of GBP, while a US entity operates in the base currency of USD. You run reports for the UK entity in GBP and for the US entity in USD. You can choose to assign a different base currency to each entity in your multi-entity company. You do this by first enabling multi-base currencies and then enabling a separate base currency for each entity as needed.

Before you add a transaction currency to your company, enable multiple transaction currencies in the General Ledger.

  • Go to Company > Admin.
  • Select Subscriptions, and scroll down to General Ledger.
  • Next to General Ledger, select Configure.
    The Configure General Ledger page is shown.
  • Under Multi-currency management, select Enable multi-currency subscription.
  • Save your changes.

Add a new currency

The currency code and name are the ISO-standard code and name.

When you set the number format for a transaction currency, the number format affects all reports and externally facing documents created in Sage Intacct using the selected currency, such as invoices.

  • Go to Company > Setup > Multi-currency > Transaction currencies.
  • Select Add.
  • Enter the information for this new currency in the fields provided.
  • Select Save.

View or edit a currency

  • Go to Company > Setup > Multi-currency > Transaction currencies.
  • Find the currency and select View or Edit.
    The Currency and format setup page is shown.
  • View or edit the currency information as needed.
  • Select Save if you made any changes.

Delete a currency

You cannot delete a currency used as the base currency for any entity in your company. If the delete option is unavailable for a currency, that means the currency is being used as the base currency for an entity in your company.

  • Go to Company > Setup > Multi-currency > Transaction currencies.
  • Find the currency that you want to delete and select Delete.

Multi-currency controls in transaction pages

This topic explains how to use foreign currencies in Accounts Payable and Accounts Receivable transaction pages. In AP, these pages include bills, recurring bills, advances and adjustments. In AR, they include invoices, recurring invoices and adjustments. Because all these pages operate in an identical manner, this section uses bills as an example. This topic also assumes that you are already familiar with the basic operation of these pages, and focuses on those differences that result from using multiple currencies. Controls for multi-currency transactions fall into the General information and Entries sections.

In the General information section

Currency. If you assigned a default currency to the vendor or customer, that currency appears here. Otherwise, select one. A currency is mandatory for a foreign-currency transaction; however, making changes to the proposed values for exchange rate and its type and date are optional. When you select the currency, the system proposes a default exchange rate and type.

Exchange rate date. The system defaults the date of the exchange rate to today; however, you may override this. For example, maybe you are making the transaction date other than today. You might want to match the exchange rate to that date.

Exchange rate type. Your company may or may not use custom exchange rate types. If you do, the Exchange rate type dropdown contains choices for them, where one can also be a default. For example, maybe your company has Monthly, Weekly and Spot rate types along with their various exchange rates. Alternatively, maybe your company has not defined any custom exchange rate types, and so the system uses the Intacct Daily Rate.

Exchange rate. You may override the default exchange rate. For example, say the system administrator has not yet entered the rate for today. In that case, the system defaults to the last rate that was entered. But if you do know today’s exchange rate, you can enter it directly into this field.

In the line item entries section

Txn amt and Base Amt. When you enter the transaction amount, the system automatically calculates the conversion to your base currency. For multi-entity companies, the base currency is determined by the location.

Foreign currency revaluation overview

Revaluation provides a way to recognize an unrealized gain or loss due to fluctuating exchange rates in multi-currency transactions. The gist of the process is that you identify transaction gains or losses and then make journal entries to compensate for them. Revalue inter-entity transactions by including your inter-entity accounts in your General Ledger revaluation report.

About foreign currency revaluation

Say you are a company based in the US that also does business in Canada. You buy goods from vendors in Canada, and resell those goods to customers there. You have on-going AP and AR transactions with those vendors and customers in Canadian dollars. Additionally, you have a Canadian bank account so that you can make payments to vendors and deposit receipts from customers. That bank account has a balance in Canadian dollars. Your reporting period is monthly. At the end of the last reporting period, you published financials that included pending Canadian transactions as well as the base-currency value of your Canadian bank account balance. In your financials, the system converts those pending foreign-currency transactions into base currency at the appropriate exchange rate. During the next month, the value of Canadian currency fluctuates relative to your base currency, US dollars. Meanwhile, some pending transactions remain unpaid at the end of the next month as well. The base-currency value of those transactions will be different at the end of that month. This causes an unrealized gain or loss.

For example, say you previously stated an AP transaction is valued at $100 US dollars, it might now be valued at $96 due to currency fluctuation. Because you have to pay $4 less, you have an unrealized gain of $4 relative to what you previously stated. Consequently, at the end of the reporting period, you revalue the outstanding foreign-currency transactions in both Accounts Payable and Accounts Receivable. More specifically, you make journal entries to offset those unrealized gains or losses. Following that, you make a reverse set of those journal entries so you can begin the following period anew. You also perform a similar process to foreign-currency bank accounts in Cash Management.

Check out our Free Additional Articles