balance interest calculations in sap fico

Balance Interest calculations:

Path: Accounting – Financial accounting – General ledger- periodic processing- Interest calculation-Balance interest calculation (F.52)

Company code                                             :AML

Give the GL account                                   :100300 ( SBI Rupee Term Loan)

Calculation period                                       :01.04.2008 to 31.03.2009

Execute

Select back arrow

To view line item wise interest

Select additional balance line check box

Execute

Select bank arrow

How to give effect for floating rate of Interest

Interest rate change from 10% to 12% from 01.06.2008

On 100000 from 10/04/2008 to 31/05/2008 @10%

On 100000 from 01.06.2008 to 09.09.2008 @12%

On 90000 from   10/09.2008 to 31/03/2009 @12%

Open one more session with SPRO

Path :SPRO- Financial accounting – General ledger accounting – Business transactions- Bank account interest calculation – Interest calculation- Enter Interest Values (OB83)

Select new entries button

Reference interest rate       : G2    

Valid from                              :01.06.2008

Interest rate                           :12      

Save

Press enter to save in your request come to the first session

Execute

Select back arrow

Interest postings to accounts:

Change the calculation period      : 01.04.2008 to 30.04.2008

Select post interest settlements check box

Select update master records check box

Session name                                  :  AML

Posting to business area                : AMLH

Posting date of session                  :30.04.2008

Posting segment text                       : Interest for April 2008

Select execute button

To view the batch input session

From the menu select system – >Services –> Batch inputà Session

Select session name           : AML

Select process button

Select display errors only radio button

Select process button

We get a message processing of batch input session completed

Select exit batch input button

To view the document posted use the (Tr. Code FB03)

Go and see the GL maser (FS00)

Give the GL Account no.                :100300 (SBI rupee T.L)

Company code                                 : AML

From the menu select GL account –->Display –-> Select create / Bank / Interest tab

Key date of last interest calculation :30.04.2008

Date of last interest run                     :20.10.2008

On which date we have to run

1. Simple interest                                                    2. Compound interest

SBI rupee term loan 10.04.2008 100000             SBI rupee term loan 10.04.2008 100000

30.04.2008         575

0002-400400 Interest A/c                                       For may it calculates on 100575

2000-100510 Interest payable a/c

For may it calculates on 100000

Interest also to post to separate accounts

400400 Interest on SBI Rupee Term Loan

400401 Interest on IDBI Rupee Term Loan

400402 Interest on ICICI Rupee Term Loan

0002-400400 interest on SBI rupee term loan, we are calculating interest for IDBI rupee term loan

In batch input session – select process forward radio button

Deselect display errors only radio button

40                          400400 Interest on SBI Term Loan 1000

Change account no to 400401

How to make open items initially inactive:

Clearing

1             1000 Cr

2             2000 Cr

3             3000 Cr

Payment 1000 Dr

The difference is too large for clearing all items are initially inactive

1                     1000 Cr

2                     2000 Cr

3                     3000 Cr

Payment        1000 Dr

Path : Accounting – Financial Accounting – General ledger – Environment – User parameter- Editing options (Tr.code is FB00)

Select open items tab

Select selected items initially inactive check box

Save

Foreign Currency Balance Revaluation

FC term loan (Foreign currency TL)

            |

Long term working capital                          Fixed assets purchase

                                                                                    |

                                                                        Local assets              Imported assets

21.10.2008    100000 USD             47        4700000

13.10.2008    100000 USD             50        5000000

                                                                        -----------

                                                                          300000

                                                                        ========

As per accounting standard 11 (ASII)

Balance to be revaluated and charge to profit & loss account.

Creation of 3  GL Masters

A) SBI FC Term loan                                   Secured loans

B) Exchange Gain                                       other income

C) Exchange Loss                                       Administration

To check account groups for giving account No.OBD4

Select position button

Give the chat of accounts                          : AML

Enter

Note the other income range 300100 to 300199

Create of GL masters FS00

Give the GL account no.100301

Company code                                 : AML

Select with template button

Give the GL account no                  :100300 (SBI Rupee Term Loan)

Company code                                 : AML

Enterjjgjgjgyhghjkykhuiky

Change short text and long test to SBI FC term loan

Select control data tab

Account currency change to USD

Deselect only balance and loan currency check box

Select create / bank / Interest tab

Interest indicator                              : Blank                       

Delete the dates

Save

GL Account                                       :300100

Company code                                 : AML

Select with template button

Give the GL account no.                 :400300 Rent account

Company code                                 : AML

Enter

Select type/ Description tab

Change account group to other income

 change short text and GL account long text to exchange gain

Save

GL Account                                       : 400301

Company code                                 : AML

Select with template button

Give the GL account no.400300 rent account

Company code                                 : AML

Enter

Change short text and GL account long text to exchange loss

Save