Difference between revisions of "Aakash-Business-Tool/C2/Viewing-Reports/English"
Line 226: | Line 226: | ||
Whenever we long press on any account name in the row, it takes 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 ''' | ||
+ | |||
+ | |||
+ | |||
We have drill down for all reports including '''Bank reconciliation''' | We have drill down for all reports including '''Bank reconciliation''' | ||
Line 258: | Line 263: | ||
| 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;"| | | 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. | We will see '''Net Trial Balance''' as at 31 march 2015. | ||
+ | |||
We can view '''Difference in opening balances''' at the bottom of the screen. | We can view '''Difference in opening balances''' at the bottom of the screen. | ||
Line 264: | Line 271: | ||
| 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. | | 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. | ||
Line 275: | Line 283: | ||
| 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 have created transactions with '''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''' | 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. | This is the project statement with '''Difference in opening balance''' at the bottom of the report. | ||
Line 281: | Line 291: | ||
| 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;"| | | 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''' | Next, '''Cash Flow''' | ||
+ | |||
For cash flow we need transactions in '''Payment '''or '''Receipt '''Vouchers. | For cash flow we need transactions in '''Payment '''or '''Receipt '''Vouchers. | ||
Line 290: | Line 302: | ||
| 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;"| | | 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''' | Next, '''Balance Sheet''' | ||
+ | |||
'''Balance Sheet''' summarizes a company’s | '''Balance Sheet''' summarizes a company’s | ||
Line 315: | Line 328: | ||
| 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;"| | | 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 | 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, | We can view '''Corpus & Liabilities at the left of the screen, | ||
+ | |||
Whereas | Whereas | ||
+ | |||
Property and Assets are at the right of the screen. | Property and Assets are at the right of the screen. | ||
Revision as of 14:32, 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.
|
|
/* 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,
|
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
|
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,
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
|
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.
|
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
|
Under Reports menu, Point to Trial Balance | Next, Trial Balance.
|
Click on Trial Balance Type drop down | We have three types of 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
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
Tap on view
|
Point to Balance sheet |
This is the Balance sheet for Free Accounting Foundation as at 31 march 2015
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,
|
/* 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 |