Difference between revisions of "Aakash-Business-Tool/C2/Viewing-Reports/English"
(Created page with ' {| style="border-spacing:0;" | style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <c…') |
|||
Line 1: | Line 1: | ||
− | |||
{| style="border-spacing:0;" | {| style="border-spacing:0;" | ||
| style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center> | | style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center> | ||
Line 32: | Line 31: | ||
− | + | * '''ABT''' 1.0 | |
− | + | * '''Android''' 4.2 Firefox version 3.6 or above. | |
− | + | ||
Line 61: | Line 59: | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Select Existing Organization''' button | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| * We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial | + | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| |
+ | * We had already created an organization called '''Free Accounting Foundation''' in '''Managing organization''' tutorial | ||
* We will select it from the drop-down list. | * We will select it from the drop-down list. | ||
Line 73: | Line 72: | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu''' | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| * We are now on the master menu of '''ABT''' | + | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| |
+ | * We are now on the master menu of '''ABT''' | ||
Line 87: | Line 87: | ||
Under '''Reports''', we have | Under '''Reports''', we have | ||
− | ''' | + | * '''Ledger''' |
− | ''' | + | * '''Trial Balance''' |
− | ''' | + | * '''Project Statement''' |
− | ''' | + | * '''Cash Flow''' |
− | ''' | + | * '''Balance Sheet''' and |
− | ''' | + | * '''Income and Expenditure''' |
− | Since organization '''Free Accounting Foundation''' is of type '''NGO''', we see '''Income and Expenditure | + | Since organization '''Free Accounting Foundation''' is of type '''NGO''', we see '''Income and Expenditure''' |
− | If the organization is of type '''Profit Making, '''we would see '''Profit and Loss | + | If the organization is of type '''Profit Making, '''we would see '''Profit and Loss''' |
|- | |- | ||
Line 149: | Line 149: | ||
Ledger | Ledger | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | + | | 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 link | |
− | + | * This link is for entering details to view ledger as we did in previous screen | |
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to ledger | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to ledger | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | + | | 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''' | | 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 217: | Line 210: | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To Date ''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''To Date ''' | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | + | | 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 227: | Line 219: | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| There are three types of '''Trial Balances''' in GNUKhata. | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| There are three types of '''Trial Balances''' in GNUKhata. | ||
− | + | * '''Net Trial Balance''' | |
− | + | * '''Gross Trial Balance''' | |
− | + | * '''Extended Trial Balance''' | |
− | + | ||
− | + | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Select '''Net Trial Balance''' from the drop down | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding: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 256: | Line 245: | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement''' | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Project Statement''' | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | + | | 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 266: | Line 255: | ||
|- | |- | ||
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to cash flow | ||
− | | style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| | + | | 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 | |
|- | |- |
Revision as of 10:57, 21 October 2013
|
|
/* Slide 1 */
Display desktop |
Hello and welcome to this spoken tutorial on Viewing_ Reports in ABT |
/*Slide 2 */
Objectives |
At the end of this tutorial, you will be able to view:
|
/*Slide 3 */
System Requirements |
To record this tutorial, I am using
|
/*Slide 4*/
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 |
|
Tap on Login button | Lets Login as guest |
Point to Master Menu |
|
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 new screen appears
|
Point Select account name |
|
Point to from date and to date |
|
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 |
|
| |
Point to title bar |
|
Point to export as pdf |
|
| |
Point to title bar |
|
Point to ledger |
|
Point to Opening Balance in Ledger |
|
Under Reports menu, Click on Trial Balance | Now let us see the Trial Balance. |
Point to To Date |
|
Click on Trial Balance Type drop down | There are three types of Trial Balances in GNUKhata.
|
Select Net Trial Balance from the drop down |
|
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 |
|
Point to view button | We can view the report under No Project |
Point to cash flow |
|
Point to Balance sheet | * There are 2 types of balance sheet:
Conventional balance sheet & Sources and application of funds * Conventional balance sheet is horizontal balance sheet * Sources and application of funds is vertical balance sheet |
Likewise you can view other reports too | |
That's it for this tutorial. | |
/* Slide 6 */
Summary |
* Let's summarise
|
/* 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 |