New 2019.1 Release Feature: Foreign Currency Expense Reports

A New Foreign Currency Expense Reports feature is set to be released as part of the NetSuite’s 2019.1 release. The feature facilitates expense reporting for employees who prefer to be reimbursed in a currency outside of their subsidiary base currency. Payments can now be made in the currency of the expense report and NetSuite will calculate and post the resulting fx adjustments.

Enabling foreign currency expense reports:

  1. The Multiple Currencies feature checkbox can be enabled by navigating to Setup > Company > Enable Features.Foreign Currency Expense Reports
  2. Currencies must be created to be made available expense reports. Currencies can be managed by navigating to Lists > Accounting > Currencies.Foreign Currency Expense Reports

Setting up employee expense report currencies:

First, the employee record must be set up with the currencies that will appear on their expense report. To configure expense report currencies:

  1. Navigate to the employee’s record.
  2. Select the Human Resources tab on the employee record.
  3. Click the Expense Reports Currencies subtab.Foreign Currency Expense Reports
  4. Pick the currencies from the dropdown.Foreign Currency Expense Reports
  5. Save the employee record.

Creating the expense report:

Three fields have been added to the expense report form for use with foreign currency expense reports:

  • Currency (header level) – The default currency on the employee record on the person selected on the Employee field will populate in the Currency field.
  • Exchange Rate (header level) – Exchange rate based on the date field, the base currency of the subsidiary on the expense report, and the currency selected.
  • Total Reimbursement Amount (header level, summary subsection) – the total amount of the expense report to be paid out to the employee in the currency specified in the Currency field. Foreign Currency Expense Reports

To create a foreign currency expense report:

  1. Enter the Employee name and date.
  2. In the header level Currency field, select the preferred reimbursement currency for the expense report. The exchange rate will automatically populate.
  3. At the line level, enter your expense.

    Foreign Currency Expense Reports
    Note: On the line level Currency field, select the currency for the expense line. The exchange rate will populate with the conversion rate from the currency at the line level to the currency on the header level based on the dates on both the line and header level. The amount field will populate with the line level total based on the header level currency.
  4. Save & Submit for Approval.

Paying the expense report:

The new foreign currency expense report feature allows payment of the expense report in the currency specified at the header level of the expense report. The exchange rate calculated on the payment is based on the conversion rate of the currency on the payment record to the base currency of the specified subsidiary.

After saving the payment record, the system will auto-calculate a revaluation and post the revaluation to a revaluation account.

Foreign Currency Expense Reports

The benefit of the foreign currency expense report feature is that employees now have the ability to select a preferred reimbursement currency, subsidiaries can pay employees in their preferred currency ad the system autogenerates revaluations based on the exchange rate gain and losses.

If you have questions or need assistance implementing NETSUITE expense reports,  PLEASE FEEL FREE TO CONTACT US!

About Abaci
Abaci is a premier NetSuite Solution Provider with deep knowledge in both business process and technology architecture. Our team is passionate about NetSuite and has an exclusive commitment to NetSuite and to providing the highest level of system expertise on its full suite of cloud-based business management applications.