Bank Reconciliations-Cash Internal Controls-Excel Practictic
4.3 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
713 students enrolled

Bank Reconciliations-Cash Internal Controls-Excel Practictic

Excel worksheet bookkeeping Internal controls, bank reconciliations, and internal controls related to checking account
4.3 (9 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
713 students enrolled
Last updated 8/2018
English
English [Auto]
Current price: $23.99 Original price: $34.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Internal Controls
  • Cash Receipts Internal Controls
  • Cash Disbursements Internal Controls
  • Bank Reconciliation
  • Petty Cash
Requirements
  • We should have a basic understanding of financial accounting and debits and credits.
Description

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

Who this course is for:
  • Accounting students
  • Business owner
  • Anyone who whats to learn accounting
Course content
Expand all 13 lectures 01:39:43
+ Bank Reconciliations
8 lectures 01:16:54
Excel Download
00:05
Excel Download
00:05
9.12 Bank Reconciliation Adjusting Entries January
17:48
Excel Download
00:05
9.15 Bank Reconciliation February
21:01
Excel Download
00:05
9.20 Bank Reconciliation Feb. Adjusting Entries
14:16
+ Petty Cash
4 lectures 20:51
Excel Download
00:05
800.10 Petty Cash Journal Entries Part 1-Accounting%2C Financial
10:02
800.20 Petty Cash Journal Entries Part 2-Accounting%2C Financial
10:39
Excel Download
00:05