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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 1: Line 1:
 
Title of script: '''Viewing Reports'''
 
Title of script: '''Viewing Reports'''
 +
  
 
Author: Trupti Rajesh Kini
 
Author: Trupti Rajesh Kini
  
−
Keywords: Video Tutorial, Organisation, Contra, Journal, Receipt, transaction, Voucher number and Voucher reference number, Payment Mode
+
 
 +
Keywords: Ledger,Trial Balance-Net Trial Balance,Gross Trial Balance,Extended Trial Balance,Project Statement,Cash Flow,Balance Sheet-Conventional balance sheet & Sources and application of funds,Income & Expenditure/Profit & Loss
 +
 
 +
Cash Book,Export as pdf,Export as CSV,Drill down,option button,icon.
 +
 
  
  
 
{| 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-top:0.097cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| <center>'''Visual Cue'''</center>
 
| style="border:0.05pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center>
 
| style="border:0.05pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center>
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 1 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 1 */  
−
 
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Hello and welcome to this spoken tutorial on '''Viewing Reports''' in 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;"| Hello and welcome to this spoken tutorial on '''Viewing Reports''' in ABT
+
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /*Slide 2 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /*Slide 2 */  
  
−
Objectives
+
Objectives  
−
| 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 this tutorial, you will be able to view,
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In this tutorial, you will be able to view,  
  
−
* '''Ledger'''
+
* '''Ledger'''  
−
* '''Net''' '''Trial Balance'''
+
* '''Net''' '''Trial Balance'''  
−
* '''Project Statement'''
+
* '''Project Statement'''  
 
* '''Cash Flow '''
 
* '''Cash Flow '''
−
* '''Balance Sheet'''
+
* '''Balance Sheet'''  
−
* '''Income & Expenditure/Profit & Loss'''
+
* '''Income & Expenditure/Profit & Loss'''  
−
* '''Cash Book'''
+
* '''Cash Book'''  
 +
 
  
  
Line 37: Line 42:
  
 
* '''ABT 1.0 '''
 
* '''ABT 1.0 '''
−
* '''Android''' 4.2 (JellyBean) &
+
* '''Android''' 4.2 (JellyBean) &  
 
* Rooted tablet  
 
* Rooted tablet  
 +
 +
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Slide 4
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Slide 4  
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| For more information please visit,
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| For more information please visit,  
  
 
[https://github.com/androportal/ABT https://github.com/androportal/ABT]  
 
[https://github.com/androportal/ABT https://github.com/androportal/ABT]  
Line 49: Line 56:
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Slide 5
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Slide 5  
  
 
Prerequisites  
 
Prerequisites  
Line 55: Line 62:
  
 
* The principles of book keeping.  
 
* The principles of book keeping.  
−
* How to run and start '''ABT''' and
+
* How to run and start '''ABT''' and  
 
* How to create a new organization  
 
* How to create a new organization  
  
 
If not, for relevant tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]  
 
If not, for relevant tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]  
 +
 +
  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Start '''ABT'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Start '''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;"| Select '''ABT''' application on '''Android''' 4.2
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Select '''ABT''' application on '''Android''' 4.2.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''ABT's''' Welcome screen  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''ABT's''' Welcome screen  
−
| 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 '''ABT's''' welcome screen  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We will see '''ABT's''' welcome 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 '''Select Existing Organization''' button  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''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;"|  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We had already created an organization called '''Free Accounting Foundation'''.  
−
We had already created an organization called '''Free Accounting Foundation'''.
+
 
−
Let's select the organization.
+
  
  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to login page
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to login page  
−
| 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 Login as '''admin'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Lets login as '''admin.'''
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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;"|  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We are now on the master menu of '''ABT'''.  
−
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:none;padding:0.097cm;"| Point to '''Reports'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''Reports'''  
−
| 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;"| Tap on '''Reports'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''Reports'''  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to new page
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to new page  
−
| 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 see the Organization name,type and financial year at the top
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| You will see the Organization name,type and financial year at the top  
  
−
Under '''Reports''', we have  
+
Under '''Reports''', we have,
  
−
* '''Ledger'''
+
* '''Ledger'''  
  
−
* '''Trial Balance'''
+
* '''Trial Balance'''  
  
−
* '''Project Statement'''
+
* '''Project Statement'''  
  
−
* '''Cash Flow'''
+
* '''Cash Flow'''  
  
 
* '''Balance Sheet''' and  
 
* '''Balance Sheet''' and  
  
−
* '''Income and Expenditure'''
+
* '''Income and Expenditure'''  
  
−
* '''Cash Book'''
+
* '''Cash Book'''  
  
 +
'''Free Accounting Foundation''' is of type '''NGO'''.
  
−
'''Free Accounting Foundation''' is of type '''NGO'''.
+
So we see '''Income and Expenditure''' under '''Reports''' instead of '''Profit and Loss'''.  
−
So we see '''Income and Expenditure''' under '''Reports''' instead of '''Profit and Loss'''.
+
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Interface */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Interface */  
  
−
Click on '''Ledger''' option
+
Click on '''Ledger''' option  
  
  
  
−
| 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;"| when I click on '''Ledger''' option, a dialog-box appears
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| When I tap on '''Ledger''' option, a new window appears.
 +
 
  
  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point '''Select account name'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''Select account name'''  
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Select account name for which the ledger is to be shown.
−
Select account name for which the ledger is to be shown
+
−
We will select SBI
+
−
 
+
  
 +
Let us view ledger for '''Sbi.'''
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to from date and to date  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''From date''' and '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| <tt>'''From date</tt> '''and <tt>'''to date'''</tt>, by default is financial year period.
−
<tt>From date</tt> and <tt>to date</tt>, by default is financial year’s from date and to date.  
+
 
−
Change date as per the requirement or keep it as it is.
+
Change date as per the requirement or keep it as it is.  
−
Lets keep it as it is
+
 
  
  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to display narrations
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''Display narrations '''
−
| 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 check the Check box to view transactions with <tt>narrations</tt>
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Let us check the Check box to view transactions with <tt>narrations.</tt>  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Select project name '''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''Select project name '''
−
| 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 default is No Project in Projects
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| There are no projects created yet.
 +
 
 +
 
 +
 
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to view button
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''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;"| Lets tap on '''view''' button to continue
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''view''' button to continue.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 5*/
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 5*/  
 +
 
 +
Ledger
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We will see the 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;"|
 
−
We will see the ledger
 
 
A '''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.
+
 
 +
It is a book of final entry summarizing all of a company's transactions.  
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to the '''Ledger '''report
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We will be able to view the organization name,type & financial year at the top.
−
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  
 
Opening balance is located at the first row of the table  
 +
 
It is followed by  
 
It is followed by  
−
* Transactions, with Total of transactions
+
 
−
* Closing balance  
+
* '''Total of transactions '''
−
* Grand total at bottom of the table.
+
* '''Closing balance '''
 +
* '''Grand total '''
 +
 
 +
 
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to the top right of the screen
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| On the top right of the screen, you will find the report period.
−
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:
+
Above that, there is '''options''' button.
−
* Export as pdf
+
 
−
* Export as CSV
+
As soon as we tap on the button,we see 2 options:  
 +
 
 +
* '''Export as pdf '''
 +
* '''Export as CSV '''
 +
 
 +
 
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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;"|  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''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'''
+
 
 +
 
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to the new window
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| A new window appears.
−
It says pdf generation completed see /mnt/sdcard/and file name
+
 
−
Similarly we can save CSV files.
+
You can secure your file by giving it a password here.
 +
 
 +
Lets enter a password
 +
 
 +
Tap on '''Set password and save file''' button.
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to the message
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| It says pdf generation completed see''' /mnt/sdcard/ '''location for the desired file.
−
On the left side of the title bar you will notice a icon.
+
 
−
This icon is for changing input 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''/mnt/sdcard'''
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Let us go to the location.
−
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'''
+
−
We have drill down for all reports including '''Bank reconciliation'''
+
  
 +
Enter the given password.
  
 +
We can view our report.
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"|  
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Similarly, we can save '''CSV''' files.  
−
As you can see, the '''Opening Balance''' is on the '''Debit''' Side.
+
−
This is as per the rules of Accounting.
+
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Under '''Reports '''menu, Click on '''Trial Balance'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to the top left of the screen
−
| 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 see the '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| On the top left of the screen, you will notice another icon.
 +
 
 +
 
 +
This is for changing input 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 '''To Date '''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to ledger report->'''drill down->voucher'''
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In reports, there is a feature called '''drill down.'''
−
The from date and to date is the financial from date and to date respectively
+
 
−
To date is editable
+
Long press on any row in reports.
−
We shall keep it as it is
+
 
 +
It will take us to its voucher.
 +
 
 +
We can view voucher details through drill down say drill down for '''Cash '''
 +
 
 +
We have drill down for all reports including '''Bank reconciliation'''
 +
 
 +
 
 +
 
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Click on '''Trial Balance Type '''drop down
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Under '''Reports '''menu, Point to '''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;"| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Now let us see '''Trial Balance'''.  
  
−
* '''Net Trial Balance'''
+
Balances of all ledgers are compiled into debit and credit columns .
−
* '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''Trial Balance'''
−
From the drop down, let us select the '''Net Trial Balance.'''  
+
 
−
And click on '''View '''button.
+
A new window appears.
 +
 
 +
'''To date '''is editable here.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''difference in opening balances'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Click on '''Trial Balance Type '''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;"| You will notice difference in opening balances at the bottom
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| There are three types of '''Trial Balance '''in''' ABT.'''
 +
 
 +
* '''Net Trial Balance'''
 +
* '''Gross Trial Balance'''
 +
* '''Extended Trial Balance'''
 +
 
  
−
of the report
 
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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;"| If we click on any row in the report, we are directed to that account's ledger present in the row
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| From the drop down, let us select the '''Net Trial Balance.'''
 +
 
 +
Tap 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;"| Point to '''Trial Balance for Another Period'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''difference in opening balances'''  
−
| 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 any other '''Trial Balance''', you can tap on the top left icon
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| You will notice, difference in opening balances at the bottom
 +
 
 +
of the report.
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to drill 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Long press on any row in the report.
−
We can view project statement for various projects
+
 
−
The dropdown contains only '''No Project '''as no other project is created by us
+
We are directed to that account's 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 view button
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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;"| We can view the report under '''No Project'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We can view project statement for various projects
 +
 
 +
The dropdown contains only '''No Project '''as no project is created by us.
  
 
|-
 
|-
−
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We can view the report under '''No Project.'''
−
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
+
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Balance sheet'''
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| 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;"|  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| To view cash flow report we need to have transactions in '''Payment '''or '''Receipt '''Vouchers.
−
There are 2 types of balance sheet:
+
 
 +
Net Flow is located at the bottom of the report.
 +
 
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to '''Balance sheet'''  
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| '''Balance Sheet s'''ummarizes a company’s
 +
 
 +
<nowiki>* Assets, </nowiki>
 +
 
 +
<nowiki>* Liabilities and </nowiki>
 +
 
 +
<nowiki>* Shareholders’ equity </nowiki>
 +
 
 +
at a specific point in time
 +
 
 +
There are 2 types of balance sheet:  
  
−
'''Conventional balance sheet''' & '''Sources and application of funds'''
+
'''Conventional balance sheet''' & '''Sources and application of funds'''  
  
 
* '''Conventional balance sheet''' is horizontal balance sheet  
 
* '''Conventional balance sheet''' is horizontal balance sheet  
  
−
*'''Sources and application of funds''' is vertical balance sheet
+
* '''Sources and application of funds''' is vertical balance sheet  
  
−
|-
 
−
| 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;"| Likewise you can view other reports too
 
  
−
|-
 
−
| 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;"| That's it for this tutorial.
 
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 6 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"|  
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Likewise you can view other reports too.
  
−
Summary
+
In '''Income and Expenditure '''it records the income and
−
| 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
+
  
 +
expenditure of an organization .
  
−
In this tutorial, we learnt to view
+
Difference between '''Cash Book '''and '''Cash Flow '''is,
  
−
* '''Ledger'''
+
In Cash Book all cash receipts and
−
* '''Net''' '''Trial Balance'''
+
cash payments are recorded.
−
* '''Project Statement'''
+
−
* '''Cash Flow '''
+
−
* '''Balance Sheet'''
+
−
* '''Income & Expenditure/Profit & Loss'''
+
−
* '''Cash Book'''
+
  
 +
In Cash Flow Statement all inflows
 +
and outflows of cash are exhibited.
  
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"|
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| That's it for this tutorial.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 7*/
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 6 */  
 +
 
 +
Summary
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In this tutorial, we learnt to view,
 +
 
 +
* '''Ledger'''
 +
* '''Net''' '''Trial Balance'''
 +
* '''Project Statement'''
 +
* '''Cash Flow '''
 +
* '''Balance Sheet'''
 +
* '''Income & Expenditure/Profit & Loss'''
 +
* '''Cash Book'''
 +
 
  
−
Assignment
 
−
| 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 an assignment, explore '''Gross Trial Balance''' and '''Extended Trial Balance''' reports.
 
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 8 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 7*/
−
| 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/
+
Assignment
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| As an assignment, explore '''Gross Trial Balance''' and '''Extended Trial Balance''' reports for '''Sbi.'''
 +
 
 +
|-
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 8 */
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Watch the video available at
  
 +
http:spoken-tutorial.org/
  
 
It summarizes the Spoken Tutorial  
 
It summarizes the Spoken Tutorial  
  
 
project  
 
project  
−
 
  
 
If you do not have good  
 
If you do not have good  
Line 338: Line 400:
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 9 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 9 */
−
 
+
−
Spoken tutorial Workshops
+
−
| 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 Spoken Tutorial Project Team
+
  
 +
Spoken tutorial Workshops
 +
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| The Spoken Tutorial Project Team
  
 
Conducts workshops using spoken tutorials  
 
Conducts workshops using spoken tutorials  
−
 
  
 
Gives certificates to those who pass an online test  
 
Gives certificates to those who pass an online test  
−
 
  
 
For more details, please write to contact@spoken-tutorial.org  
 
For more details, please write to contact@spoken-tutorial.org  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 10 */
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| /* Slide 10 */  
  
−
Acknowledgements
+
Acknowledgements  
−
| 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;"| Spoken Tutorial Project is a part of the Talk to a Teacher project  
+
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| 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  
 
It is supported by the National Mission on Education through ICT, MHRD, Government of India  
−
 
  
 
More information on this Mission is available at  
 
More information on this Mission is available at  

Revision as of 16:26, 17 February 2014

Title of script: Viewing Reports


Author: Trupti Rajesh Kini


Keywords: Ledger,Trial Balance-Net Trial Balance,Gross Trial Balance,Extended Trial Balance,Project Statement,Cash Flow,Balance Sheet-Conventional balance sheet & Sources and application of funds,Income & Expenditure/Profit & Loss

Cash Book,Export as pdf,Export as CSV,Drill down,option button,icon.


Visual Cue
Narration
/* Slide 1 */ Hello and welcome to this spoken tutorial on Viewing Reports in ABT
/*Slide 2 */

Objectives

In this tutorial, you will be able to view,
  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income & Expenditure/Profit & Loss
  • Cash Book


Slide 3

System Requirements

In this tutorial, I am using
  • ABT 1.0
  • Android 4.2 (JellyBean) &
  • Rooted tablet


Slide 4 For more information please visit,

https://github.com/androportal/ABT

http://aakashlabs.org/docs/abt/index.html

Slide 5

Prerequisites

For this tutorial, you must be familiar with:
  • The principles of book keeping.
  • How to run and start ABT and
  • 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.
Point to ABT's Welcome screen We will see ABT's welcome screen.
Point to Select Existing Organization button We had already created an organization called Free Accounting Foundation.



Point to login page Lets login as admin.
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
  • Cash Book

Free Accounting Foundation is of type NGO.

So we see Income and Expenditure under Reports instead of Profit and Loss.

/* Interface */

Click on Ledger option


When I tap on Ledger option, a new window appears.



Point to Select account name Select account name for which the ledger is to be shown.

Let us view ledger for Sbi.

Point to From date and To date From date and to date, by default is financial year period.

Change date as per the requirement or keep it as it is.



Point to Display narrations Let us check the Check box to view transactions with narrations.
Point to Select project name There are no projects created yet.



Point to view button 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.

Point to the Ledger report We will be able to view the organization name,type & financial year at the top.

Opening balance is located at the first row of the table

It is followed by

  • Total of transactions
  • Closing balance
  • Grand total


Point to the top right of the screen On the top right of the screen, you will find the report period.

Above that, there is options button.

As soon as we tap on the button,we see 2 options:

  • Export as pdf
  • Export as CSV


Point to export as pdf Tap on Export as pdf.



Point to the new window A new window appears.

You can secure your file by giving it a password here.

Lets enter a password

Tap on Set password and save file button.

Point to the message It says pdf generation completed see /mnt/sdcard/ location for the desired file.



Point to /mnt/sdcard Let us go to the location.

Enter the given password.

We can view our report.

Similarly, we can save CSV files.
Point to the top left of the screen On the top left of the screen, you will notice another icon.


This is for changing input details to view ledger as we did in previous screen.

Point to ledger report->drill down->voucher In reports, there is a feature called drill down.

Long press on any row in reports.

It will take us to its voucher.

We can view voucher details through drill down say drill down for Cash

We have drill down for all reports including Bank reconciliation



Under Reports menu, Point to Trial Balance Now let us see Trial Balance.

Balances of all ledgers are compiled into debit and credit columns .

Point to To Date Tap on Trial Balance

A new window appears.

To date is editable here.

Click on Trial Balance Type drop down There are three types of Trial Balance in ABT.
  • 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.

Tap on View button.

Point to difference in opening balances You will notice, difference in opening balances at the bottom

of the report.

Point to drill down Long press on any row in the report.

We are directed to that account's ledger.

Point to Project Statement We can view project statement for various projects

The dropdown contains only No Project as no 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 Payment or Receipt Vouchers.

Net Flow is located at the bottom of the report.

Point to Balance sheet Balance Sheet summarizes a company’s

* Assets,

* Liabilities and

* Shareholders’ equity

at a specific point in time

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.

In Income and Expenditure it records the income and

expenditure of an organization .

Difference between Cash Book and Cash Flow is,

In Cash Book all cash receipts and 

cash payments are recorded.

In Cash Flow Statement all inflows 

and outflows of cash are exhibited.
That's it for this tutorial.
/* Slide 6 */

Summary

In this tutorial, we learnt to view,
  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income & Expenditure/Profit & Loss
  • Cash Book


/* Slide 7*/

Assignment

As an assignment, explore Gross Trial Balance and Extended Trial Balance reports for Sbi.
/* 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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=Aakash-Business-Tool/C2/Viewing-Reports/English&oldid=8692"