cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

importing qbo files

I have a credit card account in QuickBooks. The credit card company had to change the number. As a result, it's two credit card accounts in QuickBooks - the old and the new one.  Now after I convert a credit card statement into a qbo file, and import it to Quickbook, it goes into the old account instead of the new one. And if I make the old account inactive, QuickBooks still does not import the file into the new account but asks me to create a another account. Does anyone know how to fix this?   

Solved
Best answer 08-19-2019

Accepted Solutions
Experienced Member

Re: importing qbo files

Hi Precious B,

I had planned to log back here tonight to provide an update. I tried your suggestion this morning. And it worked. Thanks so much. That was a very frustrating problem for the past few weeks, and I had racked my brain on how to fixt it. You were a great help.  

6 Comments
Moderator

Re: importing qbo files

Hi Dac43,

 

I can provide the steps to help you import your bank transactions to the correct credit card account.

 

When you update credit card numbers, you'll need make sure to disable the online service for the old account. This way you can enable Bank Feeds and download bank items to the new account. Please be reminded that this process does not cancel your services with the bank.

 

Follow these steps to deactivate Bank Feeds:

  1. Go to the Lists menu.
  2. Choose Chart of Accounts.
  3. Right-click on the account you're deactivating then click Edit Account.
  4. Go to the Bank Feed Settings tab.
  5. Select Deactivate all online services.
  6. Choose OK.
  7. Select Save & Close.

You can also find these steps in this article: Deactivate Bank Feeds for an account.

 

Once done, you can now set up online banking for the new account. Doing this will help you pull up the most current data from the bank server during re-setup. Check out this article for the complete instructions: Set up an account for Bank Feeds.

 

Please let me know if there's anything you need help. I'll be glad to work with you whenever you needed me. Have a great day!

Experienced Member

Re: importing qbo files

Hi Jen,

Thanks for your reply. I did what you said. I had actually tried that as well before, but it did not resolve the situation. When I am importing the qbo file to the credit card account in QuickBooks, it gives me the option of using an existing account or create a new one. When I click on existing account, the drop down box is empty. It's as if the credit card register does not exist. And I do not want to create a new account because I have at least five years of transactions in the existing account that I want to continue with. 

Moderator

Re: importing qbo files

Thanks for getting back to us here in the Community, Dac43.

 

It's unusual for the system to let you use an empty account.

 

Since QuickBooks asked you to enter a new one, you can set up a test account and merge it to your original account. All transactions, including reconciled ones, will be merged under the account you keep.

 

This process helps us determine if the original account is corrupted.

 

Here's how:

  1. Go to Lists at the top menu bar, and select Chart of Accounts from the drop-down.
  2. Right-click anywhere, and select New.
  3. Tick the radio button for Bank and click Continue.
  4. Enter the correct bank's name in the Account Name field and hit Save and Close.
  5. Right-click the old account, then rename it to the correct bank's name.
  6. Click Save and Close
  7. Choose Yes when you get the prompt to merge the accounts.

Don't worry about merging accounts since it will not remove your previous reconciliations. This is because the test account doesn't have any transactions in it. We simply merged the bank account information and previous transactions.

 

For the complete details of the online banking feature in QuickBooks Desktop, check out this article: Get started with Bank Feeds for QuickBooks Desktop.

 

Please leave a reply if you have other questions. I'm here to help anytime.

Experienced Member

Re: importing qbo files

Hi Precious B,

I had planned to log back here tonight to provide an update. I tried your suggestion this morning. And it worked. Thanks so much. That was a very frustrating problem for the past few weeks, and I had racked my brain on how to fixt it. You were a great help.  

Experienced Member

Re: importing qbo files

Hi Precious B,

I had planned to log back here tonight to provide an update. I tried your suggestion this morning. And it worked. Thanks so much. This had been a very frustrating problem the past few weeks. I had racked my brain on how to fix it until I remember about this QuickBooks online community. Thanks a lot for your help. 

Moderator

Re: importing qbo files

You're welcome, Dac43.

 

I'm happy you've successfully imported the bank transactions into QuickBooks Desktop.

 

It's my pleasure to help you, so please come back to the Community if you have other questions in the future. Take care.