How to Set Up Bank Feeds in QuickBooks Desktop
How to Set Up Bank Feeds in QuickBooks Desktop — And What to Do When They Stop
A complete guide to setting up and using bank feeds in QuickBooks Desktop, how they work, which banks are supported, why they stop at the service sunset date, and how to continue reconciling accurately without them.
Bank feeds — the automatic download of transactions from your bank and credit card accounts directly into QuickBooks — are one of the most convenient features in QuickBooks Desktop. They save hours of manual data entry, reduce transcription errors, and keep your books continuously up to date.
But bank feeds in QuickBooks Desktop come with an important limitation that many users discover too late: they stop working when your version reaches its service sunset date. This guide covers how to use them while they’re active, and how to continue reconciling efficiently after they stop.
📋 Table of Contents
- What Are Bank Feeds in QuickBooks Desktop?
- Setting Up Bank Feeds: Step-by-Step
- Using Bank Feeds Day-to-Day
- Which Banks Are Supported?
- Why Bank Feeds Stop at the Service Sunset Date
- Reconciling Without Bank Feeds: The Manual Import Method
- How to Import Bank Statements via CSV
- Bank Feed Best Practices
- Frequently Asked Questions
1. What Are Bank Feeds in QuickBooks Desktop?
Bank feeds (also called bank connections or online banking) allow QuickBooks Desktop to connect directly to your bank or credit card issuer and automatically download recent transactions. Once downloaded, you match or categorize each transaction against records already in QuickBooks — such as checks you’ve written or invoices you’ve received payment on.
QuickBooks Desktop supports two types of bank connections:
- Direct Connect: QuickBooks connects to your bank’s server using a direct financial data protocol (OFX). Transactions download automatically within QuickBooks. Many banks charge a monthly fee ($10–$15) for Direct Connect access.
- Web Connect: You log into your bank’s website, manually download a transaction file (.qbo or .ofx), and import it into QuickBooks. Free at most banks. Requires more steps but is more universally supported.
💡 Which to use: If your bank supports Direct Connect and you don’t mind the potential fee, it provides the smoothest experience. If you want to avoid bank fees or your bank only supports Web Connect, the manual import process adds about 5 minutes to your reconciliation workflow and works equally well.
2. Setting Up Bank Feeds: Step-by-Step
Open the Bank Feeds Center
Go to Banking → Bank Feeds → Bank Feeds Center. This is the central hub for all your bank connections.
Set up account for bank feeds
Click Set Up Bank Feed for an Account. Select the bank account from your chart of accounts that you want to connect.
Search for your bank
In the search box, type your bank’s name. QuickBooks displays a list of supported financial institutions. Select your bank from the list.
Choose connection type
QuickBooks will indicate whether your bank supports Direct Connect, Web Connect, or both. Choose your preferred method.
Enter your online banking credentials
For Direct Connect: enter your bank’s online banking username and password. For Web Connect: QuickBooks will open your bank’s website where you download the transaction file.
Match the account
QuickBooks asks you to confirm which account in your chart of accounts corresponds to this bank account. Verify the match and confirm.
Download and review transactions
Once connected, QuickBooks downloads your recent transactions. Review each transaction in the Bank Feeds Center and either match it to an existing QuickBooks record or add it as a new transaction.
3. Using Bank Feeds Day-to-Day
After the initial setup, your daily bank feed workflow is:
- Open Banking → Bank Feeds → Bank Feeds Center
- Click Download Transactions (Direct Connect) or import your downloaded file (Web Connect)
- Review the downloaded transactions in the Matched Transactions and Unmatched Transactions sections
- For matched transactions: QuickBooks has automatically identified the corresponding record in your books — review and accept
- For unmatched transactions: manually assign each to the correct account, customer, or vendor
- When all transactions are reviewed, click Accept All or accept individually
✅ Best practice: Download and review bank feeds at least weekly. Letting transactions accumulate for a month means more unmatched items and a longer reconciliation session. A 15-minute weekly bank feed review is far easier than a 90-minute monthly catch-up.
4. Which Banks Are Supported?
QuickBooks Desktop supports bank feeds from most major US financial institutions, including:
- Chase, Bank of America, Wells Fargo, Citibank
- US Bank, PNC, Capital One, TD Bank
- American Express, Discover, Visa/Mastercard credit cards issued by major banks
- Most regional and community banks that offer OFX or Web Connect export
- PayPal, Stripe (via third-party connectors)
If your bank is not in QuickBooks’ supported list, check whether your bank offers OFX or QFX file downloads from its online banking portal. If so, you can use Web Connect even if Direct Connect is not supported.
5. Why Bank Feeds Stop at the Service Sunset Date
Bank feeds in QuickBooks Desktop require an active connection between Intuit’s servers and your financial institution. When Intuit ends support for a specific Desktop version, they decommission the server infrastructure that handles those connections. The result: Direct Connect and Web Connect downloads stop functioning for that version.
| Version | Bank Feed Status |
|---|---|
| QuickBooks Desktop 2021 | ⛔ Bank feeds stopped May 2024 |
| QuickBooks Desktop 2022 | ⛔ Bank feeds stopped May 2025 |
| QuickBooks Desktop 2023 | ⚠️ Bank feeds stopping ~May 2026 |
| QuickBooks Desktop 2024 | ✅ Bank feeds active through ~May 2027 |
⚠️ What this means in practice: If you are on a version past its sunset date, your bank feeds have already stopped. This does not affect the core accounting software — all your historical data remains intact, and you can continue invoicing, reporting, and reconciling. You just need to use manual CSV import instead of automatic download, which adds a few minutes per reconciliation session.
6. Reconciling Without Bank Feeds: The Manual Import Method
When bank feeds stop, you have two practical approaches for reconciling your accounts:
Method A: CSV Import (Recommended)
Most banks allow you to download your transaction history as a CSV file from their online banking portal. You can import this CSV into QuickBooks Desktop using a free third-party utility or convert it to OFX format first.
Method B: Manual Reconciliation
This is the traditional approach — compare your bank statement to your QuickBooks register line by line and check off matching transactions. For businesses with modest transaction volumes (under 100 transactions per month), this takes 20–40 minutes and is a completely reliable approach that has been used successfully for decades.
Go to Banking → Reconcile, enter your statement ending balance and date, and check off each transaction that appears on your bank statement. QuickBooks calculates the difference and shows you when you’ve reached a zero balance.
7. How to Import Bank Statements via CSV into QuickBooks Desktop
Download your bank statement as CSV
Log into your bank’s online portal. Navigate to your account history. Select the date range and download format. Choose CSV (or Excel) if available.
Convert CSV to OFX format
QuickBooks Desktop does not natively import CSV files — you need OFX format. Use a free converter tool such as ProperSoft’s CSV2QBO (paid) or a free online converter. This is a one-time setup step.
Import the OFX file into QuickBooks
Go to Banking → Bank Feeds → Import Web Connect File. Select your converted OFX file. QuickBooks imports the transactions into the Bank Feeds Center exactly as if they were downloaded automatically.
Review and accept transactions
The imported transactions appear in the Bank Feeds Center. Match them to existing QuickBooks records or categorize new ones, then accept.
8. Bank Feed Best Practices
- Reconcile monthly at minimum — bank feeds make reconciliation easier but should still be completed formally each month, not just reviewed
- Never reconcile without a bank statement — always compare against your official statement, not just the downloaded transactions
- Review unmatched transactions carefully — an unmatched transaction often indicates a duplicate, a data entry error, or a transaction that needs a new category
- Create rules for recurring transactions — QuickBooks Desktop lets you create matching rules so recurring transactions (like monthly subscriptions or regular vendor payments) are categorized automatically
- Back up before accepting large batches — when importing several months of transactions at once, create a backup first in case you need to reverse an incorrect batch
Frequently Asked Questions
Get QuickBooks Desktop 2024 with Active Bank Feeds
Genuine perpetual license — bank feeds active through ~May 2027. From $199, delivered in 2–4 hours.