INTEREST CALCULATIONS:
We have two types of interest calculations in SAP.
| | Type 1 | Type 2 |
| A. B. C. | Balance Interest Calculations Defined as Type "S" Used for General Ledger A/c | Item Interest Calculation Defined as Type "P" Used for Vendors/ Customers |
Type 1: Balance Interest Calculations
Step1. Define Interest Calculation Type
PATH: SPRO---->Financial Accounts---->General Ledger A/c----> Business Transactions Bank Interest Calculations---->Interest Calculations Global Settings---->Define Interest Calculation Type.
Select New Entries Button
Int. Indicator Name Int. Calculation Type
P1 10% Monthly S( Balance Interest Calculation)
SAVE → ENTER to save in your request.
Step2. Prepare A/c Balance Interest Calculation
PATH: Next step to last path ( TC=OBAA) Select New Entries Button
Int. Cal Indicator P1
Int. Cal Frequency 01 ( 1 Month) Under Period Determination
Calender Tyep G
Select Balance Interest Check Box under Output Section
SAVE → ENTER to save in your request.
Step3. Define Reference Interest Rates
For Example there is SBI Term Loan which was take on 15.4.2009 for Rs. 100000.
ON 15.07.2009 we repaid 1st Installment of Rs. 10,000
Interest Calculation for the Whole year:
Method 1. Aprox.
On 100000 from 15.04.09 to 31.03.10 @ 10% 15000
On paid 10000 from 15.07.09 to 31.03.10 @ 10% -3000
Balance Interest Payable 12000
Method 2.
On 100000 from 15.04.09 to 15.07.09 @ 10% 4000
On 90000 from 15.07.09 to 31.03.10 @ 10% 8000
Balance Interest Payable 12000
In Both the Methods Interest Rate will be Same.
In the above Example the Rate of Interest we are paying interest on Loan taken from SBI and the Rate of Interest we are received from SBI on amout repaid to Bank are same.
i.e, Interest Charged by Bank 10%
Interest Given by Bank 10%
If both are Different ie., When Loan acount is having Credit Balance 10%
When Loan account is having Debit Balance 8%
We have to define Reference Indicators for Inerest.
P2 for A/c having Credit Balance 10%
P3 for A/c having Debit Balance 8%
Following are Steps to follow for Interest Calculation under Type I
1 Interest rates are given to Reference Interest Rates- for P2 -10% & for P3-8%
2 Reference Interest Rates are assaigned to Accounts
P2 to Accounts having Credit Balances
P3 to Accounts having Debit Balances
3 Accounts having Credit Balance and Accounts Having Debit Balance are assaigned to interest indicators
4 Interest Indicator will be specified in Loan Account.
Step 1. Define Interest Rates:
PATH:SPRO---->Financial Accounting--->Gen Ledger a/c--->Business Transactions----> Bank A/c Interest Calculation--->Interest Calculation---->Reference Int. Rates(OBAC)
Select New Entries Button
Ref. Interest Rate: P2
Long Text Int: 10% A/c Having Credit Balance
Description : 10% Accounts Credit Balance
Date From: 01.04.09
Currency: INR
Select Save or Ctrl +S-----> press Enter to Save in your request.
Select New Entries Button
Ref. Interest Rate: P3
Long Text Int: 8% A/c Having Debit Balance
Description : 8% Accounts Debit Balance
Date From: 01.04.09
Currency: INR
Select Save or Ctrl +S-----> press Enter to Save in your request.
Define Time Dependent Terms: Same Path ( Next Line to Last Path)
Select New Entries Button 1
Int. Cal Indicator P1
Currency Key INR
Effective From 01.04.09
Sequential No 1
Term Select Cr. Interest : Balance Interest Calculation
Ref. Int. Rate P2
Select Save or Ctrl +S-----> press Enter to Save in your request.
Select New Entries Button
Int. Cal Indicator P1
Currency Key INR
Effective From 01.04.09
Sequential No 2
Term Select Dr. Interest : Balance Interest Calculation
Ref. Int. Rate P3
Select Save or Ctrl +S-----> press Enter to Save in your request.
Enter Interest Values:
Same Path ( next line to last path) ( TC=OB83)
Select New Entries Button
Reference Interest Rate P2 P3
Valid From 01.04.09 01.04.09
Interest Rate 10% 8%
Select Save or Ctrl +S-----> press Enter to Save in your request
Step 2.Creation of GL Masters: ( FS00)
As we have not created GL Masters for SBI Term Loan and Interest Account , we have to create now. Before Creating the GL Master check the Available A/c Nos in OBD 4 and see the Number Ranges for Account Groups. Select the available Account Number from that Range
GL Master A/c Group A/c No
SBI Rupee Term loan A/c Secured Loans 100300
Interest Account Interest Group 400400
1st A/c
GL A/c# 100300 Comp.Code: PSL F.Year: 2009
Select With Template Button
GL A/c# 100000
Comp.Code: PSL Press Enter
Select Type/ Description Tab
Change Account Group to Secured Loans
Change Short Text & Long Text to SBI Rupee Term Loan
Select Create/Bank/Interest Tab
Change Field Status Group to G005
Int. Indicator P1 → SAVE
2nd A/c
GL A/c# 400400 Comp.Code: PSL F.Year: 2009
Select With Template Button
GL A/c# 400300
Comp.Code: PSL Press Enter
Select Type/ Description Tab
Change Account Group to Interest
Change Short Text & Long Text to Interest Account → SAVE
Step 3.Assaignment of Accounts for Automatic Postings:
PATH: SPRO---->Financial Accounting--->General Ledger Accounting---->Business Transactions
--->Bank A/c Interest Calculation--->Interest Posting--->Prepare GL A/c Balance Interest Calculation
( OBV2)
Select Symbols Button ( F8)
Select A/c. Buttons
Chart of Accounts: PSL → ENTER
A/c Symbol 002 (Interest Paid) Currency INR
GL A/c 400400
A/c Symbol 2000 ( GL A/c Paid) Currency INR
GL A/c ++++++++++ ( 10 Times)
Save -----> Enter
Interest A/c Debit 002 Assaign to 400400
SBI Rupee Term Loan A/c Credit 2000 Assaign to 100300
If More than One Term Loan in Against 2000 '++++++++++ ( 10 Times)
We are giving + symbol 10 times as Max length of A/c Number would be 10 digits
But we are using 6 digits only. If at the time of Posting Cash A/c Dr and Equity
Share Capital Credit, system take Cash account as 0000200100 and Equity Share
Capital as 0000100000 and when we see it shows 200100 Dr and 100000 Cr
But we are using 6 digits only. If at the time of Posting Cash A/c Dr and Equity
Share Capital Credit, system take Cash account as 0000200100 and Equity Share
Capital as 0000100000 and when we see it shows 200100 Dr and 100000 Cr
Suppose if we give 6 times + Symbol for SBI Rupee Term Loan . It takes 000010 which it cannot post.
100300 SBI Rupee Term Loan A/c
100301 IDBI Rupee Term Loan A/c
100302 IFCI Rupee Term Loan A/c
At the time of Interest Calculations, we have to specify for which Loan Account Interest to be calculated and when.
End User Area: To Open Posting Periods for April ( OB52) Select Positon Button
PP.Variant PSL
For Variant PSL From Period 1
Save Press Enter to save in your request.
Step 4 SBI Rupee Term Loan Receipt Entry ( F-02)
SBI has given Cheque Dated 15.04.09 but we deposited in on 17.04.09.
At the time of Posting
Document Date 17.04.09
Posting Date 17.04.09 Posting Date is not Modifiable once document posted
in this case, SBI Calculate Interest from 15.04.09 but SAP calculate Interest from 17.04.09. So to match the Interest, SAP Has given the option of Value Date.
Value date is 15.04.09. So system will calculate interest from Value Date but not
from Posting Date. Value date is modifiable after positng the document also.
from Posting Date. Value date is modifiable after positng the document also.
F-02 ----> Doc.Dt: 17.04.09 Type : SA Comp.Code: PSL
Post.Dt: 17.04.09 Currency : INR
P.Key: 40 A/c No: 200100 → ENTER
Amount 100000 Business Area: PSLH
Value Dt: 15.04.09 Text: SBI Rupee Term Loan Receipt
P.Key: 50 A/c No: 100300 → ENTER
Amount * Business Area: PSLH
Value Dt: 15.04.09 Text: +
Menu----> Document -----> Simulate and Save
Step 5 SBI Rupee Term Loan Repayment (F-02)
1st Installment Due Date 15.07.09
Doc.Dt: 13.07.09 Type : SA Comp.Code: PSL
Post.Dt: 13.07.09 Currency : INR
P.Key: 40 A/c No: 100300 → ENTER
Amount 10000 Business Area: PSLH
Value Dt: 15.07.09 Text: SBI Rupee Term Loan Payment
P.Key: 50 A/c No: 200100 → ENTER
Amount * Business Area: PSLH
Value Dt: 15.07.09 Text: +
Menu----> Document -----> Simulate and Save
INTEREST CALCULATIONS:
PATH: Accounting---->Financial Accounting ---->General Ledger---->Periodic Processing---->Interest Calculations---->Balance Interest Calculation(F.52)
GL A/c 100300 (SBI Rupee term loan)
Comp. Code PSL
Cal.Period 01.04.09 to 31.03.2010
Select Execute Button (F8)
↓
We can see Interest Calculation, but we can not see Interest Line Item Wise To See Line Item Wise Interest select Back Arrow and Choose Line Item Check Box and Execute (F8)
If we want to calculate interest in different rates i.e., from 1st June 2009 to Intereste is increased from 10% to 12%
From 15.04.09 to 31.05.09 on 100000 @ 10%
From 01.06.09 to 15.07.09 on 100000 @ 12%
From 15.07.09 to 31.03.10 on 90000 @ 12%
From 01.06.09 to 15.07.09 on 100000 @ 12%
From 15.07.09 to 31.03.10 on 90000 @ 12%
Open One more Session with SPRO:
Financial Accounting ----> GL A/c----->Business Transactions----> Bank A/c Interest Calculations
---->Interest Calculations----> Enter Interest Values (OB83)
Select New Entries Button
Ref. Interest Rate P2
Valid From 01.06.09
Inte. Rate 12 ----> Save ----> Enter Save in your request.
Come Back to 1st Session : Select Execute Button . We can see New Interest Calculation on Screen with 10% and 12% rates.
Posting of Interest for One Month ( 01.04.09 to 30.04.09)
Select Back Arrow
Cal.Period 01.04.09 to 30.04.09
Post Interest Check Box √
Update Master Records √
Session Name PSL
Posting to Buss Area PSLH
Posting Dt. Of Session 30.04.09
Document Dt. Of Session 30.04.09
Posting Segment Text Interest of April 2009
Execute ( F8) it shows the interest amount calculated
To Post the Batch Input Session:
Menu----> System----> Services----> Batch Input ----> Session
Select Session Name PSL
Select Process Button
Select Display Errors Only Radio Button
Select Process Button ----> We will get a message that Batch Input Session
Completed
Completed
Select Exit Batch Input Session
To View Document Posted ( FB03):
We can see the Document latest posted
Go and see GL Master ( FS00):
GL A/c 100300 ( SBI Rupee Term Loan)
Comp.Code: PSL
Menu----> GL A/c----> Change
Select Create/Bank/Interest Tab
Key Date of Last Int. Cal 30.04.09 (Upto which date we have calculated interest)
Date of Last Run 31.07.09 (ON which date we have run the Interest Cal)
SAP Methods for Interest Calculation:
1 Simple Interest and Compound Interest
Simple Interest Compound Interest
15.04.09 SBI RT Loan 100000 Cr 15.04.09 100000
For Symbol 2000 Assaign A/c # 100520 30.04.09 438
Int Payable Int. 438 Posted to 100300 on 30.04.09
For May It Calculate on 100000 only For May it Calculates on 100438
2 Interest Rates Based on Slabs
If Interest Rate is varied from Amount to Amount this system is useful
for ex: on INR 30,000 Int. Rate 10% P2
on 30001 to 50000 Int .Rate 12% P4
In SPRO---> Define Time Dependent Terms---> Amount from 30001
3 Int. Calculation from 15.04.09 to 14.05.09 ( instead of 01.04.09 to 30.04.09) SPRO--->Prepare A/c Balance Interest Calculation ( OBAA)
Enter Settlement Day 14.
Enter Settlement Day 14.
4 Interest Posting to Different Accounts:
A/c # 400400 Interest on SBI Rupee Term Loan
A/c # 400401 Interest on IDBI Rupee Term Loan
A/c # 400402 Interest on ICICI Rupee Term Loan
So If we are Calculating interest of IDBI Rupee term Loan For Symbol 0002 assaign A/c # 400401
In the Batch pocessing select Process Fore Ground Only
System Shows the Entry which is going to be posted
400400 Interest on SBI R.T Loan 438
100301 IDBI Term Loan 438
Change A/c # 400400 to 400401
No comments:
Post a Comment