Net Worth & Account Balance Report -- One Account Wrong

Windows - Subscription R62.16
Hi -
I have one brokerage account that has a significantly wrong balance in both the Net Worth and Account Balances reports ran from the Reports menu. The reports have a higher balance than the register.
I ran the File Validation to no effect on the reports. No Placeholder entries. Accounts reconciled to actual brokerage statements.
Comparing the balances month-by-month with the account balance I identified a specific November 2017 cash deposit transaction in the exact amount of the difference. It is almost as if the deposit was recorded twice. Deleted it and added it back with no effect on the reports.
Any ideas?
Would prefer to fix the report properly but guess I could try corrupting 2017 with a bogus entry to fix this.
Thx!
Comments
-
Hello @teke123,
Thanks for reaching out!
Since you identified a specific transaction from 2017 as the likely source of the discrepancy, but modifying it didn’t affect the report totals, I’m curious: when you re-entered that deposit, did you ensure it was entered exactly the same way (same date, category, memo, and account)? Also, have you tried customizing the report to only show that one account for a narrow time window—say, just November 2017—to see if anything else unexpected is showing up in the data?
I’m also wondering if the register balance and the report balance diverge consistently after that point in time, or if the difference fluctuates, which might point to a lingering issue like a hidden or misclassified transaction that only appears in reporting. Have you ever changed the account type or transferred this account between Quicken files, which could leave behind residual data affecting reports but not registers?
Let me know!
-Quicken Jasmine
Make sure to sign up for the email digest to see a round-up of your top posts.
0 -
You say No placeholders. Do you have your preference settings set to show hidden transactions? Placeholders can be hidden.
You deleted and re-entered the cash transaction with no change. Did just the delete operation change the reports?
What are the details of the apparently key transaction? Specifically, what is the category for the transaction? If the category is the same account, that is a self-referencing transaction that by design does not affect the cash balance. Such a categorization should not normally be used.
0
Categories
- All Categories
- 22 Product Ideas
- 29 Announcements
- 206 Alerts, Online Banking & Known Product Issues
- 19 Product Alerts
- 750 Welcome to the Community!
- 621 Before you Buy
- 1K Product Ideas
- 50.9K Quicken Classic for Windows
- 15.7K Quicken Classic for Mac
- 996 Quicken Mobile
- 785 Quicken on the Web
- 82 Quicken LifeHub