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

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 8: Line 8:
  
  
−
 
+
{|border=1
−
{| style="border-spacing:0;"
+
| <center>'''Visual Cue'''</center>
−
| 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>
+
| <center>'''Narration'''</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 */
+
| /* Slide 1 */
−
 
+
| 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: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 */
+
| /*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:0.097cm;"| In this tutorial, you will be able to learn,
+
| In this tutorial, you will be able to learn,
  
 
* Bank Reconciliation  
 
* Bank Reconciliation  
 
* Cleared and Uncleared Transactions
 
* 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  
+
| Slide 3  
  
 
System Requirements  
 
System Requirements  
Line 38: Line 31:
  
  
−
| 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  
+
| In this tutorial, I am using  
  
 
* '''ABT''' 1.0  
 
* '''ABT''' 1.0  
 
* '''Android''' 4.2 &  
 
* '''Android''' 4.2 &  
 
* Rooted Tablet  
 
* 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  
+
| 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,
+
| 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]  
  
 
[http://aakashlabs.org/docs/abt/index.html http://aakashlabs.org/docs/abt/index.html]  
 
[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*/
+
| /*Slide 4*/
  
 
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: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'''  
 
* How to run and start '''ABT'''  
 
* How to Create a New Organization
 
* How to Create a New Organization
Line 70: Line 58:
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| 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:0.097cm;"| Select '''ABT''' application on '''Android''' 4.2.
+
| 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  
+
| 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.
+
| 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  
+
| 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.'''
+
| 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  
+
| 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'''
+
| 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'''
+
| 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.'''
+
| 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'''
+
| 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.
+
| 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
+
| 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:
+
| There are 5 options in this pop up:
−
 
+
−
* Select account name
+
−
* From date
+
−
* To date
+
−
* Display cleared transactions
+
−
* Display Narrations
+
−
 
+
  
 +
* '''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'''
+
| 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:
+
| Here I have already created an account called '''HDFC''' with 2 transactions:
  
 
1. One with '''SBI'''
 
1. One with '''SBI'''
Line 113: Line 99:
 
2. Another with '''ICICI''' bank
 
2. Another with '''ICICI''' bank
  
−
Let us account name as '''HDFC'''.
+
Let us select 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'''
+
| 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.
+
| The '''from date''' and '''to date''' are financial period.
  
 
They are editable and can be changed as per requirement.
 
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 '''
+
| 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.
+
| Check '''Display cleared transactions '''and '''Display narrations '''checkboxes.
  
 
'''Display cleared transactions '''will show cleared transactions.
 
'''Display cleared transactions '''will show cleared transactions.
Line 132: Line 118:
  
 
|-
 
|-
−
| 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
+
| 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.
+
| 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
+
| 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:  
+
| Note:  
−
 
+
Only bank-to-bank transactions will be visible in '''Bank Reconciliation''' table.
−
Only bank to bank transactions will be visible in bank reconciliation table.
+
−
 
+
−
New screen appears.
+
  
 +
A new screen appears.
  
 
'''Account Name HDFC''' and Financial period is visible at the top.
 
'''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
+
| 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.  
+
| On the top left of the screen, you will notice another icon.  
  
  
 
This is for changing input details to view '''Bank Reconciliation.'''
 
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
+
| 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.
+
| On the top right of the screen, there is a '''Save''' button and '''Options''' button.
  
 
The options button are:
 
The options button are:
  
−
<nowiki>* Export as pdf</nowiki>
+
* '''Export as PDF'''
−
 
+
* '''Export as CSV'''
−
<nowiki>* Export as CSV</nowiki>
+
  
 
These options function similar to those in '''Reports''' tutorial.
 
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
+
| 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:
+
| Here there are columns like:
  
−
<nowiki>* Date</nowiki>
+
*'''Date'''
−
 
+
*'''Particulars'''
−
<nowiki>* Particulars</nowiki>
+
*'''Cheque no.'''
−
 
+
*'''Reference no.'''
−
<nowiki>* Cheque no.</nowiki>
+
*'''Debit'''
−
 
+
*'''Credit'''
−
<nowiki>* Reference no.</nowiki>
+
*'''Clearance Date'''
−
 
+
*'''Memo'''
−
<nowiki>* Debit</nowiki>
+
*'''Narration'''
−
 
+
−
<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
+
| Click on 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.
+
| 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'''
+
| 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.
+
| Tap on '''Clearance Date ''' field to enter the clearance date of voucher.
−
 
+
−
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'''
+
| 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.
+
| We can give '''Memo '''as a statement while clearing transaction.
  
 
Let us give '''Memo '''as '''cleared.'''
 
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'''
+
| 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.  
+
| <tt>Total Debit</tt> & <tt>Total Credit</tt> amounts are present at the end of the table.  
  
  
Line 217: Line 184:
  
 
|-
 
|-
−
| 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  
+
| 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
+
| 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.
+
| After entering '''Clearance date''' with optional field '''Memo''', save the changes.
  
 
It says “'''Changes saved successfully'''”
 
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
+
| 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.
+
| We can view the changes in the '''Reconciliation statement''' table.
  
 
The amount in row '''Cheques deposited but not cleared '''changes.
 
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 */
+
| /* Slide 5 */
  
 
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:0.097cm;"| So, in this tutorial, we learnt about,
+
| So, in this tutorial, we learnt about,
−
 
+
−
<nowiki>* Bank Reconciliation &</nowiki>
+
−
 
+
−
<nowiki>* How to Clear transactions.</nowiki>
+
−
 
+
  
 +
* Bank Reconciliation &
  
 +
* How to clear transactions
  
 
|-
 
|-
−
| style="border-top:none;border-bottom:0.05pt solid #000000;border-left:0.05pt solid #000000;border-right:none;padding:0.097cm;"| /* Slide 6*/
+
| /* Slide 6*/
  
 
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:0.097cm;"| As an assignment, clear one or more transactions and view Bank Reconciliation Statement.
+
| 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 */
+
| /* 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  
+
| Watch the video available at http:spoken-tutorial.org/
  
−
http:spoken-tutorial.org/
 
  
 +
It summarizes the Spoken Tutorial project
  
−
It summarizes the Spoken Tutorial
 
  
−
project
+
If you do not have good bandwidth, you can download and watch it  
−
 
+
−
 
+
−
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 */
+
| /* Slide 8 */
  
 
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:0.097cm;"| The Spoken Tutorial Project Team  
+
| The Spoken Tutorial Project Team  
−
 
+
−
 
+
−
Conducts workshops using spoken tutorials
+
−
 
+
  
−
Gives certificates to those who pass an online test
 
  
 +
*Conducts workshops using spoken tutorials
 +
*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:0.097cm;"| /* Slide 9 */
+
| /* Slide 9 */
  
 
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: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  

Revision as of 16:23, 11 March 2014

Title of script: Bank Reconciliation Statement


Author: Trupti Rajesh Kini


Keywords: Organisation, Video Tutorial


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 1.0
  • Android 4.2 &
  • 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 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:

Only bank-to-bank transactions will be visible in Bank Reconciliation table.

A new screen appears.

Account Name HDFC and Financial 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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=Aakash-Business-Tool/C2/Bank-Reconciliation/English&oldid=9044"