How to Exclude Bank Transactions in QuickBooks Online: A Practical Step-by-Step Guide

Keeping bank feeds tidy is essential for accurate books. This guide explains how to exclude bank transactions in QuickBooks Online so downloaded items do not affect reconciliation or reports. The steps below cover the QuickBooks Online app workflow, common scenarios, and a compact checklist for safe exclusion.

Detected intent: Informational

How to exclude bank transactions in QuickBooks Online — quick overview

To exclude bank transactions in QuickBooks Online, open the Banking (or Transactions) tab, find the entry under the For Review list, and choose Exclude or Exclude Selected. Excluded items move to the Excluded tab and do not post to accounts or affect reconciliation. If needed later, excluded entries can be reviewed and restored.

When and why to exclude transactions

Excluding transactions is appropriate when a downloaded item is:

• Clearly a duplicate of an already-recorded transaction.
• Personal or non-business in nature and the books should not record it.
• An automated bank fee that will be recorded through another process or handled during reconciliation.
• Obvious bank-feed noise (e.g., authorization holds that will never post).

CLEAR Exclusion Checklist (named framework)

Use the CLEAR framework before excluding a transaction:

• Confirm — Verify the transaction is not already in the ledger and check dates/amounts.
• Locate — Find the match in Banking > For Review and open details.
• Assess — Decide if exclusion or categorization is correct for bookkeeping.
• Review — Check reconciliation status and consider consulting the accountant for ambiguous items.
• Execute — Use Exclude or Exclude Selected to remove it from For Review.
• Archive — Keep a short exclusion log (date, amount, reason) if exclusions are frequent.

Step-by-step: Exclude a bank transaction in the QuickBooks Online app

Follow these steps inside the QuickBooks Online app to exclude a single transaction.

Step 1 — Open the Banking/Transactions page

Tap or click Banking (sometimes labeled Transactions > Banking). Choose the connected bank account with the transaction.

Step 2 — Find the item in For Review

Scroll or use the search/filter to locate the downloaded bank item. Confirm the amount and date match the feed entry.

Step 3 — View details and decide

Open the transaction card and check if it matches an existing ledger entry. If it is a duplicate or irrelevant, proceed to exclude.

Step 4 — Exclude

Click or tap Exclude (or Exclude Selected for multiple items). The entry moves to the Excluded tab. If exclusion was a mistake, use the Excluded tab to Undo and move it back to For Review.

Real-world example

Example: A small consulting firm downloads bank feed items and sees a $120 credit card charge for a software trial. The firm already recorded the subscription as an expense on the same date. Confirming the ledger duplicate, the bookkeeper uses the CLEAR checklist and excludes the bank feed item to avoid double-counting the expense. The exclusion log notes: "2026-01-15, $120, duplicate subscription charge."

Practical tips

• Maintain a brief exclusion log (spreadsheet or note) with date, amount, and reason to support audits.
• Use bank rules to automatically categorize recurring legitimate transactions and reduce manual exclusions.
• Before excluding, always check the current reconciliation period to avoid removing a transaction needed for a completed reconciliation.
• If unsure, temporarily move suspicious items to a review folder or flag them for the accountant instead of immediate exclusion.

Common mistakes and trade-offs

Common mistakes

• Excluding entries that are actually unmatched business expenses, causing underreported expenses and incorrect profit figures.
• Failing to document why an exclusion occurred, which complicates audits and reviews.
• Overusing exclusion instead of fixing bank rules or matching transactions properly.

Trade-offs

Excluding removes clutter and prevents double-entry but also removes a safety net: excluded items are not posted and therefore will not appear on financial reports. If a transaction was excluded in error, restoring it adds administrative steps and potential reconciliation adjustments. Balance cleanliness with traceability by logging reasons and reviewing exclusions periodically.

Related workflows and keywords to know

Understanding related terms helps avoid mistakes: reconcile bank transactions QuickBooks refers to the bank reconciliation workflow that ensures ledger balances match bank statements. QuickBooks Online bank rules automate categorization of frequent transactions and reduce manual exclusions.

Core cluster questions

• How to match bank transactions to QuickBooks Online records?
• When should a bank transaction be excluded versus categorized?
• How to restore an excluded transaction in QuickBooks Online?
• How do bank rules reduce the need to exclude transactions?
• What to do if excluded transactions affect prior reconciliations?

For official guidance on banking workflows and exclusions, see the QuickBooks Help Center: QuickBooks Help Center.

When to contact a professional

Contact an accountant or bookkeeper if exclusions regularly affect financial statements, if reconciliation discrepancies appear after exclusions, or when handling complex transactions like transfers, refunds, or disputed charges.

Final checklist before excluding

• Confirm no matching ledger entry exists.
• Verify reconciliation impact and current statement period.
• Record a short reason in the exclusion log.
• Consider creating a bank rule if the item recurs.

FAQ

How do I exclude bank transactions in QuickBooks Online?

Go to Banking > For Review, find the transaction, open it, and choose Exclude or Exclude Selected. The item moves to the Excluded tab and will not post to the ledger.

Can excluded transactions be restored?

Yes. Open the Excluded tab, locate the transaction, and select Undo to move it back to For Review so it can be matched or added.

Will excluding a transaction affect bank reconciliation?

Excluding a transaction prevents it from posting, so it will not appear on reconciliation reports. Exclude only after confirming it should not be part of the ledger for the reconciliation period in question.

Are excluded transactions permanently deleted?

No. Excluded transactions remain visible in the Excluded tab and can be restored. They are not deleted from the bank feed history unless manually removed.

How to avoid excluding business expenses by mistake?

Follow the CLEAR Exclusion Checklist: confirm matching entries, review reconciliation status, and document reasons. When doubtful, flag for professional review instead of excluding immediately.