Difference between revisions of "FrontAccounting-2.4.7/C2/Banking-and-General-Ledger-in-FrontAccounting/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with "'''Banking and General Ledger''' {| style="border-spacing:0;" | style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206...")
 
 
Line 5: Line 5:
  
 
'''Title Slide'''  
 
'''Title Slide'''  
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Welcome to spoken tutorial on '''Banking and General Ledger in Front Accounting'''.
+
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Welcome to the spoken tutorial on '''Banking and General Ledger in Front Accounting'''.
  
 
|-
 
|-
Line 56: Line 56:
  
 
If not, for relevant '''FrontAccounting''' tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]  
 
If not, for relevant '''FrontAccounting''' tutorials please visit [http://spoken-tutorial.org/ http://spoken-tutorial.org]  
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| And you should have already set up an '''Organisation/Company''' in '''FrontAccounting'''  
+
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| And you should have already set up an organisation or '''Company''' in '''FrontAccounting'''.
  
 
If not, for relevant '''FrontAccounting''' tutorials please visit this website.  
 
If not, for relevant '''FrontAccounting''' tutorials please visit this website.  
Line 72: Line 72:
 
|-
 
|-
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''browser''' >>'''localhost/account''' >> Press '''Enter'''  
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on '''browser''' >>'''localhost/account''' >> Press '''Enter'''  
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Open the browser and type '''localhost slash account '''and press '''Enter.'''  
+
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Open the '''browser''' and type '''localhost slash account '''and press '''Enter.'''  
  
 
|-
 
|-
Line 111: Line 111:
  
 
'''Charts of Accounts'''  
 
'''Charts of Accounts'''  
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| * The '''Charts of Accounts''' in '''FrontAccounting''' is defined by '''Type, Class, Group''' and '''Account'''.
+
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"|  
* All '''transactions''' are charged to an '''Account''', '''Group''', '''Classes'''
+
* The '''Charts of Accounts''' in '''FrontAccounting''' is defined by '''Type, Class, Group''' and '''Account'''.
 +
* All '''transactions''' are charged to an '''Account, Group''' and '''Classes'''.
 
* These are used to group '''transactions''' for '''reporting purposes'''.  
 
* These are used to group '''transactions''' for '''reporting purposes'''.  
 
|-
 
|-
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:0.75pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Slide 7'''
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:0.75pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Slide 7'''
  
'''Why''' '''GL Accounts, Groups''' and '''Class?'''  
+
'''Why GL Accounts, Groups and Class?'''  
  
 
* '''Account''' belongs to a '''Group''' and '''Group''' belongs to '''Class'''
 
* '''Account''' belongs to a '''Group''' and '''Group''' belongs to '''Class'''
* It will be reflected in Balance Sheet and Profit and Loss A/c statements as per the account group
+
* It will be reflected in '''Balance Sheet''' and '''Profit and Loss A/c statements''' as per the '''account group'''
  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In '''FrontAccounting''',  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In '''FrontAccounting''',  
  
 
* '''Account''' belongs to a '''Group''' and '''Group''' belongs to a '''Class'''
 
* '''Account''' belongs to a '''Group''' and '''Group''' belongs to a '''Class'''
* It will be reflected in the Balance Sheet and Profit and Loss account statements as per the account group
+
* It will be reflected in the '''Balance Sheet''' and '''Profit and Loss account statements''' as per the '''Account Group.'''
 
|-
 
|-
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:0.75pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Narration'''  
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:0.75pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Narration'''  
Line 136: Line 137:
 
|-
 
|-
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click>> '''GL Accounts Classes'''>>  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click>> '''GL Accounts Classes'''>>  
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:0.75pt solid #000001;border-right:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''GL Account Classes '''link''' '''in the '''Maintenance''' panel.
+
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:0.75pt solid #000001;border-right:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on '''GL Account Classes '''link in the '''Maintenance''' panel.
  
 
|-
 
|-
Line 163: Line 164:
  
 
Type '''5'''
 
Type '''5'''
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:0.75pt solid #000001;border-right:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''Class ID''' field, type 5. The ID should be a unique value.
+
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:0.75pt solid #000001;border-right:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''Class ID''' field, type 5. The '''Class ID''' should be a unique value.
  
 
|-
 
|-
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click>> '''Class Name''' field>>  
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click>> '''Class Name''' field>>  
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| In the '''Class''' '''Name''' field, type '''Equity.'''
+
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| In the '''Class Name''' field, type '''Equity.'''
  
 
|-
 
|-
Line 210: Line 211:
 
This is because, in the default '''Class Type,''' '''Equity''' is on the third hierarchy level.  
 
This is because, in the default '''Class Type,''' '''Equity''' is on the third hierarchy level.  
  
So, whenever a new '''Class''' is added, it takes the default place of the '''Class''' '''Type'''.  
+
So, whenever a new '''Class''' is added, it takes the default place of that '''Class Type'''.  
  
 
|-
 
|-
Line 216: Line 217:
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Now, let us see how to add '''GL Groups.'''  
 
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Now, let us see how to add '''GL Groups.'''  
  
Go to the '''Banking and General Ledger '''tab'''.'''
+
Go to the '''Banking and General Ledger '''tab.
  
 
|-
 
|-
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click>> '''GL Groups''' >>  
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click>> '''GL Groups''' >>  
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the '''GL Account Groups''' link''' '''in the '''Maintenance''' panel.
+
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Click on the '''GL Account Groups''' link in the '''Maintenance''' panel.
  
 
|-
 
|-
Line 244: Line 245:
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| The '''Group Name “Fixed Assets” '''does not belong to any '''subgroup''' that is already available.  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| The '''Group Name “Fixed Assets” '''does not belong to any '''subgroup''' that is already available.  
  
Hence, in the '''subgroup''' field, keep the field as '''None.'''  
+
Hence, in the '''Subgroup''' field, keep the field as '''None.'''  
  
 
|-
 
|-
Line 253: Line 254:
 
According to the '''Charts of Accounts, Fixed Assets '''comes under the '''class''' of '''Assets.'''  
 
According to the '''Charts of Accounts, Fixed Assets '''comes under the '''class''' of '''Assets.'''  
  
So select '''Assets''' as '''Class.'''  
+
So select '''Class''' as '''Assets'''.
  
 
|-
 
|-
Line 259: Line 260:
  
 
Point to the message which appears  
 
Point to the message which appears  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| To save these changes, click on '''Add new '''button at the bottom of the window'''.'''
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| To save these changes, click on '''Add new '''button at the bottom of the window.
  
We can see an error message that says -  
+
We can see an error message that says - '''"This account Group ID is already in use".'''  
 
+
'''This account Group ID is already in use”.'''  
+
  
 
|-
 
|-
Line 269: Line 268:
  
 
Narration  
 
Narration  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| So a unique '''Class''' '''ID''' has to be added to each '''Group''' '''Name'''.
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| So a unique '''Class ID''' has to be added to each '''Group Name'''.
  
 
|-
 
|-
Line 277: Line 276:
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Let’s change the '''Group ID '''to '''13.'''  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Let’s change the '''Group ID '''to '''13.'''  
  
Click on the '''Add new '''button at the bottom of the window
+
Click on the '''Add new '''button at the bottom of the window.
  
 
|-
 
|-
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Point to the>> '''message bar'''>>  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Point to the>> '''message bar'''>>  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| This time we can see a message that says -  
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| This time we can see a message that says - '''"New account type has been added."'''  
 
+
'''New account type has been added.'''  
+
  
 
|-
 
|-
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| '''Point to the newly added Group Name'''  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| '''Point to the newly added Group Name'''  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| The new '''Group Name '''is added randomly''' '''within the '''class “Assets”.'''  
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| The new '''Group Name '''is added randomly within the '''class “Assets”.'''  
  
 
|-
 
|-
Line 304: Line 301:
 
|-
 
|-
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click>>'''GL Accounts''' >>  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click>>'''GL Accounts''' >>  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then click on '''GL Accounts '''link''' '''in the '''Maintenance''' panel.
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then click on '''GL Accounts '''link in the '''Maintenance''' panel.
  
 
|-
 
|-
Line 320: Line 317:
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on the '''Account Name''' field.  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click on the '''Account Name''' field.  
  
Type the '''Account Name '''as '''Land and Building”.'''  
+
Type the '''Account Name '''as '''"Land and Building".'''  
  
 
You can give any name of your choice.  
 
You can give any name of your choice.  
Line 327: Line 324:
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click >> '''Account Group''' field>>  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Click >> '''Account Group''' field>>  
  
Select the '''Fixed''' '''Assets''' '''Account''' '''Group'''>>  
+
Select the '''Fixed Assets Account Group'''>>  
  
 
Narration  
 
Narration  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''Account Group''' drop-down box, select the '''Account Group''' as '''Fixed Assets.'''  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| In the '''Account Group''' drop-down box, select the '''Account Group''' as '''Fixed Assets.'''  
  
The '''Account''' '''Name''' '''Land & Building''' has to come under the '''Group Fixed Assets''' as per the '''Charts of Accounts.'''  
+
The '''Account Name Land and Building''' has to come under the '''Group Fixed Assets''' as per the '''Charts of Accounts.'''  
  
 
|-
 
|-
Line 344: Line 341:
  
 
Narration  
 
Narration  
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then click on '''Add Account '''button''' '''at the bottom of the window.
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Then click on '''Add Account '''button at the bottom of the window.
  
We can see the message -  
+
We can see the message - '''"New account has been added".'''  
 
+
'''New account has been added’.'''  
+
  
 
|-
 
|-
Line 384: Line 379:
  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We have learnt to create
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| We have learnt to create
 
'''  '''
 
  
 
* '''General Ledger Classes  '''
 
* '''General Ledger Classes  '''
Line 396: Line 389:
 
'''Assignment 1'''  
 
'''Assignment 1'''  
  
* Create new''' GL Accounts -''' '''Cash''' and '''Capital''' with the below details
+
* Create new''' GL Accounts - Cash''' and '''Capital''' with the below details
*
+
  
 
{| style="border-spacing:0;"
 
{| style="border-spacing:0;"
Line 418: Line 411:
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| As an assignment.  
 
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| As an assignment.  
  
* Create new''' GL Accounts -''' '''Cash''' and '''Capital''' with the below details
+
* Create new''' GL Accounts - Cash''' and '''Capital''' with the below details
 
* Save the changes  
 
* Save the changes  
  
Line 425: Line 418:
  
 
Point the newly added account (after assignment)
 
Point the newly added account (after assignment)
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Now we have set the '''Charts of Accounts''' for our '''Company '''with new '''GL Accounts'''
+
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.092cm;padding-right:0.106cm;"| Now we have set the '''Charts of Accounts''' for our '''Company '''with new '''GL Accounts'''.
  
 
|-
 
|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Slide''' '''9:'''
+
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| '''Slide 9:'''
  
 
'''Acknowledgement'''  
 
'''Acknowledgement'''  
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| * The video at the following link summarises the Spoken Tutorial project.
+
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"|  
* Please download and watch it
+
* The video at the following link summarises the Spoken Tutorial project.
 +
* Please download and watch it.
 
|-
 
|-
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Slide 10:
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Slide 10:
Line 453: Line 447:
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.
  
More information on this mission is available at
+
More information on this mission is available at this link.
 
+
this link.
+
  
 
|-
 
|-
Line 461: Line 453:
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| The script and video has been contributed by Spoken Tutorial team.  
 
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.206cm;padding-right:0.191cm;"| The script and video has been contributed by Spoken Tutorial team.  
  
This is Pratik kamble signing off. '''Thanks '''for joining.  
+
This is Pratik Kamble signing off. Thanks for joining.  
  
 
|}
 
