Connect the Google Sheet your biometric/attendance system already writes to, and this becomes a live payroll engine — no re-typing attendance, no month-end scramble, no separate register for every form. Free for establishments up to 10 employees.
No more re-typing attendance into payroll
Know today's salary liability, not just month-end
One master feeds every register — zero duplicate entry
Free tier — 0 / 10 employees used
All core calculations included. Upgrade for unlimited employees, live multi-sheet sync and multi-state support.
Paste each into its own Google Sheet (File → Import → Replace current sheet), keep the header row, then share it as "Anyone with the link – Viewer". Paste the 3 links in Section 3 and everything below fills itself in — including the Attendance sheet your biometric/manual marking system already writes to, if it can export to this same column layout.
📇 Employee Master
Fill in once, edit in place. IDs, Date of Joining, Designation, Category and State. Leave Category blank and we suggest one from the Designation, with that category's minimum wage, for you to confirm.
💰 Salary Structure
Fill in once, update when pay changes. Basic+DA, HRA, Other Allowances, and any fixed monthly advance recovery.
🗓️ Daily Attendance
The only sheet that changes every month. One row per employee per day, with Status (P/A/HD/OF/H/leave) and OT hours. An auto-marking system can append to it daily.
📆 Month tabs
The two sheets the portal itself files — Attendance_YYYY-MM (muster roll, day marks and all) and Payroll_YYYY-MM. Same columns going in as coming out, so an upload and a read-back are the same sheet.
One workbook, a tab per template, with a Read me tab. Every header here is a header the portal reads back by name — a column gets appended, never renamed.
2. Establishment & State
Pick the state where your employees work. Every salary below is checked against that state's minimum wage, and payroll will not run while anyone is paid less.
Rates come from the portal's state-wise minimum wage table, the same one shown on Live Rates. Minimum wages are usually revised every April and October. Check the latest notification if the date above looks old. A Salary Structure sheet with a State column can set a different state for an individual employee.
3. Connect Your Google Sheets
Paste the shareable link (or just the Sheet ID) for each template above. Sync pulls Employee Master + Salary Structure into Section 4 below, and Attendance into a live day-by-day feed — so nobody has to type the same headcount into three places.
Attendance re-checks itself every 5 minutes while this page stays open, so the Live Snapshot in Section 5 tracks today's marking automatically.
4. Employee Salary Structure
Filled in when you sync Sections 1–3 above; add or correct anyone by hand here. A red row is paid below the minimum wage, or is missing a skill category. Fix it here (change the category, or press Raise to minimum) and the row turns green.
Emp ID
Name
Category
Basic+DA
HRA
Other
Total CTC
Remarks
No employees yet — add your first one above, or sync a Google Sheet in Section 3.
5. Monthly Attendance & Run Payroll
Auto-filled from your synced Attendance Sheet for the selected month; edit any cell by hand if needed. Overtime wages are twice the ordinary rate (s.14, Code on Wages) — always, and that is not a setting.
Live Payroll Snapshot ● Live
Emp ID
Name
Paid Days incl. weekly offs, holidays, paid leave
LOP Days taken off paid days
OT Hours
6. Dashboard —
Totals for the run above, compared against the previous month you processed here.
Emp ID
Name
Days
Gross
EPF (Emp)
ESI (Emp)
PT
LWF
TDS
Advance
Net Pay
Every employee in this run was checked against the minimum wage for the state shown in step 2 before it ran. PT is charged only where the state levies it, capped at that state's monthly figure; the slab inside that cap is generic, so check it against your state's schedule. LWF is charged only in states that have it, in June and December (December only where it is yearly), at the state's employee and employer rates. TDS is a new-regime estimate (FY 2025-26 slabs, no surcharge); use the TDS Salary Calculator for an exact old-vs-new regime figure per employee. "Export Full Register Package" also produces the Leave with Wages, Overtime and Advance registers straight from this same run — no re-entry.
7. Your Workbook — One File, A Tab Per Month
Payroll data is sensitive — we don't want to hold it either. Every run files itself as its own tab
(Payroll_2026-06) in one Google Sheet in your own Drive, with the month's attendance beside it. Next month adds
tabs; it never overwrites this one. Closing a month locks it, so a filed wage register cannot be quietly restated — and any
past month reads straight back for a wage slip, the annual return or an inspector who names a month.