GNUKhata/C2/Bank-Reconciliation/English

From Script | Spoken-Tutorial
Revision as of 10:45, 3 September 2013 by Trupti (Talk | contribs)

Jump to: navigation, search

Title of script: Bank Reconciliation Statement


Author: Trupti Kini


Keywords: Organisation, GNUKhata, Video Tutorial, Create Account, Edit Account


Visual Cue
Narration
/* Slide 1 */

Display desktop

Hello and welcome to the spoken tutorial on Bank Reconciliation Statement in GNUKhata.
/*Slide 2 */

Objectives

At the end of this tutorial, you will be able to:
  • Learn Bank Reconciliation in GNUKhata
  • Learn about Cleared and Uncleared Transactions
  • View Bank Reconciliation Statement in GNUKhata


/*Slide 3 */

System Requirements

To record this tutorial,

I am using :

  • GNUKhata version 1.2
  • Ubuntu 12.04 Operating System and
  • Firefox version 17.0

To use GNUKhata, I would recommend the use of Firefox version 3.6 or above. It works well with other browsers, too. Eg-Chromium and Opera.

/*Slide 4*/

Prerequisites

I assume that you already know
  • The principles of Book-keeping
  • Creating New Organisation in GNUKhata
  • Creating Accounts in GNUKhata
  • Adding Transactions in GNUKhata

If not, for relevant tutorials please visit http://spoken-tutorial.org



/* Interface */ Let us open the GNUKhata interface.



On the main page of GNUKhata
  • In the earlier tutorials, we learnt to create Accounts and adding Transactions
  • In this tutorial, we will learn about Bank Reconciliation.
  • So let's get started
Click on Master menu >> Bank Reconciliation Statement
  • Click on the Master menu and then click Bank Reconciliation Statement.
  • You will be presented with a screen with Bank Account Names
Point to SBI On clicking SBI , From and To date is displayed with View button
Point to From and To dates * By default the start date of the financial year is the From date.


* The end date of the financial year is the To date.


* You can change these dates if you want.

Click on View button Click on View button to proceed ahead.
Point to Account Name, Organisation Name Free Accounting Foundation, For the Period (Dates) You will see a screen with

* '''Account Name''' '''SBI''' * Organization Name '''Free Accounting Foundation''' and * Financial Date in '''For the Period'''

Point to Narrations and Cleared Transactions check box You can also see that there are two check boxes, Narrations and Cleared Transactions
Check on Narrations check box Since I want to see the Transactions with Narration, I will check the Narrations check box.



Click Ok button Now click on Ok button
Below the Ok button, you will be able to see fields

* Date

* Particulars

* Ref. No

* Debit

* Credit

* Clearance Date

* Memo

Point to Date field The Dates are arranged in the chronological order.
Point to Particulars The Particulars gives details of Accounts.
Point to Ref.No The Ref.No is the Voucher Number
Point to Debit and Credit Amounts The Debit and Credit fields give the Debit and Credit Amount
Point to Clearance Date field In Clearance Date field, we have to enter a Clearance Date in DD MM YYYY format.
Point to Memo * The Memo can be used to confirm transaction details with the passbook or bank.


* It serves as a reminder to verify the transaction details

Enter Clearance Date 05-06-2011 in the Let us enter a Clearance Date for the first transaction as 05-06-2011
Type in Memo, Check with the Bank In the Memo field, we will type Check with the Bank
Click on Save button To clear this transaction, click on Save button.
Point to Statement of Uncleared Statement * A new screen will appear with Statement of Uncleared Statement on the top.


* Below this statement, you can also see the Bank Reconciliation Statement

Point to Bank Reconciliation Statement


Point to Balance as per our Book


Point to Balance as per Bank

The Bank Reconciliation Statement gives the


* Balance as per Pass book

* Balance as per Bank

Click on Back to Reconciliation Menu * To go back, click on '''Back to Reconciliation Menu.'''

* You will come back to '''View Reconciliation '''screen

Select SBI and click on View Button Select SBI and click on View button.
Click on Narration and Cleared Transaction checkbox Let us now see what happens when we click on Narration and Cleared Transaction checkbox.



Click on OK button Now click on OK button
Point to Clearance Date and Memo You will be able to see the new Clearance Date and Memo


The transactions with Clearance Date are Cleared Transactions.



Point to blank Clearance Date The transactions without a Clearance Date are the uncleared Transactions.
That's it for this tutorial
/* Slide 5 */

Summary

Let us summarize.

In this tutorial, we learnt

* Bank Reconciliation in GNUKhata

* Cleared and Uncleared Transactions

* How to clear a Transaction

* View Bank Reconciliation Statement

/* Slide 6*/

Assignment

As an assignment, clear one or more transactions and view Bank Reconciliation Statement.
/* Slide 7 */ Watch the video available at

http:spoken-tutorial.org/


It summarizes the Spoken Tutorial

project


If you do not have good

bandwidth, you can download

and watch it

/* Slide 8 */

Spoken tutorial Workshops

The Spoken Tutorial Project Team


Conducts workshops using spoken tutorials


Gives certificates to those who pass an online test


For more details, please write to contact@spoken-tutorial.org

/* Slide 9 */

Acknowledgements

Spoken Tutorial Project is a part of the Talk to a Teacher project

It is supported by the National Mission on Education through ICT, MHRD, Government of India


More information on this Mission is available at

http://spoken-tutorial.org /NMEICT-Intro

Contributors and Content Editors

Trupti