Exclude a bank transaction you downloaded into QuickBooks Online
by Intuit•180• Updated 3 months ago
Learn how to exclude a downloaded bank transaction.
From your browser or app, you can connect your bank account and download transactions automatically into QuickBooks. Sometimes, though, you may want to keep a downloaded transaction from going into your company expenses. Here’s how to exclude it and keep your books in order.
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
Step 1: Check if you should exclude the transaction
Before you exclude a downloaded transaction, make sure it’s the right thing to do for your accounting.
When you exclude a transaction, it doesn’t appear in any account registers or financial reports. Depending on the type of transaction, this may make it easier or harder for you to reconcile an account. Here are a couple situations to consider.
If it's a duplicate transaction
If a downloaded transaction is a duplicate of one you already recorded in your books, excluding it makes sense. You can go on to step 2.
If it's a personal expense
If the downloaded transaction is a personal expense, it’s best to add it to QuickBooks, rather than exclude it. Otherwise, your bank account in QuickBooks won’t match your bank statement when you reconcile it.
To avoid recording the transaction as a business expense, many business owners add the transaction to an equity account they’ve created, called an owner’s draw.
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. We can help you find a ProAdvisor.
Step 2: Exclude a downloaded transaction
Once you confirm that excluding a transaction makes sense, here’s how to do it:
Exclude a transaction in QuickBooks Online on the web
- Go to Transactions, then select Bank transactions (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.
Exclude a transaction in QuickBooks Online for Android
- Go to Menu ☰ and select Transactions.
- Select Review transactions.
- Select the transactions to exclude, then select the trash can icon.
- Select Confirm.
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.
Excluding vs. deleting
Once a downloaded transaction is either accepted or excluded, QuickBooks will stop the bank from bringing the transaction into the bank feed again.
If you do not add the transaction and remove it by deleting it, rather than excluding it, the system will recognize the transaction is not accounted for and will download the same transaction again from the bank.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Void or delete transactions in QuickBooks Onlineby QuickBooks•9940•Updated June 19, 2024
- Undo or remove transactions from reconciliations in QuickBooks Onlineby QuickBooks•7239•Updated August 19, 2024
- Record and make bank deposits in QuickBooks Onlineby QuickBooks•4541•Updated June 24, 2024
- Set up bank rules to categorize online banking transactions in QuickBooks Onlineby QuickBooks•5821•Updated June 24, 2024
- Unmatch downloaded bank transactions or move them to another accountby QuickBooks•1185•Updated 1 week ago