Procedure for Annual Interest Calculation at HO [PPF/SB/NSS]

NOTE

If you intend to transfer interest calculated at the HO for SOs to the respective SOs electronically, then download and execute Int_Seq_2015.exe at both the SO and HO, before calculation of interest at HO. This will enable generation of interest file with sequence number 1 at HO and will enable its subsequent import / posting at SO.

• The file ‘Int_Seq_2015.exe’ can be executed on or after 30/03/2015 only.
• Interest calculation and posting should be done only on or after 01/04/2015.

Step 1

1. Download the revised DBAnalyzer Software. Run DBAnalyzer software. Select ‘Database Discrepancies’. 
2. Ensure that previous financial year Interest Entry (2013-2014) is made for all accounts. (‘Ledger entries without previous year interest entry’ option will list the accounts without interest entry).
3. Login to Data Entry Module as Data Entry Supervisor and insert the interest transaction for the previous financial year (i.e. for 2013-2014) with the transaction date as '01/04/2014’ and transaction type as 'interest'. 
4. Ensure that account type is available for all accounts. (Account numbers with blank account type’ option) Login as Supervisor. Use 'Common -> Account type Conversion' form. Select the correct account type and save.
5. Ensure that ledger entries with Cleared Date as ‘01/01/1900’ are not available. (‘Ledger entries with LOT / Cleared Date as 01/01/1900’ option) 
6. Ensure that account status is updated for all accounts. (Account numbers with blank account status' option) 
7. Select 'Database Discrepancies >> SB >> Account numbers with blank account status' option in DBAnalyzer and update the account status.

Step 2 

1. Login as ‘Supervisor’ in on-line module.
2. Check interest rates in initialisation group.
3. Check the current financial year in the form (Form No.0410) ‘Initialisation >> Financial Year – SB / PPF / NSS’ (Financial Year should be 01/04/2014 –31/03/2015). 

Step 3

From the menu,

1. Select ‘Annual Interest Calculation’ form (Form No. 1305 / 1004 / 0904) to calculate interest for SB / PPF / NSS.
2. Select 'IBB Report' option to generate IBB Report. 
3. Select 'Annual Interest Calculation' option to carry out calculation.

Step 4

After calculation is finished,

1. Check the error files in SP5\OT folder to view the accounts for which interest was not calculated.
2. Rectify the errors listed. It is advisable to rectify as many of the errors listed if not all and then re-calculate interest by selecting 'Annual Interest Calculation' option again, before interest posting. The process can be repeated any number of times till no accounts is listed in the error list.
3. After rectifying  all  the errors listed during interest calculation,  recalculate interest before  selecting  the 'Annual Interest Posting' option to carry out interest posting.

NOTE

Interest calculation should be performed at HO for all SOs (including MDGs) and hence the database discrepancies rectifications mentioned above are to be done for both HO as well as SO accounts.