4.60 (34 reviews)
☑ Bank Reconciliation QuickBooks Online
☑ Bank Reconciliation Theory
☑ Bank Reconciliation Excel
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:
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.
QuickBooks Set Up
QuickBooks Online Set Up
Bank Reconciliations First Month
QuickBooks - 9.10 Bank Rec Jan
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 - 9.15 Bank Reconciliation February
Excel - 9.20 Bank Reconciliation Feb. Adjusting Entries
The course was very useful and I really enjoyed it. The tutor explained the topic well and I was able to follow and copy the steps that he did for the bank rec on excel and on quickbooks. I did however raise a query with the tutor and chased him up on it but have still not heard back from him. I was able to resolve this query myself in the end however so all is good now!
A great course as usual for this instructor! Everything is explained in a clear and easy-to-understand and follow way. Bob is highly knowledgeable about the topic and, most importantly, has loads of hands-on experience in the field, which makes the course true to real-world business situations. He is also very responsive to the "issues" the students may come across throughout the course and always willing to give thorough answers and additional explanations. I highly recommend this course!