Import Bank Transactions in QuickBooks Desktop 2020 After Sunset

Keep bank data flowing into QuickBooks Desktop 2020 after Direct Connect ended. Use Web Connect, CSV, and IIF imports to maintain your books offline.

QuickBooks Desktop 2020 officially reached the end of its supported lifecycle on May 31, 2023. When Intuit sunsets a version, one of the first services to disappear is Direct Connect—the feature that pulls transactions automatically from your bank directly into the software. Fortunately, losing live connectivity does not mean you have to upgrade. You can keep your 2020 desktop file perfectly up to date by manually importing your banking data.

Here is how to keep bank feeds flowing into QuickBooks Desktop 2020 without Intuit's live services.

Option 1: Web Connect (.QBO) Files

Web Connect is the most reliable replacement for Direct Connect. Instead of QuickBooks reaching out to your bank, you log into your bank's website, download a standard transaction file, and feed it into your software manually.

This process is identical across almost all QuickBooks Desktop versions, including 2020:

1. Log in to your bank or credit card's website.
2. Find the transaction download or export section.
3. Select a date range and choose the QuickBooks (.QBO) format.
4. Save the file to your computer.
5. Open QuickBooks 2020 and go to File > Utilities > Import > Web Connect Files.
6. Select the downloaded .QBO file and follow the prompts to map it to your existing account.

QuickBooks will bring those transactions into the Bank Feeds center, where you can match or add them just as you did when the live connection was active.

Option 2: CSV Conversion

Not all financial institutions offer .QBO downloads. If your bank only provides standard spreadsheet formats, you will need to convert those files before QuickBooks 2020 can read them.

QuickBooks Desktop natively prefers the .QBO format, meaning a standard .CSV file will not import directly through the Web Connect utility. To bridge this gap, you must use a third-party conversion tool to translate the CSV into a .QBO file. Once the conversion is complete, you simply import the newly generated .QBO file using the exact same steps outlined in Option 1 above.

Option 3: IIF Import

For advanced users, Intuit Interchange Format (.IIF) offers an alternative way to bring data into a sunsetted version. The .IIF format allows you to import actual transactions directly into your register, bypassing the Bank Feeds center entirely.

This method requires strict formatting. You can create an .IIF file from scratch in a text editor or convert your bank's CSV data into an .IIF file using conversion software. To import the file, navigate to File > Utilities > Import > IIF Files.

Because .IIF bypasses QuickBooks' built-in safety checks, it is highly unforgiving. A single formatting error can place transactions in the wrong account or disrupt your chart of accounts. If you are dealing with corrupted data resulting from a bad IIF import or a damaged company file, you may need professional QuickBooks Desktop file repair to restore your records safely.

Establish a Monthly Routine

To prevent a backlog of un-cleared transactions, replace your old automatic downloads with a strict manual schedule. On the same day each month—ideally right after your bank statement closes—log into your banking portal, download your Web Connect file, and import it.

By treating manual imports as a standard part of your monthly bookkeeping close, you ensure your QuickBooks Desktop 2020 file remains accurate and fully up to date for years to come, entirely independent of Intuit's connectivity servers.