How to Adjust Cost Basis of Investment

JCOldSchool
JCOldSchool Quicken Windows Subscription Member
edited May 24 in Investing (Windows)

One of my retirement investments is a money market account whose cost basis for the lots shown in the investment details is always $1.00 per share. However, when the lots are rolled up into the total line, the total cost basis is substantially greater than $1.00. How can I adjust the rolled-up total cost basis so that it matches the aggregate value of the underlying lots?

EDIT: I reviewed the instructions and the used the AI tool, but there appears to be no option for me to adjust the security costs at the total line. The individual lot values of cost basis are correct, the cost basis error exists only as the lots are rolled up into the total. Screen shot below.

image.png
Tagged:

Answers

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭

    The next two steps I would take:

    • From the account transaction list, Ctrl-z to recalculate the register, and
    • Change the As of date for the view you snipped to find a time when the total did agree. Investigate subsequent transactions possibly including deleting and re-entering transactions.
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited April 23

    What I see is that the total cost basis of $146,459.31 is many times what it should be. This might have been caused by a bug in Quicken if you have done a Mutual Fund Conversion for a security that has the Use average cost option selected, or a corrupted transaction.

    To find when this problem occurred, you can set the As of date back to see if there is a date when the cost basis jumps up. Look for a transaction on that date and correct or even better, delete and re-enter it.

    Always back up your data before modifying historical transactions, in case something goes wrong.

    Please let us know what you find.

    QWin Premier subscription
This discussion has been closed.