Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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).
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.
Now, you can reconnect the account with the new credit card number. Here's how:
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.
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?
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here