Staff Attendance & Salary Register – Excel with Mahendra Singh Deora

Simple payroll for shops, offices, workshops and small factories. Add your staff once (monthly salary or daily wage), mark attendance on a colourful monthly grid with P / A / H / L codes, and Sundays and holidays are shaded and counted as paid automatically. Paid days, earned salary, PF, ESI, professional tax, salary advances and net pay are calculated for you. Pick an employee from the dropdown to print a clean salary slip with amount in words, and see the month on a Payroll Summary dashboard: gross, deductions, net payable, pending salaries, attendance %, department-wise chart and employer cost. Works in Excel and Google Sheets. No macros.

Staff ki hazri aur salary ka jhanjhat khatam! Employees ki list ek baar banao, roz P (present), A (absent), H (half day), L (leave) lagao. Sunday aur chhutti apne aap shade hoti hai aur paid maani jaati hai. Paid days, salary, PF, ESI, advance ki katauti aur net salary sab apne aap calculate hoga. Dropdown se employee chuno aur salary slip print/PDF karke WhatsApp kar do. Mahine ka poora payroll summary ek dashboard par.