cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtfs
Level 2

Finding Duplicates after Reconciling

Hello,

 

i have a process that after an account is reconciled one of my team members reviews to see if there are any duplicate expenses or deposits.  Is there a report that i can run that can show any expenses or deposits that need be deleted.  For example if an account is reconciled up 5.31.22 and an expense is dates on 5.2.22 and a deposit on 5.12.22 they need be deleted.  In this scenario we would go to that account make the ending balance the same as the ending balance, and enter 5.31.22 as the ending date as if we were going to reconcile again.  From here we delete any expenses or deposits that need to be deleted and "CLOSE WITHOUT SAVINGS".  

 

It would be nice to find these deposits and expenses from a report.  I know i can run a report for a particular account and sort those that are uncleared.  However there is still the chance that it can be cleared, but not reconciled and it would still need be deleted.  Can i run a report that has transactions that are cleared or uncleared.

 

Thanks!

3 Comments 3
JenoP
Moderator

Finding Duplicates after Reconciling

I'd be glad to help you look for duplicate transactions that need to be deleted, schmidtfs.

 

Yes, there's a report where you can see transactions that are cleared and uncleared. Let me share these steps with you:

 

  1. Open your Chart of Accounts and look for the account that you reconciled.
  2. Click the drop-down list beside View register and select Run report.
  3. Look for the Customize button in the upper-right hand corner and click on it.
  4. Scroll-down to Rows/Columns section and check the box for Clr.
  5. Select Run report.

 

1.PNG2.PNG

 

This will add a column to your report that will indicate if the transaction has been cleared or not. Then, click on each of them if you want to make changes or delete it. 

 

3.PNG

 

You can also check out these articles in case you need more guidance when running reports in QBO:

 

 

Don't hesitate to always ask questions if you still need more help with the program. 

schmidtfs
Level 2

Finding Duplicates after Reconciling

Is there a way you can filter only the transactions that have are uncleared or cleared?

katherinejoyceO
QuickBooks Team

Finding Duplicates after Reconciling

Thanks for coming by this thread, @schmidtfs.

 

We can run a report filtered by cleared and uncleared status. Here's how: 

 

  1. Go to Business overview and select Reports.
  2. Select Customize. Then, select All Dates in the Report period dropdown.
  3. Select Filter.
  4. Select the Transaction Type checkbox. 
  5. Select the Cleared checkbox. In the dropdown menu, select Uncleared, then select Run report

 

For future reference, select Save customization to use this report in the future. See this article for further insights: Memorize reports in QuickBooks Online

 

Feel free to visit again if you still have questions in mind. I'm always around to help. 

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

Need to get in touch?

Contact us