FINANCIAL STATEMENT VERSION
Balance Sheet and Profit & Loss account
format creation
In India –Companies Act –Schedule VI format
Summary
Schedules Amount
Share capital
Equity
share capital 100000
Preference
share capital 100001
Reserves & Surplus
General
Reserves 100101
Capital
Reserve 100102
Secured loans
Unsecured loans
By using 0-9 levels –we can get all 3
versions consultant creates 2 versions –Summary -Schedules
In 000 Client SAP has given for India Bain.
Path :SPRO-Financial Accounting –General ledger Accounting-Business
transactions-Closing –Document-Define financial statement versions.
Select new entries
button
Financial
statement version :BIL1
Name Balance
Sheet and Profit & Loss account
Maintain Language :EN
Select item keys
automatic check box
Chart of Accounts :BIL
Save
Press enter to
save in your request
Select financial
statement item button
Keep the cursor on
AML1
Select create
items button
Give the items :Balance Sheet
:Profit
& Loss account
:Net profit
/Loss transfer to Balance Sheet
Enter
Kept the cursor on
profit and loss account
Double click on No
text exists against Liability +Equity
Give item :Liabilities
Enter
Double click no
text exists against Assets
Give the item
Assets
Enter
Keep the cursor on
Assets
Press select
button (beside reassign button)
Keep the cursor on
Balance sheet
Select resign
(Shift+F6) button
Select subordinate
radio button
Enter
Keep the on liabilities
Press select
button (F9)
Keep the cursor on
Balance Sheet
Select resign
button (Shift+F6)
Select subordinate
radio button
Enter
Keep the cursor on
Profit & Loss account
Select create item
button
Give the items :Income
Give the items :Expenditure
Enter
Save
Press enter to
save in your request
Keep the cursor on
Liabilities
Select create
items button
Give the Share capital
Reserves &
Surplus
Secured loans
Unsecured loans
Enter
Keep the cursor on
Assets
Select create
items button
Give the items :Net Fixed Assets
:Net Current
Assets
:Misc. expenditure to the extent not written off Eg: Preliminary exp.
Enter
Keep the cursor on
Income
Select create
items button
Give the heads :Sales
:Other
Income
:Inc/Dec in
Stocks
Enter
Keep the cursor on
expenditure
Select create item
button
Expenditure :
Raw material consumption
Personnel expenses
Manufacturing expenses
Administration Expenses
Interest
Depreciation
Enter and Save
Double click no
text existent against net result :Profit
Give the item :Net profit transferred from P & L Account
Enter
Keep the cursor on
Net profit transfer from P & L Account
Press select
button (F9)
Keep the cursor on
reserves & Surplus
Select reassign
button (shift +F6)
Select subordinate
radio button
Enter
Double click on no
text exists against net result loss
Item :Net loss transferred from P & L Account
Enter
Keep the cursor on
net loss transferred from P & L Account
Press select
button (F9)
Keep the cursor on
Misc. Expense to extend not written off
Select reassign
button
Select subordinate
radio button
Enter
Save
Assignment of
accounts are to be assigned to the last note
Keep the cursor on
Share Capital
Select assign
accounts button
Enter
From Account :100000
To Account :100099
Select debit check
box
Select credit
check box
From Account :100101
To :199999
Select debit check
box
Select credit
check box
Note :Expect
100000 all are same
Enter
Keep the cursor on
net fixed assets
Select assign
accounts button
From Account :200000
To Account :299999
Select debit check
box
Select credit
check box
Enter
Keep the cursor on
sales
Select assign
accounts button
From account :300000
To account :399999
Select debit and
Credit check box
Enter
Keep the cursor on
Raw material consumption
Select assign
account button
From account :400000
To account :499999
Select Debit and
Credit check box
Enter
Keep the cursor
net profit/loss transferred to Balance Sheet
Select Assign
account button
From account :100100
Select Debit &
Credit Check box
Enter & Save
To check whether
all accounts assigned or not
Select check
button
Select non
assigned account check box
Enter & Save
Liabilities Amount
Sources of Funds:
100000
100001
100002
Share capital 100003
------- X
100100
100101
Reserves & Surplus 100102
Secured loans X
Unsecured loans X
------
Total Liabilities X
=====
Double click on
liabilities
Start of group
Liabilities
End of group total
liabilities
Select display
total check box
Enter
Double click on
share capital
Start of group :Source of funds
End of group :Share capital
Select display
totals check box
Enter
Double click on
Reserves & Surplus
End group
:Reserves & Surplus
Select display
total check box
Enter
Note :Same way
secured and unsecured loans
Double click on
assets
Start of group :Assets
End of group :Total Assets
Select display
total check box
Enter
Double click on
Net fixed Assets
Start of group :Application of funds
End of group :Net fixed Assets
Select display
total check box
Enter
Double click on
Misc. expenditure to extend not written
off
End group Misc.
expenditure to the expend not written off
Select display
totals
Enter
Double click on
Profit & Loss Account
End of Group :Net Profit /Loss for the year
Select display
total check box
Enter
Double click on
Income
Start of group :Income
End of Group :Total Income
Select display
total check box
Enter
Double click on
sales
End of Group :Sales
Select display
total check box
Enter
Double click on
Expenditure
Start of group :Total expenditure
Select display
total check box
Enter
Double click on
Raw material consumption
End of group :Raw material consumption
Select display
total check box
Enter
Double click on
net profit /Loss transferred to Balance
sheet
Start of group :Net Profit /Loss transferred to balance Sheet
Select display
total check box
Enter
Double click on No
text exist against P & L result
Item :Net profit/Loss transferred to Balance
Sheet
End of Group: Net profit/Loss transferred to Balance Sheet
Select display
total check box
Enter & Save
Open one more session :
Path :Accounting-Financial Accounting –General
Ledger-Information system—General Ledger reports-Balance Sheet/Profit loss
Statement /Cash flow-General –Actual/Actual comparisons- Balance sheet/Profit
Loss Statement (S_ALR_87012284)
Company code :BIL
Business area :BILH
Financial
Statement version :BIL1
Reporting year :2008
Reporting period :1 to 16
Comparison
year :2007
Comparison periods
:1 to 16
Select classical
list radio button
Select special
evaluations tab
Balance sheet type
:1 (Standard Financial
Statement )
Select output
control tab
Company code
summarization :Select 1 (Balance sheet per company code)
Business area summarization
:select 1(Balance Sheet per business
area)
Summary report :3
Comparison
type :1
Note :2 types of comparison in SAP
2008 2007
Sales
100 75
1) Percentage of Increase Current year –Previous year *100
----------------------------------
Previous
year
100-75/75*100=33.3
2) Percentage of growth
:Current year *100
--------------------
Previous year
100/75=133
Scaling :5/2
Scaling note :
A) Only Rupees
without paise 0/0
B) Rupees with
paise 0/2
C)Rupees in lakhs
–without decimals 5/0
D)Rupees in
mission without decimals 6/0
E)Rupees in crores
without decimals 7/0
F)Rupees in laksh
–Thousands in decimals 5/2
Sales 987654321.55
Rupees in lakhs (100000) 5 Decimals
2
decimals 2 decimals 9876.54
Select execute
button
Select back arrow
Select special
evaluations tab
Give the display
currency dollar execute
No comments:
Post a Comment