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 :

Loantransaction1

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)

Loan Transaction Entry :

Loantransaction2

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 :

Loantransaction3

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)

Loan Transaction Entry :

Loantransaction4

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.

Loantransaction5