Difference between revisions of "GNUKhata/C2/Viewing-Reports/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 112: Line 112:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Period''' – '''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 '''Period''' – '''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>* In the </nowiki>'''Period''', we have to select the '''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;"|  
 
+
* In the '''Period''', we have to select the '''From '''and '''To''' dates.  
 
+
* By default, the Start and End dates of the Financial Year of the organisation appear as the '''From''' and '''To''' dates respectively.
<nowiki>* By default, the Start and End dates of the Financial Year of the organisation appear as the </nowiki>'''From''' and '''To''' dates respectively.
+
  
 
|-
 
|-
Line 127: Line 126:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''View Ledger with Narration''' check box
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''View Ledger with Narration''' check 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;"| <nowiki>* Since I want to view the </nowiki>'''ledger''' with narration, I will click on '''View Ledger with Narration''' check 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;"|  
 
+
* Since I want to view the '''ledger''' with narration, I will click on '''View Ledger with Narration''' check box.
<nowiki>* We wont select Project here.</nowiki>
+
* We wont select Project here
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''View''' button
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''View''' button
| 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>* Lets click on </nowiki>'''View''' button.  
+
| 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;"|  
 
+
* Lets click on '''View''' button.  
<nowiki>* You will be able to view the </nowiki>'''Ledger'''
+
* You will be able to view the '''Ledger'''
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Opening Balance''' in '''Ledger'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Opening Balance''' in '''Ledger'''
| 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>* As you can see, the </nowiki>'''Opening Balance''' is on the '''Debit''' 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;"|  
 
+
* As you can see, the '''Opening Balance''' is on the '''Debit''' Side.  
<nowiki>* This is as per the rules of Accounting.</nowiki>
+
* This is as per the rules of Accounting
  
 
|-
 
|-
Line 153: Line 152:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Find/Edit Accounts'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Find/Edit Accounts'''
| 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>* You will be presented with the page to Add or Edit Accounts. </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;"|  
 
+
* You will be presented with the page to Add or Edit Accounts.  
  
  
Line 160: Line 159:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Edit''' button
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Edit''' button
| 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 edit the account details, click on the </nowiki>'''Edit''' button.  
+
| 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 edit the account details, click on the '''Edit''' button.  
 
+
* You will be able to edit the '''Account Name''' as well as the '''Opening Balance Amount.'''
<nowiki>* You will be able to edit the </nowiki>'''Account Name''' as well as the '''Opening Balance Amount.'''
+
  
 
|-
 
|-
Line 171: Line 169:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Confirm''' button
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Confirm''' button
| 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>* Now click on </nowiki>'''Confirm''' button.  
+
| 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 '''Confirm''' button.  
 
+
* A message is displayed which says that the Opening Balance has been changed
<nowiki>* A message is displayed which says that the Opening Balance has been changed.</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 '''Reports''' >> '''Ledger'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Reports''' >> '''Ledger'''
| 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>* Now let us view the changes reflected in the </nowiki>'''Ledger. '''
+
| 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 let us view the changes reflected in the '''Ledger. '''
 
+
* Click on '''Reports''' and then '''Ledger'''
<nowiki>* Click on </nowiki>'''Reports''' and then '''Ledger'''
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| In the '''Account Name''', select SBI. Click '''View Ledger with Narration''' check box. Click on '''View '''button
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| In the '''Account Name''', select SBI. Click '''View Ledger with Narration''' check box. Click on '''View '''button
| 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>* You will notice that the </nowiki>'''Opening Balance''' is now on 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;"|
 
+
* You will notice that the '''Opening Balance''' is now on the Credit side.  
<nowiki>* But it is a positive number.</nowiki>
+
* But it is a positive number
 
+
* Also notice that the '''Closing Balance''' has changed.
<nowiki>* Also notice that the </nowiki>'''Closing Balance''' has changed.
+
* This is obvious because any change in the transactions will be reflected in the '''Ledger'''.
 
+
<nowiki>* This is obvious because any change in the transactions will be reflected in the </nowiki>'''Ledger'''.
+
  
 
|-
 
|-
Line 199: Line 193:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To '''date
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To '''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;"| <nowiki>* In </nowiki>'''Trial Balance''' you have to enter a '''To '''date within the 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;"|  
 +
