Bank reconciliations are the first steps to complete when it comes to accounting for your business. It is crucial that all the cash on hand, money being received and payments going out are being accounted for in your books. Bank reconciliations are the core of bookkeeping services that accountants provide.

Thankfully with the help of accounting software such as QuickBooks Online and online banking, bank reconciliations have become easier to do even on a daily basis. Here’s a step by step general guide to help you get started on your bank reconciliation in QuickBooks.

Step 1: Access Bank Records

We recommend creating an online banking account to have the most convenient and instant access to your bank records. Through online banking, you can link your account to most accounting software so the transactions upload directly to your software or your bank statement can be downloaded in different versions compatible for manual uploads. Not to mention it’s Eco-friendly. Also, enabling us to perform efficient bank reconciliations on a timely basis.

Step 2: Access Accounting Records

For bank reconciliations, we highly recommend linking your online bank account to have instant and efficient access to your transactions. By directly linking your bank account, accounting software such as QuickBooks can recognize repeated transactions over time and suggest journal entry classifications for you.

Step 3: Navigate to the Reconcile Page

Now we’re going to begin our bank reconciliation. Click on the Gear button, then “Tools” and “Reconcile”. Another method is to click on “Accounting” and then “Reconcile”.

Step 4: Select an Account to Reconcile

For your business, be sure to link all accounts associated including your business checking account and all your business credit card accounts. It is important to reconcile each account. What we like best about QuickBooks is that you can classify the payments between the accounts, such as credit card bills, as transfers.

Step 5: Enter Statement Information

For bank reconciliations, there are three critical fields you’ll want to make sure you have your bank statement on hand for: Beginning Balance, Ending Balance and Ending Date. Ending date should be the month end of the month you are trying to close out and that your bank statement is dated for.

Step 6: Match and Clear Transactions

Once again you’ll need your bank statement handy to match and check off these transactions. As you label these transactions and clear them, the difference will slowly be brought down to zero – which means you have completed checking all transactions.

If you aren’t sure how to classify each transaction, be sure to ask a professional or an expert at Founder’s CPA to assist with your bank reconciliation. It’s best to label each transaction with professional accounting knowledge so that you can reap the maximum advantages such as adding deductions to your tax return.

Tip: Apply Filters So Transactions Are Easier to Find

Once you’ve become more familiar with reconciliation process and your common transactions, we recommend using filters to distinguish between payments and deposits. If you’d like to take it a step further, utilize QuickBooks's feature in creating rules. With rules, QuickBooks recognizes these transactions and classifies them for you. The most useful practice is to apply these rules to the most common and simple transactions. We love this feature because it saves you time by having to reconcile less records each month.

Step 7: Continue Clearing Transactions Until the “Difference” Field Is Zero

Ultimately your goal is to clear all the transactions and have it matched exactly to your bank statement. Once you’ve reached this point, you’re all set until next month!

Tip: Use the Discrepancy Report to narrow down and investigate differences

To see what the difference is you can access the discrepancy report through the reconciliation page or go to Reports, under For My Accountant, you’ll find Reconciliation reports. If there are any discrepancies outstanding, you’ll be able to access the discrepancy report through there.

Some transactions to look out for that can mess up a reconciliation or a previous reconciliation. Transactions that could be contributing to the differences are any transactions that have their date changed, or any transaction that was previously reconciled and is now voided or deleted.

Tip: Outsource your bookkeeping services

We believe in spending your time efficiently and wisely. We recommend leaving the bookkeeping and accounting services to our experts here at Founder’s CPA. We can maximize your tax savings and benefits through our accounting solutions. Find out if you’re ready to outsource your services by reading this article, “Startup Founders – When to Outsource Your Bookkeeping”.

Tags:

Accounting
Curt Mastio
Post by Curt Mastio
Jul 11, 2024 11:50:16 AM
Curt Mastio started Founder’s CPA in 2017 and currently serves as the Managing Partner of the firm. After obtaining both his Bachelor’s and Master’s degrees in accounting from the University of Illinois in Urbana-Champaign Curt started his career in Big Four public accounting. Shortly thereafter Curt served as the Chief Financial Officer of Storage Squad began his stint as an Adjunct Instructor at Northwestern University’s Farley Center for Entrepreneurship and has been teaching Accounting & Finance to undergraduate students for 6+ years. In his current role Curt oversees strategy, operations, and business development at Founder’s CPA. Further, Curt has experience working directly with 200+ startups and small businesses providing accounting, tax, and outsourced CFO services. His industry expertise lies in the SaaS, Blockchain, Marketplace, and Fintech industries. He has served as a key advisor working directly with startups that range from pre-revenue to companies generating over $30 million dollars a year in revenue. Lastly, he serves a key role working directly with the firm’s clients that have collectively raised over $200 million in venture capital funding to date. Curt is also an active advisor, mentor, and investor in the startup ecosystem. He has facilitated numerous workshops, webinars, and presentations to incubators and other startup-centric organizations. He is also an active mentor for Techstars in both Chicago and Iowa. Outside of his daily professional duties Curt is actively involved with Beat the Streets Chicago and was a founding member of its Young Professionals Board. His efforts in both leadership and community involvement were recognized when he was awarded the Illinois CPA Society’s Outstanding Young Professional Leadership Award in 2020. He was also a panelist at their annual conference in 2022 where he spoke about his experiences starting and operating a public accounting firm. He maintains an active Certified Public Accountant designation that he obtained in 2014. Outside of work, Curt can be found spending time with his friends & family including his dog Rufus. His hobbies include golf, boating, cooking, reading, and attending sporting events & concerts.