Suite Guides - Consolidated Exchange Rates

Managing Consolidated Exchange Rates in NetSuite

In today's NetSuite guide, we will discuss consolidated exchange rates, including types, viewing, editing, calculating, and more.

Consolidated Exchange Rates

Consolidated exchange rates ensure that the currency amounts translate properly from child-parent subsidiaries for consolidated reports.

Consolidated Exchange Rate Types

 

Current Rate

The currency exchange rate in effect at the end of the period.

Average Rate

Weighted average based on transaction amounts for the period for all accounts with a General Rate Type of Average. The transaction amounts are multiplied by the currency exchange rates on the dates of the transactions. The weighted average equals the total of the transaction amounts multiplied by the currency exchange rates divided by the total transaction amount.

Historical Rate

Weighted average based on transaction amounts for the period for all accounts with a General Rate Type of Historical. The transaction amounts are multiplied by the currency exchange rates on the dates of the transactions. The weighted average equals the total of the transaction amounts multiplied by the currency exchange rates divided by the total transaction amount.

The Consolidated Exchange Rates table is available at Lists > Accounting > Consolidated Exchange Rates.

Wrapping Up

As a highly accredited NetSuite Solution Provider, ScaleNorth is well-positioned to help you with the full scope of your NetSuite customization needs. If you require more NetSuite assistance, contact ScaleNorth today.

Check out more Suite Guides:

About the Author

Brian Huelar is a Finance graduate and CPA with a background in accounting, financial reporting, and modeling. Brian spent 3 years at Oracle NetSuite, where he served as a Technical Support Engineer and Support Analyst, and is currently an Implementation Consultant at ScaleNorth.

Get in Touch

Popular Articles

Is NetSuite Suitable for Small Businesses?

Understanding NetSuite ERP for Small Businesses For many small businesses, choosing the right ERP software is a critical step in...

What Are Good Alternatives for QuickBooks Construction Accounting?

QuickBooks is one of the most recognized accounting software platforms in the world. For early-stage construction businesses, it gets the...

How ScaleNorth Helps Optimize & Automate NetSuite’s CRM Module

For many growing businesses, NetSuite CRM offers something that dedicated CRM platforms simply cannot: a truly unified view of the...
© Copyright 2026 ScaleNorth, Inc. All rights reserved worldwide. Specifications are subject to change without notice. Various trademarks are held by their respective owners.
magnifiercross