cancel
Showing results for 
Search instead for 
Did you mean: 
Swordbooks
Level 3

Credit Card feed linked to two accounts

Working on a cleanup project for a client. They set up a bank feed for a credit card (CC#1) and loaded FY2023 transactions for the entire year. Then they disconnected the feed and connected it to another credit card account (CC#2), again loading the entire year. So we're sitting on $122K of duplicated transactions. 

 

What I want to do is set CC#1 as inactive and delete all 2023 transactions. I've already done the due diligence of confirming everything in CC#1 is a duplicate from Jan 1 2023 forward. Is there a straightforward way to delete these 500+ transaction lines as a group, not one by one?

 

Solved
Best answer April 26, 2024

Best Answers
LouiseG
QuickBooks Team

Credit Card feed linked to two accounts

Let me provide an additional step on how to remove  transactions that have been categorized in QuickBooks Online (QBO), @Swordbooks.

In QBO, we first need to undo the categorized transactions before you can exclude or delete them.

To undo the duplicate transactions, follow the steps below:

 

  1. Navigate to Transactions, then Bank Transactions.
  2. Click the Categorized tab.
  3. Tick the box of the transactions you want to remove or the batch action button, then Undo.

    image (3).png

     

  4. Click Continue.

 

Once you Undo the transactions, they'll move back to the For review tab. Then, follow the steps provided by my colleague on how to exclude or delete them. 

 

Check out this article for future reference to help you with your reconciliation process: Reconcile an account in QuickBooks Online.

 

If you have additional concern or queries about online banking transactions, let me know by replying to this thread. I'll be there to help. 

View solution in original post

9 Comments 9
SashaMC
Moderator

Credit Card feed linked to two accounts

Thank you for connecting with the QuickBooks Community, Swordbooks. Currently, the option to do a batch delete is only available for bank feed transactions that have yet to be added to QuickBooks. Let me guide you on how to delete online banking transactions:

 

  1. Click the Banking menu.
  2. Select the correct account.
  3. Go to the For Review tab then mark the items you're deleting.
  4. Click the Batch actions button.
  5. Choose Exclude Selected.
  6. Once done, go to the Excluded tab.
  7. Mark the transactions again, then click the Batch Actions button.
  8. Click Delete.

 

If you need more, feel free to use this link, which provides third-party apps that integrate with QuickBooks and are associated with bulk transactions. Please update me if you need further assistance with QuickBooks. I'm here to help.

Swordbooks
Level 3

Credit Card feed linked to two accounts

Thanks for the response @SashaMC . As you said that solution works if the transactions haven't been added to the register. Unfortunately the client had categorized all the transactions, including the duplicates. I went through the process of deleting each of the 500+ duplicates one by one. 

The client has multiple credit cards and experienced a staffing turnover, so I can guess how this could have happened. But I want to believe that a digital program like QBO should have a better option to clean up an error of this size, especially for the accountant platform. I could have zeroed out the duplicate credit card balance by journal entry, but the vendor activity would reflect inaccurately if I did. 

alex_nj
Level 3

Credit Card feed linked to two accounts

I agree with you @Swordbooks , this is a woeful oversight. I had an issue with a set of books where prior bookkeepers relied way too heavily on automatic rules to book transactions. There should be ways to do bulk corrections on transactions that have already been added to registers--or if nothing else, a way to UN-add them to registers so they can be placed back in the queue for handling.

 

When QuickBooks makes it so easy for users to create problems like this, it should make it equally easy for administrators to fix them. 

Swordbooks
Level 3

Credit Card feed linked to two accounts

Thanks @alex_nj. Glad to know it's not just me. I do rely on the Reclass feature to do batch corrections and it feels something similar could be developed for changes within the bank register. 

LouiseG
QuickBooks Team

Credit Card feed linked to two accounts

Let me provide an additional step on how to remove  transactions that have been categorized in QuickBooks Online (QBO), @Swordbooks.

In QBO, we first need to undo the categorized transactions before you can exclude or delete them.

To undo the duplicate transactions, follow the steps below:

 

  1. Navigate to Transactions, then Bank Transactions.
  2. Click the Categorized tab.
  3. Tick the box of the transactions you want to remove or the batch action button, then Undo.

    image (3).png

     

  4. Click Continue.

 

Once you Undo the transactions, they'll move back to the For review tab. Then, follow the steps provided by my colleague on how to exclude or delete them. 

 

Check out this article for future reference to help you with your reconciliation process: Reconcile an account in QuickBooks Online.

 

If you have additional concern or queries about online banking transactions, let me know by replying to this thread. I'll be there to help. 

Swordbooks
Level 3

Credit Card feed linked to two accounts

@LouiseG That is exactly what I was wanting to do. Thank for you for this!

GebelAlainaM
QuickBooks Team

Credit Card feed linked to two accounts

You're welcome, @Swordbooks.

 

We're glad to know that the information provided by my colleague helped you with your concern. Please know that assisting and providing resolution for our valued customers is our top priority.

 

If you have any questions about managing your bank accounts in your QuickBooks, you can always drop by and post your concerns. We'll make sure to address that as soon as we can.

 

Take care and have a good one!

alex_nj
Level 3

Credit Card feed linked to two accounts

@LouiseGThis is great, but is there a way to do this in QuickBooks Desktop?

MsNorthPND18
QuickBooks Team

Credit Card feed linked to two accounts

Thank you for reaching out to the QuickBooks Community, @alex_nj.

 

Yes, there's also a similar process for excluding or deleting bank transactions in QuickBooks Desktop. Let me share more details about it.

 

The duplicate transactions can be undone by following the steps below:

 

  1. From the Banking menu, choose Banking Feeds from the list.
  2. Bank Feeds Select Bank Feeds Center.
  3. Pick a specific bank account on the left side. The Transactions List button should be clicked.
  4. Mark all the transactions you need to undo on the Transaction List window.
  5. Select Ignore from the Batch Action drop-down.

 

For more details, I have added these articles:

 

 

If you still have other questions regards the credit card feed linked to two accounts in the QuickBooks Desktop account. Just feel free to comment down below. I will be glad to answer you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us