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

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

 
7 Comments 7
Regina_Lend_A_Hand_Accounting
Level 9

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

No, and it is not advisable either. It sounds like you need an Accountant to review your books. The only reason there would be a number of unreconciled items is if the accounting in QBO has not been done correctly to begin with. When transactions show up on the reconciliation page they have already been added to the account registers, and they need to be reconciled accordingly.

Malcolm Ziman
Level 10

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

If they were duplicated - you manually entered them and also added them in the bank feed - and remain uncleared  after reconciling: If they came in in the bank feed then you can go to Banking>Reviewed, select them and click Undo. Then in For Review batch-exclude them.

If they were manually entered, you can't batch-delete them.  If there are a lot, you can put through a journal entry to reverse them, making sure the reversal is in the same month or at least year. If taxes have been filed you may have to file an amended return

Regina_Lend_A_Hand_Accounting
Level 9

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

It would be best to have an Accountant review and advise. The fact that there are un-reconciled transactions is a red flag that help is needed. Again, if the transactions are already in the reconciliation screen, they were added to the account register for the account in question.

 

Transactions can be duplicated when manually entered transactions are not properly matched to transactions that come into the bank feed. It is better to match them correctly than it is to undo and  then exclude the transactions that come back into the bank feed on an "Undo", in my view. All account transactions should be reconciled, even if they need to be corrected first.

 

It is never a good idea to direct a non-Accountant to do journal entries to reverse transactions on an account register. If this is not done correctly it can create additional accounting errors and more work to correct them. And, if the taxes have been filed, it is most certainly not a good idea to delete transactions or make journal entries that could impact the 2018 year-end account balances. Filing an Amended return increases the chances of an audit, which is not ideal.

Malcolm Ziman
Level 10

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?


@Regina_Lend_A_Hand_Accounting wrote:

It would be best to have an Accountant review and advise.

 


No no need to pay an accountant, if they understand what happened and the bank is reconciled. That is why they asked the question here

Regina_Lend_A_Hand_Accounting
Level 9

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

There is no indication that they understand what happened or that the bank is reconciled. In fact, they specifically said that they wanted to know how to batch delete un-reconciled transactions from the reconciliation screen, this is why I believe they should reach out to their Accountant for help.

jewelzee444
Level 1

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

we have 544 reconciled duplicate transactions  from 2017. As I have seen with other clients, Quickbooks Online has a steep learning curve and this is often the case.  I have recconciled and closed out 2017 and 2018 yet the transactions are still there.  Do you mean there is no easy fix for this issue other than a journal entry? 

Charies_M
Moderator

Is there a way to delete these unreconciled transactions from the reconciliation page in bulk?

Hello there, jewelzee444.

 

I appreciate you taking the time to reach us back. I want to make sure you are taken care of.

 

At this time, there isn't an option to delete unreconciled transactions in bulk. You'll have to delete them one by one. Therefore, to undo a reconciliation, you'll have to manually edit each transactions.

 

While we continue to develop new features in QuickBooks that can help you save time, I recommend you regularly check our QuickBooks Blog for the latest feature available in QuickBooks Online (QBO): https://quickbooks.intuit.com/blog/.​

 

Should you have any other questions while reconciling account in QBO, feel free to let me know as I'm always here to help.

Need to get in touch?

Contact us