What is the problem you need to solve?
The unrealized gain or losses are not showing up properly on the Trial Balance or Balance Sheet Multiple Period reports. For example, the YTD balance sheet in Quickbooks does not match what Data Dear is pulling into excel. Can you please help ASAP?
What accounting software are you using?