Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
Hello there, @user34134.
Let me step in and assist you on how to pull up the list of all uncashed cheques.
You can use the Check Detail report and filter it to uncleared checks. In that way, it will show you all the uncleared cheques of your supplier. Here's how:
I've also added an article to help you filter and save your report in QBO:
If you have other questions, feel free to leave a message in the comment section. I'm always around here in the Community to help. Take care, and have a good day.
Hello there, @user34134.
Let me step in and assist you on how to pull up the list of all uncashed cheques.
You can use the Check Detail report and filter it to uncleared checks. In that way, it will show you all the uncleared cheques of your supplier. Here's how:
I've also added an article to help you filter and save your report in QBO:
If you have other questions, feel free to leave a message in the comment section. I'm always around here in the Community to help. Take care, and have a good day.
Thank you so much for your speedy help!
Hey there, user34134.
Thanks for stopping by the Community today and if you have any other questions, feel free to post here anytime.
Thanks again and have a lovely afternoon!
It does not change to "Uncleared" even after I select it from the drop down menu. "Run Report" gives me all the CLEARED checks.
It's my pleasure to help you run a report showing the uncleared checks in QuickBooks Online, @smenashy.
Ensure that that the report period is chosen correctly. This can be the possible reason the uncleared checks are not showing in the report.
After checking the date, and still the issue persists, we can perform some troubleshooting steps to fix this. There are times that the browser is full of frequently accessed pages, thus causing some unusual responses. Let's log in to your account using a private browser.
Here's how:
Once logged in, try to run again and filter the report. If it works, go back to your default browser and clear its cache and cookies to refresh the system. If the issue persists, I'd recommend using other supported browsers in accessing the tab.
I've also added these articles to guide you more about reports:
Please let me know how it goes. I want to make sure everything has been covered. Have a blessed day ahead.
This list includes o/s checks from the prior month and all checks written for the current month also. We even push in our bank transactions - it will match to the check. But it will still list the check on the "uncleared list". I am guessing you would have reconcile the bank account. But who wants to do that every day.
The problem with this report is that the checks have to be reconciled for the month in order for the report to accurately pick up the "cleared" checks. As you know, you can have two types of "cleared" checks in the register, those with an "asterisk" (by marking it in reconciliation), and those with a full check mark (after being reconciled). The report only picks up those that have been checked. Businesses want an accurate picture of those checks that have currently cleared DURING the month and to see what checks have not cleared, and it shouldn't be necessary to cycle each entry to a "check mark" in order to run the report of uncleared checks only to have to remove those check marks to fully reconcile at the end of the month.
Should be an option to run a report of those entries "MARKED" (with an asterisk, not full check mark) to determine uncleared checks.
Thank you for joining in on the thread, Exorgeist.
The Check Detail report in QuickBooks Desktop will actually show the checks that have been cleared (* or ✓), reconciled (✓), or uncleared (no indicator) if you add the Clr column. A transaction doesn't have to be in reconciled status to be picked up on the report.
The challenge I see is the checkmark (✓) indicator because it can mean that a check has been manually cleared or reconciled. Therefore, I also like the idea of using only asterisks (*) for cleared transactions, and just using checkmarks (✓) for the reconciled ones. In line with this, I encourage you to send feedback so our engineers can consider making improvements in future updates.
Please feel free to submit more ideas or features that you see have the potential to improve further. Enjoy the rest of the day and take good care always!
That report does not have a total. Is there a way to get a total on that report?
Hello there, @Elizabeth99,
The option to show the total amount in the Check Detail report isn't available. However, you can manually add the total amount by exporting the report to an Excel file.
To export the report to Excel:
1. Go to Business overview and select Reports.
2. Search for the Check Detail report.
3. At the top of the report, select the Export icon. Then select Export to Excel.
4. Save the file in a location that is simple to access, such as your desktop or Downloads folder.
Note: If you're missing data when you open the report to Excel, the file's in protected view. In Excel, you'll need to select Enable Editing to view the full report.
For more information on how to export a report, you can visit this article: Export your reports to Excel from QuickBooks Online.
I'll also include some articles below that you can use in the future to help you learn more about reports:
If you need more help running a report, don't hesitate to get in touch with us again or leave a comment. Enjoy your day!
my check detail report looks absolutely nothing like that.
i've been using quickbooks for over 20 years - none of these solutions has been fruitful in the least.
very disappointing.
Can anyone recommend alternative software?
My check detail report looks absolutely nothing like that.
I've spent the last several hours scouring the various forumns for a solution. Nobody has one..not even close.
Just horrendously rigged, counter-intuitive (unworkable) "solutions". I have been using Quickbooks since 1996 and I remember when the whole purpose of this software was to make things easier and yet simply looking at my physical check book and comparing it with my actual bank account would have saved me hours in this case.
Can anyone recommend alternative software? This has vastly discouraged me from continuing to use quickbooks or any other (counter)intuit products.
incorrect in several ways.
there is no "uncleared" option anywhere in QuickBooks.
one can check "yes" or "no" under the "cleared" parameter...nevertheless, it won't do you any good because no matter what kind of parameters and filters one places on the report - it will simply list every single check, cleared and cleared with absolutely not discernable difference.
this is not a workable or practical solution.
solved???
lol. it really isn't.
November 2022 and this still has no workable solution...why?
Why?
Because they have proposed a solution. See a few posts before. The solution is to export the report and then use Excel to summarize and perform calculations. Considering what I pay for an accounting package, this is a load of Balogna Sausage!
They might as well suggested to get a pencil and a legal pad and list all the figures and then add them up. No fundamental difference, just using tools outside of the costly software package. Maybe an abacus, I like that...
The filter options Cleared, uncleared or both could easily contain the option to select uncleared AND unmarked for reconciliation.
Paul
We hear your suggestions and recognize your need for this option, Paul.
To notify our product engineers about this feature, I highly recommend leaving feedback. This way, they can consider adding it in future updates.
Here's how to submit feedback:
You can track feature requests through the QuickBooks Online Feature Requests website.
I'm also adding this article that tackles managing and customizing reports in QBO for more information: Customize reports in QuickBooks Online.
For more tips and other resources you can use in the future, I recommend visiting our website: Self-help articles.
Please know that I'm only a few clicks away if you have follow-up questions about this or anything else. I'll be here to assist. Take care.
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