Account balance column and investing register don't match.

Tony Luers
Tony Luers Member ✭✭✭
edited January 3 in Errors and Troubleshooting (Windows)

When looking at my investing page with the "accounts" column on the left, the total of 1 account is less than the market value total on the investing page on the right.

I can't find any error in the register to account for the difference. The market value total is the correct amount.

How can I fix this and get the numbers to match again?

Quicken issues 1.2.26.png
Tagged:

Comments

  • Tony Luers
    Tony Luers Member ✭✭✭

    @Quicken Anja Can you give your thoughts on the above issue?

  • Quicken Anja
    Quicken Anja Moderator mod

    Hello @Tony Luers,

    Thanks for sharing the details. A few quick questions to help narrow this down:

    1. When did you first notice the account balance and investing register totals not matching?
    2. Is this happening with just this one account, or multiple accounts?
    3. Does the discrepancy stay the same all the time, or does it ever self-correct (for example, after closing and reopening Quicken)?

    Check back and let us know! Thank you.

    -Quicken Anja
    Make sure to sign up for the email digest to see a round up of your top posts.

  • Tony Luers
    Tony Luers Member ✭✭✭

    I can't honestly tell you when it started, I noticed maybe 4 weeks or so ago with the 1 account.

    After checking, there are differences in 7 out of 10 accounts. The 2nd from the bottom -1354 is definitely new and should not change.

    With Fidelity, or updating Quicken in general, it is difficult as it can be days before Quicken shows me any updates. As there is typically some transaction almost daily, I've come to accept the inaccuracy as aggravating as it is, but the one 1032 difference has been constant, the account side doesn't change. I've tried changing the date to go back and look, but there has been transactions and market changes so the market value will always change.

    Closing, reopening, rebooting does nothing. Actually, my closing and reopening right now showed the new error with the 2nd from the bottom.

    Just to mention, if we go back about a month, I had issues with opening the program itself, there's some file missing or something (I sent you screen shots) and I believe you want me to download a new copy of Quicken. I haven't done it yet because I'm assuming the new copy of Quicken will use an old file and I've been waiting and hoping these 2 columns will balance first.

    So, is it possible this problem is tied to the other problem? If I delete my copy, download a new copy of Quicken, where will the information come from? Will the old backup file be inaccurate as well?

    Almost feeling like I should just delete and start over.

    Thanks,

    Tony

    Screenshot 2026-01-03 154446.png
  • Tony Luers
    Tony Luers Member ✭✭✭

    @Quicken Anja

    I may have found the issue, but don't know how to fix it.

    Evidently 1 holding recently had a reverse split. When that occurred, they issued a new CUSIP number. I struggled with this back when the split happened and at the time thought it was fixed.

    I sold the holding after the split.

    Fed up, I decided to delete the account and then re-add. The 2 columns now are equal, but Quicken still doesn't know how to deal with the pre-split old CUSIP number. So right now, that transaction is "ignored".

  • Tony Luers
    Tony Luers Member ✭✭✭

    Got it fixed! Went back to a backup file and started over.

  • Jeff Mich
    Jeff Mich Quicken Windows Subscription Member ✭✭

    I had the same issue for two accounts. After reading your comment about a Split @Tony Luers I went into the register and found a 0 for 0 split after the actual splits. I deleted the 0 for 0 split and the Market Value in the holdings and the market value in the register now equal.

    @Quicken Anja - It appears when Fidelity and Quicken download the transactions it creates 3 line items per split. One of them doesn't register the shares correctly, one for the split, one for a new stock naming the split (meaningless), and one 0 for 0 split that is meaningless related to the stock but causes Quicken to not use it for the calculations in the market value.

  • Tony Luers
    Tony Luers Member ✭✭✭

    @Quicken Anja - "It appears when Fidelity and Quicken download the transactions it creates 3 line items per split. One of them doesn't register the shares correctly, one for the split, one for a new stock naming the split (meaningless), and one 0 for 0 split that is meaningless related to the stock but causes Quicken to not use it for the calculations in the market value."

    Part of the issue I was having is that when I'd update, you would get the screen that wants you to accept/reject a holding, say "ABC". I already have ABC, so I say it is the same. But for some reason, one of these splits is assigned a new CUSIP number, so now you have 2 ABC's. Then as you said, there appears to be 3 transactions per split. I've only had this issue with Yieldmax holdings. Other splits were fine.

  • Tony Luers
    Tony Luers Member ✭✭✭

    @Jeff Mich Glad you got it resolved quickly.

Categories