QuickBooks Bank Reconciliation Tips

| 1 min read

QuickBooks Bank Reconciliation Tips

Reconciling the bank statement can be challenging and time consuming for a small business depending on many factors: how much volume is involved, how many different bank accounts, the details of what types of transactions occur etc.  There are many things you can do within QuickBooks to make sure you not only do your monthly reconciliations efficiently, but also accurately.

  • Take care to set up a method of recording sales and expenses that matches the way they hit the checking account.  If you settle credit cards once per day as a batch make sure you come up with a sales recording system that mirrors the way the deposits hit the bank. 
  • QuickBooks reconciliations screens can be sorted (2009 versions and higher).  This is a big feature that many people fail to utilize.  Any of the columns can be clicked to sort that column either ascending or descending.  This comes in very handy when you have a large amount of checks or deposits.  When reconciling checks your bank usually lists them in check number order and notes gaps in the sequence.  You can see why sorting by check number can be advantageous.  The same can be applied when you have a large amount of deposits.  I sometimes find it faster to sort by deposit amount to find and clear transactions
  • There are a few time saving features that if used properly can save large amounts of time.  The "Mark All" and "Unmark all" buttons can be used if most of your transactions clear on a monthly basis.  Sometimes it is easier to mark all the transactions and uncheck those transactions that did not clear.  This typically works better for businesses with low transaction volume.  Another feature that can save time is that you can drag the check mark to clear multiple transactions in a row rather than checking each individual transaction.  I use this feature a lot when I am marking off a large sequence of cleared checks.  For example if check numbers 1-38 all cleared it is much faster to drag the check mark through those checks rather than clearing each one individually.

The monthly bank reconciliation(s) can be a difficult and painful monthly chore.  However, by developing and following a consistent system it can get done efficiently each month. 






An Affordable Bookkeeping Alternative to a CFO

Outsourcing your bookkeeping is more affordable than you would think. We save you money the moment you hire us by cutting out the expensive cost of hiring an in-house CFO.

Working with a remote bookkeeping service will still provide you with all the value you could get from an in-office bookkeeper but at a fraction of the cost.

Learn more

Learn How We Can Impact Your Business Growth

You’ve got your company’s best interest in mind. Guess what? So do we! You can rest assured that we will work closely with you to create actionable business plans and accurate financial reporting. We offer our toolkit of financial intelligence that will be your greatest asset for business growth.

Contact an Advisor