|}

Latest revision as of 10:59, 5 November 2019

Banking and General Ledger

Slide 1

Title Slide

Welcome to the spoken tutorial on Banking and General Ledger in Front Accounting.
Slide 2

Learning Objectives

In this tutorial,we will learn to create

  • General Ledger Classes
  • General Ledger Groups
  • General Ledger Accounts
In this tutorial,we will learn to create
  • General Ledger Classes
  • General Ledger Groups
  • General Ledger Accounts
Slide 3

System Requirements

  • Ubuntu Linux OS version 14.04
  • FrontAccounting version 2.3.24
To record this tutorial, I am using
  • Ubuntu Linux OS version 16.04
  • FrontAccounting version 2.4.7
Slide 4

Pre -requisites

To practise this tutorial, you must have knowledge of:

  • Higher secondary commerce & accounting
  • Principles of Bookkeeping
To practise this tutorial, you must have knowledge of:
  • Higher secondary commerce and accounting and
  • Principles of Bookkeeping
You should have already
  • Set up an Organisation/Company in FrontAccounting

If not, for relevant FrontAccounting tutorials please visit http://spoken-tutorial.org

And you should have already set up an organisation or Company in FrontAccounting.

If not, for relevant FrontAccounting tutorials please visit this website.

Slide 5:

