Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I had a credit card that was stolen, and since I was downloading transactions from my bank using web connect, once the bank issued the new card number, QB wouldnt import those transactions to the original card in the chart of accounts.
So I created a 2nd credit card in the chart of accounts, and I have reconciled up to the last statement where the original card stops. Now on that original card account, I have and ending balance. On the new card account that I created, I have no starting balance.
Ideally, I could do a journal entry or some method of transferring the ending balance from the original card to be the beginning balance of the new card, but no idea how to do that.
What is the best way to move the ending balance from the first card that was stolen to be the beginning balance for the new card account that was created?
Solved! Go to Solution.
The best way is to merge these accounts.
When you get a replacement credit card in a case like this, you'll get a new card with a new number, but it's really tied to the same master account and continues. For example, you might see the activity for both cards on the same monthly statement. Think about how you'd handle a new debit card in the same situation, where it is tied to the same bank account. That's how CC's work as well.
So in this case, you only really need one account on your chart of accounts that represents both the old and new card, both tied to the same account at your FI.
To merge the accounts, edit the old account and rename it to match the name of the new account you set up. QB will offer to merge them. Indicate yes.
Thanks for getting back to us, @Zero1.
I appreciate you following the steps provided by @Anonymous. Allow me to step in for a moment and share some information about the warning message you get when merging two accounts in QuickBooks Desktop (QBDT).
This message means that the Bank Feeds of your old account is still active and needs to be deactivated to complete the process. Before doing so, make sure that there are no pending transactions on your Bank Feeds Center.
To deactivate Bank Feeds, here's how:
1. Go to List menu the at top, then pick Char of Accounts (or press Ctrl + A on your keyboard for the shortcut).
2. Right-click the account that needs to be deactivated and choose Edit Account.
3. Go to the Bank Feed Settings tab, then select Deactivate all online services.
4. Click OK and Save & Close.
I added some sample screenshots below for your guide.
You can also check out this article for further guidance: Deactivate Bank Feeds for an account. Once done, you may merge these two accounts. Just in case you need it, here's a helpful article with detailed steps: Merge Accounts, Customers, and Vendors.
That should do it! Please let me know how it goes or if I can be additional assistance. Don't hesitate to post again here in the Community or leave a comment in this thread if you have any follow-up questions. Have a great rest of the day.
The best way is to merge these accounts.
When you get a replacement credit card in a case like this, you'll get a new card with a new number, but it's really tied to the same master account and continues. For example, you might see the activity for both cards on the same monthly statement. Think about how you'd handle a new debit card in the same situation, where it is tied to the same bank account. That's how CC's work as well.
So in this case, you only really need one account on your chart of accounts that represents both the old and new card, both tied to the same account at your FI.
To merge the accounts, edit the old account and rename it to match the name of the new account you set up. QB will offer to merge them. Indicate yes.
Good morning BRC. Thank you for the reply.
When I followed the instructions you gave, I get a Warning message that says 'You cannot Merge two accounts which both contain online information.'
Any suggestions?
Thanks for getting back to us, @Zero1.
I appreciate you following the steps provided by @Anonymous. Allow me to step in for a moment and share some information about the warning message you get when merging two accounts in QuickBooks Desktop (QBDT).
This message means that the Bank Feeds of your old account is still active and needs to be deactivated to complete the process. Before doing so, make sure that there are no pending transactions on your Bank Feeds Center.
To deactivate Bank Feeds, here's how:
1. Go to List menu the at top, then pick Char of Accounts (or press Ctrl + A on your keyboard for the shortcut).
2. Right-click the account that needs to be deactivated and choose Edit Account.
3. Go to the Bank Feed Settings tab, then select Deactivate all online services.
4. Click OK and Save & Close.
I added some sample screenshots below for your guide.
You can also check out this article for further guidance: Deactivate Bank Feeds for an account. Once done, you may merge these two accounts. Just in case you need it, here's a helpful article with detailed steps: Merge Accounts, Customers, and Vendors.
That should do it! Please let me know how it goes or if I can be additional assistance. Don't hesitate to post again here in the Community or leave a comment in this thread if you have any follow-up questions. Have a great rest of the day.
RE: When I followed the instructions you gave, I get a Warning message that says 'You cannot Merge two accounts which both contain online information.'
In that case I think if you edit the old account and remove the online banking setup from it, then you can merge.
FritzF & BRC,
You are both amazing. Such perfectly clear instructions on how to resolve this issue. So masterfully explained by you both. Thank you!
You're welcome, @Zero1.
I'm glad to know that you're able to successfully merge your old and new credit card account.
Also, thanks for being a part of our QuickBooks family. Feel free to post again should you have any other concerns. Take care and wishing you and your business continued success!
Hi again.
One thing I realize now is that 2 of the account I 'merged' have duplicate transactions in the merged account now. I restored back to version before I merged, and trying to find a solution.
Short story is that the card was stolen twice, resulting in 3 accounts that needed to be merged. The account for the 2nd and 3rd card account had a few months of the same transactions when I downloaded them.
I tried to delete one of the accounts, but I get a message saying that 'I cant delete the account because it has a balance, or was used in at least one transaction.'
Is there a way to avoid having to manually go through and delete the duplicate transactions?
Hi again, @Zero1.
It's nice to see you again here in the Community. I can share some information about deleting duplicate transactions in QuickBooks Desktop (QBDT).
Currently, QBDT doesn't have the option to delete the duplicate credit card transactions in your Bank Feeds by the batch. You need to do this manually before deactivating the account they're associated with.
Here's how:
1. Go to Banking menu at the top, then pick Bank Feeds and Bank Feeds Center.
2. Choose the statement from Items Received From Financial Institution and choose View.
3. Match the transactions and select Done, then click Yes in the Not Finished Matching screen.
4. Select the same statement from the Items Received From Financial Institution and Delete.
For your reference, you can check out this article for further guidance: Remove duplicate transactions. Once done, you can go ahead and deactivate the Bank Feeds for that account. Just in case you need it, you may refer to this article for the detailed steps: Deactivate Bank Feeds for an account.
If you wish for this option to be added, I encourage you to submit a feedback to our Product Development Team for review when determining features to be added in updates. Intuit values your request and product suggestions so we know how this feature can help your company and improve the way you manage your transactions. Here's how to send feedback:
1. At the top menu bar, go to Help, then pick Send Feedback Online.
2. Enter your request/product suggestion, then select Next.
3. Click Skip and send a message, and choose Feedback as the Category.
That's it! Should you need further assistance, please let me know so I can get back to you right away. Have a great day.
Looks like this will not work for me since I already added all of the transactions to the accounts.
Hi there, Zero1.
Let me share some insight about your concern.
Since you've already added all transactions to those accounts, you'll need to manually delete those transactions from the account. However, if you're using QuickBooks Desktop Accountant or Enterprise version, you'll have the option to delete those transaction by batch to save time.
Before doing this, make sure your QuickBooks is on a single-user mode. You can do this by going to the File menu and click Switch to Single-user mode.
Once done, you can follow the steps below:
I'll leave you with an article to learn more about deleting transactions by batch in QuickBooks: Delete transactions by batch using Batch Delete/Void Transactions.
Should there'll be anything else you need or questions feel free to reach us back. It's always our pleasure to help you out.
RE: "One thing I realize now is that 2 of the account I 'merged' have duplicate transactions in the merged account now. I restored back to version before I merged, and trying to find a solution. "
In this case, you need to delete the duplicates, whether or not you merge the accounts. This is because the duplicates are incorrectly increasing your expenses. Each charge should only be represented in QB once.
How do I do this with QB online?
Do I set up a new credit card accont first, then edit the old account and will get a merge prompt?
Hi davidwwaddell!
No need to merge, just disconnect and reconnect your credit card account.
I've already answered this question in another thread. Please check it out using this link: https://intuit.me/2XvLKkH.
Have a nice day!
Hi,
I have a different issue with a replacement credit card from the bank with a new number. I am using QB Premier Edition 2019 desktop. I was manually loading transactions before QB 2019 for over 10 years for my Wells Fargo Business Visa card. Wells Fargo issued me a new card #33 after a fraudulent charge on my credit card #48. The new #33 card went into effect 10/21/2019. I had reconciled the account #48 through August 2019 and made a backup. The bank feed now recognizes #33, but no longer shows #48. I just went into reconcile for year end and there are no purchase transactions before 10/21/2019 and no payment/credits listed before 2/1/2019 at which the account balance is $0. The old #48 account no longer exists in my chart of accounts and a search of the exact name yields no results. What happened? Do I need to manually input all of my previous transactions for 2019? Please help.
Welcome to Community @Jay57,
The reason that you cannot see the #48 account, is when the account is already inactive. Let me help you locating the inactive account. Follow these steps.
If it's not showing, it might be deleted. However, restore your back-up from 10/21/2019 and manually enter the unrecorded transaction.
In case you need help fixing your beginning balance before reconciling your account, refer to this link: Fix beginning balance issues in QuickBooks Desktop.
I've also added QuickBooks Desktop Help Article for more information about reconciliation.
Just let me know if you have additional concerns. I'm always here to help.
Thanks. Where do I find the Accountant menu?
Best, Jay
Hello there, Jay57,
I'll provide a screenshot on the steps provided by my colleague above. The Accountant menu is located at the top of your QuickBooks Desktop account.
Please let me know if you need further assistance.
Thanks.
I do not have that tab. I did find the file as an inactive account though and clicked the "X" which restored it to active. Thanks for your help.
I did merge the accounts as per above and but i see all the old transaction also under new account which seem to be wrong. Is there a way to fix it? Can I undo the merge. Please assist.
Hi there, @saakshi1.
Welcome to the Community. Let me share what I know about merging accounts in QuickBooks.
Performing the process combines the transactions from both accounts. You can only undo the merge if you created a backup copy before consolidating the data.
To restore a backup company file:
If you don't have a backup copy, you'll need to manually delete the old transactions. You can follow these steps:
For additional reference, I've attached a link you can use to learn more about the chart of accounts in QuickBooks: Understand the chart of accounts in QuickBooks.
Drop me a comment below if you have any other questions. I'll be happy to help you some more.
I will try these steps. Thank you so much for your help on this.
My wallet was misplaced, and I wish to lock the old one down and have it replaced with a new one.
I'm currently living at a new address
4564 Ficus Tree Rd Kissimmee, FL 34758
Hope you'll get your wallet back, mortal kombat character.
You can call your bank to report what happened. Then, if they'll give you a new card, you can create a new credit card account in your Chart of Accounts. If the old one is connected to bank feeds, you can disconnect it and connect the new one.
If you have a payroll subscription and the old card is used for it, you can update it in the Customer Account Management Portal (CAMPs).
Let me know if you have other questions in mind.
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