nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Investment cash balance not correct

SmokeyToo

I have an investment account that I enter all the transactions manually. Stock trades, interest payments, bonds, etc…. Ive not been plagued by an incorrect cash balance in a long time, so lucky there. But now, the beginning cash balance from my statement does not match my last successful reconciliation from feb. All inflows and outflows match, but the reconciliation is off by $66,302.00. For investment trades I have cash to to same account balance. Ive looked at all ins and out since December and all transactions seem to be ok. I did a CTRL-Z in account. No errors. Validate and repair - but nothing to repair - all was good. Not sure what else to check? Im reluctant rio let the reconciliation enter a bogus balance adjustment as I seem to remember way back when, when ive done that, nothing but problems afterwards. I dont see any older uncleared transactions - even though Quicken seems to have changed in that regard - not as easy as I remember to change the register view to check ( ?!? )….

What else can I do / check?

Find more posts tagged with

Reconcile

balances

Comments

[Deleted User]

@SmokeyToo check the reconciliation status of your prior older transactions and if see if the status of any of the changed somehow (R to C or blank) and changed them back to (R ).

SmokeyToo

ok. Checked. All I have are “R” , except for current statement time frame.

SmokeyToo

perplexed!

[Deleted User]

@SmokeyToo does your current Cash Balance in Quicken match the current cash balance in your account at your financial institution or your current statement? If so, then the difference could be a "timing issue".

SmokeyToo

https://community.quicken.com/discussion/comment/20487702#Comment_20487702

no. Doesn’t match.

[Deleted User]

@SmokeyToo I am making an assumption that you reconcile your investment account monthly? And, prior to this last statement, when you do, the cash balance on Quicken balances to the penny with your statement?

Do you have prior statements so you can go back and compare each monthly statement cash balance with the monthly cash balance on Quicken? This way you can confirm or narrow down when the cash balance went off kilter and then locate what transaction(s) caused the cash to go out of balance.

You can find the monthly cash balance on Quicken by going to Portfolio on the Investing tab. Group by Accounts. Then expand the account by clicking on the little triangle on the left side. The cash amount is at the bottom of the security listing. Change the As of Date to see the cash for that date. Hopefully you can find were the cash went off kilter and no longer agrees with your statement cash balance.

SmokeyToo

are you talking running daily balance or monthly? I reconcile monthly and theyve all zero’d out. Regardless, ill take a look at what you mentioned. Stumped! Tks.

SmokeyToo

https://community.quicken.com/discussion/comment/20487729#Comment_20487729

So ive looked, going back to Dec 2024. All my reconciliations have balanced - zero'd out - up to this problem. But in looking at the view you say and my cash balances there, none match my paper statements. They are all off way more than what im now experiencing. This has gone from weird to weirder !

[Deleted User]

@SmokeyToo - I think the cash differences could be due to timing issues. I think you next step would be start as far back as you can and compare your investment account statements to your transactions and balances on Quicken. Essentially you are redoing your reconciliations, from then, to current. You should then be able to tell when your balances went off kilter.

It could be not just a cash balance issue. Maybe a buy or sell got deleted and affected your cash balance. But hopefully, by redoing your monthly reconciliations, you will be able to find out what the issue is.

SmokeyToo

https://community.quicken.com/discussion/comment/20487949#Comment_20487949

So, I went back to jan '24 looking at the monthly cash balance in quicken. In June I found the difference - a withdrawal for a purchase that was not entered. Not sure how that was missed. But , now im more curious to know is how did all my subsuquent reconciliation balance out with that transaction missing?

[Deleted User]

@SmokeyToo I am glad you found the difference. That's the good news. The bad news is you may never have an explanation of "how and why". I wouldn't worry about it unless it becomes a recurring issue.

mmpunch

SmokeyToo I quickly scanned the posting, so pardon me if I missed something. If you are manually entering everything, WHY? I download all my investment transactions directly from the Investment firms using Quicken’s direct connect.

SmokeyToo

https://community.quicken.com/discussion/comment/20488247#Comment_20488247

When the new firm took over, I did not agree with the updated terms of agreement and Schwabs guarantee of coverage was voided if account was breeched due to 3rd party hack.