Summary Panel Balance Erroneous and Not Matching Register

Snap

In a manually self-created investment account, not connected outside my computer. Quicken is Classic Deluxe ver R60.15, Build 27.1.60.15

One of my 18 accounts is reporting improperly in the summary panel.

The last entry, a future posting is for adding funds and the summary panel is oddly reporting that number as a negative amount and not reporting the actual balance, current or future. It is off by a very large amount. The panel is acting like it ignores the other register entries that make up the majority of the history and the balance.

I tried to delete the future entry but the summary panel reported balance does not change at all. Again like the number is stuck in the summary panel and it's not relating to the register.

Based on someone else's thread about the issue:

I have tried resorting (and back) the ledger by dates with no change.

I have tried to change (and back) the way (timing) the summary panel reports which brought up an odd thing in that reporting the "current" balance shows zero balance which it is not correct nor what the ledger shows. Showing the future or ending balance remains the same odd number noted in the beginning.

I have tried to validate the file that reported a future dated entry (too far ahead) and claimed that it corrected the issue, but the same bad reporting in the summary panel remains unchanged.

The other thread suggested deactivating and reactivating the file but that option did not appear to be available as the file was not externally linked outside my computer.

Any more ideas short of creating a new account and filling the old data in again?

Snap

I am sorry but with 15 accounts that needed bring up to date with numerous transactions each, which I had to do more than once while doing the previous guided diagnoses, You can understand that I can't take a chance on messing up the current working state of the rolled back version of the program. It has taken two half days of down time. I would have appreciated a recommendation at the start to try a roll back.

Quicken Jasmine

Hello @Snap,

Would you mind providing the financial institution that you are experiencing this issue with? If possible, could you also link the thread that you are referring to?

If you don’t mind, could you please provide screenshots of what you described seeing? If needed, please refer to this Community FAQ for instructions on how to attach a screenshot. Alternatively, you can also drag and drop screenshots to your response if you are not given the option to add attachments. Please remember to redact any personal information as needed.

Thanks!

Snap

No institution as noted. It's an investment type account set up for on system manual input.

Basically the end balance of the ledger in the right pane, which is correct, is not matched by the balance shown in the narrow column on the left of accounts listed with their balances.

As these are financial records there is reluctance to post screen shots on a public forum.

Snap

I am experimenting with a restored file. Hold off for a bit. I ran through reentering information on several accounts and it was working until near the end so I need to go through it again and pay closer attention to which account messed up the investment account account summary balance.

when I get more information I'll post.

Quicken Anja

https://community.quicken.com/discussion/comment/20465235#Comment_20465235

Hello @Snap,

We appreciate you updating your post with these additional details and will look forward to your next response if you still require any further assistance with this later on.

Thank you!

Snap

I found where the problem occurs.

The program functions properly with coordinated balances in both the ledger and and the account list summary to the left UNTIL I do a backup.

When the screen refreshes after the backup, the investment account balance in the account list on the left is messed up. The ledger is still ok.

Something appears to be at issue with the backup button routine so the program is suspect.

How would I approach that?

mshiggins

@Snap it seems odd that a backup would change an account balance. What happens if you just close and reopen the file without backing up? Does the issue still occur?

Snap

I just tried to to restore the good file from a few days ago, made the one addition to the investment account, both balances properly matched.

I just quit the program without backup, restarted the program and the ledger was correct as usual but the account list balance to the left was messed up again. Atleast it always show the same error when it goes bad rather than a random number.

So it appears it is a "save" issue which I assume would apply to the backup routine too.

I should add that there are numerous accounts and this issue only happens to the one being discussed.

Quicken Anja

Thank you for following up again.

To make sure I understand correctly, this issue occurs after you save a backup, but before then the data is correct, is that right? If so, when you restore that backup that was saved, is the data correct in the restored backup file, or did it save the data incorrectly as well?

Check back and let us know!

Snap

Anja,

You are correct that the balances are correct while working on a known good file. The known good file is dated 12-3-2024 (or earlier). The issue was discovered on 12-5-2024 when an entry was made in the account in question.

