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

Stolen Credit Card, new card in chart of accounts

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
Best answer January 08, 2019

Best Answers
Highlighted
Anonymous
Not applicable

Stolen Credit Card, new card in chart of accounts

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.

View solution in original post

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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.

View solution in original post

21 Comments
Highlighted
Anonymous
Not applicable

Stolen Credit Card, new card in chart of accounts

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.

View solution in original post

Highlighted
Level 2

Stolen Credit Card, new card in chart of accounts

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? 

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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.

View solution in original post

Highlighted
Anonymous
Not applicable

Stolen Credit Card, new card in chart of accounts

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.

Highlighted
Level 2

Stolen Credit Card, new card in chart of accounts

FritzF & BRC, 

 

You are both amazing. Such perfectly clear instructions on how to resolve this issue. So masterfully explained by you both. Thank you! 

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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!

Highlighted
Level 2

Stolen Credit Card, new card in chart of accounts

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? 

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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.


 

Highlighted
Level 2

Stolen Credit Card, new card in chart of accounts

Looks like this will not work for me since I already added all of the transactions to the accounts. 

Highlighted
Moderator

Stolen Credit Card, new card in chart of 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:

  1. From the Accountant menu, select Batch Delete/Void Transactions.
  2. Select the transactions you want to delete or void from the Available Transactions list.
  3. Select Review & Delete (or Review & Void).
  4. On the Review Batch Delete Transactions screen, you will be presented with the option to Back Up & Delete (or Back Up & Void). You can also skip this by selecting Delete only from the Back Up & Delete drop-down.
  5. On the confirmation window, select Yes to proceed.
  6. Once the transactions are deleted, you will be given the option to View Deleted Transaction Report so you can print a copy of the transactions that were deleted.

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.

Highlighted
Anonymous
Not applicable

Stolen Credit Card, new card in chart of accounts

@Zero1

 

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.

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

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? 

Highlighted
QuickBooks Team

Stolen Credit Card, new card in chart of accounts

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!

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

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.

Highlighted
QuickBooks Team

Stolen Credit Card, new card in chart of accounts

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.

  1. Go to the Accountant menu.
  2. Select Chart of Accounts.
  3. From the bottom portion, click the Account button.
  4. Select Show Inactive Accounts.
  5. Look for the account.
  6. If you want to make it active, click the X mark beside the account name.

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.

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

Thanks.  Where do I find the Accountant menu?

Best, Jay

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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.

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

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.

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

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.

Highlighted
Moderator

Stolen Credit Card, new card in chart of accounts

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:

 

  1. Open the QuickBooks program.
  2. Click the File tab at the top menu, then select Open or Restore Company.
  3. Select Restore a backup copy and then Next
  4. Select Local Backup and then Next.
  5. Browse your computer for your backup company file. It should look like this: [Your company name].qbb.
  6. Select a folder to decide where to save your restored company file. Then select Open.
  7. When you're ready, select Save. If you see any messages about possibly overwriting your data, select the option that best fits your needs.

If you don't have a backup copy, you'll need to manually delete the old transactions. You can follow these steps:

 

  1. Click the Lists tab at the top menu bar.
  2. Select Chart of Accounts.
  3. Double-click the account.
  4. Select the transaction.
  5. Press the Edit tab at the top menu.
  6. Choose Delete

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.

Highlighted
Level 1

Stolen Credit Card, new card in chart of accounts

I will try these steps. Thank you so much for your help on this.

Need to get in touch?

Contact us