Difference between revisions of "GNUKhata/C2/Viewing-Reports/English"
(2 intermediate revisions 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;"| | + | | 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 | |
− | + | ||
|- | |- | ||
Line 112: | Line 111: | ||
|- | |- | ||
| 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;"| | + | | 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. | |
− | + | ||
|- | |- | ||
Line 127: | Line 125: | ||
|- | |- | ||
| 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;"| | + | | 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. | |
− | + | * 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;"| | + | | 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. | |
− | + | * 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;"| | + | | 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. | |
− | + | * This is as per the rules of Accounting | |
|- | |- | ||
Line 153: | Line 151: | ||
|- | |- | ||
| 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;"| | + | | 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 158: | ||
|- | |- | ||
| 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;"| | + | | 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.''' | |
− | + | ||
|- | |- | ||
Line 171: | Line 168: | ||
|- | |- | ||
| 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;"| | + | | 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 | |
− | + | ||
|- | |- | ||
| 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;"| | + | | 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''' | |
− | + | ||
|- | |- | ||
| 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;"| | + | | 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. | |
− | + | * 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'''. | |
− | + | ||
− | + | ||
|- | |- | ||
Line 199: | Line 192: | ||
|- | |- | ||
| 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;"| | + | | 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. | ||
− | + | * By default, the end date of the Financial year appears in the '''To''' date. | |
|- | |- | ||
Line 208: | Line 202: | ||
| 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. | ||
− | + | * '''Net Trial Balance''' | |
− | + | * '''Gross Trial Balance''' | |
− | + | * '''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;"| | + | | 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. | |
− | + | ||
|- | |- | ||
| 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;"| | + | | 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. | |
− | + | ||
|- | |- | ||
Line 236: | 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 | ||
|- | |- | ||
| 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;"| | + | | 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. | |
− | + | * Click on '''Confirm.''' | |
− | + | ||
|- | |- | ||
Line 274: | Line 268: | ||
|- | |- | ||
| 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;"| | + | | 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''' | |
− | + | ||
|- | |- | ||
Line 291: | Line 284: | ||
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;"| | + | | 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 | ||
− | + | * To view a '''Ledger''' | |
− | + | * To view a '''Net Trial Balance''' | |
− | + | ||
|- | |- | ||
Line 310: | 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
|
|
/* 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:
|
/*Slide 3 */
System Requirements |
To record this tutorial, I am using
If you are using GNUKhata, I would recommend the use of Firefox version 3.6 or above.
Eg-Chromium and Opera. |
/*Slide 4*/
Prerequisites |
I assume that you already know
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 |
|
Point to Reports menu | Under Reports, we have :
|
/* Slide 5*/
Ledger |
|
/* 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 |
|
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 |
|
Click on View button |
|
Point to Opening Balance in Ledger |
|
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 |
|
Click on Edit button |
|
Change the sign of the Opening Balance Amount | Let us make the Opening Balance Amount negative. |
Click on Confirm button |
|
Click on Reports >> Ledger |
|
In the Account Name, select SBI. Click View Ledger with Narration check box. Click on View button |
|
Under Reports menu, Click on Trial Balance | Now let us see the Trial Balance. |
Point to To date |
|
Click on Trial Balance Type drop down | There are three types of Trial Balances in GNUKhata.
|
Select Net Trial Balance from the drop down |
|
| |
Click on Transactions >> Contra >> Find/Edit/Delete Record | We have learnt how to edit of a Transaction in an earlier tutorial.
|
Click Search Record By drop down.
Select Time Interval (From – To). Click on Search button |
|
Click on any of the View button. |
|
Click on Edit button |
|
Change the Debit Amount and Credit Amount to 5000. Click 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 |
|
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 |
In this tutorial, we learnt
|
/* Slide 7*/
Assignment |
As an assignment, explore Gross Trial Balance and Extended Trial Balance reports. |
/* Slide 8 */ | Watch the video available at
project
bandwidth, you can download and watch it |
/* Slide 9 */
Spoken tutorial Workshops |
The Spoken Tutorial Project Team
|
/* 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
http://spoken-tutorial.org /NMEICT-Intro |