If I start with a good working file restored from before the issue began, everything is good while working on it until it gets saved as backup or if normally saved when quitting the program. If I do a restore of the file just saved as a backup the issue reappears as does it if I just restart the program and let it use the file that it saved on shutdown.

So it appears that the save and restore functions are altering the reporting in the relationship between the ledger and the file list balances.

Was there a program update around 12-3-24 or later?

Quicken Anja

Thank you for explaining that in detail.

I suspect that this may either be a data file issue. However before we begin troubleshooting, can you please confirm where your main data file is stored on your computer? Is it in your local hard drive (C: drive), or do you have it stored in a cloud-based/external drive?

Snap

Data and program are on Samsung SSD 860 Evo in the laptop. It is half filled.

Quicken Anja

Thank you for providing those details.

In that case, I suggest that you please try validating and/or super validating your data file. However, I do recommend that you first save a backup file prior to performing these steps.

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.

I hope this helps!

Snap

Validate Printout:

QDF:
Validating your data.
Quicken repaired damaged transaction index. No action required.
Quicken found an invalid transaction record and removed it. "ACCT_1096d" 0/ 0/1900
Quicken repaired some transaction information. No action required.
"ACCT_1096d" 0/ 0/1900
Quicken found an invalid transaction record and removed it. "ACCT_1096d" 0/ 0/1900
Quicken repaired some transaction information. No action required.
"ACCT_1096d" 0/ 0/1900

Summary:
Quicken repaired 1 accounts. No action required.

QEL:
No read errors.

QEL:
All internal consistency checks passed.

Closed and restarted program with recommended delay but the problem of non-matching balances for the one account remains.

Supervalidate Printout:

File: "C:\Users\Ed\Documents\Quicken\QDATA"

QDF:
Validating your data.

QEL:
No read errors.

QEL:
All internal consistency checks passed.

Closed and restarted program and problem remains on one account.

Quicken Anja

Thank you for following up again.

Next, I suggest that you try creating a copy of your data file which will rebuild all of the internal lists and database tables. You'll want to do this with a file that has the correct data. If successful, you would then move forward with the copied file. To create a copy, please navigate to File > Copy or Backup File... > Create a copy or template (see examples below) which will also allow you to select a date range to move forward with. If you wish to move forward with your entire data file, please check the full date range of your entire data file before copying so you can enter the correct date range if you do not wish to "shrink" your file by eliminating certain dates.

However, it's important to know that doing so will disconnect all online services in the copied file and you will need to sign back in with your Quicken ID and reconnect all of your online accounts, online billers, Quicken Bill Manager services, etc if you plan to use that copied file going forward. The reason for this is that the new copy also creates a new and separate dataset ID.

If the issue is not resolved in the copied file either, then feel free to switch back to your original file.

Thank you!

Snap

I will do that but is there certainty that the program update that is dated the on the day before I noticed the issue is not at fault?

Snap

I tried the file copy and there was no change to the error in balances not matching.

I took it upon myself to roll the program back to ver 59.35 and it's working properly with balances matching over several shut downs and restarts so it appears that I am set. I suspected the program update and hopefully it won't try to update itself. Is there a way to control that?

q_lurker

… and hopefully it won't try to update itself. Is there a way to control that?

You can control the update installation with the Windows User Access Account Controls (UAC) settings.

Quicken Jasmine

Hello @Snap,

In order to report this problem for further investigating, would you mind updating to the latest patch then navigating to Help > Report a problem and submit a problem report with log files, a sanitized data file, and screenshots (if possible) attached in order to contribute?

After you have done so, you can then revert back to a previous version if you so choose.

Please let me know.

Thanks!

Snap

I am sorry but with 15 accounts that needed bring up to date with numerous transactions each, which I had to do more than once while doing the previous guided diagnoses, You can understand that I can't take a chance on messing up the current working state of the rolled back version of the program. It has taken two half days of down time. I would have appreciated a recommendation at the start to try a roll back.

Quicken Jasmine

Hello @Snap,

I understand. Please reach out if you still experience this issue in the future and would like further assistance!

Thanks!