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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 72: Line 72:
 
|-
 
|-
 
| 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: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-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:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Select '''ABT''' application  
  
|-
 
| 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-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-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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We had already created an organization called '''Free Accounting Foundation'''.  
+
| 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 organisation '''Free Accounting Foundation'''.  
  
  
Line 87: Line 84:
 
|-
 
|-
 
| 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: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-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:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Login as '''admin.'''
 
+
|-
+
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We are now on the master menu of '''ABT'''.
+
  
  
Line 102: Line 95:
 
|-
 
|-
 
| 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: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-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  
+
| 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 period at top centre
  
 
Under '''Reports''', we have,
 
Under '''Reports''', we have,
Line 126: Line 119:
 
|-
 
|-
 
| 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 */  
 
| 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 */  
 
+
Tap on '''Ledger''' option  
Click on '''Ledger''' option  
+
  
  
Line 140: Line 132:
 
| 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.
 
| 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.
  
Let us view ledger for '''Sbi.'''
+
Let us select '''Sbi.'''
  
 
|-
 
|-
Line 153: Line 145:
 
|-
 
|-
 
| 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: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-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: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 for '''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 '''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-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:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We have created transactions with '''No Projects'''.
 +
So, keep the default 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 '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''view''' button to continue.
 
  
 
|-
 
|-
Line 170: Line 159:
  
 
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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We will see the ledger here
 
+
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.
+
  
 
|-
 
|-
 
| 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: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-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.
+
| 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 organization name,type & financial period at the top center
  
 
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  
+
Followed by  
  
 
* '''Total of transactions '''
 
* '''Total of transactions '''
Line 192: Line 178:
 
|-
 
|-
 
| 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: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-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.
+
| 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, we will find the report period.
  
Above that, there is '''option''' button.
+
Above that, there are '''options'''
 
+
Options to export report as pdf or as CSV.
As soon as we tap on the button,we see 2 options:
+
 
+
* '''Export as pdf '''
+
* '''Export as CSV '''
+
  
  
Line 205: Line 187:
 
|-
 
|-
 
| 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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''Export as pdf option.'''
  
  
Line 216: Line 198:
 
You can secure your file by giving it a password here.
 
You can secure your file by giving it a password here.
  
Lets enter a password
+
And then tap on '''Set password and save file''' button.
 
+
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-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: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-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.
+
| 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/ ''' for the file.
  
  
  
  
|-
 
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Let us go to the location.
 
  
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-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: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;"| Similarly, we can save '''CSV''' files.  
+
| 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 as '''CSV''' files.  
  
 
|-
 
|-
 
| 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: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-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.  
+
| 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, there is another icon.  
  
  
Line 248: Line 223:
 
|-
 
|-
 
| 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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In reports, there is a feature called '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| There is a feature called '''drill down''' in reports.
 
+
Long press on any row in reports.
+
  
It will take us to its voucher.
+
Whenever we long press on any account name in the row, it takes us to its voucher.
  
 
We can view voucher details through drill down say drill down of '''Cash '''
 
We can view voucher details through drill down say drill down of '''Cash '''
Line 263: Line 236:
 
|-
 
|-
 
| 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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Now let us see '''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;"| Next, '''Trial Balance'''.  
  
Balances of all ledgers are compiled into debit and credit columns .
 
 
|-
 
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''Trial Balance'''
 
 
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-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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| There are three types of '''Trial Balance '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We have three types of '''Trial Balance.
 
+
 
* '''Net Trial Balance'''  
 
* '''Net Trial Balance'''  
 
* '''Gross Trial Balance'''  
 
* '''Gross Trial Balance'''  
Line 287: Line 250:
 
|-
 
|-
 
| 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: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-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.'''  
+
| 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 select the '''Net Trial Balance.'''  
 
+
Here '''To-date''' is editable.
Tap on '''View '''button.
+
Tap on '''View'''
 +
  
 
|-
 
|-
 
| 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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right: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;"|  
 
+
We will see '''Net Trial Balance''' as at 31 march 2015.
of the report.
+
We can view '''Difference in opening balances''' at the bottom of the 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 drill 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 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Long press on any row in the report.
+
| 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.
 
+
 
We are directed to that account's ledger.
 
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-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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We can view project statement for 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"|
 +
Next, '''Project Statement'''
  
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-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: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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right: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 have created transactions with '''No project'''
 +
So let us view project statement for '''No Project'''
 +
This is the project statement with '''Difference in opening balance''' 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 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 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-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.
+
| 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;"|  
 +
Next, '''Cash Flow'''
 +
For cash flow we need transactions in '''Payment '''or '''Receipt '''Vouchers.
  
'''Net Flow''' is located at the bottom of the report.
+
We can view '''Net Flow''' 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: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
+
| 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;"|  
 +
Next, '''Balance Sheet'''
 +
'''Balance Sheet''' summarizes a company’s
  
 
* Assets,  
 
* Assets,  
Line 328: Line 297:
  
 
* Shareholders’ equity
 
* Shareholders’ equity
 
+
It summarizes at a specific point in time  
at a specific point in time  
+
  
 
There are 2 types of balance sheet:  
 
There are 2 types of balance sheet:  
  
 
'''Conventional balance sheet''' & '''Sources and application of funds'''  
 
'''Conventional balance sheet''' & '''Sources and application of funds'''  
 +
Let us select '''Conventional balance sheet'''
  
* '''Conventional balance sheet''' is horizontal balance sheet  
+
* '''Conventional balance sheet''' is horizontal balance sheet whereas
  
 
* '''Sources and application of funds''' is vertical balance sheet  
 
* '''Sources and application of funds''' is vertical balance sheet  
 +
Tap on view
  
  
  
 
|-
 
|-
| 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: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;"| 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:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"|  
 +
This is the Balance sheet for Free Accounting Foundation as at 31 march 2015
  
In '''Income and Expenditure '''it records the income and  
+
We can view '''Corpus & Liabilities at the left of the screen,
 +
