Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Bank Reconciliation Statement using Excel - Easy Guide
Highest Rated
Rating: 4.7 out of 5(1,491 ratings)
5,380 students

Bank Reconciliation Statement using Excel - Easy Guide

Keep a track of Your Bank Balance through a Bank Reconciliation Statment and Develop your own Template
Highest Rated
Created byNiran Marshall Perera
Last updated 11/2017
English

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

Course content

1 section • 12 lectures • 1h 1m total length

  • Introduction3:09
  • Reasons for the difference between Cash Book Bank balance and Bank Statement7:58
  • Two methods of Preparing Bank Reconciliation Statement0:59
  • Concept of Recording Bank Transactions2:13
  • Why We use Adjusted Cash Book Method0:58
  • Adjusted Cash Book Method11:33
  • Example Adjusted Cash Book Method10:02
  • Without Adjusting Cash Method Introduction1:29
  • Without Adjusting Cash Method Format2:25

    Learn the bank reconciliation format without adjusting the cash book, starting from the cash book balance and using add and less sections, including cheques in transit and bank errors.

  • Without Adjusting Cash Method Example4:12
  • Template for Bank Reconciliation16:24
  • The End + Bank Reconciliation Template0:36

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

Report abuse