Learn Bank Reconciliation with QUICKBOOKS

Become an expert in Bank Reconciliation and master the tools that QuickBooks gives you to find and fix any mistakes
4.8 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
505 students enrolled
Take This Course
  • Lectures 8
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

This course will make you an expert in Bank Reconciliation using QuickBooks.

First, you will learn about the general concepts and ideas of what bank reconciliation really is. Then you will perform several bank reconciliations as you follow along step by step. This course includes "follow along files" that you will download before each video lecture. Open them in half your screen and the video lecture in the other half and do exactly what you see, The files are bank statements in Excel and matching QuickBooks files so each separate lecture has a successful bank reconciliation. You will feel satisfied and proud of yourself after completing them.

The reconciliations start easy and build up more challenges for each consecutive month. The best part is the more challenging ones ant the end that actually have pre-set mistakes for you to find and fix. IT WILL SHOW YOU EVERY POSSIBLE SITUATION YOU CAN ENCOUNTER WHEN DOING BANK RECS!! This is actual hands on real life experience with bank reconciliation. I hope you learn well and enjoy the course!

What are the requirements?

  • Basic computer skills
  • Basic middle school or junior high school education

What am I going to get from this course?

  • Perform the most complex and challenging Bank Reconciliation using QuickBooks
  • Identify and fix the most common bank reconciliation mistakes
  • Use the special tools that QuickBooks makes available to perform and fix any bank reconciliation

Who is the target audience?

  • Anyone who needs to do Bank Reconciliation in QuickBooks
  • Anyone who needs to understand what bank reconciliation is and the concepts behind it
  • Anyone experiencing a difficult time doing bank reconciliation
  • Anyone trying to master the most important parts of QuickBooks including Security features

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Here is everything you need to be a QuickBooks Bank rec expert. ENJOY!!
Welcome to Bank Reconciliation with QuickBooks

This video lecture will explain what bank reconciliation actually is. It discusses the main ideas of bank reconciliation and explains the concepts behind the act of performing a bank rec.

I encourage you to ask questions and post feedback


This video lecture will show you in the clearest possible way, how to do a simple bank reconciliation. This step by step follow along video will show you the way it looks if you are doing a reconciliation for the very first month of the company's bank account. Don't forget to download he bank statement and the QuickBooks file that goes with this video.


This video lecture shows how to do a bank rec for the second consecutive month. It starts where the previous lecture finished. The previous lecture finished at the end of January. The QuickBooks file that you will use for this video already includes everything you finished with for January and also includes February transactions, This way, you can imagine that is it 1 month later and you will need to reconcile the same bank account at the end of February.

You will notice specific things that yo need to be aware of when doing several month in a row.

Please ask questions and please leave feedback. Thank you so much


This video lecture discusses the most common mistakes when doing bank reconciliation. It show you the most important tool in QuickBooks for this purpose, the RECONCILIATION DISCREPANCY REPORT. You will learn how to use this report and you will learn how to find and fix the most common mistakes made by people who do bank reconciliation using QuickBooks.


This lecture is the most important in the whole course. You actually download a file WITH PRE-SET MISTAKES. You must use what you learned in the previous videos to fix the problems and reconcile the bank account. Don't worry if you have trouble doing it. The end of the video shows you what the mistakes were and how to fix them.

Please ask questions and leave feedback


Because I want to provide you with every possible situation, This video will show you what to do if you are doing your first month's bank rec with a bank account that you have used for a long time but the QuickBooks file is new and includes only the current year. 

Some of the video is a review of what you learned. You may need this one day!


Because I want to provide you with every possible situation, I have included this video that shows what to do if you have been using QuickBooks for a while and never reconciled. Allot of the information is repeated but you may need this one day.

8 questions

This Quiz will test your memory and understanding of the concepts and ideas of doing bank reconciliation.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Professor Mark Smolen, Professor of Computerized Accounting

I have 2 decades of experience teaching Computerized Accounting. I have taught QuickBooks at A.S.A college in Manhattan New York. I have made my lessons available to job training schools for adult education and have helped place hundreds of students in good paying jobs using QuickBooks and other software that they learned in my class. I am a permanently licensed teacher by the New York State Education Department. I am also a Certified QuickBooks Pro adviser. I have made these videos by determining what my clients needed and how effective they were in real life situations. I enjoy helping students turn frustration in to a feeling of comfort and satisfaction with QuickBooks

Ready to start learning?
Take This Course