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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 86: Line 86:
  
 
Ledger
 
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>* A </nowiki>'''Ledger''' is a book of accounts in which entries from transactions are recorded.  
+
| 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 '''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
<nowiki>* It is a book of final entry summarizing all of a company's transactions.</nowiki>
+
  
 
|-
 
|-
Line 227: Line 226:
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click '''Search Record By''' drop down. Select '''Time Interval (From – To). '''Click on '''Search''' button
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click '''Search Record By''' 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;"| In '''Search Record By''' drop down, select '''Time Interval (From – To).'''
+
Select '''Time Interval (From – To).  
 
+
'''Click on '''Search''' 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;"|  
Click on the '''Search '''button.
+
* In '''Search Record By''' drop down, select '''Time Interval (From – To).'''
 +
* Click on the '''Search '''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 any of the '''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 any of the '''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;"| You will be able to see all the Transactions listed. Click on any of the '''View''' buttons.
+
| 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 able to see all the Transactions listed.  
 +
* Click on any of the '''View''' buttons.
  
 
|-
 
|-
 
| 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;"| Now click on '''Edit''' button. You will be presented with the '''Transaction''' in an editable form
+
| 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 '''Edit''' button.  
 +
* You will be presented with the '''Transaction''' in an editable form
  
 
|-
 
|-
Line 245: Line 249:
 
| 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;"|  
 
* Change the '''Debit Amount''' and '''Credit Amount''' to 5000.  
 
* Change the '''Debit Amount''' and '''Credit Amount''' to 5000.  
 
 
 
* Click on '''Confirm.'''
 
* Click on '''Confirm.'''
  
Line 300: Line 302:
 
| 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;"| Watch the video available at  
 
| 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;"| Watch the video available at  
  
http:spoken-tutorial.org/
+
http://spoken-tutorial.org/
  
  

Latest revision as of 16:03, 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