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!
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.
This Quiz will test your memory and understanding of the concepts and ideas of doing bank reconciliation.
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