How to Categorize Bank Transactions in QuickBooks Online

Quick Answer: Open Bank transactions in QuickBooks Online, pick the account, and work the review list (labelled For review in older layouts and Pending in newer ones). For each line, choose a category and select Add or Post, or select Match when the payment is already in your books. Create bank rules for payees that repeat, and tick several lines to handle them in one batch.

To categorize bank transactions in QuickBooks Online, you decide one thing per downloaded line: is this new activity that needs an account, or is it a copy of something you already recorded? New activity gets a category and is added; existing activity gets matched. Rules and batch actions then cut the repetitive part, so most of your time goes to the handful of lines that are genuinely ambiguous.

Which action fits each transaction?

Before touching the dropdowns, sort the line into one of these buckets. Picking the wrong bucket is the main source of double-counted income and phantom expenses.

Where is the review list in QuickBooks Online?

Intuit's help article on categorizing and matching online bank transactions gives the path as All apps > Accounting > Bank transactions. Select Update to pull anything new, choose the account tile at the top, then open the review tab. Intuit has renamed parts of this screen over time, so your file may show For review with an Add button, or Pending with a Post button. They do the same job.

QuickBooks suggests a category for each line based on how you handled similar transactions before. Treat the suggestion as a draft. On a new company file it is often a guess built from the merchant name, and a guess posted without a glance is how a hardware store run ends up in Meals.

How do you choose the right category?

The category is an account from your chart of accounts. A few habits keep the choice consistent:

• Decide by what the money bought, not who it went to. Amazon can be office supplies, inventory or a personal item. The payee does not settle it; the receipt does.
• Use the payee field as well as the category. Filling in the vendor or customer makes later reports by name possible, and it is what bank rules key on.
• Keep owner money separate. If you pay yourself or put money in, use the owner's draw or equity accounts your accountant set up, not an expense.
• Turn on item tracking only if you need it. Intuit's article explains that you can show an items table on expense forms via Settings > Account and settings > Expenses, which adds a Product/service dropdown to bank lines.

If you are unsure which account a type of spending belongs to for tax purposes, the IRS page on deducting business expenses is a sensible reference, and our guide to bank statement deduction categories maps common lines to Schedule C style headings.

When should you match instead of add?

Match whenever the transaction already exists in QuickBooks. That happens more than people expect:

• You sent an invoice and the customer paid it. The deposit should be matched to the invoice payment, otherwise income is counted twice.
• You wrote a check in QuickBooks before it cleared. The cleared amount should be matched to that check.
• You entered a bill and paid it. The payment should match the bill payment.
• A card payment was recorded from both the checking side and the card side. Match one to the other as a transfer.

When QuickBooks finds a likely candidate, the line shows a match suggestion. If it finds none but you know the record exists, open the line and search for it before falling back to Add. Adding instead of matching leaves the invoice open in Accounts Receivable and inflates income, a problem that only surfaces at reconciliation.

How do you split one charge across categories?

A warehouse club receipt might cover office supplies, cleaning products and a client gift. Per Intuit, select the line in the review tab, choose Split, pick a category on each row, and enter amounts until the Difference reads $0, then select Split and add. Keep the receipt; a split is only as good as the paper behind it.

Setting up bank rules for repeat payees

Rules are where categorizing stops being daily work. Intuit's community article on setting up bank rules describes the flow:

1. Go to All apps > Accounting > Rules, then select New rule.
2. Name it something you will recognize in six months, such as "Gusto payroll fees".
3. Choose Money in or Money out, and either one bank account or all of them.
4. Add conditions on Description, Bank text or Amount using Contains, Doesn't contain or Is exactly. A rule can hold up to five conditions.
5. Set what QuickBooks should fill in: transaction type, category, payee, and any class or customer.
6. Leave Auto-post off at first. Once the rule has been right for a month, turn it on so matching lines post without review and show an AUTO badge.

Two details trip people up. Rules run in priority order, so a broad rule ("contains AMAZON") placed above a narrow one ("contains AMAZON WEB SERVICES") will win every time; drag the specific rule higher. And Intuit notes that Bank text is the raw text from the bank while Description is a cleaned-up version, so a rule built on the wrong one may never fire.

Working through the backlog in batches

If you have a few hundred lines waiting, do not open them one by one. Filter the list by description or amount, tick the boxes for lines that share a category, and use the batch action menu to accept or update them together. Use the same menu to exclude a block of obvious duplicates. A practical order:

1. Exclude true duplicates and holds first, so they stop cluttering the list.
2. Match everything that has a suggested match and looks right.
3. Batch-categorize the repeat payees, then write rules for them.
4. Handle what remains one line at a time.

What if a transaction is already posted to the wrong category?

Open the Categorized (or Posted) tab, find the line and choose Undo. It goes back to review, and you can recategorize or match it properly. Undo is cleaner than editing the expense directly because it keeps the link between the bank line and the record. If the period has been reconciled, talk to whoever closed the books before changing it; edits to reconciled transactions break the reconciliation.

What about months the bank connection never downloaded?

A bank connection usually brings in only a limited stretch of history, and some accounts cannot connect at all. For those gaps, QuickBooks accepts a file through Link account > Upload from file. If all you have is the PDF statement, a converter such as QuickBankConvert turns it into a .QBO or CSV upload file (QBO output is on the paid plans); see converting PDF statements to QBO. Uploaded lines land in the same review list and get categorized exactly as described above. Check the date range against what is already in QuickBooks before uploading, because overlapping dates create duplicates you will then have to exclude.

Our walkthrough on importing bank transactions into QuickBooks Online covers the upload itself, column mapping and file limits.

Related guides

• Import bank transactions into QuickBooks Online
• How to categorize bank transactions in a spreadsheet
• Bank statement deduction categories
• How to reconcile in QuickBooks Online
• QuickBooks integration overview