How do I exclude or restore a downloaded bank-feed transaction in my accounting software so that it is not posted to the books?

What does excluding a downloaded transaction actually do?

A bank feed copies your bank's transactions into your accounting software and holds each one on a review list until you decide what it is. Intuit's help on excluding downloaded transactions in QuickBooks Online describes what excluding does there: the transaction moves to the Excluded tab of the Banking page, it does not appear in any account register or financial report, and QuickBooks stops the bank from bringing that transaction into the feed again. The same page contrasts this with deleting a line you never added, which QuickBooks treats as not accounted for and downloads again.

What excluding does not do matters as much:

• It does not touch the bank. The feed is a copy, so the transaction stays in the bank's records and on your statement, and the statement balance still includes it.
• It does not record anything. No expense, deposit, transfer or payment is created, so if the transaction was real and nothing else in the books carries it, the books are now missing it.
• It does not remove anything already posted. Exclusion acts on the arriving line, not on a record in the ledger, so it cannot clean up a duplicate already in the books. Intuit's exclusion page notes that if you have duplicate transactions in your books you may need to fix them first, and finding and removing those is a separate question on duplicate bank transactions.

How is excluding different from matching or adding a line?

Every arriving line should end up matched, added or excluded. Of these, only exclusion leaves nothing in the books; deleting a line also records nothing, but QuickBooks downloads it again.

Intuit's help on matching bank and credit card transactions in QuickBooks Online sets the rule for the first two: match when you already entered a record for the transaction, and categorize when you don't have an existing record; matching, the same page says, prevents duplicate entries.

Exclusion is therefore what remains after matching and adding are ruled out, not a third option of equal standing. Pairing lines with existing records, including customer payments against invoices, is covered in the separate question on matching bank-feed transactions.

When is excluding the right choice?

Why you want a line off the list decides whether excluding is safe:

When the reason is that the transaction is already recorded, find the record before you touch the line. Open it and check that the date, payee and amount agree and that it sits in the same bank or card account the line came from; a record in the wrong account leaves this account's book balance out by that amount even though a record exists. If the record is in the wrong account, correct the account on that record first, then match the line to it. Adding the line as well would record the transaction twice, and excluding it would leave this account unable to reconcile. If you cannot find it, the belief that it was recorded was wrong, and the line needs to be added.

What test should a line pass before I exclude it?

Run these checks in order on each line you intend to exclude:

1. Name it. Say who the payee is, what the transaction was for and how much it was. If you cannot, do not exclude it until you find out.
2. Check the statement. Find the transaction on the statement, or in the bank's online account activity if the statement is not out yet, and count how often it appears there and in the feed. Once there and twice in the feed means one feed line is an extra copy.
3. Find the record. If you believe it is already in the books, open that record rather than relying on memory, and confirm its date, amount, payee and account.
4. Prefer a match. If the record exists and no other copy of this line is matched to it, match this line instead of excluding it.
5. Write down the reason. Note why no record is needed and where the existing record is, before you click Exclude.

If the bank cleared the transaction and step 3 finds nothing, add it. Exclusion is right only when step 3 finds the transaction already carried in this account's records. If the bank shows no such transaction at all, do not add it; leave it on the list until you know why the feed shows it.

Excluding a line because it is unfamiliar or unwanted is the most damaging use of the button, because it hides a missing record behind a clean review list. The IRS, in Publication 583, notes that your records can identify the source of your receipts, and that you may forget expenses when you prepare your tax return unless you record them when they occur. An unexplained deposit excluded today is money in the account with no record of where it came from; an excluded expense is a cost the books never show. Intuit's exclusion page says QuickBooks Online does not bring an excluded line into the feed again, so the feed will not remind you of it; usually the first sign is a reconciliation that will not tie.

What does an exclusion do to the bank reconciliation?

Intuit's reconciliation help for QuickBooks Online defines reconciling as matching the transactions you have entered in QuickBooks with your bank and credit card statements. An excluded line is not a transaction entered in the books, so there is nothing to tick off, while the statement still includes every transaction the bank cleared. Intuit's exclusion page says that, depending on the type of transaction, excluding may make reconciling easier or harder. It is harder whenever the excluded line was the only copy of a real transaction.

Here is how the gap shows. A checking statement ends at 12,480.00 after a genuine 250.00 debit for an equipment repair that was excluded because nobody recognized the payee. Everything else is recorded, so the books show 12,730.00. The reconciliation is out by exactly 250.00, and stays out in every later period, until the debit is recorded.

Whether the period is already reconciled changes what an exclusion touches: a line in a reconciled period is handled as in the table above, and a line in the current period affects only the reconciliation still to come. Working through a reconciliation that will not balance is a separate question.

What changes when the account carries personal spending too?

