Removing unnecessary prior year investment transactions

Found nearly 200 investment transactions that are no longer relevant, the equities have been sold/traded. Is there a way these entries can be removed enmasse? Lot of time to remove them one-at-a-time!

Best Answers

  • UKR
    UKR SuperUser ✭✭✭✭✭
    edited August 2020 Accepted Answer
    If you're an active trader and your current investment account has many transactions pertaining to sold securities you may want to consider this:

    Archive Investment Transactions

    For about a year now, a new function has been available in Quicken, Archive Transactions. It will split your investment account register into two parts, leaving only those securities' transactions where you currently hold >0 shares in the active register. The rest is moved to a new Archive register within the current data file.

    Having less transactions in your active register might improve performance.

    Please read and follow instructions here: https://www.quicken.com/support/how-archive-investment-transactions


Answers

  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    @bob_s - Simply deleting investment transactions because you no longer hold them is generally not a good idea because it can really mess up the historical and current portfolio values and performance data of the investment account.  Help me understand more about your situation better so an appropriate recommendation can be made:
    • Does Quicken show that you still own shares of these equities?
    • Does your investment account in Quicken show a Cash Balance amount that is accurate?
    • Does your investment account in Quicken show an accurate Market Value?
    (QW Premier Subscription: R33.24 on Windows 10)
  • UKR
    UKR SuperUser ✭✭✭✭✭
    edited August 2020 Accepted Answer
    If you're an active trader and your current investment account has many transactions pertaining to sold securities you may want to consider this:

    Archive Investment Transactions

    For about a year now, a new function has been available in Quicken, Archive Transactions. It will split your investment account register into two parts, leaving only those securities' transactions where you currently hold >0 shares in the active register. The rest is moved to a new Archive register within the current data file.

    Having less transactions in your active register might improve performance.

    Please read and follow instructions here: https://www.quicken.com/support/how-archive-investment-transactions


  • splasher
    splasher SuperUser ✭✭✭✭
    If you are dead set on doing the delete, run a Banking->Transaction report for the account & securities in question.
    You can select them in the report and then delete them.  Be careful though, you can't undelete your mistakes.
    As always, make a Quicken backup prior to starting.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • bob_s
    bob_s Member ✭✭
    > @Boatnmaniac said:
    > @bob_s - Simply deleting investment transactions because you no
    > longer hold them is generally not a good idea because it can really mess
    > up the historical and current portfolio values and performance data of the investment
    > account.  Help me understand more about your situation better so an
    > appropriate recommendation can be made:* Does Quicken show that you still own shares of these equities?
    > * Does your investment account in Quicken show a Cash Balance amount that is accurate?
    > * Does your investment account in Quicken show an accurate Market Value?

    Bottom line, these securities have ZERO shares and are from a period when my broker(s) were trading small caps in and out...
    Investment account is accurate (to the penny) in both security values and cash.
    Just ran an Investing Archive, as suggested later in this thread, and did exactly what I wanted...found 200+ of 700+ transactions to 'remove'.

    Thanks for the thoughts and concerns.
  • bob_s
    bob_s Member ✭✭
    > @splasher said:
    > If you are dead set on doing the delete, run a Banking->Transaction report for the account & securities in question.You can select them in the report and then delete them.  Be careful though, you can't undelete your mistakes.As always, make a Quicken backup prior to starting.

    I learned something new today (after decades of using Quicken): Did not realize you could 'mass' delete records through a report! Always double clicked the cross-hairs and never right clicked the mouse! (Duh!)
This discussion has been closed.