After you’ve connected your bank or downloaded your latest transactions, it’s important to make sure that everything is where it needs to be.
This page will everything you need to know about finding and categorising (viewing, matching, adding, and excluding) your transactions from both QuickBooks Online and the QuickBooks Mobile App. |
Selecting the following headings to find what you need.
Find your transactions
QuickBooks downloads the latest available transactions every day - the specific time depends on your bank. You can also manually update your accounts anytime to get the latest available transactions:
- Go to Bookkeeping, select Transactions, then select Bank transactions (Take me there).
Select the bank account or credit card tile that you want to search.
- Newly downloaded transactions will be in the For review tab.
- Recently categorised transactions will be in the Categorised tab.
- If you mark a transaction as personal or a duplicate, it goes to the Excluded tab. QuickBooks won't add excluded transactions to your accounts. If you want to include it, select Undo from the Action column.
Can’t find the transaction you’re looking for?
Check your Account History where you can use filters to speed up your search.
- Go to Bookkeeping and select Chart of accounts (Take me there).
- Find the account you want to review. Then, in the Action column, select Account history.
- Select the Filter icon and select the filters you want to apply. You can use the Find field to search by amount, reference number, or memo.
- To remove a filter, select the X next to the filter name.
- Select Apply.
You can also edit each transaction from here.
- Find and select the transaction in the account register to expand the view.
- Make changes to the available fields.
- If you want to change something that is greyed-out, select Edit to open the full transaction form where you can make additional changes.
- When you're ready, select Save or Save and close.
Note: If the transaction you want to edit is marked with the letter R, this means the transaction has already been Reconciled. In order to edit it, keep clicking on the field with the letter until the field becomes blank. Then select Save. You will now be able to edit this transaction.
Check your uncategorised accounts.
If you don’t categorise transactions into specific accounts, QuickBooks puts them into the Uncategorised Income or Uncategorised Expense account. To check these accounts:
- Go to Bookkeeping and select Chart of accounts (Take me there).
- Look for the Uncategorised Income or Uncategorised Expense accounts.
- Select Run report.
- Look for your missing transaction in the report.
Categorise your transactions
Select if you're in QuickBooks Online on your laptop
You can match, add, view, or exclude multiple matches from the For Review tab.
Match: All you have to do it make sure we've got it right
This means QuickBooks has matched the downloaded transaction with the one you've already entered. This links them together so you don't get duplicates.
- Find a downloaded transaction with the Match option in the Action column.
- Note the Date, Description, Payee, and amount spent or received.
- Select the downloaded transaction to expand the view.
- Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
- Select the link next to each match to get more details.
- Make sure this is the correct match. In particular, review the Deposit to, Payment method, or Bank account fields on forms for the existing transaction in QuickBooks.
- If this is the correct match, close the open transaction.
- Select Match.
If you notice one, you can learn how to account for bank fees when matching transactions here.
Add: just make sure we haven't missed anything, then approve the addition
This means QuickBooks didn’t find an existing matching transaction. Instead, it started a brand new transaction for you using the info from your bank or credit card.
- Find a downloaded transaction with the Add option in the Action column.
- Select the transaction to expand the view.
- Review the recommended Category. This is the account QuickBooks wants to categorise the transaction into. For example, for a petrol expense, QuickBooks may suggest categorising it under expenses related to travel. You can always change the category and put it in a different account.
- Change the supplier or customer as needed. Note: If you think you already entered this transaction into QuickBooks, select the Find match option. Review the list of possible matches and select one if you find it.
- Review and add any other information that may be mandatory or missing.
- When everything looks good, select Add.
View: you only need to pick the right one
View means QuickBooks found more than one potential match.
- Find a downloaded transaction with the View option in the Action column.
- Select View.
- Review the Matching records found in QuickBooks. These are the possible matching transactions you already entered in QuickBooks.
- Select the link next to each match to get more details.
- Make sure one of these is a match. In particular, review the Deposit to, Payment method, or Bank account fields on forms for the existing transactions in QuickBooks.
- Note: The fields you see may differ depending upon the transaction you are matching.
- Compare the potential matches.
- When you find the correct match, close the open transactions.
- Select the correct match and then select Match.
Exclude: if it's a personal expense, or a duplicate transactions, excluding it just makes sense
As always, check with your accountant or bookkeeper if you’re not sure how to handle a personal expense or any other type of transaction.
- Go to Bookkeeping, select Transactions, then select Banking (Take me there).
- Select the For Review tab.
- Select the checkbox of the transactions to exclude.
- Select Exclude.
The transaction moves to the Excluded tab of the Banking page.
Tip: If you accidentally exclude the wrong transaction, that’s easy to fix. Just select the Excluded tab, select the checkbox for the transaction, then select Undo. The transaction goes back to the For Review tab so you can decide what to do with it again.
Select if you're in QuickBooks Online on your mobile device
Here, you can match, categorise, review, or exclude your transactions on the go.
Match: scan already matched transactions and approve them
- Select Banking and choose a bank. You can use the list icon to get a better view of all connected accounts.
- Select New Transactions. This will bring up a list of suggested matches. If a match is correct, swipe right to accept it. If you want to see transaction details, select the transaction.
- If there's just one match and it's correct, select Accept.
- If there are multiple matches, choose the correct one, then select Accept.
- If none are correct, search to find other possible matches. Choose the correct one, then select Accept.
Categorise: put your transactions in the right place
- From the Menu ☰, select Transactions and the bank you want to work with.
- Select the transaction you want to categorise.
- Depending on your mobile device:
- iOS: Tap > beside a field, select an option, and then select Accept.
- Android: Under Category, tap >, select a category, and then select Confirm.
- Select Accept.
Review: just look over what we've done and make quick changes if necessary
- From the Menu ☰, select Banking.
- On the iPad, if you have multiple accounts, select the drop-down arrow to see your list of bank accounts, then you can choose the one you want.
- Select New Transactions.
- Select Recognised to review transactions QuickBooks Online has already recognised, categorised, and matched for you.
- If the transaction is correctly categorised and matched, swipe right to accept it.
- If the transaction is incorrectly categorised and matched, select the transaction and make the necessary changes.
- Select Accept.
- Select All to see any remaining, uncategorised transactions.
- Select the transaction, then review and add categories as necessary.
- Select Accept.
Exclude: if it's a personal expense or a duplicate transactions, excluding it just makes sense
Exclude a transaction in QuickBooks Online for IOS
- Go to Menu ☰ and select Transactions.
- Select Review transactions.
- Select the transactions to exclude, then select the trash can icon.
- Select Exclude.
Exclude a transactions in QuickBooks Online for Android
- Go to Menu ☰ and select Transactions.
- Select Review transactions.
- Select the transactions to exclude.
- Select Exclude.
- Select Confirm.
Next steps
It's always a good idea to plan for every scenario. Learn how to fix common bank and transaction errors like duplicate transactions and transaction feeds that aren't updating.
To save some time in the future, you can set up bank rules to categorise online banking transactions in QuickBooks Online. The more QuickBooks uses your rules, the better it gets. After a while, it can even scan transactions and add details like payees!
We're here to help
If you need additional help or have questions, or you require assistance at any point in this process, our Customer Success team is happy to help.
Sign in to QuickBooks and start a discussion in our QuickBooks Community or join one of our Facebook Groups to connect with other like-minded QuickBooks customers.