Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Is there a way to bulk edit the Actions field in transactions? (Q Mac)

You can bulk edit Payees, Categories, Tags, Notes, etc. by editing a group of transactions but it doesn't appear that I can bulk edit (e.g., delete DEBIT or CREDIT) actions without modifying each transaction separately. Also, does QMac automatically assign an Action such that even if I wanted to just use an Action for a limited set of transactions (e.g., EFT), the CREDIT and DEBIT Actions would just reappear anyway on new transactions?

Best Answers

Answers

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Sorry, my mistake about that auto-enter aspect, and thanks for the correction, @RickO . Most of my transactions have either been imported from Quicken 2007 or entered manually, so I don't see a lot of those things.

    What the difference between TXFR and XFER? ;)  How does it determine if an ATM deposit is ATM or DEP or DEBIT? Or if an ATM withdrawal is ATM or CASH or CREDIT?
    Quicken Mac Subscription • Quicken user since 1993
  • RickO
    RickO SuperUser, Mac Beta Beta
    jacobs said:
    What the difference between TXFR and XFER? ;)  How does it determine if an ATM deposit is ATM or DEP or DEBIT? Or if an ATM withdrawal is ATM or CASH or CREDIT?
    I have no idea. That quirk makes me suspect that the entries do in fact come in from the bank. I'm sure it could be determined by examining the QFX logs, but since it's a trivial issue (to me), I'm not going to spend the time.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • kv0rmwald
    kv0rmwald Member
    Thanks for the helpful discussion. It pretty much confirms the behavior I am seeing. I too wasn't thinking that I'd make a lot of use of this Action field, but it could be helpful in a few cases such as for EFTs or also identifying credit card or loan payments without using the Notes field. I originally suspected that the existing Actions were one-time created when I migrated from the PC Quicken to Mac Quicken. So I thought if I could bulk edit clean those up, I could begin to use the Action field as desired. But then I noticed that I was seeing CREDIT and DEBIT show up on very recent downloaded transactions from my bank. So then it hit me that even if I could do a one-time bulk cleanup, I'd have to diligently keep doing that after every download in order to keep the undesired Actions from reappearing. And I'd agree that the cost outweighs the benefit. I've been just using Tags instead.
  • RickO
    RickO SuperUser, Mac Beta Beta
    Tags is a great solution. I primarily use tags for a different purpose, and since I don't need to report on it, using Action for method of payment works for me.

    One tip: if you want to bulk edit an Action (to get rid of a particular one), you can open the Actions window and delete it from there. It will disappear from all transactions. It will, however, re-appear if it's one of those that gets auto created.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • kv0rmwald
    kv0rmwald Member
    Thanks Rick, I discovered that neat trick myself and was just about to mention it here for others. That did work for my objective which was to eliminate all of the CREDIT and DEBIT Actions to get a "clean slate" to start back from. And I'm hoping that even if new CREDIT and DEBIT Actions show up via downloaded transactions, that QMac will add them back into the list of Actions from which I can periodically easily remove them. Not the best solution, but it will work for my needs. Thanks again for the discussion.
  • mybank2002
    mybank2002 Member ✭✭✭
    jacobs said:

    What the difference between TXFR and XFER? ;)  How does it determine if an ATM deposit is ATM or DEP or DEBIT? Or if an ATM withdrawal is ATM or CASH or CREDIT?
    Cool glad to see the action window was mentioned.  Regarding the difference between TXRF and XFER I just switched from Quicken for Windows so I don't know if the same rules apply but when I would use Quicken to transfer money between accounts and have it do that for me on my bank then it would put in XFER so basically between your own accounts. It would do TXFR automatically when I would transfer between my other bank accounts. This mark helped with reports and not calculated as income or an expense. I would imagine that would be the same in Quicken for Mac but based on the reply from @jacobs of them being nothing more than cosmetic it sounds like that might not be the case on Mac.

    I have started using this field for a note to talk to my wife about certain transactions but as mentioned above you could just use tags for this sort of thing.
  • kv0rmwald
    kv0rmwald Member
    I too recently switched from Quicken for Windows to the Mac version. I haven't noticed QMac doing anything with TXFR or XFER Actions with respect to my bank transfers. But I did notice another quirk in that for some transfer transactions, like making a payment by transferring money from the bank checking account to the same bank's credit card account, QMac may not let you set the Action field on both sides of the transfer. You can set the field on one side of the transfer, but on the other side you get a message that it's a transfer that can't be edited at this side and it points you to the origination of the transfer to make any edits. Except any change made to the Action field on the originating side of the transfer isn't carried over to the other side of the transfer. So I've been mainly using Tags as they are also bulk-editable if I change my mind.
This discussion has been closed.