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

How do I see a list of all uncashed cheques?

Cheques written to suppliers.
Solved
Best answer October 26, 2020

Best Answers
Rejeil_O
QuickBooks Team

How do I see a list of all uncashed cheques?

                             

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:

 

  1. Go to the Reports tab.
  2. In the search field, enter the Check Detail report.
  3. Filter the date range.
  4. Click the Customize button.
  5. Under the Filter dropdown, go to the Cleared section and filter it to Uncleared.
  6. Once done, hit Run report.

 

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.

                                    

View solution in original post

17 Comments 17
Rejeil_O
QuickBooks Team

How do I see a list of all uncashed cheques?

                             

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:

 

  1. Go to the Reports tab.
  2. In the search field, enter the Check Detail report.
  3. Filter the date range.
  4. Click the Customize button.
  5. Under the Filter dropdown, go to the Cleared section and filter it to Uncleared.
  6. Once done, hit Run report.

 

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.

                                    

user34134
Level 1

How do I see a list of all uncashed cheques?

Thank you so much for your speedy help!

Nick_M
QuickBooks Team

How do I see a list of all uncashed cheques?

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!

smenashy
Level 1

How do I see a list of all uncashed cheques?

It does not change to "Uncleared" even after I select it from the drop down menu. "Run Report" gives me all the CLEARED checks.

Rubielyn_J
QuickBooks Team

How do I see a list of all uncashed cheques?

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: 

  • Ctrl + Shift + N for Google Chrome
  • Ctrl + Shift + P for Mozilla Firefox and Microsoft Edge
  • Command + Shift + N for Safari

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. 

pam27295
Level 2

How do I see a list of all uncashed cheques?

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.  

Exorgeist
Level 1

How do I see a list of all uncashed cheques?

 

 

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.

JessT
Moderator

How do I see a list of all uncashed cheques?

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.

 

  1. From the Help menu, select Send Feedback Online.
  2. Choose Product Suggestion for the feedback type and Reports for the Product Area.
  3. Enter the details in the box provided, and you may enter your name and email.
  4. Read the short message below Send Feedback to understand how we treat your suggestion.
  5. Click Send Feedback.

 

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!

Elizabeth99
Level 1

How do I see a list of all uncashed cheques?

That report does not have a total.  Is there a way to get a total on that report?

DHeraV
Moderator

How do I see a list of all uncashed cheques?

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!

TheatreMacon
Level 2

How do I see a list of all uncashed cheques?

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? 

TheatreMacon
Level 2

How do I see a list of all uncashed cheques?

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. 

TheatreMacon
Level 2

How do I see a list of all uncashed cheques?

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. 

TheatreMacon
Level 2

How do I see a list of all uncashed cheques?

this is not a workable or practical solution.

 

TheatreMacon
Level 2

How do I see a list of all uncashed cheques?

solved???

lol.  it really isn't.

November 2022 and this still has no workable solution...why?

Paul92708
Level 1

How do I see a list of all uncashed cheques?

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

 

 

 

FritzF
Moderator

How do I see a list of all uncashed cheques?

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:

 

  1. In QuickBooks Online (QBO), go to the Gear (Settings) icon at the top right.
  2. Select Feedback.
  3. Enter your comments or product suggestions. Then click Next to submit.

 

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.

Need to get in touch?

Contact us