GNUKhata/C2/Viewing-Reports/English

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 Period – From 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