[GNC] Unrealized gains in trial balance and balance sheet do not match

Chang Wang wangchang327 at gmail.com
Thu Aug 21 14:03:32 EDT 2025


Hi all,
I recently recorded a currency conversion transaction (a transfer from an
HKD account to a USD account) and noticed that the trial balance no longer
balanced afterward. If I delete the currency conversion, the trial balance
returns to normal. Using a trading account did not resolve the issue.

I don't believe the transaction was entered incorrectly. I used the
currency conversion rate stored in the price database for that day. The
main difference I see is in the unrealized gain entry: it decreases (a lot
more than it should be for the loss due to FX transaction) after the
conversion, leaving the credit column out of balance with the debit column.

I've also noticed that the unrealized gain shown in the balance sheet
differs from the one shown in the trial balance. If I substitute the
balance sheet value into the trial balance, the numbers in the trial
balance reconcile correctly.

Since all unrealized gains are calculated automatically by GnuCash, I'm
unsure whether the values in the balance sheet and trial balance are
supposed to match. If they should, this may be a bug? Has anyone
encountered this issue or found a way to fix it?

Thanks,
Chang


More information about the gnucash-user mailing list