Incorrect cash balance for an investment account in the register

Vlad Kaplan
Vlad Kaplan Quicken Windows Subscription Member ✭✭
edited February 22 in Investing (Windows)

I'm on Quicken Classic for Windows, Version R65.29, Build 27.1.65.29. The problem started recently, no more than a couple of weeks ago.

I have an investment account that shows a Cash Balance of $470,550.92 at the bottom of the register. When I click on that, the Update Cash Balance window pops up and it shows the correct cash balance of $77.92. The Total Market Value at the bottom of the register is accurate but the Securities Value is low by the $470,473 (the difference between the shown and the actual cash balance).

Quicken Mismatch 2.png

The Account Overview window shows the correct securities and cash in the Holdings pane but the wrong amount of cash and the reduced market value of the securities in the Account Status (which matches the register).

Quicken Mismatch.png

I found a case with the identical symptoms back in 2021 that was resolved by replacing Bought transactions with N/A for cash with Add Shares transactions. But in my case, it appears that Bought transactions are correct: they show shares added to the account with the cash subtracted.

Any help would be greatly appreciated!

Comments

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod

    Hello @Vlad Kaplan,

    Thank you for reaching out! Do you have a core fund that's used instead of cash? If you do, then it's possible that the reason for the discrepancy is that Quicken is seeing that fund as cash instead of as a money market fund.

    To check for that, navigate to Tools>Account List, and click the Edit button next to the problem account. Then, go to the Online Services tab. Near the lower right, you should see a Reset Money market securities/cash options button.

    reset money market option.png

    Click that button. If it's set to interpret the fund as cash, you should be able to change it there.

    I hope this helps!

    Quicken Kristina

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

  • Vlad Kaplan
    Vlad Kaplan Quicken Windows Subscription Member ✭✭

    Thank you, Kristina, for your response. I keep excess cash in SGOV to earn dividends, but it's not counted as cash in the account. The actual cash, usually very little, is just kept in a sweep fund.