Categorise online bank transactions in QuickBooks Online
SOLVED•by QuickBooks•95•Updated 4 days ago
Learn how to categorise transactions uploaded to QuickBooks Online.
Review categories for automatically downloaded transactions when you connect your bank to QuickBooks Online. QuickBooks suggests categories based on how you categorise similar transactions.
Download the latest bank and credit card transactions
For most banks, we try to refresh transactions every 24 hours. You can also manually update your accounts anytime:
Go to Transactions and select Banktransactions (Take me there).
Select Update.
This updates the transactions on all of your 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.
If you have trouble downloading your transactions, you can try other options.
Note: QuickBooks recognises common suppliers from your bank transactions, and will automatically add new suppliers into your account. Turn this option off if you don’t want new suppliers added. In Bank transactions, go to Settings ⚙ and turn off Add new suppliers.
Review and categorise downloaded transactions
Go to Transactions and select Banktransactions (Take me there).
Select the For review tab.
Select the account you want to review.
QuickBooks sends downloaded transactions to the For review tab, and suggests categories for each transaction. Review them one by one:
If the transaction says Add:
Select Add if the suggested category is correct.
Change the category by choosing one from the dropdown or adding a new one.
Note: You can create a bank rule that automatically categorises transactions for you. You can also turn suggestions off if you want to manually categorise your transactions. In Bank transactions, go to Settings ⚙ and uncheck Enable suggested categorisation.
Duplicates may sometimes occur when transactions automatically update from your bank after you’ve manually uploaded them. In these cases, you might want to exclude them.
Go to Transactions and select Banktransactions (Take me there).
In 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. If you excluded a transaction by mistake, from the Excluded tab, find the transaction and select Undo.
If you spend money on a personal transaction using a business account, that’s anowner’s draw. If you add personal money to a business account, that’s an owner's investment.
QuickBooks has partnered with selected banks to include check images for check transactions.
To view the check images:
Go to Transactions and select Banktransactions (Take me there).
In the For review tab, select the transaction you want to view the check image for. Note: Transactions with an attached image will have a number in the Add attachment column.
Select the image name, then view the check image in the Explore sidebar.