Realized gain or loss posting to separate accounts.

The client required us to check if it is possible to post Realized gain or loss to separate accounts. 

Now it is posted to default system generated account. 

They want to create new accounts and post gain to one account and loss to another account. 

  1. Unrealized gain or loss is calculated for open transactions of a period for which no payments are applied. We must run the Revalue Open Currency balances to post the foreign currency variance amounts of open transactions of that period to the Unrealized gain or loss account. 
  2. When a payment is applied to close a transaction, NS automatically calculates the variance amounts due to the exchange rate variation and posts to the Realized gain or loss account. The variance posts by default to the Realized Gain/Loss account. 
  3. As standard, Loss will be posted to debit of Realized Gain/Loss account and Gain will be posted to Credit of Realized Gain/ Loss account. 

Eg : An invoice recorded in January and is paid in July. The variance due to exchange rate fluctuation is calculated on the open balance for each period from January through June and posted as unrealized gain or loss. When the payment is made in July, the realized gain or loss is automatically posted in that period. 

  1. If your company uses the Foreign Currency Variance Mapping feature, your realized gains and losses may be posted to different accounts. 
  2. The Foreign Currency Variance Mapping feature enables you to create foreign currency variance posting rules that determine the accounts into which foreign currency variances are posted. 
  3. If your NetSuite implementation has no variance posting rules, NetSuite posts the gains and losses from fluctuations in foreign exchange rates to default system-generated accounts. 

Leave a comment

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