Guides · Updated 2026-10-13

How to Categorize Bank Transactions in QuickBooks Online

Getting transactions into QuickBooks is only half the job. Each one then needs a category so your reports, and later your tax figures, mean something. Doing it by hand gets slow, which is where bank rules help. This page explains the workflow using QuickBooks' own bank-rules help page, plus a simple category list for a freelancer's books.

Based on a QuickBooks help article we read in the South African edition. Menu names, tab names (for example Pending or For review) and options differ by country and change over time, so treat this as a map and check the labels in your own account.

The basic workflow

1. Get the transactions in. Connect your bank, or upload a file if you cannot connect. If your bank's CSV needs reshaping first, see how to import bank transactions into QuickBooks Online and bank feed vs CSV upload.
2. Review them regularly. QuickBooks says rules apply to transactions waiting for review and suggests looking at that tab daily; weekly works for most freelancers.
3. Categorize, match or exclude. Give each transaction a category, match it to an invoice or bill you already entered, or exclude it if it should not be in your books (for example a duplicate).
4. Turn repeat patterns into rules so you stop doing the same ones by hand.
5. Reconcile against your statement at month end.

Set up a bank rule

According to QuickBooks' bank-rules article:

1. Go to Accounting, then Rules, then the Bank rules tab and New rule.
2. Name the rule.
3. Choose whether it applies to Money in or Money out, and which bank account (or all accounts).
4. Choose whether All or Any of your conditions must match.
5. Add conditions. A rule can have up to 5. Each one checks Description, Bank text or Amount using Contains, Doesn't contain or Is exactly, plus a value.
6. Choose what the rule sets: transaction type, category, product/service, payee, tax and customer. The options you see depend on your company settings.
7. Save.

You can also start a rule from a transaction in the review list by choosing Create rule, which fills in the details for you.

Description or bank text?

QuickBooks explains that bank text is the information received from the bank, as shown on your statement, while description is a simplified version, such as only the supplier name. If a rule is not matching, check that you used the right field. QuickBooks suggests turning on Show full bank description in the Bank transactions settings to see the full text.

Rule order and auto-post

Rules are applied in priority order: drag them to reorder, and the rule with the highest priority is applied first, so put the most specific rules at the top. An auto-post option adds matching transactions automatically instead of leaving them for review. QuickBooks says auto-post rules run when you sign in, upload a file, or create or change an auto-post rule, and suggests starting with simple, consistent transactions such as rent or fuel. A caution of our own: auto-post means nobody looks at the transaction, so keep it for payments that are the same every time, and spot-check the results each month.

A simple category list for a freelancer

Your accountant may want specific accounts, but most solo books need only a handful:

• Income: one account per main service or product line.
• Software and subscriptions, equipment, advertising and marketing, professional fees, travel, office or workspace, bank and payment fees, insurance.
• Owner draws or transfers: money you move to yourself is not an expense. Moving money between your own accounts is a transfer, not income or expense.
• Tax payments: estimated tax payments are not a business expense either; track them separately so they do not distort your profit.

Profit is income minus business expenses, and it is the base for your self-employment and income tax. Once your books are categorized, plug your profit into the tax set-aside calculator to see how much to move to savings.

Common mistakes

• Categorizing everything as "ask my accountant." It is better to pick the closest category and fix it later.
• Letting transactions pile up. A month of uncategorized items takes far longer than a week's worth.
• Mixing personal and business spending. Use a separate account if you can.
• Rules that are too broad. A rule on "Amazon" will catch both office supplies and personal buys; add an amount or other condition.

When your bank will not connect

If your bank is not supported, you will be categorizing from uploaded files. StatementSnap is a free browser tool we make that converts a bank CSV into the layout QuickBooks accepts (free for the first 25 rows; your file is not uploaded anywhere). See also the bank CSV import errors checklist if an upload fails. Review the converted file before importing.

FAQ

Can QuickBooks categorize bank transactions automatically?

Yes, with bank rules. QuickBooks applies the rules you create to transactions waiting for review, and an auto-post setting can add matching ones without review. Start with simple repeating payments.

How many conditions can a rule have?

Up to 5, according to the QuickBooks article we read.

What if a rule picks the wrong category?

Reorder the rules so the most specific is first, add a condition such as an amount, or disable the rule and categorize by hand.

Sources

• QuickBooks: Set up bank rules to categorize online banking transactions (read 2026-10-13)

Disclosure: we make StatementSnap, which is linked above, and used AI assistance to write this guide. We are not affiliated with Intuit or QuickBooks. Not accounting or tax advice. QuickBooks can change its rules and menus; follow its current help pages.