Import Bank Transactions Into QuickBooks Desktop 2017 After Sunset

Keep bank data flowing into QuickBooks Desktop 2017 after Direct Connect ended. Use Web Connect, CSV conversion, and IIF imports with a monthly routine.

If you are still running QuickBooks Desktop 2017, you are managing a perfectly capable accounting system past its official May 31, 2020 sunset date. Because Intuit discontinued live services for this version, active bank feeds via Direct Connect eventually stop working. Fortunately, you do not need Intuit's live connection to keep your accounts reconciled. Here is how to keep your bank and credit card data flowing into your 2017 company file manually.

Web Connect (.QBO) Files

Web Connect is the most reliable direct replacement for live bank feeds. Instead of having QuickBooks reach out to your bank, you log into your bank's website, download a file, and import it. QuickBooks 2017 reads the standard .qbo format natively.

1. Log into your financial institution's website and locate the transaction download or export section.
2. Select the desired account and date range.
3. Choose the QuickBooks ( .qbo) format if available, or the Web Connect option.
4. Save the file to your computer.
5. In QuickBooks Desktop 2017, go to File, then Utilities, then Import, and select Web Connect Files.
6. Browse to the downloaded .qbo file and open it.
7. QuickBooks will prompt you to map the file to the correct existing account or create a new one.

Once mapped, the transactions will drop directly into your Bank Feeds center, where you can add or match them just as you did when the live connection was active.

CSV Conversion

Many banks and credit card companies do not offer .qbo files for standard checking accounts, or they try to charge an extra monthly fee for Direct Connect access. If your bank only allows you to download standard .csv (comma-separated values) or Excel files, you cannot import that directly into QuickBooks Desktop. You must convert it first.

To bridge this gap, you can use a reliable third-party utility to translate your bank's CSV file into a QuickBooks-compatible format. If you need to convert raw spreadsheet data into a usable format, downgradeo.com provides tools for formatting and converting CSV files into .qbo or .iif files that QuickBooks 2017 can read. Once the file is converted to .qbo, you simply import it using the standard Web Connect steps above.

IIF Importing

The Intuit Interchange Format (.iif) is an older, text-based format that QuickBooks Desktop still supports. Importing an .iif file bypasses the Bank Feeds center entirely and writes transactions directly into your account registers.

While powerful, .iif imports require strict formatting. If a column is out of place, the import will fail or create unbalanced entries. You can create .iif files from scratch using a spreadsheet editor, or convert your bank's CSV files into .iif using formatting software.

To import an .iif file in QuickBooks 2017, go to File, select Utilities, then Import, and choose IIF Files. Because this method writes directly to the register, we recommend reconciling your accounts immediately after an .iif import to verify that the data posted correctly.

A Simple Monthly Routine

To prevent a backlog of unentered transactions and keep your 2017 company file accurate without live feeds, establish a repeating monthly workflow:

1. Pick a consistent date: Choose a day a few days after your bank statement closes (for example, the 5th of every month).
2. Download your data: Log into all your bank and credit card portals and download the previous month's transactions.
3. Convert if necessary: Change any CSV files to .qbo or .iif.
4. Import and categorize: Bring the files into QuickBooks 2017 and clear out the Bank Feeds center.
5. Reconcile: Pull up your standard reconciliation screen and match your newly imported transactions against the official bank statement.

A Note on Version Differences

The steps for importing Web Connect and .iif files have remained largely identical across QuickBooks Desktop versions for many years. The menu paths outlined above are the same whether you are using QuickBooks 2017, 2019, or 2022. The primary difference for the 2017 version is simply that the live Direct Connect background service is no longer supported, making these manual imports a permanent necessity rather than a backup plan.

Set a recurring calendar reminder for your new monthly download day, and your Desktop 2017 file will stay perfectly up to date without requiring any forced upgrades or live Intuit services.