Did you reconcile?

Love it or hate it, most small business owners are using QuickBooks to track their company's finances. I've found that many people, while using QuickBooks to enter transactions, fail to follow through to ensure they are getting everything entered. If you get to the end of the year with a bunch of missing transactions, it is going to be that much harder to track down the reason why your checking balance and your QuickBooks balance are worlds apart.

Before I give the basic how-to of reconciling in QuickBooks, let's establish some ground rules:

  1. A bill, such as phone, electricity, Internet, car payment, etc., is entered as a bill within QuickBooks. When the bill is paid, you are using the Enter Bills/Pay Bills feature.
  2. Money received is entered either using the Sales Receipt or Create Invoice/Receive Payments feature.
  3. Deposits are made from undeposited funds by using the Record Deposits feature.
  4. Purchases made using your debit card are entered into the check register directly or by using the Write Checks or Enter Bills/Pay Bills feature.

If you are following the above on a daily/weekly basis, then reconciling your account should only take a few minutes of your time and should be very easy.

  1. Click Banking > Reconcile.
  2. Ensure that the beginning balance is the same as the beginning balance on your bank statement.
  3. Enter the statement date.
  4. Enter the ending balance.
  5. Check off each of the deposits and credits that appear on your bank statement. If you missed a deposit, go back to home and record the deposit.
  6. Check off each of the checks and payments that appear on your bank statement. If you missed entering a purchase, payment, or check, go back to banking and do it now. Change the amount of any item by double clicking and editing.
  7. The amount in the lower right hand corner should be zero. Print (to a printer or to adobe pdf) a reconciliation report to be filed.

By doing this each and every month, you are taking a proactive approach toward your finances. You will spend less money on your accountant at tax time, you will enjoy a feeling of better control, and you will have an easier time using QuickBooks' more advanced features.

AccountingWEB would like to thank Maine Accounting for providing this article.

You may like these other stories...

By Jason Bramwell San Francisco–based online accounting software provider Xero launched a free conversion platform on October 8 that will enable small businesses to migrate their Intuit QuickBooks data into Xero...
By Michael Callan, CPA, cofounder of Swizznet It wasn't that long ago that small and medium-size business (SMB) accounting software resided on a PC – and only on a PC. Today, with more than 1.3...
By Stacy KildalSo you have a client that wants to make the jump from QuickBooks Pro, Premier, Mac, or Enterprise? This is indeed exciting news, and I shall happily guide you through this process. Come with me, and let's...

Upcoming CPE Webinars

Apr 22
Is everyone at your organization meeting your client service expectations? Let client service expert, Kristen Rampe, CPA help you establish a reputation of top-tier service in every facet of your firm during this one hour webinar.
Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
Apr 30
During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.