Start XAMPP service

Start the XAMPP services before you begin working on FrontAccounting interface.
Narration Let us open the FrontAccounting interface.
Click on browser >>localhost/account >> Press Enter Open the browser and type localhost slash account and press Enter.
Narration The login page appears.
Enter Username = admin and Password = spoken>> Click on login Type the username as admin and the password.

Then click on Login button.

Point to>> Frontaccounting >> The FrontAccounting interface opens.
Click on Banking and General Ledger tab. Click on Banking and General Ledger tab.
Point to>> Maintenance bar>>
  • GL Accounts
  • GL Account Groups
  • GL Account Classes
In the Maintenance panel we can see the options:
  • GL Accounts
  • GL Account Groups
  • GL Account Classes
Narration Before we start with any transaction, we need to set the Charts of Accounts.
Slide 6

Charts of Accounts

  • The Charts of Accounts in FrontAccounting is defined by Type, Class, Group and Account.
  • All transactions are charged to an Account, Group and Classes.
  • These are used to group transactions for reporting purposes.
Slide 7

Why GL Accounts, Groups and Class?

  • Account belongs to a Group and Group belongs to Class
  • It will be reflected in Balance Sheet and Profit and Loss A/c statements as per the account group
In FrontAccounting,
  • Account belongs to a Group and Group belongs to a Class
  • It will be reflected in the Balance Sheet and Profit and Loss account statements as per the Account Group.
