QuickBooks Desktop can be quite restrictive on the acceptable file types to import bank statement data as bank transactions, However, our QuickBooks Web Connect File type allows you to get your captured Bank Data files from AutoEntry into QuickBooks Desktop in bulk.
📎NOTE: As of March 2020, you can't import statement data if you use QuickBooks Desktop 2017 (all) versions or older.
Download bank statement file
When the extraction is completed by AutoEntry when you download the bank statement simply use the Quickbooks Desktop - Web Connect File (.qbo) option.
AutoEntry pre-populates the following fields for you using default Bank ID and INTU.BID numbers.
Account Number
Account Number
As the Account Number is visible, AutoEntry captures it and it appears by default here. If not you should enter the unique Account Number for this account as QuickBooks Desktop recognises it for future imports.
📎NOTE: 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. Make sure this number is unique per Bank Account even if you don't use the true number.
Account Type
Account Type
Choose the most appropriate Account Type from the drop-down.
Currency
Currency
Currently USD is the only supported currency.
Bank ID
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
INTU.BID
We mentioned earlier that we mimic a Bank Feed to make this Bank Data import. This means 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 makes no difference in getting the data into QuickBooks Desktop except that you will have a Wells Fargo logo associated with it.
📎NOTE: See below if you receive an error that QuickBooks can't verify the institution details.
Generally you can just cast your eyes over the above fields before you click Download, but do make sure the Account Number is captured and, if not, at least that it's unique.
Import into QuickBooks Desktop
Next, import the data to QuickBooks Desktop:
📎NOTE: If you're 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.
If this is the first time you've imported a .qbo file for this Bank Account you're presented with the following pop-up.
Choose from an existing Bank Account already in your Chart of Accounts or create a new Bank Account.
Click Continue. You should be redirected to the Bank Feeds Center with all your transactions available to view for that Bank Account.
📎NOTE: Do you get the following error?
QuickBooks is unable to verify the Financial Institution information for this download
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.