Difference between revisions of "GNUKhata/C2/Bank-Reconciliation/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 53: Line 53:
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| I assume that you already know
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| I assume that you already know
  
−
<nowiki> * The principles of Book-keeping </nowiki>
+
* The principles of Book-keeping
−
 
+
* Creating New Organisation in '''GNUKhata'''
−
<nowiki> * Creating New Organisation in </nowiki>'''GNUKhata'''
+
* Creating Accounts in '''GNUKhata'''
−
 
+
* Adding Transactions in '''GNUKhata'''
−
<nowiki> * Creating Accounts in </nowiki>'''GNUKhata'''
+
−
 
+
−
<nowiki>* Adding Transactions in </nowiki>'''GNUKhata'''
+
  
 
If not, for relevant tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]
 
If not, for relevant tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]
Line 75: Line 72:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| On the main page of GNUKhata
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| On the main page of GNUKhata
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* In the earlier tutorials, we learnt to create Accounts and adding Transactions</nowiki><nowiki>
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
* In this tutorial, we will learn about </nowiki>'''Bank Reconciliation'''.
+
* 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
−
<nowiki>* So let's get started.</nowiki>
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Master '''menu''' >> Bank Reconciliation Statement'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Master '''menu''' >> Bank Reconciliation Statement'''
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* Click on the </nowiki>'''Master''' menu and then click '''Bank Reconciliation Statement.'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
 
+
* Click on the '''Master''' menu and then click '''Bank Reconciliation Statement.'''
−
'''<nowiki>* </nowiki>'''You will be presented with a screen with '''Bank Account Names'''
+
* You will be presented with a screen with '''Bank Account Names'''
  
 
|-
 
|-
Line 93: Line 89:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''From '''and''' To '''dates
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''From '''and''' To '''dates
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* By default the start date of the financial year is the </nowiki>'''From''' date.  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
 
+
* By default the start date of the financial year is the '''From''' date.  
−
 
+
* The end date of the financial year is the '''To '''date.
−
<nowiki>* The end date of the financial year is the </nowiki>'''To '''date.
+
* You can change these dates if you want
−
 
+
−
 
+
−
<nowiki>* You can change these dates if you want.</nowiki>
+
  
 
|-
 
|-
Line 106: Line 99:
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Account Name, '''Organisation Name '''Free Accounting Foundation''', '''For the Period''' (Dates)
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Account Name''', '''Organisation Name '''Free Accounting Foundation''', '''For the Period''' (Dates)
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| You will see a screen with  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
<nowiki> * '''Account Name''' '''SBI'''</nowiki><nowiki> * Organization Name '''Free Accounting Foundation''' </nowiki> and <nowiki>* Financial Date in '''For the Period'''</nowiki>
+
You will see a screen with  
 +
* Account Name '''SBI'''
 +
* Organization Name '''Free Accounting Foundation''' and  
 +
* Financial Date in '''For the Period'''
  
 
|-
 
|-
Line 129: Line 125:
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Below the '''Ok''' button, you will be able to see fields
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Below the '''Ok''' button, you will be able to see fields
  
−
<nowiki>* Date</nowiki>
+
* Date
−
 
+
* Particulars
−
<nowiki>* Particulars</nowiki>
+
* Ref. No
−
 
+
* Debit
−
<nowiki>* Ref. No</nowiki>
+
* Credit
−
 
+
* Clearance Date
−
<nowiki>* Debit</nowiki>
+
* Memo
−
 
+
−
<nowiki>* Credit</nowiki>
+
−
 
+
−
<nowiki>* Clearance Date</nowiki>
+
−
 
+
−
<nowiki>* Memo</nowiki>
+
  
 
|-
 
|-
Line 165: Line 155:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Memo'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Memo'''
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* The </nowiki>'''Memo''' can be used to confirm transaction details with the passbook or bank.  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
 
+
* The '''Memo''' can be used to confirm transaction details with the passbook or bank.  
−
 
+
* It serves as a reminder to verify the transaction details
−
<nowiki>* It serves as a reminder to verify the transaction details</nowiki>
+
  
 
|-
 
|-
Line 184: Line 173:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Statement of Uncleared Statement'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Statement of Uncleared Statement'''
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* A new screen will appear with </nowiki>'''Statement of Uncleared Statement '''on the top.  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
 
+
* A new screen will appear with '''Statement of Uncleared Statement '''on the top.  
−
 
+
* Below this statement, you can also see the '''Bank Reconciliation Statement'''
−
<nowiki>* Below this statement, you can also see the </nowiki>'''Bank Reconciliation Statement'''
+
  
 
|-
 
|-
Line 198: Line 186:
 
Point to''' Balance as per Bank'''
 
Point to''' Balance as per Bank'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| The '''Bank Reconciliation Statement '''gives the  
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| The '''Bank Reconciliation Statement '''gives the  
−
 
+
* Balance as per Pass book  
−
 
+
* Balance as per Bank
−
<nowiki>* Balance as per Pass book </nowiki>
+
−
 
+
−
<nowiki>* Balance as per Bank</nowiki>
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Back to Reconciliation Menu'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Back to Reconciliation Menu'''
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <nowiki>* To go back, click on '''Back to Reconciliation Menu.'''</nowiki>
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|  
−
 
+
* To go back, click on '''Back to Reconciliation Menu.'''
−
<nowiki>* You will come back to '''View Reconciliation '''screen</nowiki>
+
* You will come back to '''View Reconciliation '''screen
  
 
|-
 
|-
Line 251: Line 236:
 
In this tutorial, we learnt  
 
In this tutorial, we learnt  
  
−
<nowiki>* Bank Reconciliation in </nowiki>'''GNUKhata'''
+
* Bank Reconciliation in '''GNUKhata'''
−
 
+
* Cleared and Uncleared Transactions
−
<nowiki>* Cleared and Uncleared Transactions</nowiki>
+
* How to clear a Transaction
−
 
+
* '''View '''Bank Reconciliation Statement'''
−
<nowiki>* How to c</nowiki>lear a Transaction
+
−
 
+
−
'''<nowiki>* </nowiki>'''View '''Bank Reconciliation Statement'''
+
  
 
|-
 
|-

Latest revision as of 10:59, 3 September 2013

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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=GNUKhata/C2/Bank-Reconciliation/English&oldid=5864"