Skip to main content
R
RikiTikiTavi3
June 9, 2020
Question

I have quickbooks mac desktop and web connect and wells fargo bank are not working,

  • June 9, 2020
  • 1 reply
  • 0 views

I have just purchased quickbooks mac desktop and web connect and wells fargo bank are not working, I can not download and import transactions.  Quickbooks keeps saying to setup the online banking-  I have too many times to count.  What's the deal?  Why don't these work? And from what I am reading while researching for help, these problems are old.  Is there a way to download transactions with web connect and wells fargo that does work?  Wells Fargo is my main bank and I have a ton of transactions.  I wanted a helpful automated solution NOT more work and wasted time.  Very disappointed with this service.

    1 reply

    R
    RaymondJayO
    June 9, 2020

    Welcome to the Community, @RikiTikiTavi3. I can see the need to get your banking issue resolved immediately. With this, yes, there's a way to download transactions with Web Connect and Wells Fargo that does work. 

     

    I've read the error message you've mentioned above. It looks like you haven't completely set up the online banking in the program. Also, the file type may not be .qbo since this is our supported format when importing bank transactions. That may be the reason you're unable to import them.

     

    First, I'd suggest setting up online banking in QuickBooks Desktop (QBDT) for Mac. This way, you'll be able to import your Wells Fargo transactions to the software through Web Connect. I'll guide you how. 

    1. Go to Banking from the top menu.
    2. Select Online Banking Setup. 
    3. Enter Wells Fargo in the Search field. 
    4. Depending on your bank, you may be presented with options for Direct Connect/Web Connect or Web Connect only.
    5. You can choose which bank accounts you can add to the program on the Link your Accounts screen. 

     

    Second, you'll have to download a statement from your bank's Web Connect site using a .qbo file. Then, import it to QBDT for Mac. It helps you complete the setup process. Here's how: 

    1. Choose Website.
    2. Locate the download area for your account.
    3. Download a statement to your computer.
    4. Open the Downloaded Transactions window from the Banking menu. 
    5. Click the Import File icon to import your statement.
    6. For each downloaded account, choose a matching QuickBooks account from the Store in the QuickBooks Account menu.
    7. Hit Continue.
    8. Select OK after QuickBooks finished importing transactions.

     

    For the detailed instructions, see this article's Set up the account section: Set Up And Use Online Banking (Mac). 

     

    Once imported, I recommend adding your Wells Fargo transactions and creating renaming rules. You can also match them to the existing entries in your register. Doing so will help ensure your financial records are accurate in the software. For more information, view the Add and match transactions section through the article I've provided above. 

     

    Also, you can visit this website: Fix Online Banking. It provides you the recommended solutions to help you resolve any online banking issues. 

     

    Please know that you can count on me if there's anything else you need. Keep safe always, @RikiTikiTavi3.

    R
    RikiTikiTavi3Author
    June 13, 2020

    This does NOT fix the problem.  I am stuck in a setup banking loop.  As I have said before - I have done this setup many, many times and it does not work.  It does not upload the Well Fargo document and so it sends me back to the setup online banking.  Wells Fargo downloads a qfx file.  Apparently this is not the correct file.  How do I get the correct file?

     

    R
    RaymondJayO
    June 13, 2020

    Thank you for providing me the exact file type Wells Fargo uses, @RikiTikiTavi3. It helps me determine the root cause of this issue. Rest assured that I've got the steps to help you get the correct file. This way, you'll be able to bring in your transactions to the software. 

     

    Right now, the supported format when importing bank transactions to QBDT for Mac is .qbo file. I'd first recommend converting the .qfx file into that type to help you complete the Web Connect process. I'll guide you how. 

    1. Open the .qfx file in a text editor like Notepad.
    2. Locate the Intuit Bank ID label near the top of the code: <INTU.BID> with a number after it.
    3. Change the number after <INTU.BID> to a code used by a financial institution that is supported by Intuit. 
    4. Save the file as .qbo.

     

    Also, you can open your Safari browser. Then, enter Convert .qfx file to .qbo as the keyword in the Search box. You'll be able to see a lot of websites that provide you steps about the file conversion process.

     

    Once converted, import the file again using the second batch of steps I've provided above. 

     

    I suggest adding your bank transactions or matching them to the existing entries in your register. It helps you ensure the accuracy of your financial records in the program. Just go to the Downloaded Transactions window from the Banking menu to perform this activity. 

     

    You can always check out Chapter 7 through this PDF article: QuickBooks for Mac 2020 User Guide. From there, you'll learn more about managing your bank-related tasks in the software.

     

    I'll lend a helping hand if you need further assistance. Take care always, @RikiTikiTavi3.

    Terms & ConditionsAccessibility statement