QuickBooks Online Users Replace Manual Categorizing With Bank Rules

QuickBooks Online users keep raising the same frustration in community threads. The bank feed connects, the transactions download, and the For Review tab refills faster than anyone can clear it. Every downloaded item needs a category before it can reach the right account. Handled manually, the work repeats with every connection.

The accepted answer here is an Intuit walkthrough for bank rules, the built-in tool that assigns categories on its own. That advice has aged in one respect: the menus have moved. We rechecked the steps against the current product, and the core approach still holds.

The symptom is a queue that refills

Each item in For Review wants a category, a payee, and often a tax treatment before you can accept it. The same charges tend to return month after month: subscriptions, delivery services, card fees, fuel. Without automation you make the same picks again and again, and small inconsistencies creep in. One month a payment lands in one account. A near-identical payment the next month lands somewhere else. Those mismatches turn into cleanup work later, in reports and at tax time.

How do bank rules change the workflow?

A bank rule is a saved instruction. You describe what to look for, such as a phrase in the bank text or an exact amount, and what to do when a match appears. QuickBooks Online applies the instruction to transactions as they download. Matched items still arrive in For Review, so nothing reaches the books without passing your eye. The details come in filled, though, and your part shrinks to a quick confirmation.

The software also learns from steady use. The more rules it applies, the better it reads your transactions and adds details on its own. Early effort comes back as fewer manual entries in later months.

Setting up your first rule

One detail in the answer needed correction. Its menu path points to an older layout, and the page has since moved. In the current product you open the Transactions menu and choose Rules, where a prompt may appear for anyone adding a rule for the first time. From there, setup runs as follows:

• Choose New rule and give it a name you will still recognize months later.
• Decide whether it covers money in or money out.
• Point it at one bank account, or let it apply to all of them.
• Add conditions, up to five in one rule. Each condition can test the description, the bank text, or the amount.
• Pick the match type: contains, does not contain, or exactly.
• Set the result: the transaction type, the category, a product or service, the payee, and tax. The options you see depend on your company settings.
• Save the rule once it reads the way you intend.

Rule order and day-to-day upkeep

Rules can collide, and priority settles the conflict. Use the reorder control and drag them into sequence; the rule at the top always runs first. The Actions column on the same page offers copy, a temporary on and off switch, and delete. A shortcut helps during review as well. Select a transaction in For Review and choose the Create a rule link, and the rule window opens with that transaction in front of you. Conditions are easier to write when the example is on screen.

Moving rules between company files

Anyone keeping more than one company file does not have to rebuild the set by hand. Rules export from one file and import into another. That keeps categorization consistent across separate books, which matters when several files draw on the same banks and vendors.

Where rules stop helping

Automation trims the chore; it does not erase it. Matched transactions still wait in For Review, so plan on a short daily pass rather than none. Loose conditions can overreach. A rule matching every description that contains the word fee will sweep in far more than one bank’s charges. Test each new rule against recent transactions before trusting it. The five-condition ceiling also nudges complex cases toward several narrow rules instead of one broad one.

Our take: few settings in QuickBooks Online repay the effort this well. A short setup session removes a sorting chore that returns with every download, and the rules grow more useful the longer they run.