Difference between revisions of "FrontAccounting-2.4.7/C2/Banking-and-General-Ledger-in-FrontAccounting/English"
(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...") |
Nancyvarkey (Talk | contribs) |
||
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 ''' | + | | 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 | + | * 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 | + | '''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 | + | * 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 | + | | 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 | + | | 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 | + | 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 | + | | 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 ''' | + | 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 ''' | + | 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".''' |
− | + | ||
− | + | ||
|- | |- | ||
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 | + | | 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."''' |
− | + | ||
− | + | ||
|- | |- | ||
| 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 | + | | 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 | + | | 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 | + | 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 | + | 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 | + | 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 | + | | 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".''' |
− | + | ||
− | + | ||
|- | |- | ||
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 - | + | * 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 - | + | * 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 | + | | 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 | + | 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
|
In this tutorial,we will learn to create
| |||||||||
Slide 3
System Requirements
|
To record this tutorial, I am using
| |||||||||
Slide 4
Pre -requisites To practise this tutorial, you must have knowledge of:
|
To practise this tutorial, you must have knowledge of:
| |||||||||
You should have already
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>>
|
In the Maintenance panel we can see the options:
| |||||||||
Narration | Before we start with any transaction, we need to set the Charts of Accounts. | |||||||||
Slide 6
Charts of Accounts |
| |||||||||
Slide 7
Why GL Accounts, Groups and Class?
|
In FrontAccounting,
| |||||||||
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:
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:
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
|
We have learnt to create
| |||||||||
Slide 8:
Assignment 1
|
As an assignment.
| |||||||||
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 |
| |||||||||
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. |