Bank Reconciliation Statement

Keep a track of Your Bank Balance through a Bank Reconciliation Statment and Develop your own Template

Last updated 2022-01-10 | 4.6

- 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

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

1 sections • 12 lectures

Introduction Preview 03:09

Reasons for the difference between Cash Book Bank balance and Bank Statement Preview 07:58

Two methods of Preparing Bank Reconciliation Statement Preview 00:59

Concept of Recording Bank Transactions Preview 02:13

Why We use Adjusted Cash Book Method Preview 00:58

Adjusted Cash Book Method Preview 11:33

Example Adjusted Cash Book Method Preview 10:02

Without Adjusting Cash Method Introduction Preview 01:29

Without Adjusting Cash Method Format Preview 02:25

Without Adjusting Cash Method Example Preview 04:12

Template for Bank Reconciliation Preview 16:24

The End + Bank Reconciliation Template Preview 00:36