Account Balance Report doesn't agree with Register

Question

When I run an Account Balance Report for today only, it is correct. But when I run it for the last 12 months, with weekly intervals, one investment account shows a different current balance. It is based on the cost basis for the only security in the account, a US Treasury Bond which was purchased in the last 12 months. When I use a shorter period, the current balance changes, probably to what the value was at the BEGINNING of the period used.

What's wrong

cooperhs · Answer

@CaliQkn  Thanks for the suggestions. Still no change. Again, the weird thing is that if I run the report for YTD, it pulls cost. (I bought the bond this year). If i run the report for today only, it's correct. For any other day, I believe it uses the value as of the date at the beginning of the period.

[Deleted User] · Answer

@cooperhs check your price history for that security to see if there are any that look "out of place".

Another thing to try to do a data file validate with the "Rebuild investing lots" selected.

Also try a doing a "Ctrl-Z" while in the investment account register. Click on any transaction in the register beforehand to capture focus.

Double check your report options and make sure that all securities are selected.

cooperhs · Answer

Thanks but Nope, that didn't work. I'm still getting a value that differs from the register (and correct) value by the amount of the unrealized gain.