Lesson 45 of 48 โ€“ Attendance in Tally Prime
90%

๐Ÿ“… Attendance in Tally Prime

Attendance Management in Tally Prime is used to record employee attendance, leave, overtime and working days. It helps calculate salaries accurately during payroll processing.

Lesson Objective Learn how to create Attendance Types, Attendance Units, record Attendance Vouchers, manage leave and overtime, and use attendance records for payroll processing.
1. What is Attendance Management?

Attendance Management is the process of recording employee presence, absence, leave and overtime for salary calculation and payroll reporting.

Attendance Item Purpose
Present Days Count working days.
Absent Days Calculate salary deductions.
Paid Leave Maintain leave records.
Overtime Calculate additional earnings.
Holiday Record company holidays.
2. Why is Attendance Important?
  • Calculates employee salaries accurately.
  • Tracks working days.
  • Manages leave records.
  • Calculates overtime payments.
  • Reduces payroll errors.
  • Improves employee discipline.
  • Generates attendance reports.
  • Supports payroll automation.
Accurate attendance records help ensure fair salary calculations and transparent payroll management.
3. Attendance Components
Component Description
Present Employee attended work.
Absent Employee did not attend work.
Paid Leave Leave with salary.
Casual Leave Short-term leave.
Sick Leave Medical leave.
Overtime Extra working hours.
Attendance components can be customized according to the company's attendance policy.
4. Attendance Workflow
  1. Enable Payroll Features.
  2. Create Attendance Types.
  3. Create Attendance Units.
  4. Create Employee Masters.
  5. Record Attendance Vouchers.
  6. Record Overtime (if applicable).
  7. Process Payroll.
  8. Generate Attendance Reports.
Following a proper attendance workflow helps avoid payroll calculation errors.
5. Types of Attendance Records
Attendance Type Purpose
Present Days Count working days.
Absent Days Deduct salary where applicable.
Paid Leave Paid leave management.
Casual Leave Employee leave tracking.
Sick Leave Medical leave records.
Overtime Hours Extra working time.
Attendance Types should be created before recording Attendance Vouchers.
6. Creating Attendance Types

Attendance Types define the different kinds of attendance that employees can have, such as Present, Absent, Paid Leave, Sick Leave and Overtime. These types are used while recording attendance and processing payroll.

Steps to Create Attendance Types
  1. Open Tally Prime.
  2. Go to Create.
  3. Select Attendance Type.
  4. Enter the Attendance Type Name.
  5. Select the Attendance Unit.
  6. Specify whether it is for Attendance or Production.
  7. Press Ctrl + A to Save.
Common Attendance Types
Attendance Type Purpose
Present Working Days
Absent Unpaid Leave
Paid Leave Leave with Salary
Casual Leave Personal Leave
Sick Leave Medical Leave
Overtime Extra Working Hours
Create all required Attendance Types before recording Attendance Vouchers.
7. Attendance Units & Attendance Voucher

Attendance Units define how attendance is measured. Attendance Vouchers are used to record employee attendance for a selected period.

Attendance Units
Unit Used For
Days Monthly Attendance
Hours Shift-Based Employees
Numbers Production-Based Payroll
Recording Attendance Voucher
  1. Gateway of Tally โ†’ Vouchers.
  2. Select Attendance Voucher.
  3. Select the Employee.
  4. Select the Attendance Type.
  5. Enter Attendance Quantity.
  6. Save the Voucher.
Example
Employee Attendance
Rahul Kumar 26 Present Days
Priya Singh 24 Present Days + 2 Paid Leaves
Attendance Vouchers should be entered before processing salaries.
8. Leave & Overtime Management

Attendance Management also includes leave records and overtime calculations that directly affect payroll.

Attendance Item Payroll Impact
Paid Leave No Salary Deduction
Unpaid Leave Salary Deduction
Casual Leave Company Policy Applies
Sick Leave As per Leave Policy
Overtime Additional Salary
Example
Employee OT Hours OT Amount
Rahul Kumar 12 Hours โ‚น2,400
Overtime should be verified before payroll processing to ensure correct salary calculation.
9. Attendance Reports & Verification

Attendance Reports help verify employee attendance before payroll processing.

Report Purpose
Attendance Register Employee Attendance Summary
Employee Attendance Report Employee-wise Attendance
Payroll Register Attendance & Salary Summary
Pay Sheet Department-wise Payroll
Payslip Final Salary Details
Verification Checklist
  • Attendance is recorded correctly.
  • Leave entries are verified.
  • Overtime hours are approved.
  • No duplicate attendance entries exist.
  • Attendance Reports match payroll records.
