PR

Employee MIS

PlanetRead · BookBox

Dashboard

Entity Breakdown

Entity	Total	Active	Inactive	Male	Female

Department-wise

Department	Total	Active

Employees

Emp ID	Entity	Name	Gender	Department	Designation	DOJ	Tenure	Status	Actions

Add Family Member

Family Members

Emp ID	Employee	Family Member	Relation	Age	Contact	Dep	Actions

Payroll

Emp ID	Name	Entity	Basic	HRA	Conveyance	Special	Other Earn	CTC/mo	TDS %	Actions

Add Loan

Active Loans

Employee	Type	Principal	EMI	Paid	Balance	Period	Status	Actions

Loading data from Google Sheets...

Please wait

GS

Connect Google Sheets

One-time setup — stored locally, not in source code

Apps Script Web App URL

Deploy Code.gs → Copy Web App URL → Paste here

Secret Key (must match SECRET_TOKEN in Code.gs)

Change the default in Code.gs before deploying, then enter the same value here

Security note: These credentials are saved in your browser's localStorage — not in the HTML file. Anyone with access to this browser profile can read localStorage. For shared computers, clear browser data when done.

Employee MIS

Dashboard

Entity Breakdown

Department-wise

Employees

Add Employee

Basic Details

Statutory IDs

Contact

Employment

Banking

Add Family Member

Family Members

Payroll

Add Loan

Active Loans