Import data into QuickBooks Desktop (Web Connect)

Download the transactions as a QuickBooks Web Connect File

To export the data as a QuickBooks (Web Connect) file that can be imported directly into QuickBooks Desktop follow these steps:

  • Login to DocuClipper
  • Click on "Extract Data" (top left)
  • Click on "Bank Statements"
  • Search for your bank
  • Drop one or more PDFs
  • When the data extraction is finished, click on "Download QuickBooks (Web Connect)".
  • Select the account type: "Bank" or "Credit Card".
  • Enter the routing number.
  • Enter the account number.
  • Enter the year.
  • Click on "Download QuickBooks Web Connect".
  • A QuickBooks Web Connect file will be downloaded to your "Downloads" folder.

Importing the Web Connect file into QuickBooks Desktop

Once you have the Web Connect file follow these steps to import the transactions into QuickBooks Desktop.

Before importing, make sure that the account you need to import into doesn’t have the yellow strike icon. Click 'Lists' - 'Charts of Accounts'.

Import Web Connect QuickBooks Desktop 1

If you have the icon, it means the account is online linked to direct download. You need to disconnect first to import a Web Connect file.

Import Web Connect QuickBooks Desktop 2

To disconnect, right-click - 'Edit Account'.

Import Web Connect QuickBooks Desktop 3

Then click on 'Bank Feed Settings' and 'Deactivate All Online Services' first if needed. Check there is no yellow icon after the change. After disconnecting the account from online services, you can import a Web Connect file.

Import Web Connect QuickBooks Desktop 4

To import a Web Connect file, select 'File' - 'Utilities' - 'Import' - 'Web Connect Files', select created Web Connect file.

Import Web Connect QuickBooks Desktop 5

And select an existing account to import transactions. Check bank label, Account Type, Account number to select the correct Account in QuickBooks. Then click the 'Continue' button.

Import Web Connect QuickBooks Desktop 6

Now your data is imported.

Import Web Connect QuickBooks Desktop 7

Click on 'Transaction List' to review transactions. Assign Vendor Records and expense/income accounts before adding transactions to the register.

Import Web Connect QuickBooks Desktop 8

'Downloaded as' column shows Payee names from the Web Connect file. And the 'Payee' column is empty. It shows Vendor Records. When you choose a Vendor Record, for the Payee from the Web Connect file, QuickBooks will remember your choice for the next Web Connect import.

Import Web Connect QuickBooks Desktop 9

Click 'Show Bank Memo' to see the description to the 'Bank Memo' column.

Import Web Connect QuickBooks Desktop 11

Once Vendor Records and Account are set, you can add transactions to the register. The rename rule creation dialog will show up after to use for the next time.

Import Web Connect QuickBooks Desktop 11

Handling import errors

Unable to verify the financial institution

If you get the error "QuickBooks is unable to verify the Financial Institution information for this download" follow these steps:

  • Open the Web Connect file with a text edit (e.g. Notepad)

  • Replace FID and INTU.BID numbers with the right bank number from this list. E.g. for Wells Fargo the number is 3000:

    • <FID>03000</FID>
    • <INTU.BID>03000</INTU.BID>
  • If the bank has multiple entries, select the one that says "WebConnect".
  • If the import is successful Email support so we can fix the number permanently.

When importing, QuickBooks doesn't show an existing account

When importing, if QuickBooks doesn't show an existing account, make sure you enter the right Routing and Account numbers when downloading the Web Connect file: QuickBooks does not show an existing account Routing and account numbers

Here's a video with more information on Web Connect files and how to import them into QuickBooks: