🔒 Attendance is LOCKED — editing is disabled. Go to the Salary tab to unlock.
Editable: rate, basic, allowances · Yellow = deductions (Rs.)
ƒ Gross Salary:
OFFICE
W.Days × Attendance + Basic + Incentives
(Att×Days shown separately)
|
SR / MR
Basic + Incentives
|
CC / DR / PORTER
W.Days × Daily Wages + Store Wages + Incentives
ƒ EPF Basic:
Rate of Pay + B.Allow
+ 2005 (Rs.1,000)
+ 2015 (Rs.1,000)
+ 2016 (Rs.1,500)
+ 2025 (Rs.6,000)
ƒ Net Salary:
G.Salary
−
Advance − Shorts − IOU − EPF 8% − Other
| # |
Dept |
NIC |
Name |
AC No |
Bank Code |
EPF No |
W.Days |
Rate of Pay |
B.Allow |
EPF Basic |
Basic |
Store Wages |
Daily Wages |
Incentives |
G.Salary ⓘ |
Advance (Rs) |
Shorts (Rs) |
IOU (Rs) |
EPF 8% |
Other (Rs) |
Net Salary ⓘ |
|
🔒 Attendance is LOCKED — editing is disabled. Go to the Salary tab to unlock.
🍩 Coca-Cola
Yellow = deductions · Green = auto-calc · Monthly fields: CAS / Porter Sal / Inc2
ƒ Gross Salary:
SR
Basic + FuelEx + AttAllow + Incentives (CAS×10) + BikeAllow + PorterSal + Inc2
|
CC / PORTER
D.Wages × W.Days + FuelEx + AttAllow + PorterSal
|
OFFICE
Basic only
ƒ Auto fields:
FuelEx = 10,000 ÷ 24 × W.Days · AttAllow = 2,400 ÷ 24 × W.Days · Incentives = CAS × 10
ƒ Net Salary:
G.Salary
−
EPF 8% − Shorts − IOU
| # |
Dept |
NIC |
Name |
AC No |
W.Days |
CAS |
D.Wages |
Rate of Pay |
B.Allow |
EPF Basic |
Basic |
Fuel Ex |
Att Allow |
Incentives |
Bike Allow |
Porter Sal |
Inc2 |
G.Salary |
EPF 8% |
Short (Rs) |
IOU (Rs) |
Total Ded |
Net Salary |
|