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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(11 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
{| style="border-spacing:0;"
+
Title of script: '''Viewing Reports'''
−
| 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: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 */
 
  
−
Display desktop
+
Author: Trupti Rajesh Kini
−
| 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 */
 
  
−
Objectives
+
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
−
| 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;"| At the end of this tutorial, you will be able to view:
+
  
−
* '''Ledger'''
+
Cash Book,Export as pdf,Export as CSV,Drill down,option button,icon.
−
* '''Net''' '''Trial Balance'''
+
−
* '''Project Statement'''
+
−
* '''Cash Flow '''
+
−
* '''Balance Sheet'''
+
−
* '''Income & Expenditure/Profit & Loss'''
+
  
  
 +
 +
{|border=1
 +
| <center>'''Visual Cue'''</center>
 +
| <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 3 */
+
| /* Slide 1 */  
 +
| Hello and welcome to this spoken tutorial on '''Viewing Reports''' in ABT
  
−
System Requirements
+
|-
−
| 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 record this tutorial, I am using
+
| /*Slide 2 */
  
 +
Objectives
 +
| In this tutorial, you will be able to view,
  
−
* '''ABT''' 1.0
+
* '''Ledger'''  
−
* '''Android''' 4.2 Firefox version 3.6 or above.
+
*'''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 ('''Bold text'''JellyBean) and
 +
* Rooted tablet
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /*Slide 4*/
+
| Slide 4  
 +
| For more information please visit the following links.
  
−
Prerequisites
+
[https://github.com/androportal/ABT https://github.com/androportal/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;"| For this tutorial, you must be familiar with:
+
  
−
* The principles of book keeping.
+
[http://aakashlabs.org/docs/abt/index.html http://aakashlabs.org/docs/abt/index.html]  
−
* How to run and start '''ABT'''
+
−
* How to Create a New Organization
+
−
 
+
−
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'''
+
| Slide 5
−
| 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
+
  
−
|-
+
Prerequisites
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| '''ABT's''' Welcome screen
+
| For this tutorial, you must be familiar with:  
−
| 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
+
  
−
|-
+
* The principles of book keeping
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button
+
* How to run and start '''ABT''' 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;"|
+
* How to create a new organization  
−
* We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial
+
−
 
+
−
* We will select it from the drop-down list.
+
  
 +
If not, for relevant tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]
  
 +
|-
 +
| Start '''ABT'''
 +
| Select '''ABT''' application.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Login''' button  
+
| 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;"| Lets Login as guest
+
| Select organisation '''Free Accounting Foundation'''.  
  
 
|-
 
|-
−
| 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'''
+
| 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;"|
+
| Login as '''admin.'''
−
* 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'''
+
| 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  
+
| 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
+
| 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
+
| You will see the Organization name, Type and financial period at top centre.
  
−
Under '''Reports''', we have  
+
Under '''Reports''', we have,
  
−
* '''Ledger'''
+
* '''Ledger'''  
 +
* '''Trial Balance'''
 +
* '''Project Statement'''
 +
* '''Cash Flow'''
 +
* '''Balance Sheet'''
 +
* '''Income and Expenditure'''
 +
* '''Cash Book'''
 +
'''Free Accounting Foundation''' is of type '''NGO'''.
  
−
* '''Trial Balance'''
+
So we see '''Income and Expenditure''' under '''Reports''' instead of '''Profit and Loss'''.
  
−
* '''Project Statement'''
+
|-
 +
| /* Interface */
 +
Tap on '''Ledger''' option
 +
| When I tap on '''Ledger''' option, a new window appears.
  
−
* '''Cash Flow'''
+
|-
 +
| Point to '''Select account name'''  
 +
| Select account name for which the ledger is to be shown.
  
−
* '''Balance Sheet''' and
+
Let us select '''Sbi.'''
  
−
* '''Income and Expenditure'''
+
|-
 +
| Point to '''From date''' and '''To date '''
 +
| <tt>'''From date</tt> '''and <tt>'''to date'''</tt>, by default is financial period.
  
 +
Change date as per the requirement or keep it as it is.
  
−
Since organization '''Free Accounting Foundation''' is of type '''NGO''', we see '''Income and Expenditure'''
+
|-
 +
| Point to '''Display narrations '''
 +
| Let us check the Check box for '''Display Narrations'''.
  
−
 
+
|-
−
If the organization is of type '''Profit Making, '''we would see '''Profit and Loss'''
+
| Point to '''Select project name '''
 +
| We have created transactions with '''No Project'''.
 +
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:0.097cm;"| /* Interface */
+
| /* Slide 5*/  
  
−
Click on '''Ledger''' option
+
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.
  
−
| 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 new screen appears
+
Followed by
−
 
+
* '''Total of transactions '''
−
 
+
* '''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 '''Select account name'''
+
| 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;"|
+
| On the top right of the screen, we will find the report period.
−
* Select account name for which the ledger is to be shown
+
−
* We will select SBI
+
  
 +
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.'''
  
 
|-
 
|-
−
| 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
+
| 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;"|
+
| A new window appears.
−
* <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.
+
−
* Lets keep it as it is
+
  
 +
You can secure your file by giving it a password.
  
 +
And then 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 display narrations
+
| 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;"| Lets check the Check box to view transactions with <tt>narrations</tt>
+
| 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: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:0.05pt solid #000000;padding:0.097cm;"| The default is No Project in Projects
+
| Similarly, we can save as '''CSV''' file.  
  
 
|-
 
|-
−
| 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
+
| 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;"| Lets tap on '''view''' button to continue
+
| 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.
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 5*/
+
| Point to ledger report->'''drill down->voucher'''
 +
| There is a feature called '''drill down''' in '''Reports'''.
  
−
Ledger
+
Whenever we long-press on any account name in the row, it takes us to its 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;"|
+
−
* We will see the ledger
+
−
* A '''Ledger''' is a book of accounts in which entries from transactions are recorded.
+
−
* It is a book of final entry summarizing all of a company's transactions.
+
  
−
|-
+
We can view voucher details through drill down, say, drill down of '''Cash '''
−
| 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;"|
+
−
* 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
+
We have drill down for all reports including '''Bank reconciliation'''.  
−
* It is followed by
+
−
** Transactions, with Total of transactions
+
−
** Closing balance
+
−
** Grand total at bottom of the table.  
+
  
 
|-
 
|-
−
| 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
+
| 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;"|
+
| Next, '''Trial Balance'''.  
−
* On the right of the title bar you will find the report period and one options button
+
−
* As soon as we click on the button,we see 2 options:
+
−
** Export as pdf
+
−
** Export as CSV
+
  
 
|-
 
|-
−
| 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
+
| 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;"|
+
| We have three types of '''Trial Balance'''.
−
* You can also set security to your file by giving it a password
+
* '''Net Trial Balance'''
−
* We will enter a password and tap on '''Set password and save file'''
+
* '''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:0.05pt solid #000000;padding:0.097cm;"|
+
| Let us select '''Net Trial Balance.'''
−
* It says pdf generation completed see /mnt/sdcard/and file name
+
Here '''To-date''' is editable.
−
* Similarly we can save CSV files.
+
Tap on '''View'''.
  
 
|-
 
|-
−
| 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
+
| 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;"|
+
|  
−
* On the left side of the title bar you will notice a link
+
−
* This link is for entering details to view ledger as we did in previous screen
+
  
−
|-
+
We will see '''Net Trial Balance''' as at 31 march 2015.
−
| 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
+
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:0.05pt solid #000000;padding:0.097cm;"|
+
−
* 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'''
+
  
 
|-
 
|-
−
| 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'''
+
| 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;"|
+
| Long-press on any row.
−
* As you can see, the '''Opening Balance''' is on the '''Debit''' Side.
+
−
* This is as per the rules of Accounting.
+
  
−
|-
+
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;"| 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: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:none;padding:0.097cm;"| Point to '''To Date '''
+
| 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;"|
+
|
−
* The from date and to date is the financial from date and to date respectively
+
Next, '''Project Statement'''.
−
* To date is editable
+
−
* We shall 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;"| Click on '''Trial Balance Type '''drop down
+
| 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;"| There are three types of '''Trial Balances''' in GNUKhata.
+
| We have created transactions with '''No project'''.
  
−
* '''Net Trial Balance'''
+
So let us view project statement for '''No Project'''.
−
* '''Gross Trial Balance'''
+
−
* '''Extended Trial Balance'''
+
  
−
|-
+
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:0.097cm;"| Select '''Net Trial Balance''' from the drop down
+
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|
+
−
* From the drop down, let us select the '''Net Trial Balance.'''
+
−
* And click on '''View '''button.
+
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''difference in opening balances'''
+
| 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;"| You will notice difference in opening balances at the bottom
+
|  
  
−
of the report
+
Next, '''Cash Flow'''.
  
−
|-
+
We can view cash flow for any period within the financial period.
−
| 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;"| 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: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:0.05pt solid #000000;padding:0.097cm;"| To view any other '''Trial Balance''', you can tap on the top left icon
 
  
−
|-
+
For cash flow, we need transactions in '''Payment '''or '''Receipt '''Vouchers.
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement'''
+
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"|
+
−
* We can view project statement for various projects
+
−
* The dropdown contains only '''No Project '''as no other project is created by us
+
  
−
|-
+
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:0.097cm;"| 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;"| 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:none;padding:0.097cm;"| Point to cash flow
+
| 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:0.097cm;"|  
+
|  
−
* To view cash flow report we need to have transactions in purchase, purchase return, sales & sales return
+
Next, '''Balance Sheet'''
−
* Net Flow is located at the bottom of the screen </nowiki>in the report
+
  
−
|-
+
'''Balance Sheet''' summarizes a company’s
−
| 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'''
+
* Assets,
−
| 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;"|
+
* Liabilities and
−
* There are 2 types of balance sheet:
+
* Shareholders’ equity
  
−
'''Conventional balance sheet''' & '''Sources and application of funds'''
+
It summarizes at a specific point in time.
  
−
'''* Conventional balance sheet''' is horizontal balance sheet
+
There are 2 types of balance sheets:
  
−
*'''Sources and application of funds''' is vertical balance sheet
+
'''Conventional balance sheet''' & '''Sources and application of funds'''  
  
−
|-
 
−
| 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
 
  
−
|-
+
Let us select '''Conventional 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;"| That's it for this tutorial.
+
* '''Conventional balance sheet''' is horizontal balance sheet whereas
 +
* '''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:0.097cm;"| /* Slide 6 */
+
| Point to Balance sheet
 +
| This is the Balance sheet for '''Free Accounting Foundation''' as at 31 march 2015.
  
−
Summary
+
We can see '''Corpus & Liabilities''' are at the 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;"|
+
−
* Let's summarise
+
  
 +
Whereas
  
−
In this tutorial, we learnt to view
+
'''Property and Assets''' are at the right of the screen.
−
 
+
−
* '''Ledger'''
+
−
* '''Net''' '''Trial Balance'''
+
−
* '''Project Statement'''
+
−
* '''Cash Flow '''
+
−
* '''Balance Sheet'''
+
−
* '''Income & Expenditure/Profit & Loss'''
+
  
  
 +
'''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:0.097cm;"| /* Slide 7*/
+
|  
 +
|  
 +
Next, '''Income and Expenditure''',
  
−
Assignment
+
'''Income and Expenditure''' records the income and expenditure of an organization.
−
| 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:0.05pt solid #000000;padding:0.097cm;"| Watch the video available at
+
|  
 +
Next, we can view '''Cash Book''' for the organisation '''Free Accounting Foundation'''.
  
−
http:spoken-tutorial.org/
+
|-
 +
| /* Slide 6 */  
  
 +
Summary
 +
| So, in this tutorial, we have seen,
  
−
It summarizes the Spoken Tutorial
+
* '''Ledger'''
 +
* '''Net Trial Balance'''
 +
* '''Project Statement'''
 +
* '''Cash Flow '''
 +
* '''Balance Sheet'''
 +
* '''Income and Expenditure''' and
 +
* '''Cash Book'''
  
−
project
+
|-
 +
| /* Slide 7*/
  
 +
Assignment
 +
| As an assignment, explore '''Gross Trial Balance''' and '''Extended Trial Balance''' reports for '''SBI.'''
  
−
If you do not have good
+
|-
 +
| /* Slide 8 */
 +
| Watch the video available at  http:spoken-tutorial.org/
  
−
bandwidth, you can download
+
It summarizes the Spoken Tutorial  project
  
−
and watch it  
+
If you do not have good bandwidth, you can download and watch it  
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 9 */
+
| /* 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
+
−
 
+
−
 
+
−
Conducts workshops using spoken tutorials
+
−
 
+
−
 
+
−
Gives certificates to those who pass an online test
+
  
 +
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  
 
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 */
+
| /* 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  
+
| 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  

Latest revision as of 15:54, 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
  • 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 (Bold textJellyBean) and
  • Rooted tablet
Slide 4 For more information please visit the following links.

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 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 Project.

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.

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 file.
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 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.

We can view cash flow for any period within the financial period.


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 sheets:

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 see Corpus & Liabilities are 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 have seen,
  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income and Expenditure and
  • 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=9142"