To export the data as a QuickBooks (Web Connect) file that can be imported directly into QuickBooks Desktop follow these steps:
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'.
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.
To disconnect, right-click - 'Edit Account'.
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.
To import a Web Connect file, select 'File' - 'Utilities' - 'Import' - 'Web Connect Files', select created Web Connect file.
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.
Now your data is imported.
Click on 'Transaction List' to review transactions. Assign Vendor Records and expense/income accounts before adding transactions to the register.
'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.
Click 'Show Bank Memo' to see the description to the 'Bank Memo' column.
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.
If you get the error "QuickBooks is unable to verify the Financial Institution information for this download" follow these steps:
Replace FID and INTU.BID numbers with the right bank number from this list. E.g. for Wells Fargo the number is 3000:
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:
Here's a video with more information on Web Connect files and how to import them into QuickBooks:
If you have a question, please contact support.