LUTZ BUSINESS INSIGHTS

 

How to Reconcile Your Accounts in QuickBooks

how to reconcile your accounts in quickbooks

michael perry, client accounting services director

 

There’s something satisfying about checking off transactions as you reconcile a bank account. The hard part is making those two numbers match when you’re finished – and that’s why many businesspeople avoid it. QuickBooks contains specialized tools to help make that happen.

Before you start, you should always enter all transactions for the statement period and back up your company file. Then, open the Banking menu and click Reconcile. Make sure the correct account is showing in the Account field and that the Statement Date matches the date on your bank statement (change it if needed). QuickBooks automatically enters the Beginning Balance, which is the Ending Balance from your last reconciliation. This should match your statement.

Note: If this is your first time reconciling or your Beginning Balance doesn’t match your statement, don’t complete the reconciliation. Let us advise you here.

Enter the Ending Balance from your statement and any Service Charges or Interest Earned if you haven’t yet entered them already in QuickBooks, then click Continue. This will take you to the actual reconciliation screen. There are two columns there, one for Checks and Payments and one for Deposits and Other Credits. If you’re working with a credit card account, these columns will be labeled Charges and Cash Advances and Payments and Credits.

To avoid confusion, you might want to click in the box in front of Hide transactions after the statement’s end date. You can also click the column headers (Date, Check #, etc.) to reorder the list.

Now you’re ready to do the actual reconciliation. Look at the first transaction on your statement and find one in the QuickBooks Reconcile window that matches it. Click in the checkmark column to indicate that it’s cleared. Continue to do this for all of the other transactions on your bank statement. As you mark checks and payments, the Cleared Balance in the lower right decreases.  It increases every time you clear deposits and payments.

When you’ve finished marking all of the cleared transactions, look in the lower right corner of the Reconcile window. If the Difference field reads $0.00, click the Reconcile Now button to complete the reconciliation.

What if it doesn’t? You can still click Reconcile Now. QuickBooks will open the Reconcile Adjustment window and give you three options to correct the discrepancy:

  • Return to Reconcile. Click this button to go back to the Reconcile window to see if there are transactions on your statement that are not in QuickBooks.
  • Leave Reconcile. If you want to do some more investigating of your QuickBooks transactions, this will save your work and close the window.
  • Enter Adjustment. You can force QuickBooks to post a journal entry that will bring the difference between your statement and QuickBooks down to $0.00.

We don’t recommend the third option, as you may be covering up a problem that needs to be fixed.

Our outsourced accounting services include account reconciliation. We can take on a lot of your work or a little, depending on what you need. Contact us, and we can explore the possibilities together.

ABOUT THE AUTHOR

Mike Perry + Lutz Client Accounting Services in Nebraska

402.827.2087

mperry@lutz.us

LINKEDIN

MIKE PERRY + CLIENT ACCOUNTING SERVICES DIRECTOR

Mike Perry is a Client Accounting Services Director at Lutz with over 15 years of accounting experience. He focuses on providing business consulting, software implementation and training, accounting procedure assistance and outsourced accounting replacement consulting for closely held companies.

AREAS OF FOCUS
AFFILIATIONS AND CREDENTIALS
  • American Institute of Certified Public Accountants, Member
  • Nebraska Society of Certified Public Accountants, Member
  • Intuit Certified ProAdvisor, QuickBooks Advanced
  • Certified Public Accountant
EDUCATIONAL BACKGROUND
  • BSBA in Accounting, University of Nebraska, Kearney, NE
COMMUNITY SERVICE
  • Community Bike Project Omaha, Past Treasurer
QUICKBOOKS PROADVISOR CERTIFICATIONS

Certified ProAdvisor - Online  Certified ProAdvisor - Advanced Desktop  Certified ProAdvisor - Enterprise

BILL.COM CERTIFICATIONS

Bill.com Guru Certification   

SIGN UP FOR OUR NEWSLETTERS!

We tap into the vast knowledge and experience within our organization to provide you with monthly content on topics and ideas that drive and challenge your company every day.

Toll-Free: 866.577.0780  |  Privacy Policy

All content © Lutz & Company, PC

OMAHA

13616 California Street, Suite 300

Omaha, NE 68154

P: 402.496.8800

HASTINGS

747 N Burlington Avenue, Suite 401

Hastings, NE 68901

P: 402.462.4154

LINCOLN 

115 Canopy Street, Suite 200

Lincoln, NE 68508

P: 531.500.2000

GRAND ISLAND

3320 James Road, Suite 100

Grand Island, NE 68803

P: 308.382.7850