* In '''Trial Balance''' you have to enter a '''To '''date within the Financial year.
  
  
<nowiki>* By default, the end date of the Financial year appears in the </nowiki>'''To''' date.
+
* By default, the end date of the Financial year appears in the '''To''' date.
  
 
|-
 
|-
Line 208: Line 203:
 
| 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;"| There are three types of '''Trial Balances''' 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;"| There are three types of '''Trial Balances''' in GNUKhata.
  
<nowiki>* </nowiki>'''Net Trial Balance'''
+
* '''Net Trial Balance'''
 
+
* '''Gross Trial Balance'''
<nowiki>* </nowiki>'''Gross Trial Balance'''
+
* '''Extended Trial Balance'''
 
+
<nowiki>* </nowiki>'''Extended Trial Balance'''
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''Net Trial Balance''' from the drop down
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''Net Trial Balance''' from the drop down
| 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>* From the drop down, l</nowiki>et us select the '''Net Trial Balance.'''  
+
| 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 the drop down, let us select the '''Net Trial Balance.'''  
 
+
* And click on '''View '''button.
<nowiki>* And click on </nowiki>'''View '''button.
+
  
 
|-
 
|-
 
| 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;"| <nowiki>* The </nowiki>'''Net Trial Balance''' for the Financial year will be displayed.
+
| 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 '''Net Trial Balance''' for the Financial year will be displayed.
 
+
* To see the changes in the '''Trial Balance''', let us edit any one of our transactions.
<nowiki>* To see the changes in the </nowiki>'''Trial Balance, '''let us edit any one of our transactions.
+
  
 
|-
 
