HR Management System with Loans & EMI – Google Apps Script

The whole HR department in one Google Sheets web app: attendance that proves where the employee actually stood, payroll built from that attendance, leave and loan requests that route to an approver, and a dashboard reading the lot.

Attendance you can defend

Marking attendance captures GPS location, so a remote or field employee is recorded where they were, not where they say they were. Alongside it, device fingerprinting ties a mark to the phone that made it and IP checks flag the pattern where one device marks several people. Buddy punching is the oldest problem in attendance software; these three signals together are what closes it.

Payroll that comes out of the attendance

Salaries are calculated from the attendance already recorded rather than from a separate sheet somebody maintains by hand, which removes the gap where payroll disputes are born. Employee records, salary structure and payment history sit together in the same system.

Leave and loans with an approval trail

Employees apply for leave in the app and the request goes to an approver instead of a WhatsApp message that gets lost. Loan applications carry an EMI calculator, so the instalment and schedule are worked out before the loan is granted, and the deductions are visible afterwards.

Everyone in one place

A WhatsApp-style messaging screen keeps internal conversation inside the system, and the analytics dashboard draws attendance, payroll and leave into Google Charts — present today, absent, on leave, salary cost, trend over time. It deploys as a web app, so staff open it on a phone and HR opens the same link on a laptop.