RFP Volume-II.
ICSIL Intelligent Communication Systems India Ltd.
(Joint Venture of TCIL – A Govt. of India Enterprise & DSIIDC – An Undertaking of Delhi Govt.)
Administrative Building, 1st Floor, Above Post Office, Okhla Indl. Estate, Ph.-III, New Delhi -110020
Phone : 26929051, 26830338, Fax: 26830347, e-mail: ,
TENDER No: ICSIL/2011-12/SW/02 DATED 11.11.2011
RFP forDesign, Development, Implementation Of Web Enabled Financial and Accounting Software.
VARIOUS APPLICATION MODULES TO BE DEVELOPED ARE :
LOANS
Preliminary system requirement Study
INFRASTRUCTURE LOANS
Loan to societies registered under societies registration act or Trust registered under the Indian Trust Act, which are engaged in the social sectors, namely health, education and welfare activities for construction of their own building to be used for advancement of their objectives only;provided that such as society or Trust possesses land free from all encumbrances, charge, lien mortgages, attachments frits etc. which can be mortgaged as a security of loan.
Loan to Co-operative Housing Society for installation of lifts, DGS Set, EPABX, Exterior development etc.
Unique code (Nos.)
a) Loan Application No.
b) Society’s Membership No.
c) Loan Code
Know Your Customer (KYC) Details of Applicant society trust i.e. name address,PAN No. name of the office bearers etc.
Nominal Member : Applicant,Co-applicant,Surety(s) are enrolled as nominal membrs. Sequential unique nominal membership no. is given. At present Rs. 200/= per person is charged as nominal membership fee.
Application details : Nominal Membership No. of Applicant, Co-Applicant, Surety(s) minimum 1 surety. Application no. is given unique (sequential). Loan Required, Property details for which loan is required. Tenure of loan, Type of ROI (fixed floating), Type of Property,Total cost, Amount of loan sanction, sanction date, Enhancement of loan applied, Amount enhanced date of enhancement, Enhancement of loan can be mulitple nos. With moratorium or without moratorium. Etc.
Appraisal Reports : mentioning the amount applied eligibility as per norms.
Sanction Letter : Printing of sanction letters
Disbursement of loan :Loan is disbursed through account payee cheque/DD/PO or transfer in part or full can be disbursed in mulitple installments. Every loan instalment can carry different rate of interest. Every installment of loan disbursed is treated as separate loan for recovery purpose.
ROI : Fixed earlier used to be fixed for the entire tenure, now is fixed for 3 years to be reset at the interval of three years for next three years. Floating change immediately after the decision.
Moratorium : Repayment starts after 12 months or 11 months and days of 12 month). Interest for moratorium period is capitalised on monthly basis and recovered in balance tenure with interest thereon. If tenure is 5 years interest for first year is capitlized and entire amount principal, moratorium period interest with interest thereon is recovered in 4 years.
Deductions from disbursement : Amount towards Loan Linked Share Capital at the prescribed rate at present 1 % is deducted, net amount is released interest is charged on gross amount
Release letters : Printing of Release letters
Enhancement Letters : Printing of enhancement letters.
Demand : After disbursement demand is generated on monthly basis.
Printing of Demand Letters
If the amount of PDC is less than demand. Report is to be generated for all such cases and letter is to be sent to the borrower to submit the cheque of differential amount.
Amount received towards repayment of loan : Amount received towards repayment of loan is transferred into ‘recovery suspense account’ for interim period.
Repayment of loan : The amount received towards repayment of loan is kept is suspense account. While generating the demand for next month from recovery suspense transferred in different heads of account.
Additional payment : Additional amount received towards repayment of loan over and above the normal demand is adjusted in loan account towards repayment of Moratorium period interest outstanding if any, thereafter towards principal and demand for the subsequent months is generated on reduced balance.
Repayment mode : Can be paid through ECS/Cheque/Demand Draft/PO/cash till now cash is not being recovered towards repayment of loan.
Dis-honour of cheque : Intimation regarding dis-honour of cheque is sent to the borrower. Dis-honour charges can be imposed at present nil.
ECS dis-honour : Intimation regarding dis-honour of ECS is sent to the borrower. Dis-honour charges can be imposed at present Rs. 60/=
Loan ledger :Ledger(s) is being maintained on actual receipt basis.
Default in payment : In case of default in payment penal interest is charged.
Default letter : Default letter/notices issued in case of default in repayment of loan.
Income Tax letter/certificate : Printing of income tax certificate containing the amount received between the given dates and to be recovered between the dates.
Interface with Financial Accounts (General Ledger)
All the transactions will also be transferred in Financial Accounts (General Ledger)
Printing of Cheque
Provision of printing of cheques for disbursement of loan
Essential Reports
Loan Ledger Printing
Loan Linked Share Capital Printing
Loan Balances – Total should match with Financial Accounts (General Ledger)
Loan Linked Share Capital Balances – Total should match with Financial Accounts (General Ledger)
Printing of balance letter
Printing of Balance and interest paid
Accrued interest
Default Statement
NPA Calculations
MIS Reports
Audit Annexures
List of loan application received during the given date (all or specific)
List of loan sanctioned during the given date (all or specific)
List of loan enhanced during the given date (all or specific)
List of loan released during the given date (all or specific)
List of application received pending for sanction
List of disbursement against amount sanctioned/enhanced between given period.
Interest Rate wise principal and Moratorium period outstanding
Projected Demand for the entire year or given period for all the loanees
Preliminary system requirement Study
HOME IMPROVEMENT LOAN INDIVIDUALS
Home Improvement Loan (HIL) is given to the person for improvement of the existing flat the amount is released in multiple installment in favour of applicant.
Conversion Loan is given to the person for making payment of Conversion Charges to DDA the amount is released in favour of DDA.
Separate Loan Application No./Loan Code for separate loan.
An Applicant can talk Home Loan, Home Improvemment Loan, Conersion Loan (All, any two or one)
Unique code (Nos.)
Nominal Membership No.
Loan Application No.
Society No.
Society’s Membership No.
Loan Code
Know Your Customer (KYC) Personal Details of Applicant, Co-Applicant, Surety(s) i.e. name,address,permanent address, employer, employer address PAN No. etc.
Nominal Member : Applicant,Co-applicant,Surety(s) are enrolled as nominal members. Sequential unique nominal membership no. is given. At present Rs. 200/= per person is charged as nominal membership fee. Type of employment, Falls under Physically handicapp category
Application details : Nominal Membership No. of Applicant, Co-Applicant, Surety(s) minimum 1 surety. Application no. is given unique (sequential). Loan Required, Property details for which loan is required. Tenure of loan, Type of ROI (fixed floating), Type of Property, Total cost, Rebate of Govt. Employee to be given, Rebate of physically handicapp to be given etc. Amount of loan sanction, sanction date, Enhancement of loan applied, Amount enhanced date of enhancement, Enhancement of loan can be mulitple nos. With moratorium or without moratorium. Death Coverage under master policy is to be taken or not, GIP to be paid applicant or DEPARTMENT (by default applicant) Etc.
AT PRESENT LOAN IS BEING GIVEN WITHOUT MORATORIUM
Appraisal Reports : mentioning the amount applied eligibility as per norms.
Sanction Letter : Printing of sanction letters
Disbursement of loan :Loan is disbursed through account payee cheque/DD/PO or transfer in part or full can be disbursed in mulitpleinstallments. Every loan instalment can carry different rate of interest. Every installment of loan disbursed is treated as separate loan for recovery purpose.
ROI : Fixed earlier used to be fixed for the entire tenure, now is fixed for 3 years to be reset at the interval of three years for next three years. Floating change immediately after the decision.
Moratorium : Repayment starts after 12 months or 11 months and days of 12 month). Interest for moratorium period is capitalised on monthly basis and recovered in balance tenure with interest thereon. If tenure is 5 years interest for first year is capitlized and entire amount principal, moratorium period interest with interest thereon is recovered in 4 years.
Deductions from disbursement : Amount towards Loan Linked Deposit at the prescribed rate at present 1 % is deducted, and towards GIP/PIP can be deducted. Gross amount is released net amount after deductions toward GIP,Loan Linked Deposit net amount is released interest is charged on gross amount
Release letters : Printing of Release letters
Enhancement Letters : Printing of enhancement letters.
Demand : After disbursement demand is generated on monthly basis.
Printing of Demand Letters
If the amount of PDC is less than demand. Report is to be generated for all such cases and letter is to be sent to the borrower to submit the cheque of differential amount.
Amount received towards repayment of loan : Amount received towards repayment of loan is transferred into ‘recovery suspense account’ for interim period.
Repayment of loan : The amount received towards repayment of loan is kept is suspense account. While generating the demand for next month from recovery suspense transferred in different heads of account.
Additional payment : Additional amount received towards repayment of loan over and above the normal demand is adjusted in loan account towards repayment of Moratorium period interest outstanding if any, thereafter towards principal and demand for the subsequent months is generated on reduced balance.
Repayment mode : Can be paid through ECS/Cheque/Demand Draft/PO/cash till now cash is not being recovered towards repayment of loan.
Dis-honour of cheque : Intimation regarding dis-honour of cheque is sent to the borrower. Dis-honour charges can be imposed at present nil.
ECS dis-honour : Intimation regarding dis-honour of ECS is sent to the borrower. Dis-honour charges can be imposed at present Rs. 60/=
Ledger(s) is being maintained on actual receipt basis. Loan ledger (interest, principal, gip, pip, moratorium period interest, penal interest etc.) Loan Linked Deposit Ledger (amount of LLD interest paid thereon, amount transferred from that account towards payment of GIP/PIP)
Default in payment : In case of default in payment penal interest is charged.
Default letter : Default letter/notices issued in case of default in repayment of loan.
Income Tax letter/certificate : Printing of income tax certificate containing the amount received between the given dates and to be recovered between the dates.
Interface with Financial Accounts (General Ledger)
All the transactions will also be transferred in Financial Accounts (General Ledger)
Printing of Cheque
Provision of printing of cheques for disbursement of loan
Essential Reports
Loan Ledger Printing
Loan Linked Deposit Ledger Printing
Loan Balances – Total should match with Financial Accounts (General Ledger)
Loan Linked Deposit Balances – Total should match with Financial Accounts (General Ledger)
Printing of balance letter
Printing of Balance and interest paid
Accrued interest
Default Statement
NPA Calculations
MIS Reports
Audit Annexures
List of loan application received during the given date (all or specific)
List of loan sanctioned during the given date (all or specific)
List of loan enhanced during the given date (all or specific)
List of loan released during the given date (all or specific)
List of application received pending for sanction
List of disbursement against amount sanctioned/enhanced between given period.
Interest Rate wise principal and Moratorium period outstanding
Projected Demand for the entire year or given period for all the loanees
Provisions in Existing IFS Module
HOME IMPROVEMENT LOAN INDIVIDUALS
FILES
Nominal Member : Borrower, Co-Borrower (if any), and surety(s) are enrolled as nominal member unique (sequential) is allotted to nominal membership at present @ Rs. 200 per person is received. Personal details of the member (Know your customer KYC) is stored i.e. name, father’s name, DOB, permanent address, current address, contact nos. PAN No., Name of the Employer, Employer address etc.
Society : Details of the society are entered normally linked with registration module (member society’s details are entered in registration module). New sequential no is given linked with membership no. of the society.
Loan Application : Unique (sequential) application No. is given , Nominal membership no. of Borrower, Co-borrower (if any) and surety(s) are entered, Loan applied, loan sanctioned, sanction date, Tenure, Type of ROI are entered, with moratorium or without moratorium, Enhancement(s) of Loan (Amount, date of enhancement). Amount already released(system calculated)
ROI : Fixed earlier used to be fixed for the entire tenure, now is fixed for 3 years to be reset at the interval of three years for next three years. Floating change immediately after the decision.
Moratorium : Repayment starts after 12 months or 11 months and days of 12 month). Interest for moratorium period is capitalised on monthly basis and recovered in balance tenure with interest thereon. If tenure is 5 years interest for first year is capitlized and entire amount principal, moratorium period interest with interest thereon is recovered in 4 years.
Property Details : Property details for which loan is applied. In case of society flats under construction as the flat will be allotted in due course the property details are entered in due course after allottment of flat.
Receipt Details : Copy of the Receipt module option to see the details of receipt.
TRANSACTIONS
Loan Released : Entry of loan disbursed while disbursement of first loan installment unique (sequential) loan code is allotted.
Gross amount is released net amount after deductions toward GIP,Loan Linked Deposit net amount is released interest is charged on gross amount
Release Cheque details : Details of release cheque disbursement can be made through single cheque against multiple disbursement in case of loan is being released in r/o member of society.
Release Letter Cheque : Printing of release letter where amount is being released through cheque.
Sanction Letter : Printing of sanction and enhancement letters
Release Letter Con Deed : Printing of release letter for conveyance deed loan.
Release list : List of loan released
Enhancement letters : Printing of enhancement letters.
ACTIVITIES
Loan receipt : Adding of receipt pertaining to module. Receipt is issued in receipt module. Debit portion of voucher is passed in receipt module while depositing the cheque and credit portion is passed by module. Once the voucher become balance is further processed in FA module.
In case of dis-honour of cheque credit portion of voucher is passed in receipt module. Debit portion of voucher is passed in module pertaining to receipt. Once the voucher become balance is further processed in FA module.
Cheque Dis-honour : Intimation letter regarding dis-honour of cheque
ECS Dis-honour : Intimation letter regarding ECS dis-honour
Recovery Suspense : For adjusting the receipt. The amount received is transferred into Recovery Suspense Account.
Auto Add Receipt : Automatically receipt is added in the loan account.
LIST
Appraisal Report : Printing of loan appraisal report as per the norms.
Sanction List : List of loan sanctioned between given date range
Enhancement List : List of Loan enhance between given date
Application list : List of Loan Applications
Audit Schedule: Audit Schedules
Close letter : Printing of account close letters
REPORT
Loan Ledger : Printing of loan ledger
Release details : Details of amount sanctioned,released,name address of borrower,co-borrower,surety(s) dates property details,cheque no etc.
IT letter : Income Tax letter amount rocovered between the given to period and to be recovered between the given dates
LL Deposit Ledger : Printing of Loan linked Deposit Ledger
Default letter : Printing of default letter(s) different type
Address Label : Mailing Labels (All,Single Multiple)
HELP
Keys
Contents
User interface
About
UTILITIES
Backup : for taking back up of data files
Restore for restoring the files
Reindex : Reindexing the file
Password : for changing the password
Report Path : Report path where output file on disk to be stored.
STATS
Demand : Printing of demand letter
Demand Summary : Printing of demand summary
Cons. Default : Printing of consolidated default.
PDC Statement : Generate future demand according to which the borrower can deposit the Post Dated Cheques
Diff in PDC letter : letter to submit the cheque if difference in amount due and PDC submitted.(PDC amount is less than demand)
Diff in PDC : Statement showing the demand and pdc submitted where pdc amount is less than demand
Revised PDC : amount of PDC to be given towards repayment of loan as per revised rate of interest if any. (Due to change in ROI)
Preliminary system requirement Study
INDIVIDUAL LOANS
Unique code (Nos.)
Nominal Membership No.
Loan Application No.
Society No.
Society’s Membership No.
Loan Code
Know Your Customer (KYC) Personal Details of Applicant, Co-Applicant, Surety(s) i.e. name,address,permanent address, employer, employer address PAN No. etc.
Nominal Member : Applicant,Co-applicant,Surety(s) are enrolled as nominal membrs. Sequential unique nominal membership no. is given. At present Rs. 200/= per person is charged as nominal membership fee. Type of employment, Falls under Physically handicapp category
Application details : Nominal Membership No. of Applicant, Co-Applicant, Surety(s) minimum 1 surety. Application no. is given unique (sequential). Loan Required, Property details for which loan is required. Tenure of loan, Type of ROI (fixed floating), Type of Property,Total cost, Rebate of Govt. Employee to be given, Rebate of physically handicapp to be given etc. Amount of loan sanction, sanction date, Enhancement of loan applied, Amount enhanced date of enhancement, Enhancement of loan can be mulitple nos. With moratorium or without moratorium. Death Coverage under master policy is to be taken or not, GIP to be paid applicant or DEPARTMENT (by default applicant) Etc.