Account Balance Report doesn't agree with Register

cooperhs

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

Bob_L

Have you tried validating your file (File, validate & repair)? I would just do a plain validate first, but if that doesn't work you could try other validate options such as super validate (CTL plus shift when selecting validate & repair).

Quicken Jasmine

Hello @cooperhs,

Thanks for reaching out!

I do agree with @Bob_L. You can find a detailed breakdown of the Validate/SuperValidate processes below. It is recommended to save a backup before proceeding.

Validate: 

1. File
2. Validate and Repair File...
3. Validate File
4. Click OK
5. Close the Data Log
6. Close Quicken (leave it closed for at least 5 secs)
7. Reopen Quicken and see if the issue persists.

If the issue persists, proceed to Super Validate. If the issue is resolved after performing validation, then please disregard the instructions to Super Validate.

Super Validate:

1. File
2. Hold CTRL + Shift and click Validate and Repair File...
3. Super Validate File
4. Click OK
5. Close the Data Log
6. Close Quicken (leave it closed for at least 5 secs)
7. Reopen Quicken and see if the issue persists.

Let me know how it goes!

cooperhs

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.

[Deleted User]

@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

@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.