LUTZ BUSINESS INSIGHTS
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 + 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
- BSBA in Accounting, University of Nebraska, Kearney, NE
- Community Bike Project Omaha, Past Treasurer
- QuickBooks Online vs. QuickBooks Desktop: What's the Difference?
- How to Reconcile Your Accounts in QuickBooks
- Starting a Business in 2020? Your Accounting Options
- How Automating Your Payroll Will Change Your Life
- Why You Need a Disaster Recovery Plan
- Cash Flow Problems? 5 Ways to Improve It
- QuickBooks + CRM = Better Customer Relationships
- Does Your Business Need a Merchant Accountant?
- 5 Money Management Tips You Need
- 12 Financial Reports You Should Be Creating
- Don't Click That Link! How to Avoid Phishing Scams
QUICKBOOKS PROADVISOR CERTIFICATIONS
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.