Companies that conduct transactions in multiple currencies need to account for changes in foreign exchange rates accurately. An invoice recorded in USD, EUR, or another foreign currency may have a different value in the company’s functional currency when the reporting period ends.

Sage 300 multicurrency revaluation helps businesses reassess outstanding foreign-currency balances using updated exchange rates and determine the resulting foreign exchange gain or loss. This is particularly important during month-end and year-end closing, when financial statements need to reflect the appropriate value of outstanding receivables, payables, and other monetary balances.

What Is Multicurrency Revaluation?

Multicurrency revaluation is an accounting process used to update the functional-currency value of outstanding transactions denominated in a foreign currency.

For example, assume an Indonesian company with IDR as its functional currency records a USD 10,000 customer invoice when the exchange rate is:

USD 1 = IDR 15,500

The invoice is initially recorded at:

USD 10,000 × IDR 15,500 = IDR 155,000,000

If the invoice remains unpaid at the end of the reporting period and the exchange rate changes to:

USD 1 = IDR 16,000

The same USD 10,000 receivable is now equivalent to:

USD 10,000 × IDR 16,000 = IDR 160,000,000

The IDR 5,000,000 difference represents an exchange gain that needs to be considered in the period-end accounting process.

In Sage 300, the revaluation process recalculates the functional-currency equivalent of outstanding multicurrency transactions using the applicable revaluation rate. (Sage 300 Help)

How Foreign-Currency Transactions Create Exchange Differences

Foreign-currency transactions can create exchange gains or losses because the exchange rate may change between the original transaction date, the reporting date, and the eventual settlement date.

Common examples include:

• Foreign-currency customer invoices
• Foreign-currency vendor invoices
• Foreign-currency bank balances
• Other monetary balances maintained in non-functional currencies
• Receivables and payables that remain outstanding at period end

The original transaction is recorded using the exchange rate applicable at the time of the transaction. If the transaction remains outstanding, its functional-currency equivalent may change as exchange rates fluctuate.

This creates two important accounting concepts:

Unrealised gain or loss — the exchange difference calculated while the foreign-currency transaction is still outstanding.

Realised gain or loss — the exchange difference that becomes final when the transaction is settled, such as when a customer pays an invoice or the company pays a foreign-currency supplier.

Sage 300 distinguishes between these treatments according to the exchange gain/loss accounting method configured for the company. (Sage 300 Help)

What Happens During Period-End Revaluation?

Period-end revaluation is commonly performed as part of the month-end, quarter-end, or year-end closing process.

The general process is:

1. Identify outstanding foreign-currency balances
   Review receivables, payables, and other relevant monetary accounts that have not yet been settled.
2. Determine the applicable closing exchange rate
   Establish the exchange rate to be used for the reporting date based on the company’s accounting policies.
3. Recalculate the functional-currency value
   Sage 300 calculates the value of the outstanding foreign-currency balance using the revaluation rate.
4. Calculate the exchange difference
   The difference between the existing functional-currency value and the revalued amount represents the exchange gain or loss.
5. Post the revaluation entry
   Depending on the configured accounting method, Sage 300 posts the appropriate gain/loss and balance-sheet adjustments.
6. Review and approve the result
   Finance teams should review the revaluation batch, supporting reports, exchange rates, and resulting journal entries before finalising the period.

Sage 300 supports both a Realized and Unrealized Gain/Loss method and a Recognized Gain/Loss method. The accounting method affects whether the revaluation adjustment is treated as temporary and reversed in the following period or treated as permanent.

Understanding Unrealised Foreign Exchange Gain or Loss

An unrealised foreign exchange gain or loss occurs because the exchange rate has changed, while the underlying transaction has not yet been settled.

For example, a company records a USD receivable at IDR 15,500 per USD. If the exchange rate increases to IDR 16,000 while the invoice is still outstanding, the receivable has increased in IDR-equivalent value.

However, the company has not yet received the USD payment. The final realised gain or loss could therefore be different when the customer actually settles the invoice.

Under Sage 300’s Realized and Unrealized Gain/Loss method, the period-end revaluation is treated as temporary. The unrealised gain or loss is posted and a reversing entry is generated for the beginning of the following fiscal period. 

This approach allows the financial statements to reflect the appropriate period-end value without permanently carrying the temporary revaluation adjustment into the next period.

Sage 300 Multicurrency Revaluation Example

Consider an Indonesian company using IDR as its functional currency.

The company issues a customer invoice for:

USD 20,000

At the invoice date

Exchange rate:

USD 1 = IDR 15,500

Initial functional-currency value:

USD 20,000 × IDR 15,500 = IDR 310,000,000

The invoice remains unpaid at month end.

At the reporting date

The closing exchange rate is:

USD 1 = IDR 16,000

Revalued functional-currency value:

USD 20,000 × IDR 16,000 = IDR 320,000,000

The difference is:

IDR 320,000,000 − IDR 310,000,000 = IDR 10,000,000

Therefore, the company has an unrealised foreign exchange gain of IDR 10,000,000 on the outstanding receivable.

