The Right Way to Set Up QuickBooks Online Bank Feed Rules

Home Bookkeeping Crypto Tax Payroll About Resources Blog Contact Client Portal Get Started ☰ Home› Blog› The Right Way to Set Up QuickBooks Online Bank Feed Rules (And the Mistakes That Break Your Books) Bookkeeping The Right Way to Set Up QuickBooks Online Bank Feed Rules (And the Mistakes That Break Your Books) By Jamie Waters, QuickBooks Advanced ProAdvisor & Crypto Tax Specialist • July 2025 • 10 min read Bank feed rules are one of the most powerful features in QBO — and one of the most common sources of quiet book errors. Here’s how to set them up correctly and audit the ones you already have. What Bank Feed Rules Do (and Why They Matter) QuickBooks Online’s bank feed rules automatically categorize transactions based on criteria you define — vendor name, amount range, description text. Done correctly, rules eliminate most of the manual work in monthly bookkeeping. Done wrong, they silently miscategorize transactions for months before anyone notices. This is one of the most common sources of book inaccuracy we see in diagnostic reviews: rules that were set up quickly, never audited, and have been misrouting expenses ever since. The Three Types of QBO Bank Feed Rules Categorization rules: Assign a category (expense account) to transactions matching a condition. This is what most people think of as “bank rules.” Transfer rules: Flag transactions as transfers between accounts — useful for payroll runs, owner draws, or moving funds between business accounts. Split rules: Split a single transaction across multiple categories by percentage or fixed amount. Useful for transactions that regularly contain multiple expense types. How to Set Up a Rule (Step by Step) In QBO, go to Transactions > Bank Transactions Click a transaction that you want to create a rule for, or go to Rules > New Rule Set the conditions: which account(s), what transaction type (money out / money in), and the matching criteria (description contains, amount is, etc.) Set the action: category to assign, payee to assign, and whether to auto-add (no review required) or just categorize for review Choose the priority: if multiple rules match, higher-priority rules win Save and apply to existing transactions if you want to backfill Recommendation: Keep “Auto-add” off until you’ve verified a rule is working correctly for at least one reconciliation cycle. Review-first prevents bulk miscategorizations. Matching Conditions: What to Use and What to Avoid Condition Type Best Used For Watch Out For Description contains Recurring vendors with consistent names Partial matches that catch unrelated transactions Description is exactly Transactions with fixed, predictable descriptions Any variation breaks the match Amount is Fixed subscriptions or loan payments Amount changes invalidate the rule silently Amount is between Expense categories with a predictable range Ranges that overlap with other categories Common Bank Feed Rule Mistakes These are the errors we see most often in diagnostic reviews: Too-broad description matches: A rule matching “Amazon” catches Amazon purchases, Amazon Web Services, and Amazon seller fees — three different categories. Rules that override each other: Multiple rules can match the same transaction. If priority is set wrong, the wrong rule wins. QBO silently applies the higher-priority rule — no warning. Auto-add on rules that were never validated: If a rule is wrong and auto-add is on, every matching transaction is miscategorized — often for months — before a reconciliation catches it. Transfer rules that aren’t set up: Payroll runs and owner draws that hit the bank feed as ordinary transactions, coded as expenses instead of transfers. Rules that don’t follow the actual chart of accounts: Categories assigned that don’t match how your accountant or CPA wants expenses classified. How to Audit Your Existing Rules Go to Transactions > Rules and review each rule: Is the category this rule assigns correct for every transaction it would match? Is the matching condition specific enough to avoid false positives? Is auto-add appropriate, or should this require review? Does the rule still apply? (Vendors change names, subscriptions change amounts) Cross-check against your reconciliation register: if a vendor appears with inconsistent categorizations across months, a rule conflict is usually why. Rules Are a Starting Point, Not a Replacement for Review Bank feed rules reduce the manual work of categorization. They do not replace the monthly review of every transaction. Even well-configured rules require a human to catch the edge cases — the unusual purchase from a regular vendor, the duplicate charge, the refund that needs to be matched to the original expense. If your bank feed rules are running on auto-add with no monthly review, your books are being written by an algorithm. That’s fine for routine transactions. It’s not fine for the exceptions — and there are always exceptions. $500 FLAT Not Sure If Your Bank Feed Rules Are Working Correctly? Our Bookkeeping Diagnostic includes a review of your chart of accounts, categorization patterns, and reconciliation history — so you know exactly what’s being coded correctly and what’s quietly wrong. Get My Bookkeeping Diagnostic Not sure where to start? A $500 diagnostic gives you a clear picture of what’s wrong and exactly how to fix it. Get the $500 Diagnostic Our Services Monthly Bookkeeping Catch-Up & Cleanup Crypto Tax Reconciliation Payroll Bookkeeping Diagnostic $500 Crypto Diagnostic $500 Free Resources Monthly Bookkeeping Checklist Crypto Tax Prep Checklist QBO Setup Checklist Mileage & Expense Tracker More from the Blog Bookkeeping How to Know If Your Books Are Actually Reconciled There’s a big difference between entered and reconciled. Bookkeeping Behind on Your Books? Here’s What Catch-Up Looks Like What the cleanup process actually involves and how long it takes. Small Business Contractor vs. Employee: IRS Misclassification Rules The IRS takes misclassification seriously. Here’s how they decide which is which. Credentials and Recognition Bugaboo Bookkeeping LLC 2001 West 6th StAberdeen, WA 98520 253-353-2040 info@bugaboobookkeeping.com Client Portal Book a Call Services Bookkeeping Crypto Tax Payroll $500 Bookkeeping Diagnostic $500 Crypto Diagnostic Get Started Company About Resources Blog Contact Privacy Policy Terms of Service Recognition 2025 Top CAS Accounting ProAdvisor Top 100 QuickBooks ProAdvisor, 2025

