Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHow 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! Go to Solution.
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.
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.
Does this also work in QuickBooks Desktop Mac 2020 (V19)? I can't seem to get it to work...
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.
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.
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.
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.
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:
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.
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