Under the Realized and Unrealized Gain/Loss method, the revaluation adjustment is treated as temporary and reversed in the following fiscal period. 

The accounting entry generated during revaluation will depend on the transaction type and configured accounts. For a receivable, Sage 300 documentation illustrates that an unrealised gain can involve a debit to the Receivables Control account and a credit to the Unrealized Exchange Gain account. (Sage 300 Help)

What happens when the customer eventually pays?

Suppose the customer settles the USD 20,000 invoice when the exchange rate is IDR 16,200.

The final settlement value becomes:

USD 20,000 × IDR 16,200 = IDR 324,000,000

The difference between the original transaction value and the settlement value is ultimately recognised as a realised exchange difference, subject to the company’s accounting method and configuration.

This illustrates why period-end revaluation should not be confused with the final realised foreign exchange gain or loss.

Review Controls Before Posting Revaluation

Multicurrency revaluation can affect both balance-sheet and income-statement accounts, so companies should establish appropriate review controls before posting the revaluation batch.

1. Verify exchange rates

Confirm that the exchange rates used for the reporting date are correct and consistent with the company’s approved accounting policy.

An incorrect exchange rate can cause the entire revaluation calculation to be misstated.

2. Review outstanding transactions

Review the foreign-currency receivables and payables included in the revaluation.

Look for:

• Old outstanding invoices
• Unusual balances
• Duplicate transactions
• Backdated transactions
• Transactions posted after the last revaluation
• Unexpected currency balances

Sage 300 has specific considerations for backdated multicurrency documents. Under the Realized and Unrealized Gain/Loss method, additional revaluation may be required when backdated transactions affect previously revalued periods. 

3. Check unrealised gain/loss accounts

Ensure that the appropriate unrealised exchange gain and loss accounts are correctly configured.

Sage 300 uses designated accounts for unrealised exchange gains and losses when the Realized and Unrealized Gain/Loss method is selected.

4. Review the revaluation batch

Before posting, finance teams should review:

• Source currency
• Original balance
• Revaluation rate
• Revalued balance
• Exchange difference
• Gain/loss account
• Receivable or payable control account
• Posting period

A review process helps identify unexpected movements before they become part of the financial statements.

5. Confirm the reversal

When using the Realized and Unrealized Gain/Loss method, confirm that the revaluation entry is configured to reverse in the following fiscal period.

Sage 300 creates reversing entries for this accounting method, including when the revaluation is posted at the end of a fiscal year.

Why Sage 300 Multicurrency Revaluation Matters

For businesses dealing with customers, suppliers, or bank accounts in multiple currencies, exchange-rate movements can materially affect financial reporting.

A structured Sage 300 multicurrency revaluation process can help finance teams:

• Present foreign-currency balances using appropriate period-end rates
• Identify unrealised exchange gains and losses
• Separate unrealised movements from realised settlement differences
• Maintain clearer month-end and year-end closing procedures
• Improve review and audit trails
• Reduce manual foreign-exchange calculations
• Support more consistent financial reporting

Sage 300 also allows companies to configure different revaluation codes and assign them to multicurrency accounts, helping determine how functional-currency balances are revalued when exchange rates change.

For multinational and foreign-owned businesses operating in Indonesia, multicurrency accounting may form part of a wider ERP and finance environment. In these situations, the ERP should be able to support the company’s international reporting needs while addressing local business and accounting requirements. BSC Indonesia provides ERP and accounting solutions for foreign companies in Indonesia, including support for ERP implementation, accounting systems, and related business processes.

Conclusion

Foreign-currency transactions require more than simply recording the exchange rate on the original transaction date. When receivables, payables, or other monetary balances remain outstanding, changes in exchange rates can affect their functional-currency value at the reporting date.

Sage 300 multicurrency revaluation provides a structured way to recalculate these balances, identify unrealised foreign exchange gains or losses, and generate the appropriate accounting entries based on the company’s configured gain/loss accounting method.

For finance teams, the key is not only to run the revaluation process but also to verify exchange rates, review outstanding transactions, check gain/loss accounts, assess backdated transactions, and confirm the resulting journal entries before closing the period.

If your business uses Sage 300 and manages significant foreign-currency transactions, reviewing the multicurrency configuration and period-end revaluation process can help strengthen financial controls and improve the reliability of your reporting.

Note: The accounting treatment for foreign-exchange differences should follow the company’s accounting policies and applicable financial reporting requirements. Sage 300 configuration should be reviewed with your finance or accounting team before implementation.

Talk to BSC Indonesia About Your Sage 300 Environment

If your business uses Sage 300 for multicurrency transactions and you need assistance with revaluation, exchange-rate configuration, reporting, integration, troubleshooting, or ongoing system support, BSC Indonesia can help.

As a Sage 300 service provider in Indonesia, BSC Indonesia supports businesses with practical Sage 300 requirements—from implementation and configuration to support, data integration, custom reporting, troubleshooting, and system improvements.

Rather than applying a one-size-fits-all approach, our team can review your existing Sage 300 environment and business process to identify the appropriate solution.

Need help reviewing your Sage 300 multicurrency setup? Please come visit our website and contact BSC Indonesia to discuss your requirements.