Unrealized Gain/Loss
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.
