Bank Feeds
Bank Feeds: How to Add, Match, and Exclude with Confidence
Bank feeds can save time when each transaction is reviewed before it is accepted. Knowing when to add, match, or exclude helps you avoid duplicates and keep the records easier to reconcile.
Start by checking whether the transaction is already recorded. Review the payee, date, amount, and category before adding something new. A consistent process makes this much easier.
Add activity that is not yet recorded. Match downloaded activity to the corresponding existing record. Exclude a genuine duplicate download when appropriate. Personal spending paid from a business account still needs to be accounted for; do not simply exclude it because it is personal. Careful review reduces the extra work caused by duplicates, incorrect transfers, and missing detail. Reconciliation is a separate check against the statement.
Structural Review
The patterns that show the bank feed is being used incorrectly
When the bank feed is not reviewed with intention, the same problems show up repeatedly. These are the indicators that the structure behind your QuickBooks file is already drifting.
What Needed Attention
Transactions were added instead of matched. Vendor names were missing. Income was duplicated. Expenses were dumped into broad categories. The bank feed was treated like data entry instead of a review tool, which created inconsistencies in every major report.
How the Issue Developed
The feed was used without understanding how QuickBooks connects bank activity to actual accounting records. Items were added because they appeared in the feed, not because they belonged there. Matching was ignored. Reconciliations fell apart because the underlying activity was never aligned with reality.
How the Pattern Showed Up
Duplicates appeared across income and expense accounts. Unmatched payments sat open for months. Transfers were misclassified as income. The For Review tab filled up with uncategorized activity. Each attempt to fix the issue made the next period harder to reconcile.
What the Work Required
The feed had to be cleaned out. Transactions already recorded in QuickBooks were matched instead of added. Incorrect entries were removed or reclassified. Transfers were corrected. Only then could reconciliations be completed and the file begin to report accurate numbers again.
Why bank feed mistakes cause problems everywhere
When bank feed activity is added incorrectly, nothing downstream works. Income is inflated. Expenses are distorted. Reports stop reflecting reality. Reconciliations become impossible because the activity in QuickBooks no longer matches the bank. These are not small errors. They are structural failures that spread across the file.
When you review the feed correctly, the entire system stabilizes. Matching replaces guessing. Categorization becomes consistent. Reconciliations lock in cleanly because the details support the structure. Accuracy returns because the workflow finally supports the numbers.
Frequently Asked Questions
How often should I review my bank feed?
Review it consistently. Daily or weekly for active businesses. The longer you wait, the harder it becomes to identify what belongs, what matches, and what was already recorded.
What happens if I add instead of match?
You create duplicates. The system loses track of what was actually paid or received. This leads to incorrect income, distorted expenses, and reconciliations that will never tie out cleanly.
What is the purpose of the Excluded tab?
The Excluded tab holds downloads you have chosen not to add to the books, such as duplicate bank-feed data. First confirm whether the transaction belongs in the account’s records. Personal spending through a business account may need owner-related treatment rather than exclusion.
How do I know if the bank feed is set up correctly?
Check that downloads cover the expected dates, matching is handled consistently, and recorded activity agrees with statements. A completed reconciliation alone does not prove that every category or workflow is correct.
Ready for reports that finally make sense?
The Complete Check gives you a clearer picture of your QuickBooks file and a practical recommendation for what to do next. Cleanup or reconstruction is scoped separately, based on what the review finds.
Start Your Cleanup