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
● Disbursement of salary advances to employees
● Alter/Create Salary details screen to include salary advances pay head
● Recovery of salary advances during Payroll processing
● Stopping salary advance deduction
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.
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.
● Press F2: date to change the voucher date.
● Debit Salary Advance Deduction Ledger with the required amount, Tally.ERP 9 displays a sub-form to allocate this debit to a Cost Centre.
● Select the required employee name and accept the sub-form.
● Credit Bank account and Accept the voucher.
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.
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.
1. Go to Gateway of Tally > Payroll Vouchers > Ctrl+F4: Payroll.
2. Press F2 to Change the Voucher Date.
3. Click A: Payroll Auto Fill.
4. Select the Salary in Process for field.
5. Enter the From and To date in the Employee Filter screen.
6. Select the appropriate Cost Category.
7. Select the Employee/Group (select Employee A alone) from the List of Employees / Group.
8. Select the Appropriate Payroll Ledger from the List of Ledger Accounts.
9. Enter the User Defined Pay Head Values e.g. Variable Pay and Salary Advance Deduction.
● Go to Gateway of Tally > Display > Payroll Reports >Statement of Payroll> Employee Breakup of Pay Head.
● Select Salary Advance Deduction.
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.
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.
'Tracking Loans & Advances (Payroll)' has been shared with
