Skip to main content
March 15, 2022
Question

Unrealized Gain/Loss

  • March 15, 2022
  • 1 reply
  • 0 views

Hello, 

 

In the last year we switched from QB Enterprise to Online. In the conversion QB internally generated an "unrealized gain/loss account" on our P&L and started recording  to the account. We operate in USD but we report in Canadian dollars as we are a Canadian company with 95% US customers. 

 

QB populates the unrealized amount by the difference in the invoice FX rate and the payment FX rate. Then I deposit it to the bank account and a realized gain/loss is calculated on the exchange between the deposit date and the payment date. The realized gain or loss is on our chart of accounts and we can book to this account. However, because the unrealized gain or loss is not on our chart of accounts, I cannot book adjusting entries.

 

Currently, there is a difference between our USD AR on the BS and Trail Balance because unrealized gain/loss is not recognized on the Trail balance or General Ledger.  How do I fix the issue of unrealized gain differences between payment and deposit? Currently, I book the invoice and payment at the same FX rate and the deposit at the rate it entered our bank account reflecting only a realized gain. However, 

when we switched from Enterprise to Online it pulled the FX rate from invoice to payment, including the prior closed year creating this issue because historically it was not always done this way. 

1 reply

March 16, 2022

Hi MegFeq, 

 

Thanks for taking the time to connect with us here. It's good that you made the conversion to the cloud version of QuickBooks. I'll be happy to share more info and help steer you in the right direction. 

 

Based on what you've described, I see you benefiting by creating a home currency adjustment so the currency differences also appear on your financial reports. I encourage you to check out this helpful article that shows you how to: Enter home currency adjustments for your foreign balances. You're more than welcome to ask other questions by leaving a comment below. 

 

I'll be one message away. Otherwise, I wish you a great rest of the week!