Difference between revisions of "GNUKhata/C2/Contra-Transactions/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
Title of script: Contra and Journal transaction in GNUKhata
+
Title of script: Contra transaction in''' GNUKhata '''
  
Author: Trupti Rajesh Kini
+
Author: '''Trupti Rajesh Kini '''
  
Keywords: Video Tutorial, Organisation, GNUKhata, Contra, Journal, Transaction  
+
Keywords: Video Tutorial, Organisation, '''GNUKhata''', Contra, Transaction  
  
  
Line 15: Line 15:
  
  
| 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;"| Hello and welcome to the tutorial on ‘Entering a Contra Transaction’ in 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;"| Welcome to the tutorial on '''Entering a Contra Transaction''' in '''GNUKhata'''.  
  
 
|-
 
|-
Line 23: Line 23:
 
| 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;"| After watching this tutorial, you will be able to:
 
| 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;"| After watching this tutorial, you will be able to:
  
* Enter a Contra Transaction in GNUKhata
+
Enter a Contra Transaction in '''GNUKhata'''
  
 
|-
 
|-
Line 31: Line 31:
 
| 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 record this tutorial,  
 
| 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 record this tutorial,  
  
I am using  
+
I am using :
  
* GNUKhata version 1.2
+
* '''GNUKhata version 1.2'''
  
* Ubuntu 12.04 Operating System and
+
* '''Ubuntu 12.04''' Operating System and  
  
* Firefox version 17.0
+
* '''Firefox version 17.0'''
  
To use GNUKhata, I would recommend the use of Firefox version 3.6 or above.
+
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'''.  
It works well with other browsers, too.  
+
Eg-Chromium and Opera.
+
  
  
Line 50: Line 48:
  
 
Prerequisites
 
Prerequisites
| 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  
  
* Principles of Book keeping
+
* Principles of Book keeping  
  
* Creating a new organisation
+
* Creating a new organisation  
  
* Creating Accounts in GNUKhata
+
* Creating Accounts in '''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]  
 +
 +
 +
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"|  
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"|  
| 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;"| Let us open 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;"| Let us open '''GNUKhata'''.  
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Open web browser, Firefox
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Open Terminal
| 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 will open '''Firefox '''web browser.
+
 
 +
Execute on terminal '''sudo startgk'''
 +
 
 +
 
 +
 
 +
| 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 run '''GNUKhata''', you need to start the server on your machine.
 +
 
 +
* To start the server, open the terminal through '''Ctrl+Alt+T''' from the keyboard
 +
