|
|
Line 11: |
Line 11: |
| | | |
| | | |
− | {| style="border-spacing:0;" | + | {|border=1 |
− | | style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding-top:0.097cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| <center>'''Visual Cue'''</center>
| + | | <center>'''Visual Cue'''</center> |
− | | style="border:0.05pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center>
| + | | <center>'''Narration'''</center> |
| | | |
| |- | | |- |
− | | 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 1 */
| + | | /* Slide 1 */ |
− | | 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;"| Hello and welcome to this spoken tutorial on '''Viewing Reports''' in ABT
| + | | Hello and welcome to this spoken tutorial on '''Viewing Reports''' in ABT |
| | | |
| |- | | |- |
− | | 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 2 */
| + | | /*Slide 2 */ |
| | | |
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In this tutorial, you will be able to view,
| + | | In this tutorial, you will be able to view, |
| | | |
| * '''Ledger''' | | * '''Ledger''' |
− | * '''Net''' '''Trial Balance''' | + | *'''Trial Balance''' |
| * '''Project Statement''' | | * '''Project Statement''' |
| * '''Cash Flow ''' | | * '''Cash Flow ''' |
Line 32: |
Line 32: |
| * '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Slide 3
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| In this tutorial, I am using
| + | | In this tutorial, I am using |
| | | |
| * '''ABT 1.0 ''' | | * '''ABT 1.0 ''' |
− | * '''Android''' 4.2 (JellyBean) & | + | * '''Android''' 4.2 ('''Bold text'''JellyBean) and |
| * Rooted tablet | | * 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
| + | | 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,
| + | | For more information please visit the following links. |
| | | |
| [https://github.com/androportal/ABT https://github.com/androportal/ABT] | | [https://github.com/androportal/ABT https://github.com/androportal/ABT] |
Line 56: |
Line 52: |
| | | |
| |- | | |- |
− | | 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
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| For this tutorial, you must be familiar with:
| + | | For this tutorial, you must be familiar with: |
| | | |
− | * The principles of book keeping. | + | * The principles of book keeping |
| * How to run and start '''ABT''' and | | * How to run and start '''ABT''' and |
| * How to create a new organization | | * 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] |
− |
| |
− |
| |
− |
| |
| | | |
| |- | | |- |
− | | 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;"| Start '''ABT'''
| + | | Start '''ABT''' |
− | | 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;"| Select '''ABT''' application
| + | | Select '''ABT''' application. |
− | | + | |
| | | |
| |- | | |- |
− | | 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 '''Select Existing Organization''' button
| + | | Point to '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Select organisation '''Free Accounting Foundation'''.
| + | | Select organisation '''Free Accounting Foundation'''. |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 login page
| + | | Point to login page |
− | | 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;"| Login as '''admin.'''
| + | | Login as '''admin.''' |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 '''Reports'''
| + | | Point to '''Reports''' |
− | | 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;"| Tap on '''Reports'''
| + | | Tap on '''Reports''' |
| | | |
| |- | | |- |
− | | 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 new page
| + | | Point to new page |
− | | 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;"| You will see the Organization name,type and financial period at top centre
| + | | You will see the Organization name, Type and financial period at top centre. |
| | | |
| Under '''Reports''', we have, | | Under '''Reports''', we have, |
| | | |
| * '''Ledger''' | | * '''Ledger''' |
− |
| |
| * '''Trial Balance''' | | * '''Trial Balance''' |
− |
| |
| * '''Project Statement''' | | * '''Project Statement''' |
− |
| |
| * '''Cash Flow''' | | * '''Cash Flow''' |
− |
| |
| * '''Balance Sheet''' | | * '''Balance Sheet''' |
− |
| |
| * '''Income and Expenditure''' | | * '''Income and Expenditure''' |
− |
| |
| * '''Cash Book''' | | * '''Cash Book''' |
− |
| |
| '''Free Accounting Foundation''' is of type '''NGO'''. | | '''Free Accounting Foundation''' is of type '''NGO'''. |
| | | |
Line 118: |
Line 97: |
| | | |
| |- | | |- |
− | | 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;"| /* Interface */
| + | | /* Interface */ |
| Tap on '''Ledger''' option | | Tap on '''Ledger''' option |
− | | + | | When I tap on '''Ledger''' option, a new window appears. |
− | | + | |
− | | + | |
− | | 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;"| When I tap on '''Ledger''' option, a new window appears.
| + | |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 '''Select account name'''
| + | | Point to '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Select account name for which the ledger is to be shown.
| + | | Select account name for which the ledger is to be shown. |
| | | |
| Let us select '''Sbi.''' | | Let us select '''Sbi.''' |
| | | |
| |- | | |- |
− | | 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 '''From date''' and '''To date '''
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| <tt>'''From date</tt> '''and <tt>'''to date'''</tt>, by default is financial year period.
| + | | <tt>'''From date</tt> '''and <tt>'''to date'''</tt>, by default is financial period. |
| | | |
| Change date as per the requirement or keep it as it is. | | Change date as per the requirement or keep it as it is. |
− |
| |
− |
| |
− |
| |
| | | |
| |- | | |- |
− | | 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 '''Display narrations '''
| + | | Point to '''Display narrations ''' |
− | | 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;"| Let us check the Check box for '''Display Narrations'''.
| + | | Let us check the Check box for '''Display Narrations'''. |
| | | |
| |- | | |- |
− | | 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 '''Select project name '''
| + | | Point to '''Select project name ''' |
− | | 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 Projects'''.
| + | | We have created transactions with '''No Project'''. |
| So, keep the default project name. | | So, keep the default project name. |
− |
| |
− |
| |
− |
| |
| | | |
| |- | | |- |
− | | 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*/
| + | | /* Slide 5*/ |
| | | |
| 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We will see the ledger here
| + | | We will see the ledger here. |
− |
| + | |
| | | |
| |- | | |- |
− | | 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 the '''Ledger '''report
| + | | Point to the '''Ledger '''report |
− | | 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 can view the organization name,type & financial period at the top center.
| + | | We can view the organization name,type & financial period at the top center. |
| | | |
| Opening balance is located at the first row of the table. | | Opening balance is located at the first row of the table. |
| | | |
| Followed by | | Followed by |
− |
| |
| * '''Total of transactions ''' | | * '''Total of transactions ''' |
| * '''Closing balance ''' | | * '''Closing balance ''' |
| * '''Grand total ''' | | * '''Grand total ''' |
− |
| |
− |
| |
| | | |
| |- | | |- |
− | | 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 the top right of the screen
| + | | Point to the top right of the screen |
− | | 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;"| On the top right of the screen, we will find the report period.
| + | | 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.
| + | |
− | | + | |
| | | |
| + | Above that, there are '''options'''; options to export report as '''Pdf''' or as '''CSV'''. |
| | | |
| |- | | |- |
− | | 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 export as pdf
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Tap on '''Export as pdf option.'''
| + | | Tap on '''Export as pdf option.''' |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 the new window
| + | | Point to the new window |
− | | 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;"| A new window appears.
| + | | A new window appears. |
| | | |
− | You can secure your file by giving it a password here. | + | You can secure your file by giving it a password. |
| | | |
| And then tap on '''Set password and save file''' button. | | And then tap on '''Set password and save file''' 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 the message
| + | | Point to the message |
− | | 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;"| It says pdf generation completed see''' /mnt/sdcard/ ''' for the file.
| + | | It says pdf generation completed see''' /mnt/sdcard/ ''' for the file. |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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;"|
| + | | |
− | | 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;"| Similarly, we can save as '''CSV''' files.
| + | | Similarly, we can save as '''CSV''' file. |
| | | |
| |- | | |- |
− | | 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 the top left of the screen
| + | | Point to the top left of the screen |
− | | 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;"| On the top left of the screen, there is another icon.
| + | | On the top left of the screen, there is another icon. |
− | | + | |
| | | |
| This is for changing input details to view ledger as we did in previous screen. | | This is for changing input 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Point to ledger report->'''drill down->voucher'''
| + | | Point to ledger report->'''drill down->voucher''' |
− | | 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;"| There is a feature called '''drill down''' in reports.
| + | | 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 '''
| + | |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
− | We have drill down for all reports including '''Bank reconciliation'''
| + | |
| | | |
| + | 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 have drill down for all reports including '''Bank reconciliation'''. |
| | | |
| |- | | |- |
− | | 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;"| Under '''Reports '''menu, Point to '''Trial Balance'''
| + | | Under '''Reports '''menu, Point to '''Trial Balance''' |
− | | 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, '''Trial Balance'''.
| + | | Next, '''Trial Balance'''. |
− | | + | |
| | | |
| |- | | |- |
− | | 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;"| Click on '''Trial Balance Type '''drop down
| + | | Click on '''Trial Balance Type '''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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| We have three types of '''Trial Balance.
| + | | We have three types of '''Trial Balance'''. |
| * '''Net Trial Balance''' | | * '''Net Trial Balance''' |
| * '''Gross Trial Balance''' | | * '''Gross Trial Balance''' |
| * '''Extended 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0cm;"| Select '''Net Trial Balance''' from the drop down
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"| Let us select the '''Net Trial Balance.'''
| + | | Let us select '''Net Trial Balance.''' |
| Here '''To-date''' is editable. | | Here '''To-date''' is editable. |
− | Tap on '''View''' | + | Tap on '''View'''. |
− |
| + | |
| | | |
| |- | | |- |
− | | 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'''
| + | | 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;"|
| + | | |
| | | |
| 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. |
| | | |
| |- | | |- |
− | | 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
| + | | 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. | + | | Long-press on any row. |
| | | |
− | We are directed to that account's ledger. | + | We are directed to that Account's ledger. |
| | | |
| |- | | |- |
− | | 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 '''Project Statement'''
| + | | 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-top:0cm;padding-bottom:0.097cm;padding-left:0.097cm;padding-right:0.097cm;"|
| + | | |
− | Next, '''Project Statement''' | + | Next, '''Project Statement'''. |
− | | + | |
| | | |
| |- | | |- |
− | | 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
| + | | 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'''
| + | | 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. |
| | | |
| |- | | |- |
− | | 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
| + | | 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;"|
| + | | |
| | | |
− | Next, '''Cash Flow''' | + | Next, '''Cash Flow'''. |
| | | |
− | For cash flow we need transactions in '''Payment '''or '''Receipt '''Vouchers. | + | We can view cash flow for any period within the financial period. |
| + | |
| + | |
| + | For cash flow, we need transactions in '''Payment '''or '''Receipt '''Vouchers. |
| | | |
| We can view '''Net Flow''' at the bottom of the report. | | We can view '''Net Flow''' at the bottom of the report. |
| | | |
| |- | | |- |
− | | 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 '''Balance sheet'''
| + | | 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-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 |
− |
| |
| * Assets, | | * Assets, |
− |
| |
| * Liabilities and | | * Liabilities and |
− |
| |
| * Shareholders’ equity | | * Shareholders’ equity |
− | It summarizes at a specific point in time
| |
| | | |
− | There are 2 types of balance sheet: | + | It summarizes at a specific point in time. |
| + | |
| + | There are 2 types of balance sheets: |
| | | |
| '''Conventional balance sheet''' & '''Sources and application of funds''' | | '''Conventional balance sheet''' & '''Sources and application of funds''' |
| + | |
| | | |
| Let us select '''Conventional balance sheet''' | | Let us select '''Conventional balance sheet''' |
| | | |
| * '''Conventional balance sheet''' is horizontal balance sheet whereas | | * '''Conventional balance sheet''' is horizontal balance sheet whereas |
| + | * '''Sources and application of funds''' is vertical balance sheet. |
| | | |
− | * '''Sources and application of funds''' is vertical balance sheet
| + | Tap on '''View'''. |
− | | + | |
− | Tap on view
| + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 Balance sheet
| + | | 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-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 see '''Corpus & Liabilities''' are 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.
| + | |
− | | + | |
− | '''Differences in opening balances''' is at the bottom of the report
| + | |
| | | |
| + | '''Property and Assets''' are at the right of the screen. |
| | | |
| | | |
| + | '''Differences in opening balances''' is at the bottom of the report. |
| | | |
| |- | | |- |
− | | 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;"|
| + | | |
− | | 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, '''Income and Expenditure''', | | Next, '''Income and Expenditure''', |
| | | |
− | '''Income and Expenditure''' records the income and | + | '''Income and Expenditure''' records the income and expenditure of an organization. |
− | | + | |
− | expenditure of an organization . | + | |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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;"|
| + | | |
− | | 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, we can view '''Cash Book''' for the organisation '''Free Accounting Foundation''' | + | Next, we can view '''Cash Book''' for the organisation '''Free Accounting Foundation'''. |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
− | | + | |
| | | |
| |- | | |- |
− | | 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 6 */
| + | | /* Slide 6 */ |
| | | |
| Summary | | Summary |
− | | 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;"| So, in this tutorial, we seen,
| + | | So, in this tutorial, we have seen, |
| | | |
| * '''Ledger''' | | * '''Ledger''' |
− | * '''Net''' '''Trial Balance''' | + | * '''Net Trial Balance''' |
| * '''Project Statement''' | | * '''Project Statement''' |
| * '''Cash Flow ''' | | * '''Cash Flow ''' |
| * '''Balance Sheet''' | | * '''Balance Sheet''' |
− | * '''Income & Expenditure/Profit & Loss''' & | + | * '''Income and Expenditure''' and |
| * '''Cash Book''' | | * '''Cash Book''' |
− |
| |
− |
| |
| | | |
| |- | | |- |
− | | 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 7*/
| + | | /* Slide 7*/ |
| | | |
| Assignment | | Assignment |
− | | 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;"| As an assignment, explore '''Gross Trial Balance''' and '''Extended Trial Balance''' reports for '''Sbi.'''
| + | | As an assignment, explore '''Gross Trial Balance''' and '''Extended Trial Balance''' reports for '''SBI.''' |
| | | |
| |- | | |- |
− | | 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 8 */
| + | | /* Slide 8 */ |
− | | 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;"| Watch the video available at
| + | | Watch the video available at http:spoken-tutorial.org/ |
| | | |
− | http:spoken-tutorial.org/
| + | It summarizes the Spoken Tutorial project |
| | | |
− | It summarizes the Spoken Tutorial
| + | If you do not have good bandwidth, you can download and watch it |
− | | + | |
− | project
| + | |
− | | + | |
− | If you do not have good | + | |
− | | + | |
− | bandwidth, you can download | + | |
− | | + | |
− | and watch it | + | |
| | | |
| |- | | |- |
− | | 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 9 */
| + | | /* Slide 9 */ |
| | | |
| Spoken tutorial Workshops | | Spoken tutorial Workshops |
− | | 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;"| The Spoken Tutorial Project Team
| + | | The Spoken Tutorial Project Team |
− | | + | *Conducts workshops using spoken tutorials |
− | Conducts workshops using spoken tutorials | + | *Gives certificates to those who pass an online test |
− | | + | |
− | Gives certificates to those who pass an online test | + | |
| | | |
| For more details, please write to contact@spoken-tutorial.org | | For more details, please write to contact@spoken-tutorial.org |
| | | |
| |- | | |- |
− | | 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 10 */
| + | | /* Slide 10 */ |
| | | |
| Acknowledgements | | Acknowledgements |
− | | 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;"| Spoken Tutorial Project is a part of the Talk to a Teacher project
| + | | 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 | | It is supported by the National Mission on Education through ICT, MHRD, Government of India |
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
- 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 (Bold textJellyBean) and
- Rooted tablet
|
Slide 4
|
For more information please visit the following links.
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.
|
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,
- Ledger
- Trial Balance
- Project Statement
- Cash Flow
- Balance Sheet
- 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 */
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 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 Project.
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
- Total of transactions
- Closing balance
- Grand total
|
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.
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 file.
|
Point to the top left of the screen
|
On the top left of the screen, there is another icon.
This is for changing input details to view ledger as we did in previous screen.
|
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
We have drill down for all reports including Bank reconciliation.
|
Under Reports menu, Point to Trial Balance
|
Next, Trial Balance.
|
Click on Trial Balance Type drop down
|
We have three types of Trial Balance.
- Net Trial Balance
- Gross Trial Balance
- Extended Trial Balance
|
Select Net Trial Balance from the drop down
|
Let us select 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.
We can view cash flow for any period within the financial period.
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
- Assets,
- Liabilities and
- Shareholders’ equity
It summarizes at a specific point in time.
There are 2 types of balance sheets:
Conventional balance sheet & Sources and application of funds
Let us select Conventional balance sheet
- Conventional balance sheet is horizontal balance sheet whereas
- Sources and application of funds is vertical balance sheet.
Tap on View.
|
Point to Balance sheet
|
This is the Balance sheet for Free Accounting Foundation as at 31 march 2015.
We can see Corpus & Liabilities are at the left of the screen,
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 have seen,
- Ledger
- Net Trial Balance
- Project Statement
- Cash Flow
- Balance Sheet
- Income and Expenditure and
- 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
|