Calculation of unrealized matching gain/loss

Per SuiteAnswers ID: 14964 – Foreign Currency Revaluation:

“Unrealized Matching Gain/Loss is a type of gain or loss is shown on the GL Impact subtab of certain foreign currency transactions, such as the bank deposit for a customer payment. NetSuite creates a gain or loss as part of the bank deposit, regardless of the dates of the customer payment and bank deposit.”

With this, Unrealized Matching Gain/Loss is generated in a transaction when there’s a difference in amount between the customer payment and the deposit applied on it.

For example, here’s a Customer Payment with the following details:

Transaction Amount: 1,727.27

Transaction Currency = CAD

On its GL impact (translated to Sub’s base currency = USD) | USD 1,362.13:

image.png

On the other hand, here’s the Deposit:

image.png

Since USD 1,362.13 from Customer Payment is not equal to USD 1,000 on the Deposit:

The Deposit will have a GL Impact of:

image.png

The applied amount of $1,000 is deposited to the bank account because it’s been applied/realized.

For the $362.13, it has not been applied/realized yet, so it’s transferred to the Unrealized Matching Gain/Loss account.

Leave a comment

Your email address will not be published. Required fields are marked *