Keep Bank Transactions Flowing Into QuickBooks Desktop 2023

QuickBooks Desktop 2023 loses Direct Connect after May 2026. Keep bank data flowing using Web Connect, CSV conversion, and IIF imports without upgrading.

QuickBooks Desktop 2023 is a solid, capable release, but like all Desktop versions, it has a built-in shelf life for connected services. Intuit officially discontinues live services—including bank feeds via Direct Connect—for QuickBooks Desktop 2023 on May 31, 2026. When that date arrives, the software itself will not stop working, but the automated pipeline that pulls transactions directly from your bank will go quiet.

Fortunately, keeping your accounts perfectly reconciled in QuickBooks 2023 long after this sunset is entirely possible. By shifting to manual imports, you can maintain an identical workflow without relying on Intuit's servers or paying for an upgrade.

Understanding Your Post-Sunset Import Options

Once Direct Connect stops functioning, you have three primary methods for bringing transactions into QuickBooks Desktop. The mechanics of these import methods are identical across recent Desktop versions, so if you have used manual imports in QuickBooks 2021 or 2022, the process remains exactly the same in 2023.

1. Web Connect (.QBO): The most seamless manual method. Most major banks let you download a .QBO file directly from their online banking portal. QuickBooks natively reads this format and maps it to your chart of accounts.
2. CSV Conversion: If your bank only allows you to download activity as an Excel or CSV file, you can use a third-party conversion tool to format that data into a .QBO file that QuickBooks will accept.
3. IIF Import: Intuit Interchange Format (.IIF) is a legacy, text-based format. It is highly flexible and allows you to import not just bank transactions, but also lists, journal entries, and other data, though it requires strict formatting to avoid errors.

Importing via Web Connect (.QBO)

Using .QBO files is the closest alternative to the automated bank feeds you are used to.

1. Log in to your bank or credit card's online portal.
2. Navigate to the transaction history or export section.
3. Select the desired date range and choose the QuickBooks or Web Connect (.QBO) format for the download.
4. Save the file to your computer.
5. Open QuickBooks Desktop 2023.
6. Double-click the downloaded .QBO file, or from the QuickBooks File menu, select Utilities > Import > Web Connect Files.
7. QuickBooks will open the Bank Feeds Center. Select your existing account to map the data to and click Continue.

The transactions will appear in your Bank Feeds review window, exactly as they did when the data was arriving automatically.

Converting CSV Files to QBO

Not all financial institutions provide .QBO downloads. If your bank only offers CSV or Excel exports, you do not need to enter those transactions by hand. You can convert standard spreadsheet data into a QuickBooks-compatible format.

When converting bank or credit card data, or if you ever need to move data between QuickBooks versions or editions, formatting is the most critical step.

1. Download your bank activity as a CSV or Excel file.
2. Open the file and ensure the columns are clean. At minimum, QuickBooks needs a Date, Amount, and Description/Memo. Ensure debits and credits are handled correctly (some banks use a single amount column with negative numbers for withdrawals, while others use separate payment and deposit columns).
3. Use a reputable CSV-to-QBO conversion utility to process the file.
4. Once the utility generates the .QBO file, import it into QuickBooks using the standard Web Connect steps outlined above.

Using IIF for Bulk Imports

The IIF format bypasses the Bank Feeds Center entirely. When you import an .IIF file, transactions are written directly into your company file's registers. This makes it a powerful tool for bulk data entry, but it also means you must be highly confident in your formatting, as mistakes can be harder to reverse.

To import an IIF file:

1. From the QuickBooks File menu, select Utilities > Import > IIF Files.
2. Browse to your .IIF file and click Open.
3. QuickBooks will display a confirmation message once the data has been successfully read and imported.

If you are building IIF files from scratch, always test them in a copy of your company file first to ensure your account mappings and formatting are correct.

Building a Reliable Monthly Routine

To prevent a backlog of un-entered transactions once Direct Connect ends, establish a strict monthly routine tied to your bank statement cycle.

1. Download on Schedule: On the first business day of the month, log into your banking portals and download the previous month's transactions.
2. Convert if Necessary: Run any CSV files through your conversion utility immediately.
3. Import and Review: Import your .QBO or .IIF files into QuickBooks Desktop 2023.
4. Match and Categorize: Open the Bank Feeds Center to match the imported transactions against any existing entries, and categorize the rest.
5. Reconcile: Pull up your standard reconciliation screen and check it against your bank statement to verify that your ending balances match perfectly.

By treating manual downloads as a standard part of your monthly close, you eliminate the friction of lost automated feeds and keep your books perfectly up to date indefinitely.