Bank Reconciliation Statement using Excel - Easy Guide
4.6 (35 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.
1,546 students enrolled

Bank Reconciliation Statement using Excel - Easy Guide

Keep a track of Your Bank Balance through a Bank Reconciliation Statment and Develop your own Template
4.6 (35 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.
1,546 students enrolled
Last updated 10/2017
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 downloadable resource
  • 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
  • Understanding what is a bank reconciliation
  • learn how to reconcile the cash balances of a company's cash book and cash balance of that company's bank account
  • Develop a template for Bank Reconciliation Statement using Excel
Requirements
  • Ability to understand simple English language.
  • Desire to learn Bank Reconciliation Statement.
  • Desire to develop a template by your own for Bank Reconciliation.
Description

Bank Reconciliation is an important topic for the Accounting students, employees who are engaged in bank transactions as well as business owners. It is useful not only as a study material but in a practical way also. Because in a company it is necessary to have a same cash balance in the company’s own books as well as in the bank.

So here the course will simply explain what is the meaning of a bank reconciliation and importance of it. Further it will make students identify the reasons for the mismatch of cash balance and will guide to prepare the Bank reconciliation Statement .

The course will not end up only by teaching the Bank Reconciliation Statement. After explaining to prepare the bank reconciliation statement step by step, course will guide students to prepare a template for Bank Reconciliation Statement using Excel. It will enhance the knowledge of preparing Bank Reconciliation as it will give the students a chance to go through the process step by step once again. And also it will be useful for the practical use in preparing Bank Reconciliation Statement.

So You are warmly welcome to enroll and gain knowledge about Bank Reconciliation statement and in the process you can develop your own Template.

Who this course is for:
  • No specific target student anyone can enroll and learn what is a bank reconciliation
Course content
Expand 12 lectures 01:01:58
+ Introduction
12 lectures 01:01:58
Two methods of Preparing Bank Reconciliation Statement
00:59
Concept of Recording Bank Transactions
02:13
Why We use Adjusted Cash Book Method
00:58
Adjusted Cash Book Method
11:33
Example Adjusted Cash Book Method
10:02
Without Adjusting Cash Method Introduction
01:29
Without Adjusting Cash Method Format
02:25
Without Adjusting Cash Method Example
04:12
Template for Bank Reconciliation
16:24
The End + Bank Reconciliation Template
00:36