I will build an automated payroll and attendance tracker in excel

Pakistan

I speak Punjabi, English, Urdu

Excel Attendance and Leave Tracker, HR Admin, Virtual Assistant

Hi, I'm Muzamil, from Faisalabad, Pakistan. I work in HR and Administration at State Life Health & Accidental Insurance, where I manage attendance and leave records for around 800 to 1,000 staff acros...
About this Gig

HR teams waste hours every month counting attendance by hand and one mistake in late, leave or salary math costs real money.


I will build you an Excel tracker that joins your attendance, leave and payroll in one place. You send your biometric export or staff list, and the formulas do the rest late, half leave, casual, medical and monthly totals, all counted automatically.


I work in HR & Administration myself, so this tracker is built for real office work, not just a sheet.


What you will get:

- Monthly attendance sheet P, A, L, Leave, Total, all automatic

- Leave card casual, medical, earned and LWOP balances

- Salary-ready monthly summary ready for payroll

- Biometric export (ZKTeco/CSV) import Standard and Premium

- Video guide how to use your tracker, step by step


Message me before ordering tell me your staff count and your biometric system, so I can point you to the right package.


Every tracker comes with a monthly summary dashboard and a printable payslip per employee. Google Sheets version on request; I can add your logo and colours. Please message me before ordering. Free support for 15 days after delivery.

Type:

Convert data

•

Insert data

•

Formatting

Tool:

Excel

•

Google Sheets

My Portfolio