QuickBooks Online Bank Feeds vs. Reconciliation: What Small Businesses Need to Know

Connecting a bank account to QuickBooks Online can save time, but it does not automatically mean your books are reconciled. A bank feed helps bring transactions into QuickBooks; reconciliation checks whether the books agree with a bank or credit-card statement for a specific period. Understanding the difference can prevent duplicate expenses, missing deposits, and unreliable reports.

What a QuickBooks Online bank feed actually does

When connected, the bank feed imports or displays transactions from your financial institution. You review them and decide whether to match an existing entry, categorize/add a new entry, or exclude an item when appropriate. A transaction appearing in the feed is not proof that it was recorded correctly.

Matching is not the same as adding

Suppose you entered a $420 vendor bill payment in QuickBooks. When the $420 withdrawal arrives through the bank feed, the correct next step may be to match it to the existing payment. Adding it as a new expense could count the same payment twice. Similarly, customer payments that were already recorded should be matched carefully rather than automatically added as sales.

Practical rule: Before selecting “Add,” look for an existing invoice payment, bill payment, transfer, deposit, or expense that represents the same activity. Verify the amount, date, payee, and account.

What reconciliation checks

Reconciliation compares the activity recorded in QuickBooks with the bank or credit-card statement. You confirm the statement's ending date and ending balance, then check off transactions that cleared during the period. The goal is a $0.00 difference between the cleared QuickBooks activity and the statement.

Even when every bank-feed item has been reviewed, the account may still have outstanding checks, duplicate entries, missing transactions, incorrect opening balances, or timing differences that need attention.

A practical monthly workflow

1. Collect statements. Download the official monthly statements for every business bank and credit-card account.
2. Review the feed. Match existing entries first; categorize new items only after checking the details. Review transfers between business accounts so they are not treated as income or expenses.
3. Check unusual items. Investigate duplicate amounts, personal purchases, refunds, merchant deposits net of fees, and uncleared transactions.
4. Reconcile each account. Use the statement's actual ending date and balance, and resolve differences instead of forcing an adjustment.
5. Review reports. After reconciling, inspect the Profit and Loss and Balance Sheet for unexpected balances or major changes.
6. Keep support. Retain statements and documentation according to your business's record-retention practices and applicable requirements.

Common mistakes to avoid

• Adding everything from the feed: creates duplicates when transactions already exist.
• Confusing transfers with expenses: can distort profitability.
• Ignoring payment processor fees: can cause sales and deposits to be recorded incorrectly.
• Reconciling to today's online balance: uses the wrong balance if the statement period has already ended.
• Making unexplained reconciliation adjustments: hides the cause of a discrepancy instead of fixing it.

When to ask for bookkeeping help

If you are months behind, have persistent reconciliation differences, or see income and expenses that do not make sense, it may be time for a cleanup review. A bookkeeper can help identify duplicates, correct account mapping, reconcile historical periods, and establish a repeatable monthly close process.

Frequently asked questions

Does connecting a bank account automatically reconcile it?

No. Bank feeds help bring in transactions, but reconciliation is a separate comparison with your official statement.

Should I delete a duplicate bank-feed transaction?

First determine whether it is a duplicate in the feed or an actual duplicate in the accounting records. The correct action depends on how the original transaction was entered and whether it has been reconciled.

How often should I reconcile?

Monthly reconciliation after each statement closes is a practical baseline for most small businesses. Higher-volume businesses may also review activity more frequently.