GNUKhata/C2/Viewing-Reports/English

From Script | Spoken-Tutorial
Jump to: navigation, search

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