Trupti at 03:50, 25 March 2014

2014-03-25T03:50:16Z

Nancyvarkey at 11:21, 13 March 2014

2014-03-13T11:21:20Z

Trupti at 09:29, 13 March 2014

2014-03-13T09:29:28Z

Trupti at 09:27, 13 March 2014

2014-03-13T09:27:12Z

Nancyvarkey at 10:53, 11 March 2014

2014-03-11T10:53:02Z

Show changes

Trupti at 10:24, 11 March 2014

2014-03-11T10:24:48Z

Trupti: Created page with ''''Title of script''': Bank Reconciliation Statement '''Author: ''' Trupti Rajesh Kini '''Keywords''': Organisation, GNUKhata, Video Tutorial, Create Account, Edit Account …'

2014-03-10T07:30:04Z

Created page with ''''Title of script''': Bank Reconciliation Statement '''Author: ''' Trupti Rajesh Kini '''Keywords''': Organisation, GNUKhata, Video Tutorial, Create Account, Edit Account …'

New page

'''Title of script''': Bank Reconciliation Statement

'''Author: ''' Trupti Rajesh Kini

'''Keywords''': Organisation, GNUKhata, Video Tutorial, Create Account, Edit Account

{| style="border-spacing:0;"
| style="border-top:0.05pt solid #000000;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| <center>'''Visual Cue'''</center>
| style="border:0.05pt solid #000000;padding:0.097cm;"| <center>'''Narration'''</center>

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* 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:0.097cm;"| Hello and welcome to this spoken tutorial on '''Bank Reconciliation Statement '''in ABT

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /*Slide 2 */

Objectives
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| In this tutorial, you will be able to learn,

* Bank Reconciliation
* Cleared and Uncleared Transactions

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Slide 3

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:0.097cm;"| In this tutorial, I am using

* '''ABT''' 1.0
* '''Android''' 4.2 &
* Rooted Tablet

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| For more information please visit,

[https://github.com/androportal/ABT https://github.com/androportal/ABT]

[http://aakashlabs.org/docs/abt/index.html http://aakashlabs.org/docs/abt/index.html]

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /*Slide 4*/

Prerequisites
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| Select '''ABT''' application on '''Android''' 4.2.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''ABT's''' Welcome screen
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| We will see '''ABT's''' welcome screen.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| Select organization '''Free Accounting Foundation.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''Login''' button
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Login as '''admin'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Master Menu'''
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| We are now on the master menu of '''ABT.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Bank Reconciliation'''
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Tap on '''Bank Reconciliation''' option.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| There are 5 options in this pop up:

* Select account name
* From date
* To date
* Display cleared transactions
* Display Narrations

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| Here I have already created an account called HDFC with 2 transactions:

1. One with '''SBI'''

2. Another with '''ICICI''' bank

Let us account name as '''HDFC'''.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| The '''from date''' and '''to date''' are financial period.

They are editable and can be changed as per requirement.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to 2 checkboxes '''Display cleared transactions '''and '''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:0.097cm;"| 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.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Tap on '''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:0.097cm;"| Tap on '''View''' button.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to the new screen
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Note:

Only bank to bank transactions will be visible in bank reconciliation table.

New screen appears.

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

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to the top left icon
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| On the top left of the screen, you will notice another icon.

This is for changing input details to view '''Bank Reconciliation.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| On the top right side there is a '''save''' button and options button.

The options button are:

<nowiki>* Export as pdf</nowiki>

<nowiki>* Export as CSV</nowiki>

These options function similar to those in '''Reports''' tutorial.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to columns
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Here there are columns like:

<nowiki>* Date</nowiki>

<nowiki>* Particulars</nowiki>

<nowiki>* Cheque no.</nowiki>

<nowiki>* Reference no.</nowiki>

<nowiki>* Debit</nowiki>

<nowiki>* Credit</nowiki>

<nowiki>* Clearance Date</nowiki>

<nowiki>* Memo</nowiki>

<nowiki>* Narration</nowiki>

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| Here also there is drill down facility to divert to the respective voucher.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Clearance Date'''
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| Tap on '''Clearance Date '''to select the date.

Let us select the '''Clearance Date.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Memo'''
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| We can give '''Memo '''as a statement while clearing transaction.

Let us give '''Memo '''as '''cleared.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to '''Bank Reconciliation Statement'''
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| <tt>Total Debit</tt> & <tt>Total Credit</tt> amounts are present at the end of the table.

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

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to narration
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| As we checked '''Display narrations '''checkbox, we can view narration column

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding: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:0.097cm;"| After entering clearance date with optional field memo, save the details.

It says “'''Changes saved successfully'''”

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| Point to reconciliation statement
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| We can view the changes in the reconciliation statement table.

The amount in row '''Cheques deposited but not cleared '''changes.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding: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:0.097cm;"| What is Bank Reconciliation?

'''It is a report which compares the bank balance as per company's accounting records with the balance stated in the bank statement.'''

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 5 */

Summary
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| So, in this tutorial, we learnt about,

<nowiki>* Bank Reconciliation &</nowiki>

<nowiki>* How to Clear transactions.</nowiki>

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 6*/

Assignment
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| As an assignment, clear one or more transactions and view Bank Reconciliation Statement.

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 7 */
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 8 */

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:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 9 */

Acknowledgements
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:0.05pt solid #000000;padding:0.097cm;"| 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/ http://spoken-tutorial.org] /NMEICT-Intro

|}

@@ Line 124: / Line 124: @@
 | Point to the new screen
 | Note:
-Only bank-to-bank transactions will be visible in '''Bank Reconciliation''' table.
 A new screen appears.

← Older revision		Revision as of 09:29, 13 March 2014
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 103: / Line 103: @@
 |-
 | 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.
@@ Line 128: / Line 128: @@
 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.
 |-

← Older revision		Revision as of 10:24, 11 March 2014
Line 5:		Line 5:


−	'''Keywords''': Organisation~~, GNUKhata~~, Video Tutorial~~, Create Account, Edit Account~~	+	'''Keywords''': Organisation, Video Tutorial

@@ Line 33: / Line 33: @@
 | 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