FrontAccounting-2.4.7/C2/Banking-and-General-Ledger-in-FrontAccounting/English
Banking and General Ledger
| Slide 1
Title Slide |
Welcome to 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/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 |
* The Charts of Accounts in FrontAccounting is defined by Type, Class, Group and Account.
| |||||||||
| 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 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 the 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 Assets as Class. | |||||||||
| 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 & 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 |
* The video at the following link summarises the Spoken Tutorial project.
| |||||||||
| 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. |