Narration Switch back to the FrontAccounting interface.
Point to>> GL Account Classes>> The first step is to set the General Ledger Account Classes.
Click>> GL Accounts Classes>> Click on GL Account Classes link in the Maintenance panel.
Click>> GL Account Classes >>

Point to the Class ID and the Class type

Here, by default the Class Name and Class Type are defined as:
  1. Assets
  2. Liabilities
  3. Income
  4. Expense

Also, we can see that the Class ID is set for each Class Type.

Narration We need to set this class before setting the Account Group.
Now we will see how to add a new class.
Click >>Class ID field >>

Type 5

In the Class ID field, type 5. The Class ID should be a unique value.
Click>> Class Name field>> In the Class Name field, type Equity.
Click>> Class Type field >>

Show the dropdown box and the options

Narration

Click on the Class Type drop-down box.

We can see the default list:

  • Assets
  • Liabilities
  • Equity
  • Income
  • Cost of Goods Sold
  • Expense

FrontAccounting follows this Class Type to present in the Balance Sheet.

Select the Class type as Equity Select the Class Type as Equity.
Click>> Add new button>>

Point to the message which appears

Click on Add new button at the bottom of the window.

A message is displayed- 'New account class has been added'.

Point to the Equity status >> GL Account Classes

Point >> Class type drop down box>>

Point >> the Panel where the Equity shows in the third level>>

Here, we can see that the new Class “Equity” has been added to the third row.

This is because, in the default Class Type, Equity is on the third hierarchy level.

So, whenever a new Class is added, it takes the default place of that Class Type.

