Define Accounts groups in SAP FICO

Define Accounts groups:

100000           Equity share capital

100001           Cash account

100002           Preference share capital

100003           SBI current Account

Say We have created 1000 accounts

Requirement:

We want to see only current assets balance or transaction.

           

We can not get directly-we have to verify each and every account and add the respective accounts- in this example

Account no.100001 and 100003 – it takes time

                                           or 

We are preparing profit & loss account & balance sheet on liabilities we have items like share capital, Reserves & surplus-We have to verify each and every account and assign to the respective items- In this example

Account no. 100000 & 100002 - takes so much time                                       

To get account balances directly or to assign accounts easily SAP has given account groups. The structure is                                       

                                 Chart of accounts                  

                                                |                      

                             Accounts groups                        

                                         |                                                                 

                                   Accounts                                           

Eg :-                   Chart of accounts                                      6200             

                                                |                                                    |                 

                             Accounts groups                         Share capital (100000 - 100099)

                                         |                                                                 

                                  Accounts                                       Current assets (200000-200099)

When we create the accounts, it can be with any number with in the range given for current assets i.e  200000-200099.

ð  When we want to see current assets we give the group current assets.

ð  When we create equity share capital it can be with any number with in the range given for share capital i.e; 100000 – 100099

ð  When we prepare balance sheet for share capital item we assign accounts 100000 – 100099

ð  If the accounts balance is there it appears – otherwise it will not appear.

                                               

While crating account groups we take client's balance sheet and crate the groups-after implementation also we wants to see the way he used to get.   

We suggest:

1 Series for liabilities          

2.Series for assets  

3.Series for income

4.Series for expenditure    

At the time of posting to salaries accounts the user need not verify all the accounts.

At the time of posting he enters 4* only expenditure accounts will appear

CUSTOMIZATION (TR.CODE.OBD4)   

path:  SPRO-Financial accounting-General ledger accounting- GL accounts-master data-preparations-Define account group

select new entries button

Chart of accounts	Account group	Name	From account	To account
6200	SCPL	Share Capital	100000	100099
6200	RSPL	Reserves & Surplus	100100	100199
6200	ACDN	Accumulated depreciation	100200	100299
6200	SCLN	Secured Loans	100300	100399
6200	UNSL	Unsecured loan	100400	100499
6200	CLPL	Current Liabilities and Provisions	100500	100599
6200	FAST	Fixed Assets	200000	200099
6200	CAST	Current Assets loans & Advances	200100	200199
6200	SALE	Sales	300000	300099
6200	OTHER	Other Income	300100	300199
6200	INCR	Increase / Decrease in stocks	300200	300299
6200	RMCL	Raw material consumption	400000	400099
6200	PRSN	Personnel  cost	400100	400199
6200	MFRG	Manufacturing Expenses	400200	400299
6200	ADMN	Administration Expenses	400300	400399
6200	INTR	Interest	400400	400499
6200	DEPR	Depreciation	400500	400599

Select save button on Crtl+S

Select your request and press enter and save in your request.

Why we are using 6 digits?

6 digits                                                               4digits

1000000        100099  share capital                  1000-1099         100000000-1000000099

100100          100199 Reserves & Surplus      1100-1199

100200           100299  Accumulated Depreciation1200-1299

100400           100499 Unsecured loans            1400-1499

100500           100599 Current Liabilities & Provision1500-1599        

200000           200099  Fixed Assets                 2000-2099

Afterwards we require liabilities account groups with 1 series –10 account groups.

How many groups we can crate with 1sries . available accounts (1999-1599)=400 accounts. New account groups with 1series we can create 400/100=4 groups .

Now we have to go for –5 series .

The user at the time of posting first the will give 1*

If the account is not there then he will check with 5*

When we use 6 digits:

Afterwards we require liabilities account groups with 1 series to 10 account groups. How many groups we can create with 1 series available accounts (199999-100599=99400) accounts.

For each account group we are assigning 100 accounts new account groups with 1 series. We can create 99400/100=944 accounts groups. 5/6/7/8/ digits.