QuickBooks Online Bank Reconciliation

Learn QuickBooks Online bank reconciliation process, how to enter the first bank reconciliation and read the bank rec.

4.50 (56 reviews)
Money Management Tools
6 hours
May 2022
last update
regular price

What you will learn

Bank Reconciliation QuickBooks Online

Bank Reconciliation Theory

Bank Reconciliation Excel


If we are a business owner who would like more assurance about our books, a business professional who would like to advance our career by learning the importance of bank reconciliations, or an accounting student who would like to see the critical internal control of bank reconciliations applies to real work software, this QuickBooks course is a course for us. 

Why choose this course?

The bank reconciliation process is the second biggest internal control for most companies and one both large and small companies can, and should, implement. Reconciling the bank account provided a MUCH larger scene of assurance that our financial data and the financial reports are complete and correct. 

We will demonstrate the bank reconciliation process for two months in QuickBooks. The first month of operations is often the most difficult to enter because we must deal with the begging balance. The second month and thereafter is generally much easier to reconcile using QuickBooks software but something that takes some time to fully understand conceptional. 

We will also run the bank reconciliation process using Excel worksheets, which will provide a more conceptual view of how the process works and how the bank reconciliation report is generated from the process. 

Who will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together a curriculum.

You will be learning from somebody who is a:

  • CPA – Certified Public Accountant
  • CGMA – Chartered Global Management Accountant
  • Master of Science in Taxation
  • CPS – Certifies Post-Secondary Instructor
  • Curriculum Development Expo

As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also helped in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.

How will we be Taught?

Through viewing and then doing. We will demonstrate the reconciliation process in the software in such a way that it can be applied to practice. Because QuickBooks Online does not allow for static backup files at this time we cannot provide the exact data to follow along with, but we will include Excel worksheets that can be used to follow the same process. 

By seeing the process performed in QuickBooks and Excel and working the process in an Excel worksheet we will understand both the procedure and the reasoning for the procedure. 




QuickBooks Set Up

QuickBooks Online Set Up

Bank Reconciliations First Month

QuickBooks - 9.10 Bank Rec Jan
Excel Files
Excel - 9.10 Bank Reconciliation January
Excel - 9.12 Bank Reconciliation Adjusting Entries January
Accounting Comic Break

Bank Reconciliations Second Month

QuickBooks - 9.15 Bank Rec Feb
Excel FIles
Excel - 9.15 Bank Reconciliation February
Excel - 9.20 Bank Reconciliation Feb. Adjusting Entries


QuickBooks Online Bank Reconciliation - Screenshot_01QuickBooks Online Bank Reconciliation - Screenshot_02QuickBooks Online Bank Reconciliation - Screenshot_03QuickBooks Online Bank Reconciliation - Screenshot_04


August 25, 2022
Bank reconciliations in QuickBooks are crucial as it helps users to ensure that the transaction number and amount are correct. This is because many bookkeeping errors and discrepancies take place while feeding the numbers. Basically, bank reconciliation Quick books helps you accomplish three goals: Transaction amounts are appropriate: Bank reconciliation not only ensures that transactions are existing on both Quick books and bank statements. But it also needs the amount to be exactly the same.The QB transactions occurred: There are instances when a transaction in QB software can be inadvertently created. If that translation involves a bank account then a bank reconciliation will spot the fake transaction. Each bank transaction is properly recorded: Quick books bank reconciliation ensures that the bank account transitions are properly recorded in the software as well. Ending balance: Here, from the bank statement, enter your ending balance. Ending date: Pick the ending date of statement duration. Service charge: Here, enter the amount, date, and expense account exactly like the statement which you have not entered into Quickbooks already. Interest earned: Enter, the interest you earn on the bank balance if you have not filled it in already.
May 6, 2020
The course was very useful and I really enjoyed it. The tutor explained the topic well and I was able to follow and copy the steps that he did for the bank rec on excel and on quickbooks. I did however raise a query with the tutor and chased him up on it but have still not heard back from him. I was able to resolve this query myself in the end however so all is good now!
August 22, 2018
A great course as usual for this instructor! Everything is explained in a clear and easy-to-understand and follow way. Bob is highly knowledgeable about the topic and, most importantly, has loads of hands-on experience in the field, which makes the course true to real-world business situations. He is also very responsive to the "issues" the students may come across throughout the course and always willing to give thorough answers and additional explanations. I highly recommend this course!


2/14/2022100% OFF
2/20/2022100% OFF
2/26/2022100% OFF
3/17/2022100% OFF
6/2/2022100% OFF
6/30/2022100% OFF
7/10/2022100% OFF
7/27/2022100% OFF
8/6/2022100% OFF
8/14/2022100% OFF
9/11/2022100% OFF
9/19/2022100% OFF
10/6/2022100% OFF
10/13/2022100% OFF
11/7/2022100% OFF
11/14/2022100% OFF
11/24/2022100% OFF



QuickBooks Online Bank Reconciliation - Price chart


QuickBooks Online Bank Reconciliation - Ratings chart

Enrollment distribution

QuickBooks Online Bank Reconciliation - Distribution chart
udemy ID
course created date
course indexed date
course submited by