Learn Bank Reconciliation with QUICKBOOKS
4.8 (10 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.
528 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Bank Reconciliation with QUICKBOOKS to your Wishlist.

Add to Wishlist

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 (10 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.
528 students enrolled
Last updated 8/2016
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • Basic computer skills
  • Basic middle school or junior high school education

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!

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
8 Lectures
Here is everything you need to be a QuickBooks Bank rec expert. ENJOY!!
8 Lectures 01:51:14

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

Preview 11:29

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.

First Month's Bank Reconciliation

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

Second Consecutive month's Bank Reconciliation

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.

The Reconciliation Discrepancy Report

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

Third month's bank rec WITH MISTAKES!!

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!

First time bank rec - OLD ACCOUNT, NEW FILE!!

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.

First time reconciling; OLD FILE AND OLD ACCOUNT

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

Bank Reconciliation theory multiple choice test
8 questions
About the Instructor
Professor Mark Smolen
4.5 Average rating
204 Reviews
5,234 Students
14 Courses
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