FrontAccounting-2.4.7/C2/Banking-and-General-Ledger-in-FrontAccounting/English

From Script | Spoken-Tutorial
Revision as of 12:00, 1 November 2019 by Nirmala Venkat (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

  • 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/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, 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 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 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

  • 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