Behind on Your Books? Here’s What Catch-Up Bookkeeping Actually Looks Like

Home Bookkeeping Crypto Tax Payroll About Resources Blog Contact Client Portal Get Started ☰ Home› Blog› Behind on Your Books? Here’s What Catch-Up Bookkeeping Actually Looks Like Bookkeeping Behind on Your Books? Here’s What Catch-Up Bookkeeping Actually Looks Like By Jamie Waters, QuickBooks Advanced ProAdvisor & Crypto Tax Specialist • June 2025 • 10 min read If your books haven’t been touched in months — or years — here’s exactly what the cleanup process involves, how long it takes, and what you’ll need to get started. First: What “Catch-Up” Actually Means Catch-up bookkeeping (also called cleanup bookkeeping) is the process of bringing a set of books current after they’ve been neglected, abandoned, or done incorrectly. The starting point could be three months behind, two years behind, or anything in between. This is not the same as monthly bookkeeping. Catch-up involves reconstructing a historical record — often with incomplete data, missing source documents, and bank feeds that have expired or been disconnected. How Bad Is Bad? What We Usually Find Most catch-up files fall into a few patterns: Bank feed imports with no categorization: Transactions were pulled in but never coded. The P&L is meaningless. Mixed personal and business: Owner used the business account for personal expenses, or vice versa. Every transaction needs review. Duplicate entries: Transactions recorded manually AND through the bank feed. Revenue and expenses are both overstated. Forced reconciliations: Someone “balanced” the accounts by adding adjustment entries instead of finding the actual discrepancy. Errors are buried but compounding. Prior bookkeeper’s mystery accounts: Unexplained balances in accounts that don’t match anything in reality. The Catch-Up Process, Step by Step Every engagement is different, but the general sequence is: Bank and credit card statement collection. We need statements for every account, every month in the period. This is the source of truth — not the bank feed. Diagnostic review. Before touching anything, we assess the existing file — what’s there, what’s wrong, what’s salvageable. This prevents doing work twice. Transaction coding. Every uncoded or miscoded transaction is reviewed and categorized correctly. This is the core of the work and usually the most time-consuming part. Reconciliation by month. We reconcile each bank and credit card account against statements, month by month, from the last clean date forward. No forced reconciliations — if something doesn’t balance, we find out why. Adjusting entries. Depreciation, owner draws, loans, payroll liabilities — anything that needs to be booked correctly to reflect actual financial position. Final review. Spot-check the P&L and balance sheet against what you know about your business. The numbers should make sense. How Long Does Catch-Up Take? Timeline depends on how far behind you are, how many accounts you have, and how complete your records are. A rough guide: Months Behind Typical Timeframe 1–3 months 1–2 weeks 4–6 months 2–4 weeks 7–12 months 4–8 weeks 1–2 years 6–12 weeks 2+ years Quoted after diagnostic These are general estimates. Engagements with significant transaction volume, multiple entities, or complex payroll situations take longer. What You’ll Need to Provide To do this work, we need access to: Your QuickBooks Online file (accountant access) Bank and credit card statements for every account in the period (PDF or exported CSV) Payroll reports if payroll ran during the period Loan statements if you have business debt Any major purchase receipts or expense documentation you have Missing documents are common and not a dealbreaker. We work with what exists and flag what’s truly needed vs. what’s nice to have. What You Get at the End When catch-up is complete, you have a QuickBooks file that’s fully reconciled through the last period, a clean chart of accounts, and financial statements you can actually use — profit and loss, balance sheet, and cash flow. You can hand this file to a CPA or tax preparer and it will hold up. We also flag anything that needs attention going forward: recurring miscategorizations, owner draws that need documentation, payroll issues, or anything else that, if uncorrected, will create the same problem next year. Starting From Here: The Diagnostic Before we quote a catch-up engagement, we run a Bookkeeping Diagnostic. This is a $500 flat-fee review of your QBO file that tells us exactly what’s wrong, how bad it is, and what fixing it will realistically involve. It prevents surprises — for both of us. $500 FLAT Behind on Your Books? Start Here. A Bookkeeping Diagnostic is the fastest way to understand what you’re actually dealing with. We’ll review your QBO file and give you a written report — what’s wrong, what it’ll take to fix it, and what you can ignore. Get My Bookkeeping Diagnostic Not sure where to start? A $500 diagnostic gives you a clear picture of what’s wrong and exactly how to fix it. Get the $500 Diagnostic Our Services Monthly Bookkeeping Catch-Up & Cleanup Crypto Tax Reconciliation Payroll Bookkeeping Diagnostic $500 Crypto Diagnostic $500 Free Resources Monthly Bookkeeping Checklist Crypto Tax Prep Checklist QBO Setup Checklist Mileage & Expense Tracker More from the Blog Bookkeeping How to Know If Your Books Are Actually Reconciled There’s a big difference between entered and reconciled. Bookkeeping The Right Way to Set Up QBO Bank Feed Rules Bank feed rules save time — but set them up wrong and they silently break your books. Small Business Contractor vs. Employee: IRS Misclassification Rules The IRS takes misclassification seriously. Here’s how they decide which is which. Credentials and Recognition Bugaboo Bookkeeping LLC 2001 West 6th StAberdeen, WA 98520 253-353-2040 info@bugaboobookkeeping.com Client Portal Book a Call Services Bookkeeping Crypto Tax Payroll $500 Bookkeeping Diagnostic $500 Crypto Diagnostic Get Started Company About Resources Blog Contact Privacy Policy Terms of Service Recognition 2025 Top CAS Accounting ProAdvisor Top 100 QuickBooks ProAdvisor, 2025 and 2026 Intuit Certified Bookkeeper QuickBooks Online Advanced ProAdvisor IRS Annual Filing Season Program Washington bookkeeping services for service-based businesses. Crypto tax reconciliation and reconstruction available nationwide. 20+ years experience. 1,000,000+ crypto transactions processed. © 2026 Bugaboo Bookkeeping LLC. All rights reserved. | Privacy Policy |