|-
Line 252: Line 243:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Change the '''Debit Amount''' and '''Credit Amount''' to 5000. Click '''Confirm'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Change the '''Debit Amount''' and '''Credit Amount''' to 5000. Click '''Confirm'''
| 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>* Change the </nowiki>'''Debit Amount''' and '''Credit Amount''' to 5000.  
+
| 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;"|  
 +
* Change the '''Debit Amount''' and '''Credit Amount''' to 5000.  
  
  
<nowiki>* Click on </nowiki>'''Confirm.'''
+
* Click on '''Confirm.'''
  
 
|-
 
|-
Line 274: Line 266:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Debit''' and '''Credit''' Amounts
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Debit''' and '''Credit''' Amounts
| 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>* Notice the changes in the </nowiki>'''Debit''' and '''Credit''' Amounts.  
+
| 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 the changes in the '''Debit''' and '''Credit''' Amounts.  
 
+
* The changes made when the '''Transaction''' was edited have reflected in the '''Trial''' '''Balance'''
<nowiki>* The changes made when the </nowiki>'''Transaction''' was edited have reflected in the '''Trial''' '''Balance'''
+
  
 
|-
 
|-
Line 291: Line 282:
  
 
Summary
 
Summary
| 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>* Let's summarise.</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;"|  
 
+
* Let's summarise
  
 
In this tutorial, we learnt  
 
In this tutorial, we learnt  
  
<nowiki>* To view a </nowiki>'''Ledger'''
+
* To view a '''Ledger'''
 
+
* To view a '''Net Trial Balance'''
<nowiki>* To view a </nowiki>'''Net Trial Balance'''
+
  
 
|-
 
|-

Revision as of 12:56, 3 September 2013

Title of script: Viewing Reports in GNUKhata


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


Visual Cue
Narration
/* Slide 1 */

Display desktop

Hello and welcome to this spoken tutorial on Viewing Reports in GNUKhata.
/*Slide 2 */

Objectives

At the end of this tutorial, you will be able to:
  • View Ledger
  • View Net Trial Balance


/*Slide 3 */

System Requirements

To record this tutorial, I am using
  • Ubuntu 12.04 Operating System
  • GNUKhata version 1.2
  • Firefox version 17.0

If you are using 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

/* [http://localhost:8080/ Interface after logging into GNUKhata with 'admin' */ Let us open GNUKhata interface.
On the main page of GNUKhata
  • In the earlier tutorials, we learnt to create Accounts and add Transactions
  • In this tutorial, we will learn about the Reports menu.
  • So let's get started.
Point to Reports menu Under Reports, we have :
  • Ledger
  • Trial Balance
  • Project Statement
  • Balance Sheet and
  • Income and Expenditure


  • Since organisation Free Accounting Foundation is of type NGO, we see Income and Expenditure option.
  • If the organisation is of type Profit Making, we would see Profit and Loss option.
/* Slide 5*/

Ledger

* A Ledger is a book of accounts in which entries from transactions are recorded.


* It is a book of final entry summarizing all of a company's transactions.

/* Interface */

Click on Ledger option

Point to ABC

When I click on Ledger option, a new screen appears with the organisation name at the top.



Point to Account Name From Account Name drop down, select an account name.
Select SBI from the Account Name drop down Let us select SBI from the Account Name drop down.
Point to PeriodFrom and To dates
  • In the Period, we have to select the From and To dates.
  • By default, the Start and End dates of the Financial Year of the organisation appear as the From and To dates respectively.
We can view the report for any period within the Financial year.
Point to View Ledger with Narration check box The Ledger can be viewed with or without Narration.
Click on View Ledger with Narration check box
  • Since I want to view the ledger with narration, I will click on View Ledger with Narration check box.
  • We wont select Project here
Click on View button
  • Lets click on View button.
  • You will be able to view the Ledger
Point to Opening Balance in Ledger
  • As you can see, the Opening Balance is on the Debit Side.
  • This is as per the rules of Accounting
Let us see what happens if we make the Opening Balance of account ''SBI'' as negative.
Click on Master >> Account Creation/Find/Edit To change the Opening Balance of SBI, let us click on Master and then Account Creation/Find/Edit
Click on Find/Edit Accounts
  • You will be presented with the page to Add or Edit Accounts.


Click on Edit button
  • To edit the account details, click on the Edit button.
  • You will be able to edit the Account Name as well as the Opening Balance Amount.
Change the sign of the Opening Balance Amount Let us make the Opening Balance Amount negative.
Click on Confirm button
  • Now click on Confirm button.
  • A message is displayed which says that the Opening Balance has been changed
Click on Reports >> Ledger
  • Now let us view the changes reflected in the Ledger.
  • Click on Reports and then Ledger
In the Account Name, select SBI. Click View Ledger with Narration check box. Click on View button
  • You will notice that the Opening Balance is now on the Credit side.
  • But it is a positive number
  • Also notice that the Closing Balance has changed.
  • This is obvious because any change in the transactions will be reflected in the Ledger.
Under Reports menu, Click on Trial Balance Now let us see the Trial Balance.
Point to To date
  • In Trial Balance you have to enter a To date within the Financial year.


  • By default, the end date of the Financial year appears in the To date.
Click on Trial Balance Type drop down There are three types of Trial Balances in GNUKhata.
  • Net Trial Balance
  • Gross Trial Balance
  • Extended Trial Balance
Select Net Trial Balance from the drop down
  • From the drop down, let us select the Net Trial Balance.
  • And click on View button.
  • The Net Trial Balance for the Financial year will be displayed.
  • To see the changes in the Trial Balance, let us edit any one of our transactions.
Click on Transactions >> Contra >> Find/Edit/Delete Record We have learnt how to edit of a Transaction in an earlier tutorial.


Please refer to it for details.

Click Search Record By drop down. Select Time Interval (From – To). Click on Search button In Search Record By drop down, select Time Interval (From – To).


Click on the Search button.

Click on any of the View button. You will be able to see all the Transactions listed. Click on any of the View buttons.
Click on Edit button Now click on Edit button. You will be presented with the Transaction in an editable form
Change the Debit Amount and Credit Amount to 5000. Click Confirm
  • Change the Debit Amount and Credit Amount to 5000.


  • Click on Confirm.
Let us now see the changes in the Net Trial Balance.
Click Reports >> Trial Balance.

In Trial Balance Type drop down, select Net Trial Balance.

Click on View

We have to repeat the same steps that we did to view the Net Trial Balance.



Point to Debit and Credit Amounts
  • Notice the changes in the Debit and Credit Amounts.
  • The changes made when the Transaction was edited have reflected in the Trial Balance
Point to Trial Balance for Another Period To view any other Trial Balance, you can click on Trial Balance for Another Period option.
That's it for this tutorial.
/* Slide 6 */

Summary

  • Let's summarise

In this tutorial, we learnt

  • To view a Ledger
  • To view a Net Trial Balance
/* Slide 7*/

Assignment

As an assignment, explore Gross Trial Balance and Extended Trial Balance reports.
/* Slide 8 */ 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 9 */

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 10 */

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