cancel
Showing results for 
Search instead for 
Did you mean: 
Gentek
Level 2

New CC# was issued as replacement card, but QBO is pulling transactions from last card..?

We had CC fraud (yay), and a new card was issued (same account, but new CC number).  When this last happened, I don't recall having issues importing the new card transaction list.  This time, when I try to import the new card, it's pulling transactions from the previous card and making this a nightmare...

 

This will be the 2nd replacement card for this same account.  I can actually still see that very first card (just never deleted it), it just says there's a bank connection issue, since the card is no longer there.

 

What's the proper procedure to import a replacement card into the system without the possibility of duplicate expenses being present..?

 

I checked on some of the other expenses from the last time this happened, since I was worried that last time there were duplicates, but I don't see any.

 

All of the transactions are caught up on the previous card before the current one, so it seems strange it would try and import them all again (literally it will go back to Jan 1st if I let it).

3 Comments 3
Giovann_G
Moderator

New CC# was issued as replacement card, but QBO is pulling transactions from last card..?

I'll share the process of updating your credit card account information, Gentek.

 

You'll have to disconnect the old account and reconnect with your updated account information from the Banking page. This way, a fresh connection to that account can be established by QuickBooks. I'll show you how.

 

 

  1. In the left menu, click Transactions.
  2. Go to the Banking tab.
  3. Pick the account you want to update.
  4. Hit the Edit ✎icon.
  5. Select Edit account info.
  6. Check the box for Disconnect this account on save.Capture.PNG
  7. Choose Save and close.

 

Now, you can reconnect the account with the new credit card number. Here's how:

 

  1. Select Transactions on the left menu.
  2. Click on the  Banking tab.
  3. Pick the Link Account button.
  4. Type in the bank account details.
  5. Once done, hit Connect button.

 

For your future guidance, I've also added the following articles below:

 

 

If there's anything else I can help you with updating the credit card information, add any details below. I'll get back to you. 

Gentek
Level 2

New CC# was issued as replacement card, but QBO is pulling transactions from last card..?

Yes, and that works fine (have already tried it), however it pulls in hundreds (thousands if you let it) of the 'old' transactions which have already been pulled in by the other card number and matched to expenses.  It becomes a nightmare trying to figure out what's already been matched and not create duplicate expenses for the transactions.

 

I don't recall having this issue last time?

DHeraV
Moderator

New CC# was issued as replacement card, but QBO is pulling transactions from last card..?

Let me clear things up for you, @Gentek,

In QuickBooks Online (QBO), linking an account should normally let you choose the date range of the data that can be downloaded. In your case, you might have missed selecting the date which made QBO automatically download the 90 days' worth of transactions.

As a workaround, I suggest manually referring to your bank statements and reviewing your transactions. After identifying the old matched entries, you may need to exclude them to keep them from going into your company expenses.

Here's how:

1. Go to the Banking section, and select For Review.
2. Tick the box of the transaction you want to exclude.
3. Click Exclude.

For additional detail, please visit: Exclude a bank transaction you downloaded into QuickBooks Online.


I've also added an article you can refer to make the process of reviewing your bank transactions efficient: Set up bank rules to categorize online banking transactions in QuickBooks Online.


Let me know if you require further assistance with your QBO transactions by hitting the Reply button. I'm here to help anytime. Have a nice day!

Need to get in touch?

Contact us