Point to Banking and General Ledger tab Now, let us see how to add GL Groups.

Go to the Banking and General Ledger tab.

Click>> GL Groups >> Click on the GL Account Groups link in the Maintenance panel.
Point to the >> GL Group Name List >>

Point to the >>Group ID list>>

We can see the default Group Name, which shows GL Account Groups under the Class.

You can also see the Group ID is set according to the Class.

Point to the >>Group ID list>> In the ID field, type the new Group ID as 12.
Click>> Group Name field>> In the Name field, I will type Fixed Assets as the Group Name.
Click>> Subgroup of dropdown menu>>

Point>> Subgroup of field>>

The Group Name “Fixed Assets” does not belong to any subgroup that is already available.

Hence, in the Subgroup field, keep the field as None.

Click>> Class dropdown box >> select Assets Now, click on the Class drop-down box.

According to the Charts of Accounts, Fixed Assets comes under the class of Assets.

So select Class as Assets.

Click>> Add New button >>

Point to the message which appears

To save these changes, click on Add new button at the bottom of the window.

We can see an error message that says - "This account Group ID is already in use".

Point to the existing code 12

Narration

So a unique Class ID has to be added to each Group Name.
Type>> Group ID 13>>

Click>> Add New button>>

Let’s change the Group ID to 13.

Click on the Add new button at the bottom of the window.

Point to the>> message bar>> This time we can see a message that says - "New account type has been added."
Point to the newly added Group Name The new Group Name is added randomly within the class “Assets”.
Narration Likewise, we can add our own Group Name.

<<PAUSE>>

Point to Banking and General Ledger tab Now, let us see how to add GL Accounts.

Click on the Banking and General Ledger tab.

Click>>GL Accounts >> Then click on GL Accounts link in the Maintenance panel.
Click>> Account Code field>>

Point to the Account Code field

Here also we need to type a unique code. It is a mandatory field.

In the Account Code field, I will type 1100 as the code.

You can give any code of your choice, if you wish to.

Click>> Account Name field>> Click on the Account Name field.

Type the Account Name as "Land and Building".

You can give any name of your choice.

Click >> Account Group field>>

Select the Fixed Assets Account Group>>

Narration

In the Account Group drop-down box, select the Account Group as Fixed Assets.

The Account Name Land and Building has to come under the Group Fixed Assets as per the Charts of Accounts.

Click>> Account status field >> Next, click on the Account status drop down menu.

Select the status as Active.

Click>> Add Account button >>

Narration

Then click on Add Account button at the bottom of the window.

We can see the message - "New account has been added".

Click>>account drop down box>>

Narration

Now, click on the New account drop-down box at the top.

We can see the newly added Account here.

Point to the account code Each organisation will have their own set of account codes, as shown here.
Narration Likewise, by following the above steps, you can create your own GL Accounts.
This brings us to the end of this tutorial.

Let us summarize

Slide 8

Summary

We learnt to

  • General Ledger Classes
  • General Ledger Groups
  • General Ledger Accounts
We have learnt to create
  • General Ledger Classes
  • General Ledger Groups
  • General Ledger Accounts
Slide 8:

Assignment 1

  • Create new GL Accounts - Cash and Capital with the below details


Account code GL Account Name GL Account Group
1101 Cash Current Assets
1102 Capital Long term liabilities
As an assignment.
  • Create new GL Accounts - Cash and Capital with the below details
  • Save the changes
Narration -

Point the newly added account (after assignment)

Now we have set the Charts of Accounts for our Company with new GL Accounts.
Slide 9:

Acknowledgement

  • The video at the following link summarises the Spoken Tutorial project.
  • Please download and watch it.
Slide 10:

About workshops

The Spoken Tutorial Project Team conducts workshops and gives certificates.

For more details, please write to us.

Slide 11:

Forum for specific questions:

Please post your timed queries in this forum.
Slide 12 :

Acknowledgement

Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

Previous slide The script and video has been contributed by Spoken Tutorial team.

This is Pratik Kamble signing off. Thanks for joining.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat