How do you calculate balance interest calculation in GL.
Answers were Sorted based on User's Feedback
Answer / sai bhaskar reddy.b
There are two defined interest calculation types in the SAP
system.
1. Balance interest calculation.
2. Item interest calculation.
System defined variant for balance interest calculation type
is ‘S’ and item interest calculation type is ‘P’. Balance
interest type calculation is used for G L Accounts. Item
interest type calculation is used for vendors and customers.
To display all transaction codes:
Go to t.code:SE16
Table name: TSTC
Keep blank maximum number of hits.
Total transaction codes in SAP 70837.
The following steps are involved in interest calculation.
1. Define interest calculation types (OB46)
2. Prepare account balance interest calculation (OBAA)
3. Define reference interest rate (OBAC)
4. Define time dependent terms (OB81)
5. Enter interest values (OB83)
6. Creation of G L Accounts (FS00)
7. Define automatic posting (OBV2)
8. Entry for loan (F-02)
9. Interest calculation run (F.52)
Step 01: Define interest calculation types (OB46):
Spro/img/financial accounting/G L Accounting/business
transactions/bank A/C interest calculation/interest
calculation global settings/define interest calculation types.
Go to new entries
Interest Id Name Interest calculation type
V1 balance interest type S
V2 item interest type P
Save
Step 02: Prepare account balance interest calculation (OBAA):
Spro/img/financial accounting/GL Accounting/business
transactions/bank account interest calculations/interest
calculation global settings/prepare account balance interest
calculation.
Go to new entries
Give calculation indicator : V1
Interest calculation frequency : 01
Calendar type : G (28, 29, 30, 31)
Give number range : 03
Select balance plus interest.
Save
Go to new entries.
Calculation indicator : V2
Interest calculation frequency : 01
Calendar type : G
Number range : 03
Select balance +interest
Save
Step 03: Define reference interest rate (OBAC):
Spro/img/financial accounting/G L Accounting/business
transactions/bank account interest calculation/interest
calculation/define reference interest rates.
Go to new entries
Reference interest rate : V1
Long text : 12%balanace interest
Short text : 12% balance interest
Date from : 1.4.2006
Currency : Inr
Save
Go to new entries F8
Reference interest rate : V2
Long text : 15% item interest
Short text : 15%item interest
Date from : 1.4.2006
Currency : Inr
Save
Step 04: Define time dependent terms (OB81):
Spro/img/financial accounting/ G L Accounting/business
transactions/bank account interest calculation/interest
calculation/define time dependent terms.
Go to new entries
Interest calculation indicator : V1
Currency key : Inr
Effective from : 1.4.2006
Sequential no : 01
Term : debit interest balance interest calculation
Reference interest rate : V1
Save
Go to new entries or f8
Interest calculation indicator : V1
Currency : Inr
Effective from : 1.4.2006
Sequential no : 02
Term : credit interest balance interest calculation
Reference interest rate : V1
Save
Go to new entry or f8
Interest cal. Indicator : V2
Currency : Inr
Effective from : 1.4.2006
Sequential no : 01
Term : debit interest arrears interest calculation
Reference rate : V2
Save
Go to new entry or f8
Interest cal. Indicator : V2
Currency : Inr
Effective from : 1.4.2005
Sequential from : 02
Term : credit interest arrears interest calculation
Reference rate : V2
Save
Step 05: Enter Reference Interest Rate Values (OB83):
Spro/img/financial accounting/G L Accounting/business
transactions/bank A/C interest calculation/interest
calculation/enter interest values.
Go to new entries
Reference int. rate values effective from interest rate
V1 1.4.2006 12
V2 1.4.2006 15
Save
Go to T.Code:OBD4 to create secured loans account group.
Go to new entries
Chart of accounts a/c group name from account to account
1116 SELO secured loans 100300 100399
1116 INTR interest 400100 400199
Save
Step 06: Creation of G L Accounts (FS00):
G L A/C no : 100305
Company code : 1116
Select create button
Account group : secured loans
Select balance sheet account
Short text :IB O D Account
Long text :Indian bank overdraft account
Select control data tab
Select only balances in local currencies
Select open item
Select line item display
Sort key : 002
Select create/bank/interest tab
Field status group : G005
Select relevant to cash flow
Interest calculation indicator : V1
Save
Give G L A/C no : 400105
Company code : 1116
Select create button
Account group : interest
Select profit and loss account
Short text : interest on O D Account
Long text : interest on O D Account
Select control data tab.
Select only balances in local currencies
Select line item display
Sort key : 002
Select create/bank/interest tab
Field status group : G001
Save
Step 07: Define automatic posting account (OBV2):
Spro/img/financial accounting/G L Accounting/business
transactions/bank A/C interest calculations/interest
posting/prepare G L A/C balance interest calculation
Go to accounts
Chart of accounts : 1116
A/C symbol currency G L A/C
0002 Inr 400105(interest on o d account)
2000 Inr 100305( I B o d account)
Save
Step 08: Entry for loan (F-02):
Give document date : 1.4.2006
Posting date : 1.4.2006
Type : SA
Company code : 1116
Currency : INR
Posting key : 40
G L Account : 200005(Indian bank a/c)
Enter
Amount : 2500000
Business area : TISC
Value date : 16.07.2006
Text : loan received
Posting key : 50
G L Account : 100305(bank of Baroda O D account)
Enter
Amount : *
Business area : TISC
Text : +
Save
Step 09: Interest calculation run (F.52):
Accounting/financial accounting/general ledger/periodic
processing/interest calculation/balances
Give chart of accounts : 1116
G L A/C no : 100305(bank o d account)
Company code : 1116
Calculation period : 1.7.2006 to 31.7.2007
Select leap year.
Select post also if value date in past
Select update master records
Execute
Go to system on menu bar.
Select services
Select batch input
Select sessions
Select RFSZIS00
Select process
Select display errors only
Again select process
The system gives the message: “processing of batch input
session completed”;
Is This Answer Correct ? | 47 Yes | 5 No |
Answer / kiran konujula
Interest Calculations are Two Types:---
a)Balance Interest Calculation.
b)Item Interest or Interest On Arrears Calculation.
a)Balance Interest Calculation.:---
is a calculation of Interest on total balance of an
account or total balance of customer account.it is
represented in "s".
The configuration steps for calculation of balance
interest calculation are :---
1)define interest calculation type (ob46)]
2)prepare account balance interest calculation (obaa)
3)define reference interest rates (obac)
4)define time dependent terms (ob81)
5)define or specify interest rates (ob83)
6)prepare gl account balance interest calculation (obv2)
7)assign this interst calculation indicator in
specified gl account master record
8)run interest programm (f.52)
Is This Answer Correct ? | 33 Yes | 7 No |
In-house Cash functionality allows “Consolidate the request and make payment on behalf of subsidiaries. “ Can some one help me understand how this is different from Sending Company code and Paying company code concept?
what is meaning of rest and reversal & reset
How do you control Document line item fields?
GL posting as per order type :- Hi, We have a requirement "For free of charge order zfd , all these orders should hit one GL irrespective of movement type (it may 901 or 601)"
Which master data uploads will be done?
What is a company code ? Describe its relationship with a controlling area?
Hello friends i am preparing For SAP FICO, can u please suggest me how can i find the jobs openings?, how shall i prepare for it? and on what area i should more focus on? which kind of questions can enterviewer can ask me and how shall i reply. can please get any reference from your side.. please. i am just craving to get the job please help me....... please reply me on E-mail: g.amresh@gmail.com ....
In accounts receivable, what’s the difference between the ‘residual payment’ and ‘part payment’ methods of allocating cash?
If a company has 4 company codes, 12 plants and 3 sales offices. In this situation how many profit centers and cost centers are advisable? will appericate a qucik response.
Hi 1 Question please My client is on SAP since last 3 years and now they want to migrate their asset related data with AM solution, I would like to know the steps and precaution to be taken at the time of legacy data migration and how to reconcile ABST2 report.
what is the configuration steps of letter of credit?
What is reconciliation account; can you directly enter documents in that a/c?