Net Worth & Account Balance Report -- One Account Wrong

teke123

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!

Quicken Jasmine

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!