how to import csv file into quickbooks desktop 2020

It is possible to open the downloaded qbo file and modify the INTU.BID or FID number to match another bank. This meant that if the institutions did not purchase the license, they would not be able to import the data unless someone manually modified the file.įortunately, there are a couple ways to work around this and be able to import files from any institution.

During the registration process, the financial institution had to purchase a license to be included as a supported institution. When Intuit first started importing transactions into their platforms, they required every financial institution to register their bank.

You will receive the following popup on the screen. If the file does not have a valid INTU.BID number, The part of the story that most people are not familiar with was the registration requirements that Intuit placed on financial institutions that wanted their customers to be able to import their financial data. Initially known as QFX, Intuit developed their own proprietary file format which limited the import capabilities for both their Quicken and QuickBooks products. Somewhere along the journey from the old green sheets, toward the automated accounting solutions of tomorrow, a group of corporations (Microsoft, Intuit, and CheckFree) banded together to define a new industry standard for the transfer of financial information. Ever since Intuit first introduced the idea back in 1997, bank feeds have been both a powerful and annoying feature at the same time.

How to import csv file into quickbooks desktop 2020