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

NetSuite AI Is Here: How Automation, AI Agents, and NetSuite Next Are Reshaping ERP & CRM

Artificial intelligence is no longer a future concept for NetSuite customers; it’s already changing how companies automate operations, engage prospects,...

NetSuite CRM: Features, Benefits, Pricing, and How It Works

When most people think about NetSuite, they think about accounting, finance, and operations. But NetSuite ERP comes standard with CRM...

Why NetSuite ERP Is a Perfect Fit for Data Center Developers

The data center industry is experiencing unprecedented growth, driven by AI, cloud computing, and digital transformation. But with that growth...
© Copyright 2026 ScaleNorth, Inc. All rights reserved worldwide. Specifications are subject to change without notice. Various trademarks are held by their respective owners.
magnifiercross