How to Erase a Bank Download in QuickBooks

(Image: BananaStock/BananaStock/Getty Images)

Many QuickBooks customers choose to use online banking services to move funds and access financial information from within the QuickBooks interface. One benefit of online banking is the ability to download bank transactions such as checks and deposits, freeing the user from having to record these transactions manually. Problems can occur, however, when a user does record one or more transactions and then performs a bank download. The easiest way to prevent these duplicate transactions from appearing in the account is to erase a bank download in QuickBooks.

Things You'll Need

  • QuickBooks Pro, Premier, or Enterprise
  • Bank records


Open the Online Banking Center from the QuickBooks main menu. View the Online Banking Center “Items Received” list on the left side of the screen.

Verify bank transactions. QuickBooks does not automatically add downloaded transactions to your register. All transactions have a status of “Unmatched” until you click the “Add Transactions” button. Verify the date, payee (description), check number and amount before adding any transaction.

Erase duplicate downloads. Press the “Select Items to Delete” button at the bottom of the window and select one or more transactions to erase, and then click the “Delete Selected” button.

Add remaining transactions, if any, to your QuickBooks register. To ensure transactions map to the appropriate account, select them one at a time versus adding all transactions as a batch. For an expense payment, select the transaction, select the appropriate account, such as “Supplies,” “Advertising,” or “Meals and Entertainment” from the drop down list, and then click “Add to QuickBooks” to send the transaction to your register. For a Vendor payment, place a checkmark next to the invoices you are paying with the check. For a deposit, ensure the “From Account” is correct. Complete this process for all remaining transactions.

Tips & Warnings

  • If you do not have QuickBooks set up to automatically connect to your bank and download transactions when you log on, perform a manual download by clicking “Send/Receive Transaction” from the Online Banking Center menu. Enter your personal identification number (PIN), and then click “OK” to connect to your bank and download transactions.
  • Checks may not always appear in your bank download as you wrote them, so always verify before accepting a bank download. For example, you may use your debit card to pay for gas at the Marathon gas station and record it that way, but if the gas station is part of a chain, the transaction may clear your bank as Mobil Oil #213.

Related Searches


  • “QuickBooks 2009: The Official Guide”' Kathy Ivens; 2009
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Are You Really Getting A Deal From Discount Stores?

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!