Search Our Blogs

Got a specific
QuickBooks question?

       Certified QuickBooks ProAdvisor

Didn't find the QuickBooks
tip you were looking for?
Email me so I can answer you directly and then write a blog about it.

Subscribe by Email

Your email:

Need some
Year End Help?

How to avoid Year End Bookkeeping Problems free eBook! Get it Today!
Read this case study and learn how end of year bookkeeping increased profits by 300%!
Got a question about Quickbooks or bookkeeping? Schedule a free call!


QuickBooks Tips Blog

Current Articles | RSS Feed RSS Feed

Balancing the Books: Weekly or Daily Reconciliations in QuickBooks


Bank reconciliations...I know eeeww!  Balancing the books does not have to be a complicated art that only your accountant has the skills to pull off.  However, reconciling all of the bank accounts, loans and credit cards is an important step in the accounting cycle.  Try this helpful tip to make your reconciliations a breeze.

In a previous post I talked about how sorting your accounts by cleared status can help manage cash flow.  Using this sort feature also allows for reconciliations to be performed on a daily, weekly or monthly basis.  Here is how you perform daily reconciliations in QuickBooks:

Double click on any bank account or credit card account to open the register of that account.  On the right hand side of the register in between the payment and deposit columns you will notice a box that has a check mark in it.  This check mark indicates a transaction being in cleared status.  What this allows you to do is enter transactions as they appear in real time off of you bank or credit card online activity.  You can now reconcile your bank account  daily, weekly or as often as you please.  Pull up your online bank account activity and show ending balances.  You can reconcile to the ending balance of each transaction or each day's activity.

There are two HUGE advantages to doing this:

1.  You monthly reconciliation to your bank statement will be done.   Once your statement is generated just click reconcile and you will have it all done.

2.  By combining this procedure with sorting by cleared status you are gaining even more control over your cash flow.


Follow us on Google+

Note: This blog does not claim credit for images posted on this site unless specified.  Images are copyright to their respectful owners.  If there is an image that appears on this blog that belongs to you and you do not wish for it to appear on this site please email with a link to the image and it will be removed.


Thanks for explaining this process. Reconciling is so important to a businesses bookkeeping. Here at Intuit, we've just published a reconciling troubleshooting article: 
Though it written for a Mac audience, the information is valid for any QuickBooks user. Thanks again for publishing this information.
Posted @ Friday, May 13, 2011 11:23 AM by Shelly King, Intuit, Managing Editor for Little Square
These are great information on balancing books. Thank you for providing such a very helpful article.
Posted @ Tuesday, November 19, 2013 9:29 PM by Luetta Fox
thanks for this great article
Posted @ Friday, August 22, 2014 4:25 AM by david
great information or good article
Posted @ Friday, August 22, 2014 4:27 AM by QuickBooks Technical Support
thanks for this wonderful article.
Posted @ Thursday, September 25, 2014 12:20 PM by Best Poetry
Post Comment
Website (optional)

Allowed tags: <a> link, <b> bold, <i> italics