Aakash-Business-Tool/C2/Viewing-Reports/English
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 on Android 4.2. |
Point to ABT's Welcome screen | We will see ABT's welcome screen. |
Point to Select Existing Organization button | We had already created an organization called Free Accounting Foundation.
|
Point to login page | Lets login as admin. |
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,
Free Accounting Foundation is of type NGO. So we see Income and Expenditure under Reports instead of Profit and Loss. |
/* Interface */
Click 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 view ledger for 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 to view transactions with narrations. |
Point to Select project name | There are no projects created yet.
|
Point to view button | 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. |
Point to the Ledger report | We will be able to view the organization name,type & financial year at the top.
Opening balance is located at the first row of the table It is followed by
|
Point to the top right of the screen | On the top right of the screen, you will find the report period.
Above that, there is options button. As soon as we tap on the button,we see 2 options:
|
Point to export as pdf | Tap on Export as pdf.
|
Point to the new window | A new window appears.
You can secure your file by giving it a password here. Lets enter a password Tap on Set password and save file button. |
Point to the message | It says pdf generation completed see /mnt/sdcard/ location for the desired file.
|
Point to /mnt/sdcard | Let us go to the location.
Enter the given password. We can view our report. |
Similarly, we can save CSV files. | |
Point to the top left of the screen | On the top left of the screen, you will notice another icon.
|
Point to ledger report->drill down->voucher | In reports, there is a feature called drill down.
Long press on any row in reports. It will take us to its voucher. We can view voucher details through drill down say drill down for Cash We have drill down for all reports including Bank reconciliation
|
Under Reports menu, Point to Trial Balance | Now let us see Trial Balance.
Balances of all ledgers are compiled into debit and credit columns . |
Point to To Date | Tap on Trial Balance
A new window appears. To date is editable here. |
Click on Trial Balance Type drop down | There are three types of Trial Balance in ABT.
|
Select Net Trial Balance from the drop down | From the drop down, let us select the Net Trial Balance.
Tap on View button. |
Point to difference in opening balances | You will notice, difference in opening balances at the bottom
of the report. |
Point to drill down | Long press on any row in the report.
We are directed to that account's ledger. |
Point to Project Statement | We can view project statement for various projects
The dropdown contains only No Project as no 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 Payment or Receipt Vouchers.
Net Flow is located at the bottom of the report. |
Point to Balance sheet | Balance Sheet summarizes a company’s
at a specific point in time There are 2 types of balance sheet: Conventional balance sheet & Sources and application of funds
|
Likewise you can view other reports too.
In Income and Expenditure it records the income and 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. | |
That's it for this tutorial. | |
/* Slide 6 */
Summary |
In this tutorial, we learnt to view,
|
/* 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 |