Payroll Management in Tally Prime
Complete Study Material, Practical Exercises, Examples & Viva Questions
Tally Prime Payroll Practical Training
Table of Contents
- Introduction to Payroll
- Objectives of Payroll
- Enabling Payroll in Tally Prime
- Payroll Masters
- Attendance / Production Types
- Pay Heads
- Employee Groups and Employees
- Salary Details
- Payroll Vouchers
- Payroll Reports
- Payroll Process Flow
- Theory Questions
- Short Practical Questions
- Practical Problems
- Comprehensive Assignment
- Viva Questions
1. Introduction to Payroll
Payroll management is a crucial function in every organization because employees must be paid accurately and on time. A computerized payroll system reduces manual calculations and helps maintain proper records.
Payroll Includes
- Salaries and wages
- Payroll taxes and statutory deductions
- Provident Fund (PF)
- Employee State Insurance (ESI)
- Professional Tax
- Employee benefits
- Bonus and incentives
- Other deductions
Net Salary = Gross Salary − Total Deductions
₹30,000 − ₹2,500 = ₹27,500
2. Objectives of Payroll System
- Ensure accurate salary calculation
- Provide timely salary payments
- Maintain statutory and legal compliance
- Reduce manual calculation errors
- Maintain employee salary records
- Generate payroll reports and payslips
- Support department-wise payroll analysis
3. Enabling Payroll in Tally Prime
Before processing employee salaries, the Payroll feature must be enabled in the company.
Steps
- Press F11 to open Features.
- Set Show More Features to Yes.
- Set Show All Features to Yes, where applicable.
- Set Maintain Payroll to Yes.
- Accept and save the configuration.
4. Payroll Masters Creation
Payroll in Tally Prime works through a structured set of masters. These masters define employees, salary components, attendance and salary structures.
Main Payroll Masters
- Attendance / Production Types
- Pay Heads
- Employee Groups
- Employees
- Employee Categories
- Salary Details
5. Attendance / Production Types
Attendance or Production Types are used to record employee attendance, working hours or production quantities.
Examples
- Present Days
- Absent Days
- Overtime Hours
- Leave Without Pay
- Production Quantity
6. Pay Heads
Pay Heads define the individual components that make up an employee’s salary. They can represent earnings or deductions.
Types of Pay Heads
| Pay Head Type | Examples | Purpose |
|---|---|---|
| Earnings for Employees | Basic, HRA, DA, Bonus | Adds to employee salary |
| Deductions from Employees | PF, ESI, Professional Tax | Deducts amounts from salary |
Calculation Types
| Calculation Type | Description | Example |
|---|---|---|
| As Computed Value | Automatically calculated using a defined formula or basis. | HRA = 20% of Basic |
| As User Defined Value | Amount is entered manually during processing. | Special incentive |
| Flat Rate | Fixed amount irrespective of other values. | Conveyance = ₹2,000 |
| On Attendance | Calculated according to attendance days/hours. | Daily wages × Present Days |
| On Production | Calculated according to quantity produced. | ₹10 per unit × Units Produced |
Basic Salary = ₹20,000
HRA = 20% of Basic
HRA = ₹20,000 × 20% = ₹4,000
7. Employee Groups and Employees
Employee Groups
Employee Groups are used to categorize employees according to department, designation, function or organizational structure.
Examples
- Faculty
- Office Staff
- Accounts
- Marketing
- Administration
Employees
Employee masters contain employee-related information such as employee name, group, category and other payroll-related details.
Employee: Ramesh
Employee Group: Faculty
Employee Category: Teaching Staff
Employee Categories
Employee Categories provide another level of classification and can be useful when employees need to be grouped for payroll analysis or cost allocation.
Examples:
- Teaching Staff
- Non-Teaching Staff
- Permanent Employees
- Contract Employees
8. Salary Details
Salary Details define the salary structure applicable to an employee or employee group. The structure may contain earnings and deductions.
Example Salary Structure
| Pay Head | Calculation |
|---|---|
| Basic Salary | ₹20,000 |
| HRA | 20% of Basic |
| DA | 10% of Basic |
| Conveyance | ₹2,000 |
| Medical | ₹1,500 |
| PF | 12% of Basic |
| Professional Tax | ₹200 |
9. Payroll Voucher Entries
Once payroll masters and salary details are configured, payroll transactions can be recorded using the appropriate vouchers.
Attendance Voucher
Attendance Voucher is used to record employee attendance, overtime, leave or production information.
Shortcut: Ctrl + F5
Steps
- Select the appropriate Attendance Type.
- Select employee or employee group.
- Enter attendance details.
- Use Auto Fill where applicable.
- Save the voucher.
Payroll Voucher
Payroll Voucher is used to process employee salary based on the configured salary structure and recorded attendance.
Shortcut: Ctrl + F4
Steps
- Select the required employee or employee group.
- Use Auto Fill where applicable.
- Verify calculated earnings and deductions.
- Check the net salary.
- Save the voucher.
10. Payroll Reports
Tally Prime provides payroll reports for verification, analysis and record keeping.
Common Payroll Reports
- Pay Sheet
- Pay Slip
- Attendance Register
- Payroll Statement
- Payroll Register
- Employee-wise salary information
11. Important Features of Payroll in Tally Prime
- Automated salary calculation
- Flexible salary structures
- Attendance-based salary processing
- Overtime calculation
- Group-wise payroll management
- Employee-wise payroll records
- Statutory deduction support
- Payroll reporting
- Payslip generation
- Reduced manual errors
12. Practical Flow of Payroll Process
13. Part A – Theory Questions
14. Part B – Short Practical Questions
- Enable Payroll features in Tally Prime.
- Create an Employee Group named Faculty.
- Create another Employee Group named Office Staff.
- Create Employee Category Teaching Staff.
- Create Employee Category Non-Teaching Staff.
- Create Employee Ramesh under Faculty.
- Create Employee Suresh under Office Staff.
- Create Attendance Type Present Days.
- Create Attendance Type Overtime Hours.
- Create Pay Head Basic Salary.
- Create Pay Head House Rent Allowance (HRA).
- Create Pay Head Dearness Allowance (DA).
- Create Pay Head Conveyance Allowance.
- Create Pay Head Professional Tax.
- Create Pay Head Provident Fund.
- Create Salary Payable Ledger.
- Define Salary Details for Ramesh.
- Record attendance for one month.
- Process salary for one month.
- Generate and print the employee Payslip.
15. Part C – Practical Problems
Problem 1 – Fixed Salary
Create the following employees and process salary for June.
| Employee | Basic | HRA | DA | Conveyance |
|---|---|---|---|---|
| Ramesh | ₹20,000 | ₹4,000 | ₹2,000 | ₹1,500 |
| Suresh | ₹18,000 | ₹3,600 | ₹1,800 | ₹1,200 |
Deductions:
- PF = ₹1,800
- Professional Tax = ₹200
Problem 2 – Attendance-Based Salary
ABC Computer Institute has the following employees.
| Employee | Monthly Salary | Present Days | Working Days |
|---|---|---|---|
| Ravi | ₹30,000 | 28 | 30 |
| Kumar | ₹24,000 | 26 | 30 |
| Sita | ₹18,000 | 24 | 30 |
Calculation
Enter the attendance and process the Payroll Voucher for the month.
Problem 3 – Overtime
Basic Salary = ₹18,000
Overtime Rate = ₹120 per hour
Present Days = 30
Overtime = 15 hours
Prepare the Payroll Voucher.
Problem 4 – Multiple Pay Heads
Create the following Pay Heads:
Earnings
- Basic
- HRA
- DA
- Medical Allowance
- Special Allowance
- Bonus
Deductions
- PF
- ESI
- Professional Tax
- Income Tax
Prepare salary for three employees and verify the gross salary, total deductions and net salary.
Problem 5 – Bonus Processing
Bonus = 10% of Basic Salary.
| Employee | Basic Salary | Bonus (10%) |
|---|---|---|
| Ravi | ₹25,000 | ₹2,500 |
| Sita | ₹20,000 | ₹2,000 |
| Kumar | ₹18,000 | ₹1,800 |
Create the Bonus Pay Head and process salary.
Problem 6 – Leave Without Pay
Employee Salary = ₹24,000
Working Days = 30
Leave Without Pay = 3 Days
Calculate the salary and enter the Payroll Voucher.
Problem 7 – Department-Wise Payroll
Create the following Employee Groups:
- Accounts
- Marketing
- Faculty
- Administration
Enter salary details for two employees in each department and generate a department-wise payroll report.
Problem 8 – Salary Increment
Basic Salary = ₹20,000
Increase = 15%
Process salary using the revised basic salary for the next month.
Problem 9 – New Employee Joining
Employee joined on 16th June.
Monthly Salary = ₹30,000
Working Days = 30
Problem 10 – Salary Advance
Employee Salary = ₹25,000
Salary Advance = ₹5,000
Deduct the salary advance while processing the payroll.
16. Part D – Comprehensive Assignment
XYZ Computer Institute
Employee Groups
- Faculty
- Office Staff
Employees
| Employee | Group |
|---|---|
| Ramesh | Faculty |
| Suresh | Faculty |
| Kavitha | Office Staff |
| Priya | Office Staff |
Salary Structure
| Pay Head | Value / Calculation |
|---|---|
| Basic | ₹20,000 |
| HRA | 20% of Basic |
| DA | 10% of Basic |
| Conveyance | ₹2,000 |
| Medical | ₹1,500 |
| PF | 12% of Basic |
| Professional Tax | ₹200 |
Attendance
| Employee | Present Days | Working Days |
|---|---|---|
| Ramesh | 30 | 30 |
| Suresh | 28 | 30 |
| Kavitha | 27 | 30 |
| Priya | 25 | 30 |
Sample Full-Month Salary Calculation
Assignment Tasks
- Enable Payroll.
- Create Employee Groups.
- Create Employees.
- Create Attendance Type.
- Create all required Pay Heads.
- Create Salary Details.
- Enter Attendance Voucher.
- Process Payroll Voucher.
- Display Payroll Register.
- Generate and print Payslip.
- Display Employee Pay Sheet.
- Display Attendance Register.
17. Part E – Viva Questions
18. Additional Practice Questions
Conceptual Questions
- Differentiate between Gross Salary and Net Salary.
- What is the purpose of a Pay Head?
- Why is Basic Salary important in payroll calculation?
- What is the difference between an earning and a deduction?
- What is attendance-based salary calculation?
- What is overtime?
- What is Leave Without Pay (LWP)?
- Why are salary structures created?
- What is a Payroll Register?
- What is a Payslip?
Calculation Practice
Practical Challenge
- Enable Payroll.
- Create Faculty and Office Staff groups.
- Create five employees.
- Create Present Days and Overtime Hours.
- Create Basic, HRA, DA, Conveyance and Medical pay heads.
- Create PF and Professional Tax deductions.
- Define salary structures.
- Enter attendance.
- Enter overtime for selected employees.
- Process the Payroll Voucher.
- Verify the Payroll Register.
- Generate individual Payslips.
19. Quick Revision Chart
| Topic | Purpose |
|---|---|
| Attendance Type | Records attendance, leave, overtime or production |
| Pay Head | Defines earnings and deductions |
| Employee Group | Classifies employees |
| Employee Category | Provides an additional classification level |
| Employee | Stores employee information |
| Salary Details | Defines salary structure |
| Attendance Voucher | Records attendance information |
| Payroll Voucher | Processes employee salary |
| Payslip | Shows individual salary details |
| Pay Sheet | Shows payroll information for employees |
| Attendance Register | Shows employee attendance records |
20. Conclusion
Payroll management in Tally Prime provides a structured approach to managing employee salaries. By creating appropriate masters, defining salary structures, recording attendance and processing payroll vouchers, organizations can reduce manual work and maintain systematic payroll records.
Enable Payroll → Create Masters → Define Salary → Record Attendance → Process Payroll → Verify Reports → Generate Payslip