I will build an automated payroll and attendance tracker in excel
Excel Attendance and Leave Tracker, HR Admin, Virtual Assistant
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
FAQ
Can you use my own attendance format?
Yes. Send me your format or a sample sheet, and I will build the tracker in the same style, with the same columns and layout you already use.
Can you use my biometric export?
Yes, send your ZKTeco or CSV export and I will import the data from it (Standard and Premium).
What if my staff list changes mid-year?
Adding new staff is easy — the formulas update themselves. I show you how in the video guide.
Will formulas survive if I add employees?
Yes, the formulas are protected. You only add the name and punches, and the totals build themselves.
What do you need from me?
Your staff list with names and salaries, and your biometric export if you have one. If anything is missing, I will ask before I start.