Whereas
 +
Property and Assets are at the right of the screen.
 +
 
 +
'''Differences in opening balances''' is 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;"|
 +
| 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;"|
 +
Next, '''Income and Expenditure'''
 +
'''Income and Expenditure''' records the income and  
  
 
expenditure of an organization .
 
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.
 
  
 
|-
 
|-
 
| 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: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:0.05pt solid #000000;padding-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"|  
 +
Next, we can view '''Cash Book''' for the organisation '''Free Accounting Foundation'''
 +
 
 +
 
 +
 
 +
 
 +
 
  
 
|-
 
|-
Line 363: Line 350:
  
 
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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In this tutorial, we learnt 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;"| So, in this tutorial, we seen,
  
 
* '''Ledger'''  
 
* '''Ledger'''  
Line 370: Line 357:
 
* '''Cash Flow '''
 
* '''Cash Flow '''
 
* '''Balance Sheet'''  
 
* '''Balance Sheet'''  
* '''Income & Expenditure/Profit & Loss'''  
+
* '''Income & Expenditure/Profit & Loss''' &
 
* '''Cash Book'''  
 
* '''Cash Book'''  
  

Revision as of 14:28, 14 March 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


Point to Select Existing Organization button Select organisation Free Accounting Foundation.



Point to login page Login as admin.



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

Under Reports, we have,

  • Ledger
  • Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • 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 */

Tap 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 select 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 for Display Narrations.
Point to Select project name We have created transactions with No Projects.

So, keep the default project name.



/* Slide 5*/

Ledger

We will see the ledger here


Point to the Ledger report We can view the organization name,type & financial period at the top center

Opening balance is located at the first row of the table

Followed by

  • Total of transactions
  • Closing balance
  • Grand total


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

Above that, there are options Options to export report as pdf or as CSV.


Point to export as pdf Tap on Export as pdf option.



Point to the new window A new window appears.

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

And then tap on Set password and save file button.

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




Similarly, we can save as CSV files.
Point to the top left of the screen On the top left of the screen, there is another icon.


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

Point to ledger report->drill down->voucher There is a feature called drill down in reports.

Whenever we long press on any account name in the row, it takes us to its voucher.

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

We have drill down for all reports including Bank reconciliation



Under Reports menu, Point to Trial Balance Next, Trial Balance.


Click on Trial Balance Type drop down We have three types of Trial Balance.
  • Net Trial Balance
  • Gross Trial Balance
  • Extended Trial Balance


Select Net Trial Balance from the drop down Let us select the Net Trial Balance.

Here To-date is editable. Tap on View


Point to difference in opening balances

We will see Net Trial Balance as at 31 march 2015. We can view Difference in opening balances at the bottom of the screen.

Point to drill down Long press on any row.

We are directed to that account's ledger.

Point to Project Statement

Next, Project Statement


Point to view button We have created transactions with No project

So let us view project statement for No Project This is the project statement with Difference in opening balance at the bottom of the report.

Point to cash flow

Next, Cash Flow For cash flow we need transactions in Payment or Receipt Vouchers.

We can view Net Flow at the bottom of the report.

Point to Balance sheet

Next, Balance Sheet Balance Sheet summarizes a company’s

  • Assets,
  • Liabilities and
  • Shareholders’ equity

It summarizes at a specific point in time

There are 2 types of balance sheet:

Conventional balance sheet & Sources and application of funds Let us select Conventional balance sheet

  • Conventional balance sheet is horizontal balance sheet whereas
  • Sources and application of funds is vertical balance sheet

Tap on view


Point to Balance sheet

This is the Balance sheet for Free Accounting Foundation as at 31 march 2015

We can view Corpus & Liabilities at the left of the screen, Whereas Property and Assets are at the right of the screen.

Differences in opening balances is at the bottom of the report



Next, Income and Expenditure Income and Expenditure records the income and

expenditure of an organization .



Next, we can view Cash Book for the organisation Free Accounting Foundation




/* Slide 6 */

Summary

So, in this tutorial, we seen,
  • 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