Answer

 Search by using keywords

Search Tips
« Back to Search Results

Using Web-Connect to import banking data

Answer ID: 2627

If automatic updates aren't working for your banking transactions for any reason, web-connect is a great temporary solution to get those transactions into QuickBooks Online. Web-connect can also be used to get more than 90 days' worth of transactions from your bank, if they offer that option (banks differ in the amount of data they let you download). QuickBooks Online can't control whether your bank lets you download more than 90 days' worth of transactions--you'll have to contact your bank and ask them how far back you can get a download, in .qbo, .ofx or .qfx format.

Web-connect can be done on any supported browser. If you are a PC user, you can download via IE, FireFox or Google Chrome.  You can download by Safari, FireFox or Google Chrome if on a Mac. 

Here are some limitations you should know about:

  • You shouldn't use web-connect and automatic update at the same time. If your automatic update is working, don't do a web-connect download because you might get duplicate transactions.
  • The maximum file size is 350 KB, which is about 3 months' worth of data. To check file size, right click the file and choose Properties; the General tab will list its size.
  • We can't download transactions with amounts that exceed 11 digits.
  • We don't support files from unsupported financial institutions. Even though you might be able to get your data into QuickBooks Online using web-connect for these banks, we don't support troubleshooting that data.
  • The data must be from one of these supported types of accounts (we don't support investment accounts):
    • Checking
    • Savings
    • Credit Card
    • Money Market
    • Line of Credit

First, find and download the web-connect file from your financial institution's website:

1. Sign in to your bank's website.

2.  Look for the ability to download data to a financial management/accounting program. If you have trouble finding this on your bank's site, you'll have to contact them directly; because these vary by financial institution, we have no way of knowing where they've located this information.

3.  Locate and download one of the following file types:

  • .qbo (QuickBooks)
  • .qfx (Quicken)
  • .ofx (MS Money, etc)

4. Save the file to your computer's desktop.  If you've ever downloaded this file before for either the desktop version of QuickBooks or Quicken, the file might attempt to auto-save to that location. If this occurs you can change the auto-open QFX files with Quicken behavior as follows:

  • Open a folder on your computer (an example would be your My Documents folder).
  • Click on the Tools menu and select Folder Options.
  • Click the File Types tab.
  • Locate and highlight the QFX Quicken or OFX data choice.
  • Click the Advanced button.
  • Place a checkmark in the Confirm open after download choice.
  • Click OK.

The steps are the same for QuickBooks desktop, except in step 4 you’ll be looking for the QuickBooks QBO file type.


If you use a Macintosh:

  1. Locate the file to download, such as the QBO or QFX file, on your banks website, Right-click on Download file.
  2. Move to Finder.
  3. Click Choose file.
  4. When pop-up comes up, choose Download and look for the export file.

Now you can upload the file to QuickBooks Online (there are 2 different ways, depending on your version):

  1. Chose Banking > Online Banking or Banking > Downloaded Transactions.
  2. On the upper right, click How do I, then select Upload (or import) my bank data or Import my WebConnect or OFX file. ** see note below
  3. Click Upload the Web Connect file to QuickBooks Online.
  4. Click Start the Web Connect mini-interview.
  5. Click the Browse button and locate the .ofx, .qfx or .qbo file you saved on your computer's desktop.
  6. Click Next.
  7. On the QuickBooks Online Account drop-down menu, select the account where you'd like to upload the transactions.
  8. Click Save.
  9. When you get the message, Your bank data has been saved, click Finish.
    Note: If you attempt to upload a file of the wrong format, a message will appear stating: The uploaded file isn't a Web-Connect file.

** If you don't see the option for "How Do I?", you have the new version of QuickBooks Online! Follow these steps to get to the interview window:

  1. Go to Transactions > Banking.
  2. Once on that page - click on the File Upload link at the top right - This will launch the interview window so you can pull your file in.

One thing to note is that if the transactions precede the opening balance that was entered into QuickBooks Online, the opening balance will change.

To see when you last did a Web Connect update:

  1. Choose Banking > Online Banking (if your menu choice is Banking > Downloaded Transactions, you'll have to check the Activity Log instead).  
  2. On the lower left go to or click on the Related Activities and Information link; within the Related Activities section click Go to Update History.
  3. Look for the most recent message with the wording, Web Connect Update.

You can also check in the Activity Log:

  1. Choose Company > Activity Log.
  2. Look for a note that says Uploaded a Web-Connect bank file to [account name].

If you encounter an error or system issue while trying web-connect:

Try a different browser. Web-connect can be done on any supported browser that can access QuickBooks Online. If you are a PC user, you can download via IE, Firefox or Google Chrome.  You can download your web-connect file via Safari, Firefox or Google Chrome if  you use a Mac. If the error or system issues still occur:

Check our knowledgebase article KB 2370, Troubleshooting web-connect errors.

Details  

« Back to Search Results
Powered By RightNow Technologies
 
Most Viewed Answers