Sum of holdings not equal to sum of lots

Millersville

For a single equity, the sum of my lots is not equal to the sum of the individual lots:
I am running version: R27.42 Build 27.1.27.42.
I have read post "sum of share lots does not equal stock total; shares disappeaered (sic) form (sic) lots but not from total"; validated the copy and super validated the copy to no avail. Any further suggestions?

Jim_Harman

OK good. 

Now try going back in time by adjusting the As of date until the numbers add up correctly, then forward until the problem first occurs. Look for a transaction near that date and see if anything is amiss. Try deleting and re-entering that transaction and see if that fixes it. Repeat if necessary until the numbers are correct today.

Always back up your data before messing with historical transactions.

Jim_Harman

Make sure there are no hidden Placeholders in your account: Go to Edit > Preferences > Investment transactions and check "Show hidden transactions" if if is not already.

Look through the Transaction list (register) for any transactions that are gray even if not selected an have an Action type of Entry. Resolve the Placeholders. 

Rocket J Squirrel

To the left of the number 1,080 I see a tiny blue dot. Is that really there in Quicken? If so, it might be trying to tell you something about that lot. I've never seen that before but if it's really there, it's worth checking out.

Millersville

Mr Squirrel: The blue dot is a glitch, not visible in the original screen.
Mr. Harmon: My apologies. I forgot to mention that I had verified that all placeholders were visible as instructed in the prior post.

Jim_Harman

And have you resolved the placeholders in the problem security? Once a placeholder is down to zero shares, you should delete it. 

Millersville

Thank you for your suggestion Mr. Harman, but I have no placeholder entries.

Jim_Harman

OK good. 

Now try going back in time by adjusting the As of date until the numbers add up correctly, then forward until the problem first occurs. Look for a transaction near that date and see if anything is amiss. Try deleting and re-entering that transaction and see if that fixes it. Repeat if necessary until the numbers are correct today.

Always back up your data before messing with historical transactions.

Millersville

Mr. Harman, Following your suggestion I was able to identify the offending date, I deleted all transactions on that date of the offending security, then re-input the data. The problem has been resolved! Thank you!