While QuickBooks Desktop is quite restrictive on the acceptable file types for importing bank statement data as bank transactions, we've used the QuickBooks Web Connect File type that allows you to get your captured bank data files from AutoEntry into QuickBooks Desktop in bulk. Please Note: As of March 2020, importing statement data is not possible for users of QuickBooks Desktop 2017 (all) versions or older.
When the extraction is completed by AutoEntry simply use the QuickBooks option to download your statement data. To do this go to the relevant bank account, click Download and select the option: QBD - Web Connect File (.qbo)
AutoEntry pre-populates the following fields for you using default Bank ID and INTU.BID numbers:
- Account Number: So long as the account number is visible, AutoEntry will capture it and it will appear by default here. If not you should enter the unique account number for this account as QuickBooks Desktop will recognise it for future imports (if you decided to use a fake generic number on two separate accounts this will cause you issues as the data may merge into the wrong account automatically - so make sure this number is unique per bank account even if you don't use the true number).
- Account Type: Choose the most appropriate account type from the dropdown.
- Currency: Currently USD is the only supported currency.
- Bank id: This is the bank's routing number - if you have it you should enter it but the default zeros '000000000' is fine.
- INTU.BID: We mentioned earlier that we mimic a bank feed in order to make this bank data import and as such we need to include a recognised Intuit Bank ID for it to be accepted by QuickBooks Desktop. In this case we've used a common bank ID for Wells Fargo Bank (03000). If you know the INTU.BID of your own bank you can enter it here. Using the Wells Fargo default will make no difference in getting the data into QuickBooks Desktop except that you will have a Wells Fargo logo associated with it. See below if you receive an error that QuickBooks cannot verify the institution details.
Generally you can just cast your eyes over the above fields before clicking Download, but do make sure the Account Number is captured and, if not, at least that it's unique.
Next, import the data to QuickBooks Desktop as follows...
*Note: If you are looking to import statement data to an account that is already connected to a bank feed, you will need to disconnect the bank feed first.
In QuickBooks Desktop, go to: File > Utilities > Import > Web Connect Files
Once selected, and assuming it's the first time you've imported a .qbo file for this bank account (i.e. the combination is not recognised by QuickBooks Desktop from a prior import), then you'll be presented with the following pop up:
Now you can choose from an existing bank account already in your chart of accounts or create a new bank account.
Hit Continue and that's it - you should be redirected to the Bank Feeds Center with all your transactions available to view for that bank account...
If an error occurs that "QuickBooks is unable to verify the Financial Institution information for this download", please download the file again but use the default Bank ID and INTU.BID numbers. The file will import as normal. The only difference is that the account will appear in QuickBooks as a Wells Fargo account. As there are over 100,000 BID codes on Intuits' systems, it can be very difficult to ascertain if you have the correct code for your bank. The defaults for Wells Fargo (03000) will always work.
And that's it! Do let us know below if this article was helpful.