Intuit's exclusion page says a personal expense downloaded into QuickBooks Online is best added rather than excluded, because otherwise your bank account in QuickBooks won't match your bank statement when you reconcile it. The arithmetic is the same as above: the bank balance includes the personal purchase, so a book balance without it is off by that amount, and by every personal item excluded after it. That difference never clears on its own.

How to record the personal item, including which account it goes to and any tax effect, is not a bank-feed decision; the same Intuit page says to check with your accountant or bookkeeper if you're not sure how to handle a personal expense.

How do I exclude several lines at once without losing real transactions?

Both platforms exclude in bulk from the review list. Intuit's exclusion page has you select the checkbox of each transaction to exclude and then select Exclude. Zoho's Exclude Transactions FAQ has you tick the transactions on the Uncategorized Transactions tab, enter the reason in the Reason field and click Exclude All.

Bulk exclusion clears a backlog, for example when a newly connected feed brings in lines from a period already reconciled or covered by the balance the account started from, or a feed delivers a batch twice. It is also how real transactions disappear in quantity. Before you exclude a range, make these checks:

• Narrow the selection to the account and date range you mean rather than ticking every line on the page.
• Compare the count and total of the lines you plan to exclude with what already carries them: the reconciled records or the starting balance for lines from an earlier period, or the first copies for a batch the feed delivered twice. If lines from an earlier period have records that are not yet reconciled, match those lines instead of excluding them, following Intuit's matching rule. Exclude the extra copies of a duplicated batch only once the first copies are matched or added.
• Read every selected line for anything that does not belong, such as a deposit inside a run of duplicate card charges.
• Right after excluding, open the excluded list, confirm the same count and total, and restore anything that should not be there.

Where do excluded lines go, and how do I restore one?

In QuickBooks Online, Intuit's exclusion page says excluded transactions sit on the Excluded tab of the Banking page. To bring one back, select the Excluded tab, select the checkbox for the transaction, then select Undo. The transaction goes back to the For review tab, which the same page's exclusion steps call the Pending tab, so you can decide what to do with it again.

In Zoho Books, Zoho's Exclude Transactions FAQ says you list the lines you excluded by clicking the down arrow next to Uncategorized Transactions and selecting Manually Excluded (Zoho's Other Actions page calls the same view Excluded, and neither page is dated, so the label on your screen may differ). Zoho's Other Actions in Banking help says you restore one by selecting it and clicking the Restore button in the right pane. The same page says transactions restored in bulk are added back to Uncategorized Transactions.

Once a restored line is back on the review list, give it the disposition the test calls for. A wrong exclusion can be repaired in one of two ways:

• Restore and dispose. Bring the line back and match or add it. The bank line and the record end up linked, and there is only ever one record.
• Leave it excluded and record directly. Enter the transaction in the account yourself. The books are right, but the excluded line still looks like a decision not to record, so update your note to say where the record is, and never later restore and add the line as well, or the transaction will be in the books twice.

Prefer the first route while the line is still in the excluded list. Intuit's exclusion page and Zoho's Other Actions page describe restoring only from the excluded list and state no time limit or condition. Neither says what happens to excluded lines if the bank connection is removed, so restore while the line is still there and do not exclude on the assumption that any mistake can be undone later.

What does the software record about an exclusion, and what should I note?

Zoho Books asks for a reason: Zoho's Exclude Transactions FAQ has you enter the reason for excluding in the Reason field as part of the exclusion. Neither that FAQ nor Zoho's Other Actions page says where that reason can be read later or whether Zoho Books records who excluded the line, so keep the note below on either platform. Intuit's exclusion steps for QuickBooks Online ask for no reason, so keep it yourself. Intuit's audit-log help for QuickBooks Online says the log tracks all account activities, displays the date of each change and the user who made it, and keeps events available for two years. After you exclude something, filter the audit log by user and date (the same page says the log needs admin access; if you can't see it, ask your primary admin) to see how the exclusion appears; if you cannot find it there, your own note is the only record of who excluded the line and why.

An exclusion is a decision not to record something the bank did, and without a reason it looks the same as a mistake. For each exclusion, or each batch, note these details:

• The date, payee and amount, or the count and total for a batch
• The reason, in the terms of the test above
• Where the record that carries the transaction is, by date and number or reference
• Who decided, and who reviewed it

Keep the note where a later reviewer will look, such as the memo of the existing record or a dated exclusion log filed with the month's reconciliation. Using the audit log to trace deleted or altered posted transactions is a separate question.

How often should I review the excluded list?

Treat the excluded list as a population to review, not a bin. At each reconciliation, read the lines excluded since the last review, check each against its note, and restore any line with no reason or no record behind it. In Zoho Books, check the automatic exclusions too: Zoho's Exclude Transactions FAQ says Zoho Books will automatically exclude duplicate transactions in your bank statement, and lists them under Automatically Excluded in the same dropdown. Two genuine identical charges on the same day can look like a duplicate, so confirm each against the statement before leaving it excluded.