4.42 out of 5
6 reviews on Udemy

Bank Reconciliations-Cash Internal Controls-Excel Practictic

Excel worksheet bookkeeping Internal controls, bank reconciliations, and internal controls related to checking account
Robert (Bob) Steele
700 students enrolled
English [Auto-generated]
Internal Controls
Cash Receipts Internal Controls
Cash Disbursements Internal Controls
Bank Reconciliation
Petty Cash

This course will just provide the Excel practice problems component of our resources only so that learners can work through problems without being distracted by other resources.

Bookkeeping for cash and bank reconciliations. 

We will discuss internal controls including what they are, why they are useful, and the objectives of internal controls. We will then move to internal controls specific to cash including bank reconciliations. 

Bank reconciliations are important controls for both large and small companies. After the double entry accounting system itself, the bank reconciliation is one of the most important internal controls. The bank reconciliation will compare the bank statement to the cash book balance as of a point in time and reconcile the difference between the two. The bank reconciliation process will provide more assurance of the cash account and will provide more assurance over many other accounting processes because most accounting processes include cash. For example, reconciling the bank account provides more assurance over the revenue cycle, purchases cycle, and payroll cycle. 

We will also discuss the setting up and recording of a petting cash account, a process that can be more complex than if first seems. 

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 curriculum.

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 Export

As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.

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 benefit 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. 

Content Includes: 

·         Internal controls

·         Cash receipts internal controls

·         Cash disbursements internal controls

·         Bank reconciliations

·         Petty cash

·         Definitions and key terms



Bank Reconciliations

Excel Download
9.10 Bank Reconciliation January
Excel Download
9.12 Bank Reconciliation Adjusting Entries January
Excel Download
9.15 Bank Reconciliation February
Excel Download
9.20 Bank Reconciliation Feb. Adjusting Entries

Petty Cash

Excel Download
800.10 Petty Cash Journal Entries Part 1-Accounting Financial
800.20 Petty Cash Journal Entries Part 2-Accounting Financial
Excel Download
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4 out of 5
6 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion