--- title: "QuickBooks Online Bank Rules: Setup & Examples | MCC" description: "Build bank rules that categorize correctly, limit by amount, and avoid auto-posting mistakes. Worked example and a quarterly review." url: "https://mcc-solutionsnj.com/bookkeeping/guides/quickbooks-online-bank-rules" --- Bookkeeping guide · Updated October 12, 2026 # How to Set Up Bank Rules in QuickBooks Online Bank rules tell QuickBooks Online how to treat transactions that arrive through your bank feed. Used well, they save hours. Used carelessly, they spread the same wrong category across hundreds of entries, so it pays to set them up thoughtfully. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** A QuickBooks Online bank rule watches downloaded transactions for conditions such as the description containing a vendor name or an amount above a set value. When it matches it can assign a category, set the payee, add a class or location, split the amount and add a memo. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings) · [Void vs delete a transaction](/bookkeeping/guides/voiding-vs-deleting-transactions) · [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) **Free tools:** [What should I charge per hour?](/bookkeeping/freelance-hourly-rate-calculator) · [Depreciation schedule calculator](/bookkeeping/depreciation-calculator) Working through a backlog? The [QuickBooks Cleanup Kit](/toolkits/quickbooks-cleanup-kit) is a step-by-step checklist, a reconciliation log and a READY or NOT READY page for your books. [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## What a rule can do A rule watches the downloaded transactions for conditions you choose, such as the description containing a vendor name or the amount being above a certain value. When it matches, it can assign a category, set the payee, add a class or location, split the amount across categories and add a memo. You can choose to have the rule only suggest the match or to add the transaction automatically. ## Create your first rule Open Transactions, then Bank transactions, and go to the Rules tab, then choose New rule. Name it clearly, such as Electric utility monthly. Choose whether it applies to money in or money out and select the bank accounts. Add one or more conditions, using contains rather than exact match when descriptions carry changing reference numbers. Then pick the category, payee and any tags. Save and run it on the existing transactions in the For review tab. ## Use suggest first, automate later For the first month, set the rule to put transactions into a review list rather than adding them automatically. Look at a few cycles. When the matches are consistently correct, switch the rule to auto-add. Keep a lower trust level for vendors who sell many kinds of things, such as a big box store, where a single category will often be wrong. ## Order and overlap Rules run in priority order, and the first one that matches wins. A general rule such as contains Amazon can override a narrower rule if it sits above it. Place specific rules first. Review your list quarterly and delete rules for vendors you no longer use. Exporting the rules list can help you document your setup for a bookkeeper. ## Mistakes to avoid Do not write a rule that categorizes transfers between your own accounts, loan payments or owner draws as expenses, since those are not expenses. Do not use a rule for transactions that need a receipt decision, such as meals with clients. Watch for rules that split a payment into percentages when the proportions change. If a rule does produce wrong entries, fix the rule first, then correct the transactions it touched, otherwise the error returns next month. Finally, remember that rules classify, but they do not replace reconciliation. Reconcile every month to catch duplicates and missing items. ## A simple starter set of rules Good first rules cover predictable items: monthly software subscriptions, bank service fees, the phone bill, payroll provider debits and merchant fees. Each has a stable description and a single correct category. Leave grocery stores, big box retailers and online marketplaces to manual review until you understand how you use them. After a few months, check the rules report to see how many transactions each rule has handled. A rule that never fires can be deleted, and one that fires constantly deserves a second look to be sure it is still right. ## Worked example with numbers You create a rule: if the description contains 'ADOBE' and the amount is under $100, categorize as software and subscriptions and name the vendor Adobe. The next 12 matching charges post automatically. Later, Adobe raises a plan to $129 and the charge falls outside the rule, so it lands in For Review, where you spot the change. If instead the rule had no amount limit, a single large unrelated charge could post to software with no one noticing. ## Check your work Once a quarter, sort rules by usage and review any that auto-add. Delete rules that no longer match your categories. ## Common questions **Can a rule split one transaction into several categories?** Yes. Choose the split option and set amounts or percentages for each line. **Why did my rule not match?** Check the description text, the account selected and whether another rule above it already caught the transaction. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online) More guides - [QuickBooks Online Classes and Locations Explained](/bookkeeping/guides/quickbooks-online-classes-and-locations) - [Recurring Transactions in QuickBooks Online](/bookkeeping/guides/quickbooks-online-recurring-transactions) - [How to Use Projects in QuickBooks Online](/bookkeeping/guides/quickbooks-online-projects-feature) - [QuickBooks Online Bank Feed Not Working: Fixes](/bookkeeping/guides/quickbooks-online-bank-feed-not-working) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Chart of Accounts and QuickBooks Import Pack Start your books with an account list built for your type of business, instead of the generic default, and compare it with the accounts you already have. [See what's inside ($24)](/toolkits/chart-of-accounts-quickbooks-import-pack)14-day full refund Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)