Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Unfixable investing cash balance?

I'm stuck, and out of ideas. One of my retirement accounts has a completely bonkers cash balance listed. I've run the 'Update Cash Balance' tool and set it to the correct value. I can do this until I'm blue in the face, but nothing changes (and the value presented to enter *is* the correct value - but it never updates in the actual 'cash balance' field). I've run Validate and Repair, to no avail. No errors are presented for that account. The "Holdings" window, in the list at the very bottom shows the correct $69.39, but below in the "Account Status" listing it shows the bogus $20k value.
I'm at a loss.

Here's a screenshot, not sure if it'll post or not. No meaningful identifying info is included.

https://imgur.com/a/whotZGT

Answers

  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    Hi @Paul Theodoropoulos

    Have you checked to see if there are any placeholders in the account?  If not, here's how to do that:

    1) Go to "Edit" > "Preferences" > "Investment Transactions";
    2) The "Show hidden transactions" box should be checked.  If it isn't already checked - check it now and click "OK".

    Then go back to the account register and you should see some additional activity (i.e. placeholder(s) ).  You can also view them in the "Placeholder Entries" tab at the bottom of the register.  You need to resolve any placeholders and here's a LINK to more information about them.

    If you can't figure it out, post back about what you are actually seeing in the placeholders tab and we'll go from there.

    Frankx


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -
  • My apologies for leaving that detail out. Show Hidden Transactions is selected, and there are no placeholder or hidden transactions at this time. A couple of months ago I went through the placeholders that were there, and resolved the discrepancies. There was no cash balance issue until a couple of weeks ago. I also went through each of the assets under holdings and compared the market value of each to the market value shown in the portfolio online, and all values were identical. Just that cash balance is in error.
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    edited March 25
    It is odd that the account's cash balance at the bottom of the Holdings table does not match the cash balance in the Account Status section just below it in the account overview.

    What is the cash balance at the bottom of the register?

    On an Investing Portfolio page grouped by account?

    On the Reports > Investing > Portfolio value report subtotaled by account?
    QWin Premier subscription
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Also what version of Quicken are you running? Old versions sometimes had issues with cash.
    QWin Premier subscription
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Have you tried the Supervalidate option -- on a copy, Ctrl-Shift while you click through the Validate button?  That is a shot in the dark.  
  • Thank you folks for the suggestions and assistance. I always keep Q up to date, I am on R32.10/27.1.32.10. I just ran super validate, and while it found a very few errors, none related to the investment account in particular, and no changes in the bizarro cash balance.

    Re Jim_Harman "What is the cash balance at the bottom of the register?" that should be visible in the image I had uploaded. It now stands $1000.50 higher, after I had found a mismatched investment record that caused double entry (PCOXX changed its name which confused Q), which increased my total investment balance, but which appears to have simply iterated onto that fubar cash balance. Unfortunately that now throws the 'true' cash balance off by that amount. Sigh.

    Re "On an Investing Portfolio page grouped by account?"
    I'm afraid I don't know what/how that's done!

    Re "On the Reports > Investing > Portfolio value report subtotaled by account? "
    It also shows the same incorrect but more reasonable cash balance, rather than the $20k cash balance.

    Over the years the investment accounts have had various intervals of bad cash balances, which were "solved" by just running the 'update cash balance' dialogue, so I'm going to be going through the transactions and see if those could possibly add up to the amount in question, though I highly doubt it.

    Below are the results of super validate:

    QDF:
    Validating your data.
    Repaired your data file by removing a damaged category. Please check your category list for missing categories by going to Tools>Category List.


    QEL:
    No read errors.

    QEL:
    All internal consistency checks passed.

    [Thu Mar 25 21:19:26 2021]
    Quicken has found 1 stock split(s) for account "XXXXXXXX", security "MICRO FOCUS INTERNATIONAL PLC", on 4/30/2019 that might be missing.
    Quicken has found 1 stock split(s) for account "XXXXXXXX", security "BROOKFIELD ASSET MGMT INC CL A LTD VT SH", on 4/2/2020 that might be missing.
    No out-of-range security references found.

    Super validation has completed.
    =======================
    However, those errors are associated with a completely different investment account.

    I'll keep poking away. It's definitely weird, definitely puzzling and perplexing, but since the holdings value matches the true and correct online value at the brokerage, nothing meaningful appears to be broken 'hard'.....I hope!

    Thanks again very much for the assistance.
  • On a lark, I made a copy of the qdata file, then went in and deleted the dozen or more balance adjustments that had occurred over the years to try to straighten up the cash balance.

    It came out yet another $10k higher than the current fubar value. Oh well.
Sign In or Register to comment.