Always verify Attendance Reports before generating Payroll Vouchers.
10. Common Attendance Mistakes
Common Mistake Correct Practice
Attendance not entered. Record attendance daily or monthly.
Wrong Attendance Type. Select the correct attendance category.
Duplicate Attendance Voucher. Check existing records before saving.
Incorrect Leave Entry. Verify approved leave records.
Wrong Overtime Hours. Confirm overtime approval.
Attendance entered for the wrong employee. Verify employee name carefully.
Ignoring Attendance Reports. Review reports before payroll processing.
No attendance backup. Take regular backups before payroll processing.
Accurate attendance records are essential for correct payroll calculations and transparent employee management.
11. Real Business Case Studies

Let's understand how Attendance Management is used in different organizations for accurate payroll processing.

Organization Attendance Usage Purpose
School / College Teachers & Staff Attendance Calculate monthly salaries and leave balances.
Hospital Doctors & Nurses Manage shifts, overtime and attendance.
Manufacturing Company Factory Workers Track attendance, overtime and production shifts.
Retail Store Sales Staff Monitor attendance and incentive eligibility.
IT Company Software Developers Record attendance, work-from-office days and leave.
NGO / Trust Office Employees Maintain attendance and payroll records.
Accurate attendance records improve payroll accuracy and employee transparency.
12. Complete Attendance Management Checklist
Checklist Status
Payroll Enabled โœ”
Attendance Units Created โœ”
Attendance Types Created โœ”
Employee Masters Created โœ”
Attendance Recorded โœ”
Leave Updated โœ”
Overtime Recorded โœ”
Attendance Voucher Saved โœ”
Attendance Reports Verified โœ”
Payroll Processed โœ”
Payslips Generated โœ”
Data Backup Taken โœ”
Follow this checklist before every payroll cycle to ensure complete and accurate attendance records.
13. Professional Attendance Management Tips
  • Record attendance daily instead of waiting until month-end.
  • Verify attendance before processing payroll.
  • Approve leave requests before recording them.
  • Record overtime only after management approval.
  • Avoid duplicate attendance entries.
  • Review Attendance Reports every month.
  • Maintain proper attendance registers.
  • Update employee leave balances regularly.
  • Maintain attendance records securely for audit purposes.
  • Take regular backups before payroll processing.
Professional attendance management reduces payroll disputes and improves workforce management.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Create Attendance Units (Days).
  2. Create Attendance Types (Present, Absent, Paid Leave, Sick Leave).
  3. Create Employee Masters.
  4. Record Attendance Voucher for one month.
  5. Record Overtime for one employee.
  6. Verify Attendance Register.
  7. Process Payroll.
  8. Generate Payslip.

Interview Questions
  1. What is Attendance Management in Tally Prime?
  2. Why is attendance important in payroll?
  3. How do you create an Attendance Type?
  4. What are Attendance Units?
  5. How do you record an Attendance Voucher?
  6. What is the purpose of Paid Leave?
  7. How does overtime affect payroll?
  8. How are attendance records verified?
  9. Which reports are available for attendance?
  10. What is the Attendance Register?
  11. How is attendance linked with payroll?
  12. What is the difference between Paid Leave and Absent?
  13. How do you correct an attendance mistake?
  14. What happens if attendance is not recorded?
  15. Why should duplicate attendance entries be avoided?
  16. How often should attendance be updated?
  17. What precautions should be taken before payroll processing?
  18. How does Tally Prime simplify attendance management?
  19. Why should attendance data be backed up?
  20. Why is attendance management important for HR professionals?
15. Lesson Summary
  • Learned the concept of Attendance Management.
  • Created Attendance Types and Units.
  • Recorded Attendance Vouchers.
  • Managed Leave and Overtime.
  • Verified Attendance Reports.
  • Integrated attendance with Payroll.
  • Studied real business examples.
  • Completed practical exercises.
  • Prepared for payroll interviews.
  • Built a strong foundation in attendance management.
Congratulations! You can now confidently manage Attendance in Tally Prime, record attendance and leave, calculate overtime, generate attendance reports and process payroll accurately.

๐Ÿง  Quick Quiz

Which voucher is used to record employee attendance in Tally Prime?