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; } } }

Cash Reconciliation Issue in Reports

Pat Sills

Hello,

I am a 20+ year Quicken user who tracks investments in Quicken.

All my investments are set not to include asset class information.

In one account, A, if I look at the transaction display or holdings display, cash is correctly reported as $x.

Now I create a report where the only security is "no security (includes cash" to look only at cash balances. The cash balance is reported as $y, where y>x by a substantial amount. I cannot determine how to resolve this discrepancy.

I have three additional accounts (B, C, D) in the report with no discrepancies. In accounts B, C, and D, $y=$x - no problem.

Any ideas on what's causing the reconciliation issue in one account? I'm stumped. Thanks for any advice.

Regards,

Ken

[Edited - Readability]

Find more posts tagged with

Investments

Reconcile

Windows

Comments

Jim_Harman

What built-in report are you starting with when you see this discrepancy?

I am not sure what you mean by "All my investments are set to not include asset class information" but that should not affect the problem you describe unless you are using the Asset Allocation report.

Have you tried validating your data file? Sometimes that fixes issues like this. Start by backing up your data file in case something goes wrong, then go to File > Validate and Repair file and select the Validate File option.

If that does not resolve the problem, I suggest you set the end date for the report back in time until the cash balance matches the balance in the account's Transaction List (register) then go forward until you first see the discrepancy. Look for an unusual transaction on that date. Sometimes deleting and re-entering a transaction will fix the problem.

Please let us know what you find.

Sceptic

@Pat Sills you don't mention the report you are looking at, but does drilling down on the $y cash balance in the report identify the transactions contributing to the difference? Also, does Account A contain any Placeholder transactions (Edit→Preferences→Investments→Show Hidden Transactions)?

mshiggins

@Pat Sills I have seen the issue of cash in my Fidelity brokerage account register being X amount and in the Allocation by Security report filtered to the Fidelity brokerage account, the amount for "no security (includes cash)” is not the same as X.

Validate and Repair did not fix the issue. If I recall correctly, I used the Net Worth report with the Account Detail option selected and varied the time frames and intervals to find where the “no security (includes cash)” amount discrepancies started.

The culprit turned out to be several transfers of cash out of the brokerage account in to one of my credit card accounts from when I paid credit card payments from the Fidelity brokerage account. Although there were no discernible issues with the transfer transactions, they must have been damaged. Deleting and recreating the transfer transactions eliminated the “no security (includes cash)” discrepancy.