QuickBooks Online Bank Reconciliation

QuickBooks Online Bank Reconciliation

QuickBooks Online Bank Reconciliation

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

Language: english

Note: 4.3/5 (44 notes) 3,377 students

Instructor(s): Robert (Bob) Steele

Last update: 2022-05-22

What you’ll learn

  • Bank Reconciliation QuickBooks Online
  • Bank Reconciliation Theory
  • Bank Reconciliation Excel



  • QuickBooks Software would be best although we can review the content without the software



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. 


Who this course is for

  • Business Owners
  • Accounting Professionals
  • Accounting Students
  • Anybody who wants to learn accounting software
  • Anybody who wants to learn accounting software


Course content

  • Introduction 2022
    • 9020 Bank Reconciliation Myth Busting
    • 9040 Bank Reconciliation Month One Overview
    • Documents to Downlaod
    • Transfer Data From QuickBooks Desktop Backup File
  • Bank Reconciliations First Month 2022
    • 9060 Bank Reconciliation Month 1 Deposits
    • 9080 Bank Reconciliation Month 1 Checks
    • 9100 Bank Reconciliation Opening Balance Problem
    • 9120 Bank Reconciliation Reports Month 1
  • Bank Reconciliations Second Month 2022
    • 9140 Bank Reconciliation Month 2 Deposits
    • 9145 Bank Reconciliation Month 2 Checks and Account Decreases
    • 9160 Bank Reconciliation Month 2 Reports
  • Introduction
    • Introduction
  • 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


Time remaining or 994 enrolls left


Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate