Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am running QuickBooks Desktop Premier Plus Contractor Edition 2022. I import my company's credit card charges into my Bank Feeds via a webconnect file (QBO). This feature suddenly stopped working. When I import the QBO File, I select “Use an existing QuickBooks account” like before, but now the account (Credit Card) is not listed; instead, only my payroll accounts are listed. The only way I can import the charges is if I set up a new credit card account and import them there, but then I have to manually move each individual charge back over to the original credit card account, which takes hours. This happened in the past, and it was a QuickBooks problem, not a banking problem. I was forced to upgrade my QuickBooks to solve it. My QuickBooks is up to date, and I spent hours on the phone with support to no avail. How do I fix this issue? Extremely frustrating.
Solved! Go to Solution.
@Charlottetaylor RE: The dropdown menu used to allow me to select “Credit Card”, but now, it only shows “Other Current Liability” options, such as Payroll Liabilities.
This is the key bit if info that reveals what is wrong. For some reason, your credit card provider has written the file incorrectly and is writing it not as a credit card file but as credit line account, like a loan you've taken out. While a credit card balance is sort of a loan, that change will cause only liability accounts to appear as an option when you try to import the *.QBO file.
You can verify this is the case by opening the QBO file in Notepad or any word processor
If you search the file and you see "<ACCTTYPE>CREDITLINE", then it is the wrong type of file for a credit card.
If that's the case, you'll need to convince your credit card provider to create the correct file for a credit card.
If they won't, you can use a tool that will transform the credit line file to a credit card file, like our BRC OFX Cleaner and then import the file into QuickBooks.
I'm here to ensure you can import your .qbo file successfully,
Charlottetaylor.
There are a few factors why issues when importing a .qbo file occur:
Before doing a fix, you'll have to create a backup copy of your company file first, then ensure you have the latest QuickBooks Desktop version installed to have the latest features and fixes.
Once done, download your Web Connect file directly from your bank, not from inside QuickBooks. This is to ensure you'll download the appropriate file. Here's how:
To learn more about how to fix web connect import issues, check this article: Fix Web Connect import errors.
Keep me updated with additional info on this issue. I want to ensure everything is taken care of for you.
Thanks, but I've tried this several times. It does not work. When I import the Web Connect File (QBO), I am asked to choose the QuickBooks account into where I would like to import the transactions. I am given a drop down menu that used to display the credit card account, which was correct. Now, the drop down menu only displays "other current liability" accounts, which is incorrect. How can I make that menu go back to displaying the credit card account, so I can import the charges?
Hello, Charlottetaylor.
I can only imagine the frustration you've felt after knowing the feature you rely on no longer works. I appreciate your time in acknowledging my colleague's reply and taking this issue with our support agents.
I'd like to drop a couple of solutions that can help us see the credit card account option again when importing the .QBO file.
The support person may have missed this during your call, but have you tried doing the solutions outline in the article given by GlinetteC? If not, we can do the following steps to fix this.
There may be some damaged component within the Bank Feeds, which is why we're unable to see the option for your existing credit card. Turning it off and on can help fix this issue.
Before doing this, make sure to add and match all of the existing transactions. Turning off the Bank Feeds will remove unmatched or unreviewed records.
After matching your transactions, let's follow these steps to turn off the feeds:
I'll also add that even if you're not using the Direct Feeds (automatic download), the Web Connect version will always turn on the Bank Feeds feature for your accounts.
Another thing to try is to toggle the Bank Feeds mode to Classic. This can also help rule out any issues related to the current feed mode. To toggle it:
We have an article series that talks about the Bank Feeds in QuickBooks. Check the documents out if you need a refresher: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop.
Speaking of bank transactions, do you need to reconcile your credit card or other bank accounts after categorizing those transactions? I'll add this article in case you need help in the future: Reconcile an account in QuickBooks Desktop.
I'm up and ready to help you out again if you have more questions about managing your bank feeds within QuickBooks. Drop the details below if you also have concerns related to your entries, reports, and more. I'll see you again soon.
Thank you. I've tried your steps as well. They did not solve the problem, but they helped me understand a few issues that may help in the future.
When I try to import the file I do the following:
Is there any way to change what i see in the drop down menu using QuickBooks?
Thank you.
Hey, @Charlottetaylor.
Thanks for reaching back on this thread. Let's work together to figure out why this is happening in your QuickBooks Desktop account.
To clarify, is the account still listed under your chart of accounts at this time?
This will help me determine a few details on my mind and lead us in the direction we need to go to get this resolved. I look forward to seeing your response!
I'm having the same problem.
For clarity,
1. My Amex account is active in the chart of accounts
2. It is not set up in the bank feed to automatically pull transactions
3. I downloaded the QBO file from my Amex portal
4. I'm trying to import the file into my Quickbooks Desktop, but the dropdown box for existing accounts is not showing any existing account
Is this a bug in the system, and how do I fix it? Does have anything to do with user rights?
Thanks for providing clarification of your concern, UPAcct. I'm here to help you import your bank transactions successfully into QuickBooks Desktop.
Since your bank is not yet connected to QuickBooks Desktop we need to import your bank transactions manually, since importing your bank transactions into QuickBooks Desktop using a CSV file is not yet available. Excel/CSV files can only be used when importing customers, vendors, and item lists.
Here's how to connect your Amex account with QuickBooks:
On the other hand, follow the steps below to import your bank transactions to QuickBooks if your financial institution supports WebConnect (.QBO) file:
Here's how:
You may refer to these articles for more information:
Stay in touch with us here in the Community if you have other questions about recording your bank transactions in QuickBooks. I'm always here to answer your inquiries.
I clearly stated that I tried uploading a qbo file--exactly how you described. The issue is within the Desktop importing function; it is not seeing or displaying the existing accounts currently active on our chart of accounts.
What is causing this and how can I fix it?
We're sorry to hear about your experience and didn't meet your expectations. Let's ensure your existing accounts will show up on your chart of accounts, UPAcct.
As mentioned by @GlinetteC, some of the major reasons why you encounter issues with importing it's because the files from the bank are incomplete or in the wrong format and there are some changes on your bank's end
Typically, the steps provided by the previous representative will successfully work when trying to upload transactions to QuickBooks Desktop. You'll only have to make sure to update QuickBooks to the latest release to see the existing accounts on your end.
However, if you're still experiencing the same issue, I suggest contacting our support team so they can take a look at this further. They have the tools to pull up your account in a secure environment and will have a chance to have one-to-one interactions with one of our representatives. Here's how to reach them:
Moreover, to provide you with more transparency to your data, take a look at this article for more details: Customize Reports In QuickBooks Desktop.
Drop me a line in case you need additional assistance when importing data. I'd be happy to help you. Have a great day ahead!
@Charlottetaylor RE: The dropdown menu used to allow me to select “Credit Card”, but now, it only shows “Other Current Liability” options, such as Payroll Liabilities.
This is the key bit if info that reveals what is wrong. For some reason, your credit card provider has written the file incorrectly and is writing it not as a credit card file but as credit line account, like a loan you've taken out. While a credit card balance is sort of a loan, that change will cause only liability accounts to appear as an option when you try to import the *.QBO file.
You can verify this is the case by opening the QBO file in Notepad or any word processor
If you search the file and you see "<ACCTTYPE>CREDITLINE", then it is the wrong type of file for a credit card.
If that's the case, you'll need to convince your credit card provider to create the correct file for a credit card.
If they won't, you can use a tool that will transform the credit line file to a credit card file, like our BRC OFX Cleaner and then import the file into QuickBooks.
Don't waste money on this "cleaning" tool.
The real solution is that your bank most likely changed the account ID on you. Here's what you need to do:
1. Find an old .QBO file that you know was imported successfully.
2. Open the good file in a text editor like TextMate (mac) or Notepad
3. Now open the problem file in another TextMate window.
4. Find <ACCTID> in both files. Most likely, they are different.
5. Simply copy the value for <ACCTID> from the good file, and replace that value in the problem file.
6. Save the problem file and try to import it again.
This worked for me, and I didn't see anyone else post this solution. Most likely it will fix your problem.
You're awesome. This worked for me as well, thank you. Simple as changing the <ACCTID> to the correct credit card number and it worked again.
I have been struggling with this issue for months and have been putting off manually entering two months' worth of transactions into a register from last fall in order to get a credit card account into a state where I can reconcile it. This is so enticing and I can't wait to check it out and see if it's the answer. I'll come back and let you know if it solved my problem. THANK YOU!
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