Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Suer2
Level 1

how do I clear a range of checks in a bank reconciliation without having to "click" each check

How do I clear a range of checks in doing a bank reconciliation without having to choose each check?

Thanks in advance for help with this question.

Solved
Best answer September 21, 2021

Best Answers
AlcaeusF
Moderator

how do I clear a range of checks in a bank reconciliation without having to "click" each check

Hello @Suer2,

 

Welcome to the Community. I'm here to help you with marking checks as cleared when reconciling an account in QuickBooks Desktop.

 

Aside from clicking each check and payment, you can press and hold the left-click button of your mouse to select transactions. While holding it, you can drag the cursor down or up depending on the range of checks you want to mark cleared (see screenshot below).

 

 

However, you'll need to manually deselect or unmark transactions you don't want to be part of the reconciliation. If there are checks included between the highlighted data, untick the checkmark.

 

For more information, as well as how to run reports for reconciliation discrepancies, I recommend the following article: Fix issues when you're reconciling in QuickBooks Desktop.

 

Fill me in if you have more questions about reconciling bank accounts in QuickBooks. I'm always here to help. Take care always.

View solution in original post

8 Comments 8
AlcaeusF
Moderator

how do I clear a range of checks in a bank reconciliation without having to "click" each check

Hello @Suer2,

 

Welcome to the Community. I'm here to help you with marking checks as cleared when reconciling an account in QuickBooks Desktop.

 

Aside from clicking each check and payment, you can press and hold the left-click button of your mouse to select transactions. While holding it, you can drag the cursor down or up depending on the range of checks you want to mark cleared (see screenshot below).

 

 

However, you'll need to manually deselect or unmark transactions you don't want to be part of the reconciliation. If there are checks included between the highlighted data, untick the checkmark.

 

For more information, as well as how to run reports for reconciliation discrepancies, I recommend the following article: Fix issues when you're reconciling in QuickBooks Desktop.

 

Fill me in if you have more questions about reconciling bank accounts in QuickBooks. I'm always here to help. Take care always.

Suer2
Level 1

how do I clear a range of checks in a bank reconciliation without having to "click" each check

So much faster and easier.  Thank you so much!

davebertok
Level 1

how do I clear a range of checks in a bank reconciliation without having to "click" each check

Does this also work in QuickBooks Desktop Mac 2020 (V19)? I can't seem to get it to work...

Adrian_A
Moderator

how do I clear a range of checks in a bank reconciliation without having to "click" each check

Hello there, davebertok.

 

Yes, the information shared by my colleague also works with your QuickBooks Desktop for Mac. Though the interface may differ, the process is the same.

 

Feel free to browse these references as your guide in reconciling an account: 

 

 

You can always get back to this thread if there's anything that I can help. 

suem1963
Level 1

how do I clear a range of checks in a bank reconciliation without having to "click" each check

How do you do this in QB online? I have the accountant version of QBO. I have a client who writes hundreds of checks each month and clicking each one is a PITA.

They just switched to QBO and as accountant, I'm hating it. Taking me twice as long to reconcile them as before.

Rubielyn_J
QuickBooks Team

how do I clear a range of checks in a bank reconciliation without having to "click" each check

I've got your back to help clear a range of checks in a bank reconciliation, @suem1963.

 

In QuickBooks Online, you have the option to select all the checks you want to clear by clicking the circle button. For visual reference, you may check out the screenshot below:

 

Once done selecting all the transactions, you can clear them all at once. 


I'm adding these articles to learn more about reconciling accounts and how to fix it when you encounter balance issues:

 

 

Should you need any additional assistance while clearing your checks in the reconciliation page, you can leave a comment below. I'll be sure to get back to you.

suem1963
Level 1

how do I clear a range of checks in a bank reconciliation without having to "click" each check

That wont help. My client can write 500 checks and only 300 could clear. It means clicking on checks one at a time to clear or unclear. We need the option of clearing by a range of check numbers or by clcking and holding the mouse button down like in the desktop version.

 

Charies_M
Moderator

how do I clear a range of checks in a bank reconciliation without having to "click" each check

Welcome back, suem1963.

 

I'm here to address your concern about the clearing checks function in QuickBooks Desktop (QBDT).

 

You can only click the checks you want to clear in batch one at a time before clearing them all. The option to click and hover the mouse button down to the last check that you want to clear is unavailable. 

 

I can see how this feature would be helpful for you and your business. Since this isn't currently an option, I encourage you to submit feedback to our Product Development Team for review when determining features to be added in updates.

 

Here's how:

  1. Go to the Help menu at the top.
  2. Select Send Feedback Online.
  3. Click on Product Suggestion.
  4. Click on the drop-down for Type of Feedback and select Product Suggestion.
  5. Select the Product Area.
  6. Enter your thoughts and suggestions.
  7. Click Send Feedback.

To be updated with our latest news and updates, including product improvements, I encourage you to visit the What's New section on your QBDT account or open this link to view our product update blogs.

 

If you have any follow up questions or concerns about clearing checks, let me know by commenting below. Have a good day.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us