Categorize online bank transactions in QuickBooks Online (2024)

Learn how to review downloaded bank and credit card transactions.

After you connect your bank and credit card accounts QuickBooks automatically downloads the latest transactions and suggests categories for these transactions based on how you, and other customers, categorized similar transactions. This helps identify tax deductions and tells you where your business makes and spends money.

Note: QuickBooks Online won’t download pending transactions. It only downloads transactions when they’re no longer pending and are officially posted on the bank site.

To watch more how-to videos, visit our video section.

Step 1: Download the latest bank and credit card transactions

For most banks, we try to refresh the latest available transactions every 24 hours. Some may take a little longer. You can also manually update your accounts anytime:

Go to Transactions, then Bank transactions (Take me there).
Select Update.

This updates all of your bank and credit card accounts.

Tip: If you see a message about additional authentication, follow the prompts to continue the update. Not all banks require this, but some do for added security.

Here's what to do if you have trouble downloading your transactions.

Step 2: Review and categorize downloaded transactions

If you don't want to automatically add common vendors

The option is on by default, but may create unnecessary vendors if not turned off.

The switch is found in theFor reviewsettings forBanking.

Select ⚙️.
Turn offNew vendorsforAdd automatically.

No new transactions you download should auto-create vendors. Turn back on to auto-create vendors for newly downloaded transactions.

How to choose the right category

Categorize income—money that was paid to you—to show where the money came from, like sales, customer payments, and refunds. The business might also receive money if you sold a fixed asset, received a bank loan, or you invested in the business.
Categorize expenses—money paid to others—to explain how money was spent, for example, on office supplies, meals, payroll, taxes, and fixed assets. If you pay yourself (called an Owner pay or Owner draw), this “equity transaction” is also considered an expense for the business.

Split transactions between multiple categories

You can split transactions between multiple categories for better tracking.

In the For review tab, select the downloaded transaction to expand the view.
- If the option in the Action column is Match, change the Find match to Categorize.
Select Split (Accountant view) or Split transaction next to Category (Business view), which opens the Split transaction window.
From Category▼, select the categories you want to split the transaction into.
Enter an Amount for each split.
Select a Vendor or Customer name for each split.
Note: The fieldname may vary depending on the transaction.
When you're done, select Apply and accept.

Exclude duplicate transactions

It’s rare, but you might find duplicate transactions in your bank feed. This generally happens if there is an issue with your bank connection so you upload the transactions yourself, and then a second (duplicate) copy is later downloaded from the bank. If this happens, you should exclude the duplicates.

Go to the For review tab.
Select the checkbox for each transaction you want to exclude.
Select Exclude.

Excluded transactions move to the Excluded tab. They won’t be added to QuickBooks or downloaded again.

Categorize personal transactions done with a business account

It’s a best practice to use personal accounts for personal transactions, and business accounts for business transactions, but sometimes you may end up with a personal transaction you need to account for. Don’t worry — there’s a way to do this.

If you spend money on a personal transaction using a business account, that’s an owner’s draw: you (as the owner) drew money out of the business, and used it to buy something for yourself. If you add personal money to a business account, that’s an Owner Investment.

View images for check transactions

QuickBooks has partnered with a number of banks to automatically include front and back check images for any check transactions awaiting review. This can make it easier to review, categorize, and match transactions.

If you've already connected QuickBooks to a participating bank, the check images load automatically, and no further action is required.

To view the check images:

In the For review tab, select a downloaded transaction that shows a number in the Attachment column. (In Business View, you’ll just see the.)
In the transaction details, select one of the Check Image attachments to view the image.
In the image panel that appears, you can view the front and back of the check, and expand the image to full screen.
Review the transaction as normal. If you match or add the transaction, you can later find the images in your Attachments list, under Settings ⚙. They will also be attached directly to the transaction form itself.

Note: If your connected bank transactions don’t have check images automatically attached, your bank is not supported. However, it may be supported at a later date as we work to partner with more financial institutions.

After you categorize or add downloaded transactions, you can match online bank transactions in QuickBooks Online.