cancel
Showing results for 
Search instead for 
Did you mean: 
Anguyen24
Level 1

Bank rec-How to delete transactions?

Hello, 

I'm new to QB online and trying to fix this bank rec. My client had many duplicate payments and deposits over the course of 12 months entered into QB. Even though bank rec are completed, the balance per book is way off because of the significant deposit in transit. Is there a way to mass delete these transactions?

Also, when i go into deleting single transaction, even though it says deleted, it still show up when i go to the reconciliation report. When i click on the transaction that i thought i deleted, a message show up and say the transaction is already deleted... I dont understand why it still showing up

2 Comments 2
CharleneMaeF
QuickBooks Team

Bank rec-How to delete transactions?

Hello there, Anguyen24.

 

The possible reason the deleted transactions will still appear on the Reconciliation report is they're already reconciled. 

 

You'll have to undo those transactions in the Register to remove them.

 

  1. Go to the Accounting menu, then select Chart of Accounts.
  2. Find the account and click View register
  3. Choose the transactions you already deleted.
  4. Review the check column located between Deposit and Balance. If the transaction is reconciled, you’ll see an “R.”
  5. Select the box and keep clicking it until the box is blank.
  6. Click Save
  7. Hit Yes on the prompt message. 

 

Once done, you can also verify if you successfully deleted the duplicate transactions.

 

Here's how:

 

  1. Go to the  Gear icon.
  2. Select Audit Log.
  3. Click the Filter drop-down. 
  4. Select the appropriate UserDate, or Events to narrow the results. 
  5. Click Apply.

 

For the detailed instructions, you can go through this article: Audit Log

 

Also, we're unable to mass delete the transactions, you can use a third-party application that integrates with QuickBooks Online.

 

  1. Go to the Apps menu.
  2. Type in transactions deleter in the search bar.
  3. Choose an app that you'd like to use.
  4. Click Get the app now.

 

For other QuickBooks concerns, such as setting up advanced reports, online banking, manage reconciliation, transactions, import and export data lists, etc., you can visit our Help article page anytime.

 

Feel free to ask if you have additional questions. I'm always here to help.

Fiat Lux - ASIA
Level 15

Bank rec-How to delete transactions?

@Anguyen24 

Utilize the trial period of a 3rd party deleter tool mentioned by CharleneMae_F 

https:// transactionpro.grsm.io/qbo

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us