Books Current

Books Current / Guides

How to categorize transactions in QuickBooks Online without making a mess

Categorizing is where most small-business books go wrong, not because it is hard, but because it is done fast and inconsistently. Here is the routine that keeps it clean.

Updated 2026-09-16. Steps refer to QuickBooks Online and link to Intuit’s own help articles.

Where the work happens

In QuickBooks Online, go to Accounting, then Bank transactions, pick the account, and open the Pending tab. Every downloaded bank line waits there until you decide what it is.

For each line you have two real choices. Match links the bank line to a transaction already in QuickBooks, such as an invoice payment or a bill you entered. Add creates a new transaction with the category you choose. Picking Add when a match exists is how income and expenses get counted twice.

Source: Categorize online bank transactions in QuickBooks Online

Check the suggestion, do not just accept it

QuickBooks suggests a category from your past choices and the vendor name. That means one early mistake repeats itself. Read the suggestion, and if a vendor could be two things, such as a hardware store that sells both supplies and equipment, decide once how you will treat it and stick to it.

If the suggestions are more noise than help, you can turn them off in the Bank transactions settings and choose every category yourself.

Source: Categorize online bank transactions in QuickBooks Online

Agree the category list before you start

A category is only useful if it answers a question you or your accountant will ask. Materials, subcontractors, fuel, insurance, software, owner draws. Ten to twenty categories cover most trades. Ask your accountant which ones matter for your return, then add nothing else until a real need shows up.

Owner money is the one to get right first. Money you put in or take out is not income or expense. It goes to equity accounts, and the treatment depends on whether you are a corporation or an LLC.

Source: Owner equity in QuickBooks Online

Let bank rules do the repetitive part

A bank rule applies a category automatically when a transaction meets conditions you set, such as a payee name and an amount range. Go to Accounting, then Rules, then New rule. Make rules for the vendors you pay every month in the same way: fuel, phone, software, insurance.

Do not write rules for vendors that could be several things. A rule that guesses wrong repeats the mistake every month without you seeing it.

Source: Set up bank rules to categorize online banking transactions

A weekly routine that stays small

Pick one day a week. Open Pending, match everything that has a match, categorize the rest, and put anything you cannot place on a short question list for your accountant instead of guessing. Twenty minutes a week beats a weekend every quarter, and the question list is what makes the accountant fast.