Skip to main content
C
Charlottetaylor
November 14, 2022
Solved

Problem with Webconnect QBO File

  • November 14, 2022
  • 1 reply
  • 0 views

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. 

    Best answer by BigRedConsulting

    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: 

    •             Bank Feeds
    •             Import Web Connect (QBO) file
    •             “Use an existing QuickBooks account"
    •  The dropdown menu used to allow me to select “Credit Card”, but now, it only shows “Other Current Liability” options, such as Payroll Liabilities.  I believe QuickBooks sees the credit card account as associated with the “First Citizens Commercial Advantage” web platform.  We no longer use that.  We use First Citizens Digital Banking now, but I think QuickBooks associates that web platform with the payroll account only for some reason.

     

    Is there any way to change what i see in the drop down menu using QuickBooks?

     

    Thank you.


    @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.

    1 reply

    G
    GlinetteC
    November 15, 2022

    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:

     

    • The files from the bank are incomplete or in the wrong format
    • There are changes on your bank's end

     

    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:

     

    1. Sign in to your bank's website
    2. Find and download the Web Connect file (.qbo file).
    3. Open QuickBooks and your company file. Then, start importing your .qbo file.

     

    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.

    C
    CharlottetaylorAuthor
    November 15, 2022

    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?

     

     

      J
      jamespaul
      November 15, 2022

      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: 

       

      1. Go to Lists, then select Chart of Accounts.
      2. Find your credit card account, then right-click on it and select Edit Account.
      3. Go to Bank Settings.
      4. Check Deactivate all online services, then select OK.
      5. Proceed with Save & Close.

       

      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: 

       

      1. Go to the Banking menu. 
      2. Hover on Bank Feeds,then select Change Bank Feeds Mode.
      3. Select Classic mode (Register mode).
      4. Re-import your file, then check for the credit card account option. 

       

      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. 

      Terms & ConditionsAccessibility statement