Difference between revisions of "Aakash-Business-Tool/C2/Bank-Reconciliation/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 5: Line 5:
  
  
'''Keywords''': Organisation, Video Tutorial
+
'''Keywords''': Bank Reconciliation,Cleared Transactions,Uncleared Transactions,Options button,Memo,Clearance Date,Bank Reconciliation Statement,Cheques deposited but not cleared
  
  
Line 33: Line 33:
 
| In this tutorial, I am using  
 
| In this tutorial, I am using  
  
* '''ABT''' 1.0  
+
* '''ABT''' version 1.0  
* '''Android''' 4.2 &
+
* '''Android''' version 4.2 i.e. '''Jelly Bean''' and
 
* Rooted Tablet  
 
* Rooted Tablet  
  
Line 103: Line 103:
 
|-
 
|-
 
| Point to '''from date''' and '''to date'''
 
| Point to '''from date''' and '''to date'''
| The '''from date''' and '''to date''' are financial period.
+
| The '''from date''' and '''to date''' are financial year period.
  
 
They are editable and can be changed as per requirement.
 
They are editable and can be changed as per requirement.
Line 124: Line 124:
 
| Point to the new screen
 
| Point to the new screen
 
| Note:  
 
| Note:  
Only bank-to-bank transactions will be visible in '''Bank Reconciliation''' table.
+
 
  
 
A new screen appears.
 
A new screen appears.
  
'''Account Name HDFC''' and Financial period is visible at the top.
+
'''Account Name HDFC''' and Financial year period is visible at the top.
  
 
|-
 
|-

Latest revision as of 09:20, 25 March 2014

Title of script: Bank Reconciliation Statement


Author: Trupti Rajesh Kini


Keywords: Bank Reconciliation,Cleared Transactions,Uncleared Transactions,Options button,Memo,Clearance Date,Bank Reconciliation Statement,Cheques deposited but not cleared


Visual Cue
Narration
/* Slide 1 */ Hello and welcome to this spoken tutorial on Bank Reconciliation Statement in ABT
/*Slide 2 */

Objectives

In this tutorial, you will be able to learn,
  • Bank Reconciliation
  • Cleared and Uncleared Transactions
Slide 3

System Requirements


In this tutorial, I am using
  • ABT version 1.0
  • Android version 4.2 i.e. Jelly Bean 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 4*/

Prerequisites

For this tutorial, you must be familiar with:
  • The principles of book keeping
  • How to run and start ABT
  • 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 Select organization Free Accounting Foundation.
Tap on Login button Login as admin
Point to Master Menu We are now on the master menu of ABT.
Point to Bank Reconciliation Tap on Bank Reconciliation option.
Point to the new window There are 5 options in this pop up:
  • Select account name
  • From date
  • To date
  • Display cleared transactions
  • Display narrations
Point to Select account name Here I have already created an account called HDFC with 2 transactions:

1. One with SBI

2. Another with ICICI bank

Let us select account name as HDFC.

Point to from date and to date The from date and to date are financial year period.

They are editable and can be changed as per requirement.

Point to 2 checkboxes Display cleared transactions and Display narrations Check Display cleared transactions and Display narrations checkboxes.

Display cleared transactions will show cleared transactions.

It will show along with uncleared transactions.

Display narrations will show narrations with transactions.

Tap on View button Tap on View button.
Point to the new screen Note:


A new screen appears.

Account Name HDFC and Financial year period is visible at the top.

Point to the top left icon On the top left of the screen, you will notice another icon.


This is for changing input details to view Bank Reconciliation.

Point to the top right of the screen On the top right of the screen, there is a Save button and Options button.

The options button are:

  • Export as PDF
  • Export as CSV

These options function similar to those in Reports tutorial.

Point to columns Here there are columns like:
  • Date
  • Particulars
  • Cheque no.
  • Reference no.
  • Debit
  • Credit
  • Clearance Date
  • Memo
  • Narration
Click on drill down Here also there is drill down facility to divert to the respective voucher.
Point to Clearance Date Tap on Clearance Date field to enter the clearance date of voucher.
Point to Memo We can give Memo as a statement while clearing transaction.

Let us give Memo as cleared.

Point to Bank Reconciliation Statement Total Debit & Total Credit amounts are present at the end of the table.


Bank Reconciliation Statement is located at the bottom of the table.

Point to narration As we checked Display narrations checkbox, we can view narration column.
After entering Clearance date with optional field Memo, save the changes.

It says “Changes saved successfully

Point to reconciliation statement We can view the changes in the Reconciliation statement table.

The amount in row Cheques deposited but not cleared changes.

/* Slide 5 */

Summary

So, in this tutorial, we learnt about,
  • Bank Reconciliation &
  • How to clear transactions
/* Slide 6*/

Assignment

As an assignment,
  • clear one or more Transactions and
  • view Bank Reconciliation Statement
/* Slide 7 */ 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 8 */

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 9 */

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