Budget Exchange Rates Import
You can import budget exchange rates using CSV import if your organization.
The Budget Exchange Rates table is available at Lists > Accounting > Budget Exchange Rates. In this table you can maintain exchange rates between the child and parent subsidiaries for use in the budgeting process.
To access this table, the Multiple Currencies and Multiple Budgets features must be enabled.
The Budget Exchange Rates table is similar to the Consolidated Exchange Rates table. In NetSuite OneWorld, NetSuite uses the Consolidated Exchange Rates table to initially populate the Budget Exchange Rates table. Then, you can update and maintain the Budget Exchange Rates table as necessary.
This table shows the exchange rates for each subsidiary's base currency in relation to the currencies used by its parent subsidiaries, for each period. Table columns include: accounting period, accounting book, whether the period is closed, the From (child) subsidiary, the To (parent) subsidiary, and exchange rates.
Rates in this table are either direct or indirect (derived). Direct rates are rates set between a child and parent subsidiary. Direct rates are set by a user and may be edited. Indirect rates are rates set between a grandchild and grandparent subsidiary. Indirect rates are always calculated by the system and cannot be edited. Budget exchange rates include three different rate types per period, subsidiary, and accounting book: Average, Current, and Historical.
To import updated budget exchange rate data, in the Import Assistant, set the Import Type to Accounting and the Record Type to Budget Exchange Rate. Only the Update data handling option can be selected for the import.
The fields that you can map and update are:
-
Average Exchange Rate
-
Current Exchange Rate
-
Historical Exchange Rate
The import also requires an external ID or internal ID. For information about using external and internal IDs, see Select Reference Types. The import updates successfully if the period is not closed, is not derived, and does not include an elimination subsidiary.
For more details about how budget exchange rates are handled in NetSuite, you can review the Lists > Accounting > Budget Exchange Rates page, and see Budget Exchange Rates.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.