How to Categorize Bank Transactions in QuickBooks Online
Jul 20, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Last updated July 2026.
To categorize bank transactions in QuickBooks Online, open Transactions then Bank transactions, work the For review tab, and for each line either accept the suggested account, pick your own category, or match it to a transaction you already entered. Bank rules code your recurring payees automatically, so after the first month you mostly review exceptions. In QuickBooks a "category" is an account from your chart of accounts, so categorizing well is really about sending each transaction to the right account before you reconcile.
The step most people underestimate is getting the transactions into QuickBooks at all. A live bank feed handles a connected checking account, but it will not reach a closed account, a business account the feed refuses to link, a statement older than the feed goes back, or a PDF your accountant forwarded. In those cases you import a file, and the cleanest way to produce one is to convert the PDF bank statement to a spreadsheet and save it as a QuickBooks-ready CSV.
How do I categorize transactions in QuickBooks Online?
To categorize transactions in QuickBooks Online, go to Transactions, then Bank transactions, and open the For review tab. Every downloaded or imported line lands here first. Click a line to expand it, confirm the payee, choose the account (the category), check the tax treatment, and select Add to post it to the books. QuickBooks suggests a category for most lines, but the suggestion is a guess, so read it before you accept. Nothing hits your reports until you review a line out of For review.
Each line in the For review tab is really one of four decisions:
| Action | When to use it |
|---|---|
| Categorize (Add) | A brand new transaction. Assign the account and payee, then Add so it posts to that account. |
| Match | The transaction already exists in QuickBooks (an invoice payment, a bill you paid, an expense you keyed). Match links the bank line to it instead of creating a duplicate. |
| Record as transfer | Money moving between two of your own accounts, or a credit card payment. Post it as a transfer so it never counts as income or expense. |
| Exclude | A duplicate, a personal charge, or a line that does not belong on the books. Exclude removes it from review without posting. |
Getting these four right is most of the job. The single most common bookkeeping error is treating a transfer or an owner deposit as income, which inflates revenue and the tax bill that follows.
What does it mean to categorize a transaction in QuickBooks?
Categorizing a transaction in QuickBooks means assigning it to an account from your chart of accounts, such as Advertising, Office Supplies, or Contractor Payments. That account is what QuickBooks calls the category, and it decides where the amount shows up on your profit and loss and your tax return. Pick the account that matches how you file, confirm the payee so vendor totals stay clean, and set the correct tax rate if you track sales tax. The category, not the bank description, is what your reports read.
A useful habit is to name your chart of accounts after the lines on your tax form. If you file a Schedule C, mirror its expense lines so year-end totals drop straight onto the form without remapping. The way you categorize transactions from a bank statement should line up with your return, because that is what makes the numbers tie out in April.
How do I set up bank rules to categorize automatically?
Bank rules tell QuickBooks to code a transaction the moment it matches conditions you set. Go to Transactions, then Rules, and create a rule with up to five conditions on the description, the bank text, or the amount, using Contains, Doesn't contain, or Is exactly. Point the rule at an account, a payee, and a tax rate, and every future match arrives pre-filled so you only click to confirm. Turn on "Auto-add" and qualifying lines post without a review click at all.
Build one rule per recurring vendor, name them clearly, and add a rule that sends account-to-account moves and owner draws to a transfer account so they never touch income. Teams that keep a tight rule set auto-code the large majority of recurring lines and spend their time only on the exceptions. If receipts drive a lot of those charges, it is often cleaner to code the spend before it reaches the bank feed at all: a dedicated expense management platform reads the receipt behind each purchase and assigns the category up front, leaving less to sort at reconciliation.
How do I bulk categorize transactions in QuickBooks Online?
To bulk categorize in QuickBooks Online, open the For review tab, tick the checkbox on several transactions that share a category, and a batch action bar appears at the top. Set one payee and one account, then Accept, and all the selected lines post at once. It is the fastest way to clear a backlog: sort or filter the list so identical payees group together, select the group, and code them in a single action. Pair it with bank rules and most of a busy month clears in a few passes.
How do I categorize a statement QuickBooks will not connect a feed to?
When QuickBooks cannot pull a feed, you import the statement as a file. QuickBooks Online reads a CSV with a Date column, a Description column, and either one Amount column or split Credit and Debit columns. Convert the PDF statement to that shape first, upload it under Transactions, Bank transactions, Upload from file, map the three columns, and the rows land in the For review tab exactly like feed data. From there you categorize them the same way. One upload handles any US bank or card with the bank statement converter, which matters when the feed only reaches back a few months but you need a full year for taxes or a loan. This is also the fix when the feed stalls at 90 days: see why QuickBooks only imports 90 days of transactions.
Xero and other ledgers
The workflow travels. If your books live in Xero instead, the mechanics differ but the discipline is identical: import the statement, code each line to an account, and let rules handle the repeats. The guide to categorizing bank transactions in Xero walks through Cash Coding and Xero bank rules, and importing bank transactions into QuickBooks Online covers the upload step in detail. Whatever the ledger, categorize to the accounts you file on and your reports stay honest.
Frequently asked questions
Can QuickBooks Online categorize transactions automatically?
Yes, through bank rules. Create a rule under Transactions, Rules that matches a payee or description and points to an account, and QuickBooks pre-fills the category on every future match. Turn on auto-add and qualifying transactions post without a review click. QuickBooks also suggests categories on its own, but a suggestion is a guess you should confirm before accepting.
What does categorize mean in QuickBooks Online?
Categorizing means assigning a transaction to an account from your chart of accounts, such as Office Supplies or Advertising. That account is the category, and it controls where the amount appears on your profit and loss and tax return. You set it in the For review tab when you add or match each bank line.
How do I bulk categorize transactions in QuickBooks Online?
Open the For review tab, select the checkbox on several transactions that share a category, then use the batch bar at the top to set one payee and account and click Accept. Sort or filter first so identical payees group together, and combine it with bank rules so recurring lines are already coded before you start.
Why are my bank transactions not showing in QuickBooks Online?
Usually the feed only reaches back a limited window, often about 90 days, or the account will not connect at all. In that case download the statement as a PDF, convert it to a CSV with Date, Description, and Amount columns, and upload it under Transactions, Bank transactions, Upload from file. The rows then appear in the For review tab to categorize like any feed data. Watch for internal money movements while you work: learn how to categorize transfers between bank accounts so a transfer or card payment never lands in income or expenses by mistake.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required