Difference between revisions of "Aakash-Business-Tool/C2/Viewing-Reports/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with ' {| style="border-spacing:0;" | style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <c…')
 
Line 1: Line 1:
 
 
{| style="border-spacing:0;"
 
{| style="border-spacing:0;"
 
| style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center>
 
| style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center>
Line 32: Line 31:
  
  
<nowiki>* </nowiki>'''ABT''' 1.0
+
* '''ABT''' 1.0
 
+
* '''Android''' 4.2 Firefox version 3.6 or above.
<nowiki>* </nowiki>'''Android''' 4.2 Firefox version 3.6 or above.
+
  
  
Line 61: Line 59:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button  
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' 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;"| * We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial  
+
| 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;"|  
 +
* We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial  
  
 
* We will select it from the drop-down list.  
 
* We will select it from the drop-down list.  
Line 73: Line 72:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu'''
| 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;"| * We are now on the master menu of '''ABT'''
+
| 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;"|  
 +
* We are now on the master menu of '''ABT'''
  
  
Line 87: Line 87:
 
Under '''Reports''', we have  
 
Under '''Reports''', we have  
  
'''<nowiki>* Ledger</nowiki>'''
+
* '''Ledger'''
  
'''<nowiki>* Trial Balance</nowiki>'''
+
* '''Trial Balance'''
  
'''<nowiki>* Project Statement</nowiki>'''
+
* '''Project Statement'''
  
'''<nowiki>* </nowiki>Cash Flow'''
+
* '''Cash Flow'''
  
'''<nowiki>* Balance Sheet</nowiki>''' and  
+
* '''Balance Sheet''' and  
  
'''<nowiki>* Income and Expenditure. </nowiki>'''
+
* '''Income and Expenditure'''
  
  
Since organization '''Free Accounting Foundation''' is of type '''NGO''', we see '''Income and Expenditure '''option'''. '''
+
Since organization '''Free Accounting Foundation''' is of type '''NGO''', we see '''Income and Expenditure'''
  
  
If the organization is of type '''Profit Making, '''we would see '''Profit and Loss '''option'''.'''
+
If the organization is of type '''Profit Making, '''we would see '''Profit and Loss'''
  
 
|-
 
|-
Line 149: Line 149:
  
 
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>* </nowiki>We will see the 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;"|  
 
+
* We will see the ledger
<nowiki>* A </nowiki>'''Ledger''' is a book of accounts in which entries from transactions are recorded.  
+
* 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>
+
  
 
|-
 
|-
 
| 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>* We will be able to view the </nowiki>organization name,type & financial year at the to
+
| 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;"|  
 +
* We will be able to view the organization name,type & financial year at the to
  
<nowiki>* Opening balance is located at the first row of the table </nowiki>
+
* Opening balance is located at the first row of the table  
 
+
* It is followed by  
<nowiki>* It is </nowiki>followed by  
+
** Transactions, with Total of transactions
 
+
** Closing balance  
<nowiki>** </nowiki>Transactions, with Total of transactions
+
** Grand total at bottom of the table.  
 
+
<nowiki>** Closing balance </nowiki>
+
 
+
<nowiki>** Grand total at bottom of the table. </nowiki>
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar
| 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>* On the right of the title bar you will find the report period and one options </nowiki>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;"|  
 
+
* On the right of the title bar you will find the report period and one options button
<nowiki>* As soon as we click on the button,we see 2 options:</nowiki>
+
* As soon as we click on the button,we see 2 options:
 
+
** Export as pdf
<nowiki>** Export as pdf</nowiki>
+
** Export as CSV
 
+
<nowiki>** Export as CSV</nowiki>
+
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to export as pdf
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to export as pdf
| 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 can also set security to your file </nowiki>by giving it a password
+
| 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 can also set security to your file by giving it a password
<nowiki>* We will enter a password and tap on </nowiki>'''Set password and save file'''
+
* We will enter a password and tap on '''Set password and save file'''
  
 
|-
 
|-
 
| 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>* It says pdf generation completed see /mnt/sdcard/and file name</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;"|  
 
+
* It says pdf generation completed see /mnt/sdcard/and file name
<nowiki>* </nowiki>Similarly we can save CSV files.
+
* Similarly we can save CSV files.
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar
| 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>* On the left side of the title bar you will notice a link</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;"|  
 
+
* On the left side of the title bar you will notice a link
<nowiki>* This link is for entering details to view ledger as we did in previous screen</nowiki>
+
* This link is for entering details to view ledger as we did in previous screen
  
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to 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 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>* There is a feature called drill down </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;"|  
 
+
* There is a feature called drill down  
<nowiki>* </nowiki>Whenever we tap on the account name row in reports, It takes us to its voucher
+
* Whenever we tap on the account name row in reports, It takes us to its voucher
 
+
* We can view voucher details through drill down say drill down for '''Cash on hand'''
<nowiki>* We can view voucher details through drill down </nowiki>say drill down for '''Cash on hand'''
+
  
 
|-
 
|-
 
| 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 217: Line 210:
 
|-
 
|-
 
| 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>* The from date </nowiki>and to date is the financial from date and to date respectively
+
| 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 from date and to date is the financial from date and to date respectively
<nowiki>* T</nowiki>o date is editable
+
* To date is editable
 
+
* We shall keep it as it is
<nowiki>* </nowiki>We shall keep it as it is
+
  
 
|-
 
|-
Line 227: Line 219:
 
| 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.
+
  
 
|-
 
|-
Line 256: Line 245:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement'''
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement'''
| 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>* We can view project statement for </nowiki>various projects
+
| 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;"|  
 
+
* We can view project statement for various projects
<nowiki>* </nowiki>The dropdown contains only '''No Project '''as no other project is created by us
+
* The dropdown contains only '''No Project '''as no other project is created by us
  
 
|-
 
|-
Line 266: Line 255:
 
|-
 
|-
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow
 
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow
| 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 view cash flow report we need to have transactions in purchase, purchase return, sales & sales return</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;"|  
 
+
* To view cash flow report we need to have transactions in purchase, purchase return, sales & sales return
<nowiki>* Net Flow is located at the bottom of the screen </nowiki>in the report
+
* Net Flow is located at the bottom of the screen </nowiki>in the report
  
 
|-
 
|-

Revision as of 10:57, 21 October 2013

Visual Cue
Narration
/* Slide 1 */

Display desktop

Hello and welcome to this spoken tutorial on Viewing_ Reports in ABT
/*Slide 2 */

Objectives

At the end of this tutorial, you will be able to view:
  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income & Expenditure/Profit & Loss


/*Slide 3 */

System Requirements

To record this tutorial, I am using


  • ABT 1.0
  • Android 4.2 Firefox version 3.6 or above.



/*Slide 4*/

Prerequisites

For this tutorial, you must be familiar with:
  • The principles of book keeping.
  • How to run and start ABT
  • How to Create a New Organization

If not, for relevant tutorials please visit http://spoken-tutorial.org

Start ABT Select ABT application on Android 4.2
ABT's Welcome screen We will see ABT's welcome screen
Tap on Select Existing Organization button
  • We had already created an organization called Free Accounting Foundation in Managing organization tutorial
  • We will select it from the drop-down list.


Tap on Login button Lets Login as guest
Point to Master Menu
  • We are now on the master menu of ABT


Point to Reports Tap on Reports
Point to new page You will see the Organization name,type and financial year at the top

Under Reports, we have

  • Ledger
  • Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet and
  • Income and Expenditure


Since organization Free Accounting Foundation is of type NGO, we see Income and Expenditure


If the organization is of type Profit Making, we would see Profit and Loss

/* Interface */

Click on Ledger option


When I click on Ledger option, a new screen appears


Point Select account name
  • Select account name for which the ledger is to be shown
  • We will select SBI


Point to from date and to date
  • From date and to date, by default is financial year’s from date and to date.
  • Change date as per the requirement or keep it as it is.
  • Lets keep it as it is


Point to display narrations Lets check the Check box to view transactions with narrations
Point to Select project name The default is No Project in Projects
Point to view button Lets tap on view button to continue
/* Slide 5*/

Ledger

  • We will see the 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.
  • We will be able to view the organization name,type & financial year at the to
  • Opening balance is located at the first row of the table
  • It is followed by
    • Transactions, with Total of transactions
    • Closing balance
    • Grand total at bottom of the table.
Point to title bar
  • On the right of the title bar you will find the report period and one options button
  • As soon as we click on the button,we see 2 options:
    • Export as pdf
    • Export as CSV
Point to export as pdf
  • You can also set security to your file by giving it a password
  • We will enter a password and tap on Set password and save file
  • It says pdf generation completed see /mnt/sdcard/and file name
  • Similarly we can save CSV files.
Point to title bar
  • On the left side of the title bar you will notice a link
  • This link is for entering details to view ledger as we did in previous screen
Point to ledger
  • There is a feature called drill down
  • Whenever we tap on the account name row in reports, It takes us to its voucher
  • We can view voucher details through drill down say drill down for Cash on hand
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.
Under Reports menu, Click on Trial Balance Now let us see the Trial Balance.
Point to To Date
  • The from date and to date is the financial from date and to date respectively
  • To date is editable
  • We shall keep it as it is
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.
Point to difference in opening balances You will notice difference in opening balances at the bottom

of the report

If we click on any row in the report, we are directed to that account's ledger present in the row
Point to Trial Balance for Another Period To view any other Trial Balance, you can tap on the top left icon
Point to Project Statement
  • We can view project statement for various projects
  • The dropdown contains only No Project as no other project is created by us
Point to view button We can view the report under No Project
Point to cash flow
  • To view cash flow report we need to have transactions in purchase, purchase return, sales & sales return
  • Net Flow is located at the bottom of the screen </nowiki>in the report
Point to Balance sheet * There are 2 types of balance sheet:

Conventional balance sheet & Sources and application of funds

* Conventional balance sheet is horizontal balance sheet

* Sources and application of funds is vertical balance sheet

Likewise you can view other reports too
That's it for this tutorial.
/* Slide 6 */

Summary

* Let's summarise


In this tutorial, we learnt to view

  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income & Expenditure/Profit & Loss


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

Nancyvarkey, Trupti