Bug Report: Incorrect Account Balances in "Account Balances Report" for Investments
Product Version: Quicken Deluxe for WindowsFeature Affected: Account Balances ReportIssue Summary: The Account Balances Report generates incorrect account balances for various Investing Accounts when accessed from the Net Worth & Balances tab. Banking and Property & Debt are correctly shown.
Steps to Reproduce:
- Navigate to the Report → Net Worth & Balance in Quicken.
- Click on the Account Balances Report button.
- Observe the generated report.
Expected Result:
- The report should display account balances that match the values shown in the Accounts menu on the left sidebar.
Actual Result:
- The report displays erroneous balances for most Investment accounts:
- Balances are for manually entered data matches.
- Balance for downloaded transactions (Fidelity and ETrade) are always the same or higher in the report than in the Accounts menu.
- Some accounts show some minor differences (1.5%) (Fidelity Accounts).
- Some accounts are signficantly difference, one for ETrade is almost 2x higher.
- Accounts for HSA account downloaded from Fidelity tie exactly.
- These irregularities extend into all prior periods. A comparison of report produced last month (and saved to Excel) to this current report shows that these irregularities were not for recent reporting but impacted all prior reporting periods.
Impact:
- The report provides inaccurate data, rendering it unreliable for tracking financial information.
Other Details:
- The report was produced on November 2nd, at that time the report was reporting correct balances. Running the report this month the data is showing the irregularityies above.
- I have run VALIDATE and SUPER VALIDATE on the report, no significant issues were noted and this did not resolve the problem.
- As FYI - I submitted a report this morning of this bug through "Report a problem…" this morning with a screen shot of showing the comparison of the report to the account list balances.
Comments
-
As further research into this, this same problem was reported earlier this year.
It was noted "This morning, Quicken updated to R54.16. The Accounts Balance report is now correct." Not sure if same issue, but certainly smells like it. Maybe same/similar fix?
0 -
Thanks for the detailed report.
Please go to Help > About Quicken and let us know what version of Quicken you are running.
Have you verified that the data in the Accounts bar is correct? Click on gear at the top right of the Accounts bar and make sure Show current balance is selected, not Show ending balance. If Show ending balance is selected, future dated transactions will make the Accounts bar numbers disagree with other reports.
If you run Net Worth & Balances > Net Worth report, does it agree with the Account Balances report or the Accounts bar?
If you go to a problem account and click on Holdings, does the balance agree with the Account Balances report or with the Accounts bar?
QWin Premier subscription0 -
Thanks for your reply. My version is R59.35.
The amount in the Account Bar is correct. The difference is only showing in Investments, no future dated transactions.
The amount in the Net Worth report is the same as the Account Balances Report.
I think I have uncovered what the issue is….. In looking further at reports, I noticed the amount in the Portfolio Value report is correct (agrees to amount in Account Bar). The odd thing is the graph showing in the same report is the wrong amount. So I then looked at the Portfolio Value and Cash Basis report, pulled into Excel and it's clear now what's wrong. The Accounts Balance and Net Worth reports (and the Portfolio Value and Cash Basis report) is including values for options (Calls and Puts) that are long closed (dating back to 2020) in the balances. If I total up the amount of these closed options it is the difference I see between the two reports. Now Quicken needs to review and explain why this suddenly changed.
0 -
Anyone from Quicken looking into this? I've already done the hard part and found out the root cause. Now need a developer to correct the code. I could do that if necessary :)
0 -
This is primarily a user to user forum. Forum Moderators (users whose names begin with "Quicken") sometimes review issues discussed here and refer them to Development, but if you want Quicken to work on a problem, you should contact Support via phone. Be sure the support agent understands the problem and gives you a ticket number for future reference. Please post the ticket number here. Development only works on problems that have been referred by a Moderator or confirmed by a Support contact.
You should also use the Help > Report a Problem menu in Quicken to submit the issue online. In your submission, be as clear and thorough as possible. Reference the ticket number and provide a link to this discussion. Provide step by step instructions to reproduce the problem and note any error messages you receive. They will not pay much attention to a problem unless they can replicate it in house or see it in a support session.
You will not get a response to an electronic submission, but apparently they review and prioritize the submissions and use the data to help resolve problems they decide to work on. The more reports they receive the better.
QWin Premier subscription0 -
Hello @bobandsherry82,
We will be forwarding this to have it further investigated. I can see you have already submitted a problem report with logs and a sanitized file attached— thank you for that.
Could you please also provide screenshots so we can include those in our escalation? 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.
Thank you!
-Quicken Anja
Make sure to sign up for the email digest to see a round up of your top posts.0 -
Hi, thanks for the reply. I had sent a screen shot with markup originally when I reported the problem through Quicken program. I had to do it that way as Quicken kept dumping out with too many attachments error. I followed up later with the details. Let me know if I need to provide screen shot again.
0 -
Hello again,
Thank you, I was able to find the screenshot, and went ahead and forwarded this issue for further investigation. However, we do not have an ETA on when a resolution will become available. Once a solution has been created, it will likely be released as part of a future update release.
Thank you!
(CTP-11685)-Quicken Anja
Make sure to sign up for the email digest to see a round up of your top posts.0 -
Thank you for the update. Hopefully resolution will be quick, but understand it's out of your control.
1 -
You’re welcome!
-Quicken Anja
Make sure to sign up for the email digest to see a round up of your top posts.0 -
I have the same problem. I was doing an update, and Quicken closed. One account had some problems. I did a super validate. All in my file is OK now, however, the 1 account which is correct in the Investment tab has an incorrect net worth balance report.
0 -
Hello @mitch.trumpetwin,
Thank you for adding to this discussion, though I am sorry to hear that you are experiencing this too.
I can go ahead and get you added to the escalation ticket, however, we request that you please navigate to Help > Report a problem within your Quicken program and submit a problem report with log files and screenshots attached in order to contribute to the investigation.
It would also aid the investigation to include a sanitized file when submitting the problem report. A sanitized file is a data file that removes personally identifiable information so you can comfortably share this file with the Quicken team.
While you will not receive a response through this submission, these reports will help our teams in further investigating the issue.
Thank you!
-Quicken Anja
Make sure to sign up for the email digest to see a round up of your top posts.0 -
Another hint is that the Portfolio Value report is wrong as well. Here, the individual stocks have a correct gain/loss but the total gain/loss is not correct.
0 -
And… If I specify just the current stocks in the portfolio, then the report is correct. When I specify all stocks, the report is wrong. Strange.
1 -
I have a work around or a solution. During an update, Quicken closed… It seems that there was some corruption. So…. Run the account balances report just for the account in question. Then remove securities (I did that 20 at a time) and see if the balances start to work. If so, Add the securities slowly back and find the one creating the problem (in my case it was 2). I found the transaction and deleted it. In my case, I did not care about the security, so I did not add it back but had to fix a cash position. My report is OK. This is a data corruption issue.
0 -
You may want to create your own disccussion and also report within Quicken as Anja suggested as you have a completely different issue. I have already troubleshot the issue for my reporting difference. It is not due to any security but due to values of expired options (which should have no value and for which I have no shares) being included. The portfolio value, excluding the value of expired options ties out to the penny to my other security values. Creating a sepearate disucsion may help to escalate your specific issue. Have a great one.
1
