Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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!
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:
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.
Is there a way you can filter only the transactions that have are uncleared or cleared?
Thanks for coming by this thread, @schmidtfs.
We can run a report filtered by cleared and uncleared status. Here's how:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here