[GNC] Tracking down an unrealized gain

[John Ralls]

> On Feb 27, 2025, at 16:47, David Warren <david at warren1.net> wrote:
> 
> John,
> 
> I'm curious what you'd suggest to do to track my issue down. I got rid of all my stock accounts save one open one (where the price hasn't moved since inception) and some closed accounts (where all positions were sold). A standard balance sheet report nevertheless shows a giant "unrealized trading loss". Yet an advanced portfolio report (as expected, as I have no extant large unrealized losses) shows nothing of the sort. A trial balance report DOES show a large imbalance, though, (perhaps of the same amount), between debits and credits.
> 
> How does one track down the account(s) producing this purported unrealized trading loss. (note that trading accounts are NOT enabled) 
> 

David,

Please start a new email when you want to start a new conversation. It’s much friendlier to the thread-following in everyone’s’ mail clients and also makes searching the list archives easier.

Look at different periods in the trial balance report. Try running one for 5 years ago. Was there an unrealized gain or loss? If so try 10 years ago; if not 3 years ago, and so on. If you find that the unrealized gain has accumulated over time then you’ll need to create post-dated transactions or correct existing ones to get it to balance as you go. If it’s just one broken transaction then binary-searching with the dates is the fastest way to find it.

Regards,
John Ralls