March 2025 — Attendance Summary
152 employees · Payroll period: 01 Mar – 31 Mar · Working days: 26 · Cut-off: 28 Mar
Attendance Module
Auto-sync
→
Leave Module
Approved leaves
→
LOP Engine
Compute deductions
→
Override / Review
HR corrections
→
Lock & Confirm
Feed to payroll
→
Payroll Run
Net computation
Present Days (avg)
23.4
of 26 working days
↑ 0.8 vs Feb
LOP Days (total)
47
Across 18 employees
↑ 12 vs Feb
Late Marks
89
24 employees affected
↑ 21 vs Feb
Half Days
34
= 17 LOP days equiv.
↓ 4 vs Feb
OT Hours
312
38 employees · ₹1.84L
↑ 48h vs Feb
⚠ Exceptions Requiring Attention
Must resolve before payroll lock
🔴
Attendance not confirmed for 6 employees
Engineering dept · Biometric data missing for 01–05 Mar
🔴
2 employees: negative present days
Data sync error — attendance > working days
🟡
14 pending leave approvals affecting payroll
Leave in process — treated as LOP until approved
🟡
LOP cap exceeded — 3 employees
Net salary would go negative · Recovery needed
🟢
Ready
OT hours approved — 38 employees
All overtime claims verified and ready
Leave Type Breakdown — Mar 2025
All leave categories and their payroll impact
| Leave Type | Days | Employees | LOP? | LOP Days |
|---|---|---|---|---|
| ELEarned Leave | 68 | 31 | No LOP | — |
| SLSick Leave | 29 | 18 | No LOP | — |
| CLCasual Leave | 41 | 26 | No LOP | — |
| LWPLeave Without Pay | 23 | 11 | LOP | 23 |
| EX-CLExcess Casual | 8 | 5 | LOP | 8 |
| ABUninformed Absent | 16 | 9 | LOP | 16 |
Total LOP days
47 days
Employee Attendance Summary — Top Issues
Sorted by exceptions · Click row for full detail
| Employee | Working Days | Present | Approved Leave | LOP Days | Half Days | Late Marks | OT Hours | Attendance % | Status | |
|---|---|---|---|---|---|---|---|---|---|---|
AP Ananya Patil Engineering · EMP-1041 |
26 | 19 | 3 | 4 | 2 | 5 | 0 | 73% |
LOP | |
RK Rohan Kulkarni Sales · EMP-0872 |
26 | 15 | 5 | 6 | 0 | 2 | 0 | 58% |
LOP + Exc. | |
SM Sneha Mehta Product · EMP-1102 |
26 | 24 | 2 | 0 | 1 | 1 | 8 | 96% |
Clean | |
VN Vikram Nair Finance · EMP-0694 |
26 | 26 | 0 | 0 | 0 | 0 | 12 | 100% |
Clean | |
PS Priya Shah HR · EMP-1008 |
26 | 21 | 4 | 1 | 3 | 0 | 2 | 88% |
Review |
Showing 5 of 152 employees · 18 with LOP · 6 exceptions
Employee Attendance Detail
Full per-employee breakdown · Override individual days · Review leave impact on salary
March 2025 — Day-by-Day View
Click any day to override attendance status
■ Present
■ Absent/LOP
■ Half Day
■ Approved Leave
■ Holiday
■ Late
SUN
MON
TUE
WED
THU
FRI
SAT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Override — 13 Mar
Leave & Absence Log
| Date / Period | Type | Days | Status | LOP Impact | Approved By | |
|---|---|---|---|---|---|---|
| 06–07 Mar | Earned Leave | 2.0 | Approved | — | Priya Shah · 04 Mar | |
| 13 Mar | Absent (LOP) | 1.0 | LOP Applied | −1 day | Auto · System | |
| 14 Mar | Absent (LOP) | 1.0 | LOP Applied | −1 day | Auto · System | |
| 19 Mar | Half Day (AM) | 0.5 | 0.5 LOP | −0.5 day | Self · ESS | |
| 21 Mar | Absent (LOP) | 1.0 | LOP Applied | −1 day | Auto · System | |
| 22 Mar | Sick Leave | 1.0 | Approved | — | Manager · 21 Mar | |
| Total LOP Days | 3.5 days | |||||
Salary Impact
LOP Computation
Monthly ÷ 30 × LOP days
₹88,333 ÷ 30 × 3.5 = −₹10,306
Monthly Gross₹88,333
LOP Deduction−₹10,306
Late Mark Deduction−₹833
Payable Gross₹77,194
Leave Balance
Earned Leave
8.0
Used 2 this period
Casual Leave
0
Exhausted
Sick Leave
2.5
Used 1 this period
Comp-Off
1.0
Available
Late Mark Policy
Late marks this month: 5
Late marks before LOP: 3 (threshold)
Excess late marks: 2
2 excess × 0.5 day = 1 day LOP
Policy: every 3 late marks = 1 LOP day. Partial: every 2 excess late marks = 0.5 LOP day
LOP Rules Engine
Configure which absence types trigger loss-of-pay, computation methods, late mark thresholds and recovery rules
ℹ LOP Rules, late mark thresholds, proration formula, and recovery caps are now managed centrally in Configuration → Attendance & Leave Connect. Changes there apply company-wide across all payroll runs.
ℹ LOP rules are company-wide. Proration method (calendar days / working days / fixed 30 / 26) is set per salary structure. The formula used here is: Monthly Salary ÷ Proration Divisor × LOP Days.
Leave Type → LOP Mapping
Define which leave categories trigger LOP deduction
EL
Earned Leave
No LOP
Triggers LOP?
Earned Leave does not trigger LOP. Salary is paid for approved EL days. Balance accrual: 1.25 days/month.
SL
Sick Leave
No LOP
Triggers LOP?
Sick Leave does not trigger LOP within balance limit. Excess sick leave converts to LOP.
Annual Balance
Excess converts to
Medical certificate required after
LWP
Leave Without Pay
Full LOP
Triggers LOP?
LOP Rate
Min Days (trigger)
Max per month
AB
Uninformed Absence
Full LOP
Triggers LOP?
LOP Rate
Escalate after (days)
Show on payslip as
HD
Half Day
0.5 LOP
Triggers LOP?
LOP Units
First half / Second half
Max half days / month
Late Mark Rules
Configure when late arrivals convert to LOP
Enable Late Mark LOP
Convert excess late marks to LOP deduction
Arrivals within grace not counted as late
No LOP for first N late marks
⚠ Payroll admin can override individual late-mark-to-LOP conversions from the Override screen before payroll lock.
LOP Computation — Per Pay Item Override
Some components may not be pro-rated on LOP
By default, all components inherit the proration method from the Salary Structure. Override below for specific pay items that should NOT be deducted on LOP days.
| Pay Item | Default | LOP Override | Reason |
|---|---|---|---|
| Leave Travel Allowance | Pro-rated | Annual disbursement — not daily wage | |
| Meal Coupon | Pro-rated | Benefit — unrelated to attendance | |
| Basic Salary | Pro-rated | Core wage — always pro-rated | |
| HRA | Pro-rated | Linked to basic — always pro-rated |
LOP Simulator
Computed LOP deduction
₹88,333 ÷ 31 × 3.5 = ₹9,974
Payable Gross: ₹78,359
Recovery Rules
When deductions exceed gross
Cap max recovery per month
Never deduct more than X% of gross
% of gross
Carry forward excess LOP recovery
If cap reached, recover balance next month
Zero net salary handling
Never disburse a negative salary
Overrides & Corrections
Manual attendance adjustments · Full audit trail · All changes require reason
Override & Correction Log — March 2025
| Employee | Date | Override | Before | After | Payroll Impact | Reason | Done By | Timestamp |
|---|---|---|---|---|---|---|---|---|
RK Rohan Kulkarni |
08 Mar | Absent → Present | LOP 1 day | Present · Full pay | +₹3,013 | Client visit · Manager confirmed | Priya Shah | 22 Mar · 14:32 |
AP Ananya Patil |
14 Mar | LOP → EL | LOP 1 day | Earned Leave | +₹2,944 | Leave application submitted late · EL balance available | Priya Shah | 24 Mar · 10:15 |
MG Mohan Gupta |
02 Mar | Late excused | Late mark | On time | No impact | Traffic disruption · Metro breakdown | Auto · Policy | 03 Mar · 09:00 |
Overtime & Holiday Pay
OT hours from attendance · Holiday work pay · Comp-off vs cash config · Payout in payroll
ℹ OT pay rules (rates, eligibility, comp-off vs cash) and Holiday pay rules are now managed centrally in Configuration → Attendance & Leave Connect.
OT Pay Configuration
Applied to employees marked eligible for overtime in their salary structure
OT counted only after this many hours
Hours beyond cap not paid
OT Log — March 2025
38 employees · 312 hours · ₹1,84,320 payable
Employee
OT Hours
OT Type
Daily Rate
OT Amount
Payout Mode
Status
Vikram Nair
Finance
12.0 hrs
Weekday
₹2,160
₹3,240
Cash
Approved
Sneha Mehta
Product
8.0 hrs
Holiday
₹3,397
₹6,794
Comp-Off
Approved
Kiran Joshi
Engineering
16.0 hrs
Weekend
₹2,885
₹5,770
Cash
Pending
Showing 3 of 38 · 312 total OT hours
Total: ₹1,84,320
Holiday Pay Rules
If employee works on a holiday
Pay extra (in addition to salary)
Or offer comp-off instead
Holidays this month
15 Mar — HoliNational
25 Mar — Gudi PadwaOptional
Comp-Off Tracking
Comp-offs earned this month will be credited to the Leave module
Comp-offs issued8 employees
Total days credited11.5 days
Comp-offs are credited to Leave module after payroll finalization. Not paid in cash.
Sync Configuration
How attendance & leave data flows from source modules into payroll each period
ℹ Attendance data source, sync schedule, cut-off timing, and validation rules are configured in Configuration → Attendance & Leave Connect. The sync history log and manual pull controls remain here.
Data Source
Where payroll pulls attendance data from
Attendance Source
Leave Source
⚠ Only approved leaves are considered for payroll. Pending / rejected leaves are treated as absent (LOP) until approved.
Sync Trigger & Schedule
After all check-ins are captured
Final sync happens on this date
Any changes after this → override required
Block payroll run if cut-off sync not done
Prevent payroll from running on stale data
Alert admin if sync fails
Alert if > 5% of employees have missing attendance
Data Validation Rules
Applied after each sync — errors block payroll run
Block if any employee has 0 attendance records
Completely missing data — must be resolved before lock
Warn if present days > working days in period
Data sync error — e.g. duplicate records
Block if employee has pending leave affecting payroll
Unapproved leave treated as LOP — flag for decision
Warn if absent > 10 days without leave record
High absence — escalate for HR review
Auto-flag new joiners with no attendance (DOJ > 15th)
Sync History
Sync completed · 152 employees
Auto · 28 Mar 23:59 · 0 errors
Cut-off sync
Sync completed · 152 employees
Auto · 27 Mar 23:30 · 0 errors
Sync warning · 6 employees missing data
Auto · 25 Mar 23:30 · 6 warnings
Manual pull by Priya Shah
Manual · 24 Mar 11:15
Sync completed · 152 employees
Auto · 24 Mar 23:30
Lock & Confirm Attendance for Payroll
Once locked, attendance data is frozen — any changes require supplementary payroll. All exceptions must be resolved first.
Pre-Lock Checklist
All critical items must pass before lock is permitted
✅
Pass
Attendance data synced for all 152 employees
Cut-off sync completed 28 Mar 23:59
❌
6 employees with missing attendance records
Biometric data gap: 01–05 Mar · Engineering dept
❌
2 employees: present days > working days
Data error — must correct before lock
⚠️
14 leave applications still pending approval
These will be processed as LOP unless approved before lock
⚠️
3 employees: LOP deduction > 50% net salary
Net pay would be very low — review recovery policy
✅
Pass
All OT claims reviewed and approved
38 employees · 312 hours · ₹1,84,320
✅
Pass
No negative net salary employees
LOP cap enforcement active
Lock Summary — What Gets Frozen
Total Employees
152
Total LOP Days
47
Total LOP Value
₹2.1L
OT Payable
₹1.84L
Manual Overrides
3
Ready for Payroll
148 / 152
⚠ 2 critical errors must be resolved before locking. Once locked, attendance data cannot be changed — any correction requires a supplementary payroll run in the following month.
Audit Trail
Cut-off sync complete · 152 employees
System · 28 Mar 23:59
3 attendance overrides applied
Priya Shah · 24–26 Mar
OT approved: 38 employees · 312 hours
Priya Shah · 27 Mar
14 leaves still pending
System warning · 28 Mar
Lock attempted — blocked: 2 critical errors
Priya Shah · 29 Mar 10:00