Difference between revisions of "Aakash-Business-Tool/C2/Viewing-Reports/English"
Line 1: | Line 1: | ||
+ | Title of script: Viewing Reports | ||
+ | |||
+ | Author: Trupti Rajesh Kini | ||
+ | |||
+ | Keywords: Video Tutorial, Organisation, Contra, Journal, Receipt, transaction, Voucher number and Voucher reference number, Payment Mode | ||
+ | |||
+ | |||
{| style="border-spacing:0;" | {| style="border-spacing:0;" | ||
| style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center> | | style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center> | ||
Line 7: | Line 14: | ||
Display desktop | Display desktop | ||
− | | 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 | + | | 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 |
|- | |- | ||
Line 13: | Line 20: | ||
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;"| | + | | 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, |
* '''Ledger''' | * '''Ledger''' | ||
Line 22: | Line 29: | ||
* '''Income & Expenditure/Profit & Loss''' | * '''Income & Expenditure/Profit & Loss''' | ||
* '''Cash Book''' | * '''Cash Book''' | ||
− | |||
− | |||
|- | |- | ||
− | | 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;"| Slide 3 |
− | System Requirements | + | 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;"| | + | | 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, I am using |
+ | * '''ABT 1.0 ''' | ||
+ | * '''Android''' 4.2 (JellyBean) & | ||
+ | * 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: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] | ||
+ | [http://aakashlabs.org/docs/abt/index.html http://aakashlabs.org/docs/abt/index.html] | ||
|- | |- | ||
− | | 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;"| Slide 5 |
− | Prerequisites | + | Prerequisites |
− | | 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: | + | | 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 this tutorial, you must be familiar with: |
* The principles of book keeping. | * The principles of book keeping. | ||
− | * How to run and start '''ABT''' | + | * How to run and start '''ABT''' and |
− | * How to | + | * 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] | ||
+ | |||
|- | |- | ||
Line 62: | Line 73: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial | |
− | + | We will select it from the drop-down list. | |
Line 75: | Line 86: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu''' | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | We are now on the master menu of '''ABT''' | |
Line 123: | Line 134: | ||
| 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:0.097cm;"| Point '''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:0.097cm;"| | ||
− | + | Select account name for which the ledger is to be shown | |
− | + | We will select SBI | |
Line 131: | Line 142: | ||
| 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: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:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | <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 | |
Line 154: | Line 165: | ||
Ledger | Ledger | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | 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. | |
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | We will be able to view the organization name,type & financial year at the to | |
− | + | Opening balance is located at the first row of the table | |
− | + | It is followed by | |
− | + | * Transactions, with Total of transactions | |
− | + | * Closing balance | |
− | + | * Grand total at bottom of the table. | |
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | On the right of the title bar you will find the report period and one options button | |
− | + | 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 | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to export as pdf | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | You can also set security to your file by giving it a password | |
− | + | We will enter a password and tap on '''Set password and save file''' | |
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | It says pdf generation completed see /mnt/sdcard/and file name | |
− | + | Similarly we can save CSV files. | |
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to title bar | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | 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 icon. | |
− | + | This icon is for changing input details to view ledger as we did in previous screen | |
Line 199: | Line 210: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to ledger | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to ledger | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | 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''' | |
− | + | We have drill down for all reports including '''Bank reconciliation''' | |
Line 209: | Line 220: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Opening Balance''' in '''Ledger''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Opening Balance''' in '''Ledger''' | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | As you can see, the '''Opening Balance''' is on the '''Debit''' Side. | |
− | + | This is as per the rules of Accounting. | |
|- | |- | ||
Line 219: | Line 230: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To Date ''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To Date ''' | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | The from date and to date is the financial from date and to date respectively | |
− | + | To date is editable | |
− | + | We shall keep it as it is | |
|- | |- | ||
Line 234: | Line 245: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''Net Trial Balance''' from the drop down | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''Net Trial Balance''' from the drop down | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | ||
− | + | From the drop down, let us select the '''Net Trial Balance.''' | |
− | + | And click on '''View '''button. | |
|- | |- | ||
Line 254: | Line 265: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement''' | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | 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 | |
|- | |- | ||
Line 264: | Line 275: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | | 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 | |
− | + | 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:0.097cm;"| 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;"| | | 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 2 types of balance sheet: | |
'''Conventional balance sheet''' & '''Sources and application of funds''' | '''Conventional balance sheet''' & '''Sources and application of funds''' |
Revision as of 12:46, 7 February 2014
Title of script: Viewing Reports
Author: Trupti Rajesh Kini
Keywords: Video Tutorial, Organisation, Contra, Journal, Receipt, transaction, Voucher number and Voucher reference number, Payment Mode
|
|
/* Slide 1 */
Display desktop |
Hello and welcome to this spoken tutorial on Viewing Reports in ABT |
/*Slide 2 */
Objectives |
In this tutorial, you will be able to view,
|
Slide 3
System Requirements |
In this tutorial, I am using
|
Slide 4 | For more information please visit, |
Slide 5
Prerequisites |
For this tutorial, you must be familiar with:
If not, for relevant tutorials please visit http://spoken-tutorial.org
|
Start ABT | Select ABT application on Android 4.2 |
ABT's Welcome screen | We will see ABT's welcome screen |
Tap on Select Existing Organization button |
We had already created an organization called Free Accounting Foundation in Managing organization tutorial We will select it from the drop-down list.
|
Tap on Login button | Lets Login as guest |
Point to Master Menu |
We are now on the master menu of ABT
|
Point to Reports | Tap on Reports |
Point to new page | You will see the Organization name,type and financial year at the top
Under Reports, we have
|
/* Interface */
Click on Ledger option
|
when I click on Ledger option, a dialog-box appears
|
Point Select account name |
Select account name for which the ledger is to be shown We will select SBI
|
Point to from date and to date |
From date and to date, by default is financial year’s from date and to date. Change date as per the requirement or keep it as it is. Lets keep it as it is
|
Point to display narrations | Lets check the Check box to view transactions with narrations |
Point to Select project name | The default is No Project in Projects |
Point to view button | Lets tap on view button to continue |
/* Slide 5*/
Ledger |
We will see the ledger A Ledger is a book of accounts in which entries from transactions are recorded. It is a book of final entry summarizing all of a company's transactions. |
We will be able to view the organization name,type & financial year at the to Opening balance is located at the first row of the table It is followed by
| |
Point to title bar |
On the right of the title bar you will find the report period and one options button As soon as we click on the button,we see 2 options:
|
Point to export as pdf |
You can also set security to your file by giving it a password We will enter a password and tap on Set password and save file |
It says pdf generation completed see /mnt/sdcard/and file name Similarly we can save CSV files. | |
Point to title bar |
On the left side of the title bar you will notice a icon. This icon is for changing input details to view ledger as we did in previous screen
|
Point to ledger |
There is a feature called drill down Whenever we tap on the account name row in reports, It takes us to its voucher We can view voucher details through drill down say drill down for Cash on hand We have drill down for all reports including Bank reconciliation
|
Point to Opening Balance in Ledger |
As you can see, the Opening Balance is on the Debit Side. This is as per the rules of Accounting. |
Under Reports menu, Click on Trial Balance | Now let us see the Trial Balance. |
Point to To Date |
The from date and to date is the financial from date and to date respectively To date is editable We shall keep it as it is |
Click on Trial Balance Type drop down | There are three types of Trial Balances in GNUKhata.
|
Select Net Trial Balance from the drop down |
From the drop down, let us select the Net Trial Balance. And click on View button. |
Point to difference in opening balances | You will notice difference in opening balances at the bottom
of the report |
If we click on any row in the report, we are directed to that account's ledger present in the row | |
Point to Trial Balance for Another Period | To view any other Trial Balance, you can tap on the top left icon |
Point to Project Statement |
We can view project statement for various projects The dropdown contains only No Project as no other project is created by us |
Point to view button | We can view the report under No Project |
Point to cash flow |
To view cash flow report we need to have transactions in purchase, purchase return, sales & sales return Net Flow is located at the bottom of the screen </nowiki>in the report |
Point to Balance sheet |
There are 2 types of balance sheet: Conventional balance sheet & Sources and application of funds
|
Likewise you can view other reports too | |
That's it for this tutorial. | |
/* Slide 6 */
Summary |
|
/* Slide 7*/
Assignment |
As an assignment, explore Gross Trial Balance and Extended Trial Balance reports. |
/* Slide 8 */ | Watch the video available at
http:spoken-tutorial.org/
project
bandwidth, you can download and watch it |
/* Slide 9 */
Spoken tutorial Workshops |
The Spoken Tutorial Project Team
|
/* Slide 10 */
Acknowledgements |
Spoken Tutorial Project is a part of the Talk to a Teacher project
It is supported by the National Mission on Education through ICT, MHRD, Government of India
http://spoken-tutorial.org /NMEICT-Intro |