* Then type '''sudo startgk''' and hit '''Enter'''.  
 +
 
 +
 
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type [http://localhost:8080/ http://localhost:8080]  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Open '''Firefox''' and type in the address bar
 +
 
 +
[http://localhost/ http://localhost]  
 +
 
 +
 
 +
 
 +
| 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 run GNUKhata on your machine, open the '''Firefox''' browser
  
in firefox
+
* Type [http://localhost:8080/ http://localhost:8080] in the address bar.  
| 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;"| As you are aware, we are running GNUKhata on local machine.
+
  
  
So the web address will be [http://localhost:8080/ http://localhost:8080]
 
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Select Existing Organisation''' drop down and select '''Free Accounting Foundation'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Select Existing Organisation''' drop down and select '''Free Accounting Foundation'''
| 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 '''Select Existing Organisation''' and select '''Free Accounting Foundation''' as organisation.
+
| 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 '''Select Existing Organisation''' and select '''Free Accounting Foundation''' as organisation
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''For Financial Year'''.
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''For Financial Year'''
 
| 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;"| Select the '''financial year''' for the organisation.  
 
| 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;"| Select the '''financial year''' for the organisation.  
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Proceed''' then login as '''admin'''  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Proceed''' then login as '''admin'''
| 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;"| Now click on '''Proceed'''
+
| 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;"| Now click on '''Proceed'''  
  
and login as '''admin'''.
+
and login as '''admin'''
  
 
|-
 
|-
Line 99: Line 114:
  
  
Point to '''Transactions menu.'''
+
Point to '''Transaction 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;"| We have already discussed about how to create an account under the '''Master''' menu by selecting '''Account Creation/Find/Edit'''
+
| 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;"|  
 +
* We have already discussed about how to create an account under the '''Master''' menu by selecting '''Account Creation/Find/Edit.'''
 +
* This time we will discuss about '''Transactions''' from the main menu.
 +
 
  
This time we will discuss about '''Transactions''' from the main 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 '''Transactions'''.
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Transaction'''.
  
  
Line 116: Line 133:
  
 
/* Slide 5 */
 
/* Slide 5 */
| 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;"| From these options, I shall select '''Contra'''. Alternatively, you can use the shortcut key '''Alt+C '''from your keyboard.
+
| 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;"|  
 +
* From these options, I shall select '''Contra'''.
 +
* Alternatively, you can use the shortcut key '''Alt+C '''from your keyboard.
 +
* As you all know, in '''Contra '''transaction we can use accounts with Sub-group '''Cash''' and '''Bank'''.
 +
 
  
As you all know, in '''Contra '''transaction we can use accounts with Sub-group '''Cash''' and '''Bank'''.
 
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 6 */
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 6 */
| 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;"| As an example, consider a '''Contra''' transaction for '''Cash deposit to SBI bank Rs.2000 on 01-04-2011'''.
+
| 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;"| As an example, consider a '''Contra''' transaction for '''Cash deposit to SBI bank Rs.2000 on 01-04-2011'''
  
 
|-
 
|-
Line 128: Line 148:
  
 
Screen with '''Contra''' transaction  
 
Screen with '''Contra''' transaction  
| 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;"| For recording a Contra transaction, we should create two accounts first.
+
| 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;"|  
 +
* For recording a Contra transaction, we should create three accounts first.
 +
* The account will have the Group name''' -''' '''Current Assets''', Sub Group name '''-''' '''Bank '''and Account Name''' - SBI'''.
 +
* The second account will be under the Group name - '''Current Asset '''and Sub-group''' '''name''' - Cash. '''The second account will have the name '''Cash On Hand'''.
 +
* The third account will be under the Group name - '''Current Asset '''and Sub-group''' '''name''' - Cash. '''The second account will have the name '''Cash'''.  
  
The account will have the Group name - '''Current Assets''', Sub Group - '''Bank ''' and Account Name - '''SBI'''.
 
 
 
The second account will be under the Group - '''Current Asset '''and Sub-group - '''Cash'''. The second account will have the name -'''Cash'''.
 
  
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"|  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to the default 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;"| Now, I will show you how to record '''Contra''' transaction.
 +
* The first text-box is for '''Date''' field, it is to be entered in date, month and year format (DD-MM-YYYY).
 +
* You will notice that in the '''Date''' field, the first day of the financial year of the organisation I.e 1st April 2011 appears by default.
 +
* You can edit this date if you wish.
  
  
Point to the default 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;"| Now, I will show you how to record '''Contra''' transaction.
 
  
The first text-box is for  '''Date''' field, it is to be entered in date, month and year format (DD-MM-YYYY).  
+
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Interface */
  
You will notice that in the '''Date''' field, The first day of the financial year of the organisation I.e 1st April 2011 appears by default.  
+
Shift to '''Voucher No''' text box by using the tab button on your keyboard.  
  
You can edit this date if you wish.
+
Type '''CA12''' in '''Voucher No'''
  
  
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Interface */ Shift to '''Voucher No''' text box by using the tab button on your keyboard.
 
  
Type CA12 in '''Voucher No'''
+
| 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;"|  
| 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;"| Next comes the '''Voucher No.'''  
+
* Next comes the '''Voucher No.'''  
 +
* '''Voucher No''' can take alphanumeric characters.
 +
* So I will type '''CA12'''.
  
'''Voucher No''' can take alphanumeric characters.
 
  
So I will type CA12.
 
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Dr/Cr''' option  
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Dr/Cr''' option  
| 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 first option in the dropdown box is '''Dr/Cr'''.
+
| 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 first option in the dropdown box is '''Dr/Cr'''  
  
 
Depending on the nature of the transaction, we will select '''Dr''' or '''Cr''' option from this drop down.
 
Depending on the nature of the transaction, we will select '''Dr''' or '''Cr''' option from this drop down.
Line 171: Line 192:
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''SBI Bank account'''  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''SBI''' Bank account
| 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 next field is '''Account Name'''.  
+
| 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 next field is '''Account Name'''.
 +
* It has a dropdown box which shows all the existing Account names.
 +
* I will select '''SBI'''.
  
It has a dropdown box which shows all the existing Account names.
 
  
I will select '''SBI'''.
 
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Enter Rs 2000 as amount
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Enter '''Rs 2000 '''as amount
| 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 next is '''Debit Amount'''.
+
| 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 next is '''Debit Amount'''.
 +
* I will enter '''Rs 2000''' as the debit amount.
 +
* Press Tab
  
I will enter Rs 2000 as the debit amount.
 
  
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| From '''Dr/Cr''' dropdown Select '''Cr''' option  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| From the next '''Dr/Cr''' dropdown select '''Cr''' option  
  
  
From Account name dropdown select Cash account  
+
From Account name dropdown select '''Cash On Hand''' account  
| 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;"| Now we will see the second part of the transaction that is the credit side.  
+
| 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;"|  
 +
* Now we will see the second part of the transaction that is the credit side.
 +
* I will select '''Cr '''(Credit) option from '''DR/CR''' dropdown.
 +
* From the '''Account Name''' I will select '''Cash On Hand''' account.
  
I will select '''Cr '''(Credit) option from '''DR/CR''' dropdown.
 
  
From the '''Account Name''' I will select Cash account.
 
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type 1000 as amount
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type '''1000''' as amount
| 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;"| Because I have selected Credit ('''Cr''') option, the amount will be entered in the '''Credit Amount''' column.  
+
| 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;"|  
 +
* Because I have selected Credit ('''Cr''') option, the amount will be entered in the '''Credit Amount''' column.
 +
* Notice that '''Rs.2000/- '''comes as default '''Credit Amount'''.
 +
* This is because, as per the accounting practice, the amounts on both debit and credit side should tally.
 +
* I will enter a different amount, lets say,''' Rs. 1000'''
 +
* Let me show you what happens if you now click on '''Save'''.  
  
Notice that Rs.2000/- comes as default '''Credit Amount'''. This is because, as per the accounting practice, the amounts on both debit and credit side should tally.
 
  
I will enter a different amount, lets say, Rs. 1000 and Click on '''Ok''' button.
 
 
Let me show you what happens if you now click on '''Save'''.
 
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type 1000 for the credit entry.
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type '''1000''' for the credit entry.
  
  
 
Click on '''Save'''
 
Click on '''Save'''
| 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;"| Notice that an alert message appears saying '''Credit and Debit amounts does not tally'''.  
+
| 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;"| Notice that a new column appears with '''Dr/Cr '''drop down.
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on the delete icon
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| From the next '''Dr/Cr''' dropdown select '''Cr''' option
 +
 
 +
 
 +
From Account name dropdown select '''Cash''' account
 +
| 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 will select '''Cr '''(Credit) option from '''DR/CR''' dropdown.
 +
* From the '''Account Name''' I will select '''Cash '''account.
 +
 
 +
 
 +
 
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type '''500''' as amount
 +
| 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;"|
 +
* Because I have selected Credit ('''Cr''') option, the amount will be entered in the '''Credit Amount''' column again
 +
* Notice that '''Rs.1000/- '''comes as default '''Credit Amount'''.
 +
* I will enter a different amount, lets say,''' Rs. 500'''
 +
* If you now click on '''Save '''again, '''Dr/Cr''' column appears till the amount on credit side and debit side tallies.
 +
 
 +
 
 +
 
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on the delete (red cross) icon for the new '''Dr/Cr''' column appeared.
 +
 
  
Choose Cash account
 
  
Type Rs. 2000
+
| 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;"|  
| 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;"| Since we have no other cash or bank account we will delete the credit entry by clicking on '''delete icon'''.
+
* Since we have no other cash or bank account created we will delete the credit entry by clicking on '''delete icon'''.
 +
* Now I will type the same amount as the debit amount '''Rs. 1000 '''which was''' 500''' for account '''Cash'''
  
First we have to select the Cash account
 
  
Now I will type the same amount as the debit amount. Rs. 2000.
 
  
 
|-
 
|-
Line 231: Line 277:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type '''Being cash deposit into bank''' in the '''Narration''' box  
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Type '''Being cash deposit into bank''' in the '''Narration''' box  
| 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;"| Here in the '''Narration''' box, type the details of the transaction.  
+
| 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;"|  
 +
* Here in the '''Narration''' box, type the details of the transaction.
 +
* I will type '''Being cash deposit into bank'''.  
  
I will type '''Being cash deposit into bank'''.  
+
 
 +
 
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Select Projects '''dropdown
 +
| 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 make this transaction under a project, choose '''Spoken Tutorial''' from the dropdown of '''Select Project.'''
  
 
|-
 
|-
Line 244: Line 296:
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to Transactions Menu
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Transactions''' 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;"| This way, you can record another transaction.  
+
| 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;"|  
 
+
* This way, you can record another transaction.  
That’s it for this tutorial. In the next few tutorials, we will learn more about GNUKhata.  
+
* That’s it for this tutorial. In the next few tutorials, we will learn more about '''GNUKhata'''.  
 
+
  
  
Line 260: Line 311:
 
Summary
 
Summary
  
Contra Transactions
+
Contra Transaction
 
| 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 have completed  
 
| 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 have completed  
  
Entering of Contra Transactions
+
Entering of '''Contra''' Transaction
  
 
|-
 
|-
Line 274: Line 325:
 
| 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;"| As an assignment, Please record
 
| 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;"| As an assignment, Please record
  
A Contra transaction of cash withdrawn from bank Rs.2,000 on 01-04-2011 from HDFC.
+
A Contra transaction of cash withdrawn from bank '''Rs.2,000''' on 01-04-2011 from '''HDFC'''.
  
  
  
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Slide 10
 
 
Assignment
 
| 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 Journal transaction of Purchase of furniture worth Rs.50,000/- on credit from New Furniture company on 15-06-2011.
 
 
 
Hint:
 
 
Under Direct Expense, make an account 'Purchase'.
 
 
 
Under Current Liability, make an account 'New Furniture Company'.
 
 
Make a Journal Transaction using these two accounts.
 
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Slide 11
 
 
Assignment
 
| 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 credit transaction of 40 units sold to customer XYZ on 01-04-2012 against invoice no A12 at Rs.10 each.
 
 
 
Now on 10-05-2012, it is agreed that the said units will be charged at Rs.8.
 
 
Hint:
 
 
 
Under Indirect Income, make an account 'Sales return'
 
 
Under Current Assets, Select Sundry Debtors, make an account 'XYZ'.
 
 
The amount for transaction will be Rs 80.
 
  
 
|-
 
|-
Line 360: Line 377:
  
 
|-
 
|-
|| Thanks for joining
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Thanks for joining  
||  
+
| 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;"|  
* That’s it for this tutorial. This is Trupti Kini from the GNUKhata project, IIT Bombay.
+
* That’s it for this tutorial. This is Trupti Kini from the GNUKhata project, IIT Bombay.  
 
* Thank you for watching.  
 
* Thank you for watching.  
 +
 +
  
 
|}
 
|}

Latest revision as of 17:21, 28 August 2013

Title of script: Contra transaction in GNUKhata

Author: Trupti Rajesh Kini

Keywords: Video Tutorial, Organisation, GNUKhata, Contra, Transaction


Visual Cue
Narration
Slide 1


Welcome to the tutorial on Entering a Contra Transaction in GNUKhata.
Slide 2

Learning Objectives

After watching this tutorial, you will be able to:

Enter a Contra Transaction 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
  • Principles of Book keeping
  • Creating a new organisation
  • Creating Accounts in GNUKhata

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



Let us open GNUKhata.
Open Terminal

Execute on terminal sudo startgk


To run GNUKhata, you need to start the server on your machine.
  • To start the server, open the terminal through Ctrl+Alt+T from the keyboard
  • Then type sudo startgk and hit Enter.


Open Firefox and type in the address bar

http://localhost


To run GNUKhata on your machine, open the Firefox browser


Click on Select Existing Organisation drop down and select Free Accounting Foundation Click Select Existing Organisation and select Free Accounting Foundation as organisation
Click on For Financial Year Select the financial year for the organisation.
Click on Proceed then login as admin Now click on Proceed

and login as admin

On the main screen Now we are on the main screen.
Point to Master menu


Point to Transaction menu.

  • We have already discussed about how to create an account under the Master menu by selecting Account Creation/Find/Edit.
  • This time we will discuss about Transactions from the main menu.


Click on Transaction.


Under Transactions, you can enter different types of transactions.
Select Contra option


/* Slide 5 */

  • From these options, I shall select Contra.
  • Alternatively, you can use the shortcut key Alt+C from your keyboard.
  • As you all know, in Contra transaction we can use accounts with Sub-group Cash and Bank.


/* Slide 6 */ As an example, consider a Contra transaction for Cash deposit to SBI bank Rs.2000 on 01-04-2011
/* Slide 7*/

Screen with Contra transaction

  • For recording a Contra transaction, we should create three accounts first.
  • The account will have the Group name - Current Assets, Sub Group name - Bank and Account Name - SBI.
  • The second account will be under the Group name - Current Asset and Sub-group name - Cash. The second account will have the name Cash On Hand.
  • The third account will be under the Group name - Current Asset and Sub-group name - Cash. The second account will have the name Cash.


Point to the default date Now, I will show you how to record Contra transaction.
  • The first text-box is for Date field, it is to be entered in date, month and year format (DD-MM-YYYY).
  • You will notice that in the Date field, the first day of the financial year of the organisation I.e 1st April 2011 appears by default.
  • You can edit this date if you wish.


/* Interface */

Shift to Voucher No text box by using the tab button on your keyboard.

Type CA12 in Voucher No


  • Next comes the Voucher No.
  • Voucher No can take alphanumeric characters.
  • So I will type CA12.


Point to Dr/Cr option The first option in the dropdown box is Dr/Cr

Depending on the nature of the transaction, we will select Dr or Cr option from this drop down.

Select the Dr option I will select the Dr option.
Select SBI Bank account
  • The next field is Account Name.
  • It has a dropdown box which shows all the existing Account names.
  • I will select SBI.


Enter Rs 2000 as amount
  • The next is Debit Amount.
  • I will enter Rs 2000 as the debit amount.
  • Press Tab


From the next Dr/Cr dropdown select Cr option


From Account name dropdown select Cash On Hand account

  • Now we will see the second part of the transaction that is the credit side.
  • I will select Cr (Credit) option from DR/CR dropdown.
  • From the Account Name I will select Cash On Hand account.


Type 1000 as amount
  • Because I have selected Credit (Cr) option, the amount will be entered in the Credit Amount column.
  • Notice that Rs.2000/- comes as default Credit Amount.
  • This is because, as per the accounting practice, the amounts on both debit and credit side should tally.
  • I will enter a different amount, lets say, Rs. 1000
  • Let me show you what happens if you now click on Save.


Type 1000 for the credit entry.


Click on Save

Notice that a new column appears with Dr/Cr drop down.
From the next Dr/Cr dropdown select Cr option


From Account name dropdown select Cash account

  • I will select Cr (Credit) option from DR/CR dropdown.
  • From the Account Name I will select Cash account.


Type 500 as amount
  • Because I have selected Credit (Cr) option, the amount will be entered in the Credit Amount column again
  • Notice that Rs.1000/- comes as default Credit Amount.
  • I will enter a different amount, lets say, Rs. 500
  • If you now click on Save again, Dr/Cr column appears till the amount on credit side and debit side tallies.


Click on the delete (red cross) icon for the new Dr/Cr column appeared.


  • Since we have no other cash or bank account created we will delete the credit entry by clicking on delete icon.
  • Now I will type the same amount as the debit amount Rs. 1000 which was 500 for account Cash


Point to Total Debit Amount and Credit Amount If the amount is entered correctly, the total of debit amount will be equal to the credit amount.
Type Being cash deposit into bank in the Narration box
  • Here in the Narration box, type the details of the transaction.
  • I will type Being cash deposit into bank.


Point to Select Projects dropdown To make this transaction under a project, choose Spoken Tutorial from the dropdown of Select Project.
Click on the Save button When you are done, to save this transaction click on the Save button.
Point to message When I click on Save button, message appears saying Transaction Record has been saved.
Point to Transactions Menu
  • This way, you can record another transaction.
  • That’s it for this tutorial. In the next few tutorials, we will learn more about GNUKhata.


Switch to Slides

Slide 8


Summary

Contra Transaction

In this tutorial, we have completed

Entering of Contra Transaction

Slide 9

Assignment


As an assignment, Please record

A Contra transaction of cash withdrawn from bank Rs.2,000 on 01-04-2011 from HDFC.



/* Slide 12 */

About the Spoken Tutorial Project

Watch the video available at

http://spoken-tutorial.org


It summarises the Spoken Tutorial

project


If you do not have good

bandwidth, you can download

and watch it

/* Slide 13 */ 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 14 */

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

Thanks for joining
  • That’s it for this tutorial. This is Trupti Kini from the GNUKhata project, IIT Bombay.
  • Thank you for watching.


Contributors and Content Editors

Trupti