Tracking Loans & Advances (Payroll)

Tally.ERP 9 Payroll facilitates tracking of loans and advances paid to employees and allow defining simple to complex criteria for recovery of such advances. The Loan/Advances can be recovered in complete or a number of installments from Employee’s salary.

The process of tracking the Loans/Advances given and recoveries involves the following steps:

Creating Salary Advance Deduction Pay Head

To create the Salary Advance Deduction Pay Head, refer to Loans and Advances Pay Head Creation.

Note: If fixed EMI’s needs to be deducted to recover the Loan given, then the Calculation Type should be selected as Flat Rate.

Payment of salary advances

In order to account for the Loan payment to an employee, enter the Payment Voucher as shown below:

Go to Gateway of Tally > Accounting Voucher > F5: Payment

Note: If you are using the Single entry mode of Payment voucher, then select Bank Account in the voucher header and select Salary Advance Deduction from the List of Ledgers.

Create/Alter salary structure to include salary advance pay head

To create/alter the salary structure to include Loans/Advances Pay Head, refer Defining Salary details.

Note: When a Loan is to be recovered in Multiple Fixed Installments, it is added to an Employee’s Pay Structure with Calculation Type as Flat Rate.

Recovery of salary advance through Payroll voucher

Go to Gateway of Tally > Payroll Vouchers > Ctrl+F4: Payroll

  1. Press F2 to Change the Voucher Date

  2. Click A: Payroll Auto Fill

  3. Select the Salary in Process for field

  4. Enter the From and To date in the Employee Filter screen

  5. Select the appropriate Cost Category

  6. Select the Employee/Group (select Employee A alone) from the List of Employees / Group

  7. Select the Appropriate Payroll Ledger from the List of Ledger Accounts

  8. Enter the User Defined Pay Head Values e.g. Variable Pay and Salary Advance Deduction.

Track salary advance balances

Go to Gateway of Tally > Display > Payroll Reports >Statement of Payroll> Employee Breakup of Pay Head

All the salary advances given to employees will be listed here with details of opening and closing balances.

As per the requirements this report can be configured using the F12: Configure button.

Stopping salary advance deduction

Once the loan amount is repaid, you can remove the Salary Advance deduction Pay head from the Salary Details of the relevant employee to avoid erroneous deduction of Salary Advance during the Payroll Voucher. However, if the Calculation type is given as user-defined, you may press Enter to skip the field.