I found I can see the USD and CAD balances for any date under Revalue Currency.

My Receivable-USD balance is $868.39US and $1130.08CA

But in balance sheet, it shows as over $40,000 unless I select the "Show unrealized gain or loss".

But obviously the majority of this should be REALIZED, not unrealized (impossible to have $40K unrealized loss on a $1000 balance with an exchange rate that hasn't changed much over the years!).

How do I convert from an unrealized to a realized gain/loss?