Loan Transaction Detail
In this module, user can input the transaction of the loan given / paid to / by the employee. This helps to generate the report of Loan transactions. It is necessary to make entry in Loan transaction of given loan after adding the details in Manage Account.
There are two approaches how the Loans are managed.
Case 1) Loan is given to employee and is recovered every month as per the Installment decided where Installment and Interest deduct every Month.
Working with Manage Account and Loan Transaction Entry Module for this case:
Manage Account :
- Go to Loan Setting and uncheck setup “Do not deduct interest at the time of deducting installment” (Configuration -> Loan Setting).
- Move to Loan -> Manage Account.
- Click on 'Create' to allocate New Loan to an Employee.
- Select the Employee Name and provide Loan Given Date.
- Select the “Distributed By” (Distributed by is entered from 'Distribution' and selected from Manage Account).
- Select the “Loan Type” (Loan Type is entered from 'Loan Type' and selected from Manage Account).
- Select the Loan Name (Loan Heads defined in Salary Heads with selection of “Attached As” as “Tax Free Loan”, “Housing / Vehicle Loan”, “Other Loan” will only appear in selection list and will be allowed to select).
- Input the Installment Amount that has to be paid by Employee or that has to be deducted from his pay slip monthly in field “Installment Amt.”
- Select “Calculate Interest on” i.e. Day base or Month Base. By default Day base is selected.

Day Basis : For calculating interest system will select “Total Days of Month/365”
For E.g. Given Loan 50000, Rate 8%, Loan Given 01-Apr-2018
((50000*8%)*30/365)
Month Basis : For calculating interest system will select than system will directly divide interest by 12
For E.g. Given Loan 50000, Rate 8%, Loan Given 01-Apr-2018
((50000*8%)/12)
- User can also enter the 'Loan AC Code' and ‘Loan Int. Code’, if any for accounting purpose.
- Select the respective Rate in “SBI Interest Rate (%)” which help in calculating Tax Perquisite i.e. Loan Concession if not provided then loan consider as TAX FREE LOAN, no perquisites are calculated.
- Click on “Save”, this will save the Loan details entered (Please note that Loan number is auto generated once you save the Manage Account Entry).
Loan Transaction Entry :
- Go to Loan -> Loan Transaction Entry or from Manage Account Module click on button “Transaction”.
- Select the Name of Employee to whom Loan is given, select the type of Loan given to that employee and Click on 'View' button. The window expands giving the option to enter the details of Loan.
- Click on 'Add' button to input the Loan Transaction.
- Input the Date of Loan; Input the Total Amt. of loan given. Select the type 'Given (Loan)' from the list. Write the Narration if any and Save it.
- User must note that Loan Date from Manage Account Module and Loan Transaction Date from Loan Transaction Entry Module for given amount must be same or greater than Loan Given date of Manage Account.
- If the software process is initiated in-between the financial year and employee has already repaid some amt., then it should be inputted as type 'Repaid Loan' or ‘Repaid Int’ to keep the proper history of loan.
- Now move to Loan Process and select the month of Loan Given, Select employee and make adjustment if any
- Save & Lock Loan process record of selected employee.
- Installment amt. and Interest entered will be automatically deducted while monthly processing until any balance loan.

- After Processing user find Entry in Loan Transaction automatically which will be Salary Deducted, Interest Charge and Interest (Repaid)
For E.g.
|
1-May |
Given Amount in May |
50,000 |
339.72 |
Interest calculated will deducted as per 8% Day Basis |
|
|
Installment |
20,000 |
|
|
|
1-Jun |
Balance Amount |
30,000.00 |
197.26 |
Interest calculated will deducted as per 8% Day Basis |
|
|
Installment |
20,000 |
|
|
|
1-Jul |
Balance Amount |
10,000.00 |
67.94 |
Interest calculated will deducted as per 8% Day Basis |
Case 2) Loan is given to employee and is recovered every month as per the Installment decided where only Installment deducted every Month and Interest added to Principle Amount.
Working with Manage Account and Loan Transaction Entry Module for this case:
Manage Account :
- Go to Loan Setting and check setup “Do not deduct interest at the time of deducting installment” (Configuration -> Loan Setting).
- Move to Loan -> Manage Account.
- Click on 'Create' to allocate New Loan to an Employee.
- Select the Employee Name and provide Loan Given Date.
- Select the “Distributed By” (Distributed by is entered from 'Distribution' and selected from Manage Account).
- Select the “Loan Type” (Loan Type is entered from 'Loan Type' and selected from Manage Account).
- Select the Loan Name (Loan Heads defined in Salary Heads with selection of “Attached As” as “Tax Free Loan”, “Housing / Vehicle Loan”, “Other Loan” will only appear in selection list and will be allowed to select).
- Input the Installment Amount that has to be paid by Employee or that has to be deducted from his pay slip monthly in field “Installment Amt.”
- Select “Calculate Interest on” i.e. Day base or Month Base. By default Day base is selected.

Day Basis : For calculating interest system will select “Total Days of Month/365”
For E.g. Given Loan 50000, Rate 8%, Loan Given 01-Apr-2018
((50000*8%)*30/365)
Month Basis : For calculating interest system will select than system will directly divide interest by 12
For E.g. Given Loan 50000, Rate 8%, Loan Given 01-Apr-2018
((50000*8%)/12)
- User can also enter the 'Loan AC Code' and ‘Loan Int. Code’, if any for accounting purpose.
- Select the respective Rate in “SBI Interest Rate (%)” which help in calculating Tax Perquisite i.e. Loan Concession if not provided then loan consider as TAX FREE LOAN, no perquisites are calculated.
- Click on “Save”, this will save the Loan details entered (Please note that Loan number is auto generated once you save the Manage Account Entry).
Loan Transaction Entry :
- Go to Loan -> Loan Transaction Entry or from Manage Account Module click on button “Transaction”.
- Select the Name of Employee to whom Loan is given, select the type of Loan given to that employee and Click on 'View' button. The window expands giving the option to enter the details of Loan.
- Click on 'Add' button to input the Loan Transaction.
- Input the Date of Loan; Input the Total Amt. of loan given. Select the type 'Given (Loan)' from the list. Write the Narration if any and Save it.
- User must note that Loan Date from Manage Account Module and Loan Transaction Date from Loan Transaction Entry Module for given amount must be same or greater than Loan Given date of Manage Account.
- If the software process is initiated in-between the financial year and employee has already repaid some amt., then it should be inputted as type 'Repaid Loan' or ‘Repaid Int’ to keep the proper history of loan.
- Now move to Loan Process and select the month of Loan Given, Select employee and make adjustment if any.
- Save & Lock Loan process record of selected employee.
- Installment amt. entered will be automatically deducted while monthly processing until any balance loan.

- After Processing user find Entry in Loan Transaction automatically which will be Salary Deducted and Interest Charge.
For E.g.
|
1-May |
Given Amount in May |
50,000 |
339.72 |
Interest calculated but not deducted as per 8% Day Basis |
|
|
Installment |
20,000 |
|
|
|
1-Jun |
Balance and Interest added in Principle |
30,339.73 |
199.49 |
Interest calculated but not deducted as per 8% Day Basis |
|
|
Installment |
20,000 |
|
|
|
1-Jul |
Balance and Interest added in Principle |
10,539.22 |
71.6 |
Interest calculated but not deducted as per 8% Day Basis |
Import : For adding Multiple Entry we can add through Import button.
