Import Bank Transactions in QuickBooks Desktop 2018 After Sunset

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

QuickBooks Desktop 2018 officially reached the end of its supported lifecycle on May 31, 2021. With services discontinued, the built-in Direct Connect feature for automatic bank feeds no longer functions. However, you can easily keep your financial data current by manually importing transactions. We will walk you through the three most reliable methods for bringing your banking data into the 2018 version indefinitely.

Web Connect (.QBO) Files

The most seamless way to import transactions is through the standard QuickBooks Web Connect format. Most major banks allow you to download a .QBO file directly from their online banking portal, even when Direct Connect is disabled.

Once you download the file from your bank, simply double-click it to open it in QuickBooks. Alternatively, go to File > Utilities > Import > Web Connect Files from the top menu. QuickBooks will read the file and prompt you to match the data to the appropriate bank or credit card account in your company file. This process is identical across all recent versions of QuickBooks Desktop, so the standard workflow applies perfectly to 2018.

CSV Conversion

If your bank does not offer .QBO downloads, a standard spreadsheet CSV file is your next best option. QuickBooks Desktop natively looks for the .QBO format, so a standard CSV file requires a conversion step before it can be imported.

To bridge this gap, you can use a third-party CSV-to-QBO conversion utility. You simply download your bank activity as a CSV from your bank's website, map the date, amount, and description columns in the converter, and generate a .QBO file. Once converted, you import the new file into QuickBooks 2018 using the exact same Web Connect steps outlined above.

IIF Import

The Intuit Interchange Format (IIF) is an older, text-based format that QuickBooks uses to import lists and transactions. You can use it to bring in bank data by either downloading an IIF file directly from your bank (if supported) or by formatting a spreadsheet to match QuickBooks' strict IIF templates.

To import an IIF file, navigate to File > Utilities > Import > IIF Files. While powerful, IIF requires exact formatting. If a column is misaligned or a transaction type is unrecognized, QuickBooks may reject the file or import corrupted data. If you are dealing with a damaged IIF file or a company file that throws errors during standard imports, you may need professional QuickBooks Desktop data recovery to safely rebuild the transaction chains.

Your Monthly Bank Import Routine

To ensure your books stay accurate without relying on automated feeds, we recommend adopting a simple manual routine at the close of every month:

1. Log in to your bank: Download your statement for the month that just ended. Prioritize the .QBO format, falling back to CSV if necessary.
2. Convert if needed: Run any CSV files through your conversion tool to create a .QBO file.
3. Import to QuickBooks: Bring the file into QuickBooks Desktop 2018.
4. Review the Banking Center: Open the Bank Feeds Center to categorize, match, and add your downloaded transactions to your register.

A Note on Version Accuracy

Because QuickBooks Desktop 2018 is a discontinued version, you will not receive updates to its import logic or bank feed center. The manual import methods described above rely on core, long-standing desktop architecture that does not require an internet connection to Intuit's servers to function. By relying on manual file imports rather than live connections, your 2018 software can continue to process your financial data reliably for years to come.