Removing unnecessary prior year investment transactions

bob_s

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!

UKR

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

bob_s said:

> @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!)

It is one of those things that bites users every once in a while when they run a report, see a transaction they don't want in it, delete it thinking they are only affecting the report and then find their balance in the register is different.
While you can select a range or multiple transactions in the banking registers for deletion, doing it thru a report is the only way with invest accounts.

Unknown

This content has been removed.

Boatnmaniac

@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?
  

Unknown

This content has been removed.

UKR

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

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.

bob_s

> @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

> @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!)

splasher

bob_s said:

> @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!)

It is one of those things that bites users every once in a while when they run a report, see a transaction they don't want in it, delete it thinking they are only affecting the report and then find their balance in the register is different.
While you can select a range or multiple transactions in the banking registers for deletion, doing it thru a report is the only way with invest accounts.