Bank feeds in QuickBooks: rules, matching and common problems

Bank feeds are one of QuickBooks’ biggest time-savers and one of its most common sources of a messy file — often at the same time. Connected well, a feed keeps your books current with almost no typing. Used carelessly, it fills the ledger with duplicates and miscategorised transactions that take longer to fix than manual entry would have taken. Here’s how the feed actually works and where it goes wrong.

How the feed works

A bank feed connects to the bank and downloads transactions as they clear. For each one you either match it to something already in QuickBooks (an invoice payment, a recorded bill) or add it as a new transaction to a chosen account. Rules automate this — “anything from this payee goes to this expense account” — so recurring items categorise themselves.

The common problems

Duplicates

The number-one bank-feed mess: a transaction is entered manually and added from the feed, so it appears twice. This inflates income or expenses and throws reconciliation. The fix is discipline — decide whether a given account is driven by the feed or by manual entry, and don’t do both for the same transaction.

Over-eager rules

A rule that’s too broad silently miscodes transactions — every payment to a large retailer coded as “office supplies,” for instance, when some were something else. Because rules run automatically, the errors pile up unseen until a review catches them. Keep rules specific, and review what they’re doing.

Missed matches

When QuickBooks can’t confidently match a feed transaction to an existing entry, it may prompt you to add it — creating a duplicate of a payment you’d already recorded. Watch for “add” suggestions that should really be matches.

Feed gaps and disconnects

Feeds occasionally disconnect, skip transactions, or reconnect with an overlap. Periods where the feed was down leave gaps; reconnections can re-import a stretch. Reconciling to the statement is what catches these.

Best practice

• Pick one method per account — feed-driven or manual — and stick to it.
• Keep rules narrow and review them periodically.
• Prefer matching over adding; an “add” on something you already recorded is a duplicate.
• Always reconcile to the statement. The feed is a convenience, not a substitute — reconciliation is still what proves the account is right.