• Post category:StudyBullet-6
  • Reading time:5 mins read

Perform QuickBooks bank reconciliation, interpret QuickBooks bank reconciliation reports, and understand the process.

What you will learn

How to process bank reconciliation for the first month

How to process bank reconciliation for the second month

How the bank reconciliation is made

How to interpret the bank reconciliation


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 be provided with backup files so that we can have the exact data set in our QuicKBooks system as is being demonstrated.

We will also be provided with PDF files that can be downloaded and used as a reference and or to work part of the problem without internet connection.

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.

Get Instant Notification of New Courses on our Telegram channel.

DealsCrown Telegram Banner

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 be provided video presentations of the process and given backup files to allow us to work the same set of data.

We will also be provided PDF files that can be used as a reference and or to work part of the problem without internet connection.

We will also be provided with Excel document to work conceptual components of the course along with instructional videos.





Set Up QuickBooks File

QuickBooks Pro 2018 Download & Installation
QuickBooks Backup File 9.10
QuickBooks – Restore Backup File 9.10

Bank Reconciliations First Month

PDF File 9.10
PDF file
QuickBooks 9.10 Bank Reconciliation First Bank Reconciliation
Excel Files
Excel – 9.10 Bank Reconciliation January
Excel – 9.12 Bank Reconciliation Adjusting Entries January

Bank Reconciliations Second Month

QuickBooks Backup File
PDF File 9.15
QuickBooks 9.15 Bank Reconciliation Second Bank Reconciliation
Excel FIles
Excel – 9.15 Bank Reconciliation February
Excel – 9.20 Bank Reconciliation Feb. Adjusting Entries