How to make a salary sheet and registr book in excel

 Creating a Salary Sheet and a Registry Book in Excel can help you track employee payments, attendance, and details efficiently. Below is a guide to help you set up both.

---

🧾 1. Salary Sheet in Excel

✅ Step-by-Step to Create a Basic Salary Sheet

A. Design the Layout

In an Excel worksheet, set up your headers like this:

A	B	C	D	E	F	G	H	I
Employee ID	Name	Designation	Basic Salary	HRA	Allowances	Deductions	Net Salary	Remarks

You can also add:

• Overtime

• Bonus

• Provident Fund (PF)

• Taxes

---

B. Add Formulas

Let’s assume:

• Basic Salary = ₹30,000 (column D)

• HRA = 20% of Basic

• Allowances = Fixed

• Deductions = PF, Tax, etc.

• Net Salary = (Basic + HRA + Allowances) - Deductions

In Column E (HRA):

excel
=0.2*D2

In Column H (Net Salary):

excel
=D2+E2+F2-G2

Apply this to all rows with data.

---

C. Format the Sheet

• Use cell borders for clarity.

• Use Currency format for salary columns.

• Use Freeze Panes to lock headers.

---

📘 2. Registry Book in Excel

A registry book is usually a record of attendance, entries/exits, or logbook data.

✅ Sample Layout for Employee Attendance Registry

A	B	C	D	E	F
Date	Emp ID	Name	In Time	Out Time	Remarks

Optional Columns:

• Department

• Late/Absent

• Total Hours Worked

---

Formulas for Time Worked

In Column G (Hours Worked):

excel
=TEXT(E2-D2, "hh:mm")

Make sure columns D and E are formatted as Time.

---

📁 Tips for Organization

• Use separate sheets: One for salary, one for registry.

• Add a summary sheet with totals, averages, and filters.

• Protect sheets to avoid accidental changes (Review > Protect Sheet).

• Use Excel Tables for easy filtering and formatting (Ctrl + T).