Question

Finding Duplicates after Reconciling

Forum|Forum|4 years ago
June 16, 2022
1 reply
0 views

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!

JenoP

QuickBooks Team

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:

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

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.

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.

S

schmidtfsAuthor

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

katherinejoyceO

Level 9

Thanks for coming by this thread, @schmidtfs.

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

Go to Business overview and select Reports.
Select Customize. Then, select All Dates in the Report period dropdown.
Select Filter.
Select the Transaction Type checkbox.
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 up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded