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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 317: Line 317:
 
| 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;"| To view cash flow report we need to have transactions in '''Payment '''or '''Receipt '''Vouchers.
 
| 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;"| 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.
+
'''Net Flow''' is located at the bottom of the report.
  
 
|-
 
|-
Line 323: Line 323:
 
| 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;"| '''Balance Sheet s'''ummarizes a company’s
 
| 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;"| '''Balance Sheet s'''ummarizes a company’s
  
<nowiki>* Assets, </nowiki>
+
* Assets,  
  
<nowiki>* Liabilities and </nowiki>
+
* Liabilities and  
  
<nowiki>* Shareholders’ equity </nowiki>
+
* Shareholders’ equity
  
 
at a specific point in time  
 
at a specific point in time  
Line 351: Line 351:
 
Difference between '''Cash Book '''and '''Cash Flow '''is,
 
Difference between '''Cash Book '''and '''Cash Flow '''is,
  
In Cash Book all cash receipts and
+
In Cash Book all cash receipts and  cash payments are recorded.
  cash payments are recorded.
+
  
In Cash Flow Statement all inflows
+
In Cash Flow Statement all inflows and outflows of cash are exhibited.
and outflows of cash are exhibited.
+
  
 
|-
 
|-

Revision as of 16:30, 17 February 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
  • Net 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 (JellyBean) &
  • Rooted tablet


Slide 4 For more information please visit,

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 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,

  • Ledger
  • Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet and
  • 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 */

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

  • Total of transactions
  • Closing balance
  • Grand total


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:

  • Export as pdf
  • Export as CSV


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.


This is for changing input details to view ledger as we did in previous screen.

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.
  • Net Trial Balance
  • Gross Trial Balance
  • Extended Trial Balance


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
  • Assets,
  • Liabilities and
  • Shareholders’ equity

at a specific point in time

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.

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,
  • Ledger
  • Net Trial Balance
  • Project Statement
  • Cash Flow
  • Balance Sheet
  • Income & Expenditure/Profit & Loss
  • 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