Free Excel Salary Sheet & Employee Attendance Template
Looking for a free Excel salary sheet and employee attendance template? This ready-to-use Excel template helps you manage employee attendance, working days, salary calculations, deductions, overtime, and net pay in one organized spreadsheet. Download and customize it for your business, office, or team.
Managing employee salaries and attendance can become difficult when everythings is written down manually. A simple Excel salary sheet and employee attendance sheet can make the work much easier.
Microsoft Excel is widely used for payroll, attendance records, employee data, working hours, and monthly reports. with a few usefull farmulas, you can automate many calculations instead of doing them by hand.
In this guide, you will learn how to use an Excel salary sheet and an employee attendance tracker. You can also download the ready-made templates and edit them for your own office, business, or staff.
Download Excel Salary Sheet and Attendance Sheet
If you already needs the templates, you can download them first and then read the guide below.
Free Excel Salary Sheet
DownloadFree Employee Attendance Sheet
DownloadPart 1: Excel Salary Sheet
An Excel salary sheet is used to keep employee salary information in one place. It can include basic salary, allowances, overtime, deductions, advances, and final payable salary.
For a small business, this can b much eaiser then maintaining separate handwritten records.
A good salary spreedsheet should b simple enough to every month and clear enough to check when you need previous salary information.
What Should an Excel Salary Sheet Include?
The exact columns depend on your business, but a basic payroll sheet can include:
- Employee ID
- Employee Name
- Department
- Basic salary
- Allowances
- OverTimes
- Bonus
- Deductions
- Advance
- Gross Salary
- Net Salary
You can add or remove columns according to your payroll system.
| Employee ID | Employee Name | Basic Salary | Allowance | Deduction | Net Salary |
|---|---|---|---|---|---|
| EMP-001 | Ali Khan | 50,000 | 5,000 | 2,000 | 53,000 |
| EMP-002 | Ahmed | 45,000 | 4,000 | 1,500 | 47,500 |
| EMP-003 | Usman | 60,000 | 6,000 | 2,500 | 63,500 |
The important thing is that the figures should be calculated by formulas rather than typed manually wherever possible.
How to Calculate Net Salary in Excel
Suppose your salary sheet has:
- Basic Salary in C2
- Allowance in D2
- Overtime in E2
- Deduction in F2
You can calculate the net amount with:
=C2+D2+E2-F2
If you also have an employee advance in G2:
=C2+D2+E2-F2-G2
After entering the formula once, you can drag it down for the remaining employees.
This is one of the simplest ways to turn a normal Excel sheet into a useful payroll spreadsheet.
Gross Salary and Net Salary
It is useful to keep gross salary and net salary separate.
Gross Salary is the total of the applicable earnings before deductions.
For example:
=SUM(C2:E2)
If C2 is Basic Salary, D2 is Allowance, and E2 is Overtime, the formula adds them together.
Then the final salary can b calculated after deductions:
=G2-F2
The exact formula should match the columns in your own salary template.
Salary Sheet With Attendance
Attendence can b connected with payroll when salary depends on working days.
A monthly salary sheet can b include:
- Working Days
- Present Days
- Absent Days
- Paid Leave
- Overtime
- Per Day Salary
- Absence Deduction
- Net Salary
This is particularly useful for businesses that calculate salary according to attendance.
For example, if the monthly salary is in C2 and the number of working days is in D2:
=C2/D2
This gives the approximate salary amount per working day.
You can then use the result to calculate an absence deduction based on your company's rules.
Important: Salary deductions, tax, overtime, leave, and other payroll rules can vary by country and employment arrangement. The Excel formulas should therefore be adjusted to your actual payroll policy.
Useful Excel Formulas for Salary Calculation
You do not need complicated formulas to build a Useful salary sheet.
SUM
Use SUM to calculate totals.
=SUM(C2:C20)
AVERAGE
To find the average salary:
=AVERAGE(C2:C20)
COUNTA
To count employees whose names have been entered:
=COUNTA(B2:B20)
COUNTIF
COUNTIF becomes especially useful when working with attendance.
For example:
=COUNTIF(B2:AF2,"P")
This counts the days marked as Present.
These formulas are useful for both Excel for beginners and users who are moving toward advanced Excel.
Make Your Salary Sheet Easier to Use
A salary spreadsheet does not need to look complicated.
Use clear headings and keep related information together.
You can also use:
- Excel Tables
- Filters
- Freeze Panes
- Number formatting
- Data Validation
- Conditional Formatting
- Automatic totals
For a larger payroll file, a separate summary sheet can show total salaries, deductions, allowances, and employee counts.
Monthly Salary Report in Excel
A monthly salary report gives you a quick view of payroll for a particular month.
For example, you can keep:
- Total Employees
- Total Basic Salary
- Total Allowances
- Total Overtime
- Total Deductions
- Total Net Salary
If these values are linked to your main salary table, the summary can update when employee information changes.
This makes Excel useful for small offices and businesses that do not need a complicated payroll system.
Free Excel Salary Template
Creating a salary sheet from scratch can take time, especially if you are new to Excel.
A ready-made Excel salary template gives you a starting point. You can replace the sample employee information with your own data and change the formulas or headings when required.
The template can also be used as a practical Excel project for anyone learning Microsoft Excel.
Part 2: Employee Attendance Sheet in Excel
Keeping attendance records is another common use of Microsoft Excel.
An employee attendance sheet lets you record who was present, absent, on leave, or late during the month.
Instead of checking a paper register at the end of the month, you can use formulas to calculate attendance totals automatically.
What Is an Employee Attendance Sheet?
An employee attendance spreadsheet normally contains:
- Employee ID
- Employee Name
- Department
- Date
- Attendance Status
- Present Days
- Absent Days
- Leave Days
- Late Days
- Attendance Percentage
You can keep the sheet simple if your only requirement is daily attendance.
If you also need working hours, you can add check-in and check-out times.
Monthly Attendance Sheet in Excel
A monthly attendance sheet is one of the easiest formats to use.
Employee names are placed in rows, while the days of the month are placed in columns.
| Employee | 1 | 2 | 3 | 4 | 5 | Present | Absent |
|---|---|---|---|---|---|---|---|
| Ali | P | P | A | P | P | 4 | 1 |
| Ahmed | P | L | P | P | A | 3 | 1 |
| Usman | P | P | P | P | P | 5 | 0 |
You can use simple codes:
P = Present
A = Absent
L = Leave
If your company uses more attendance statuses, you can also add codes for Late, Half Day, Holiday, or Work From Home.
The main thing is to use the same codes throughout the sheet so the formulas can count them correctly.
How to Count Present Days in Excel
Suppose the daily attendance records are in cells B2:AF2.
To count Present days, use:
=COUNTIF(B2:AF2,"P")
For Absent days:
=COUNTIF(B2:AF2,"A")
For Leave days:
=COUNTIF(B2:AF2,"L")
This is much easier than counting the entries manually at the end of every month.
COUNTIF is one of the most useful formulas for an Excel attendance sheet with Formulas.
Calculate Attendance Percentage
Attendance percentage can be calculated from the number of days an employee was present.
For example, if Present Days are in AG2 and Total Working Days are in AJ2:
=AG2/AJ2
Then format the cell as a percentage.
For example:
24 Present Days ÷ 26 Working Days = 92.31%
This gives you a quick way to check an employee's attendance record for the month.
Employee Attendance Tracker With Late and Overtime
A more detailed employee attendance tracker can also record working hours.
Useful columns include:
- Date
- Employee Name
- Check In
- Check Out
- Break
- Total Hours
- Late
- Overtime
- Attendance Status
This format is useful for employees who work shifts or whose pay depends partly on working hours.
Conditional Formatting for Attendance
A large attendance sheet can become difficult to read when it contains hundreds of cells.
Conditional Formatting can help.
You can use it to highlight:
- Present
- Absent
- Leave
- Late
- Low attendance
This lets you spot important records quickly without checking every cell individually.
You can also use a drop-down list through Data Validation so employee attendance status is selected instead of typed manually.
That helps keep the data consistent and prevents small typing mistakes.
Employee Attendance Register for Office Staff
A basic staff attendance register can contain:
| Employee ID | Employee Name | Department | Present | Absent | Leave | Late | Attendance % |
|---|---|---|---|---|---|---|---|
| EMP-001 | Ali | Accounts | 24 | 1 | 1 | 2 | 92.31% |
| EMP-002 | Ahmed | HR | 25 | 1 | 0 | 1 | 96.15% |
| EMP-003 | Usman | Sales | 23 | 2 | 1 | 3 | 88.46% |
You can change the columns according to your office requirements.
For a small team, this simple format may be enough. For a larger company, you may want separate sheets for daily attendance, monthly summaries, leave records, and overtime.
Connect Attendance With Salary
This is where an Attendance sheet becomes even more useful.
At the end of the month, you can use attendance information to help prepare payroll.
For example:
Attendance Sheet → Present Days → Absent Days → Leave → Overtime → Salary Sheet
The attendance data can then be used for salary calculations according to your company's rules.
A combined attendance and payroll workbook can save repeated data entry because the same employee information does not have to be entered again and again.
Free Employee Attendance Sheet in Excel
If you do not want to create the spreadsheet yourself, you can download our ready-made employee attendance sheet.
You can edit employee names, dates, departments, attendance codes, and formulas according to your needs.
The template is useful for offices, small businesses, shops, schools, and other organizations that need a simple attendance record.
Free Employee Attendance Sheet
DownloadUseful Features for Salary and Attendance Sheets
You can make both templates more useful by learning a few Excel features.
Excel Formulas
Start with:
- SUM
- AVERAGE
- COUNT
- COUNTA
- COUNTIF
- SUMIF
- IF
These formulas are enough for many everyday salary and attendance tasks.
Excel Tables
Convert your data into an Excel Table when the list becomes large. Tables make filtering, sorting, and adding new records easier.
Conditional Formatting
Use it to highlight important values automatically.
Data Validation
Use drop-down lists for attendance codes such as P, A, and L.
Filters
Filters help you quickly view employees from a particular department or find specific attendance records.
PivotTables
If you have a large amount of employee data, PivotTables can help summarize information by department, month, or employee.
Excel Online and Google Sheets
You do not always need to work on a desktop computer.
Compatible Excel files can also be opened and edited with Excel Online, while many spreadsheet templates can be adapted for Google Sheets.
This is useful when you need to access an employee attendance sheet from different devices.
However, formulas, formatting, macros, or advanced features may behave differently between spreadsheet applications, so check the workbook after converting or uploading it.
Excel Salary Sheet and Attendance Sheet for Beginners
If you are just starting to learn Excel, these two projects are a good place to practice.
You can learn how to:
- Enter employee data
- Format an Excel sheet
- Use basic formulas
- Calculate totals
- Count attendance
- Calculate percentages
- Create tables
- Apply filters
- Use conditional formatting
- Prepare monthly reports
Once you understand these basics, you can move on to more advanced Excel projects such as payroll dashboards, PivotTables, charts, automated reports, and data analysis.
You can also explore our Excel invoice templates for creating professional invoices and billing records.
Final Thoughts
An Excel salary sheet can make monthly payroll easier to organize, while an employee attendance sheet can keep daily attendance records clear and easy to check.
The best spreadsheet is not necessarily the one with the most columns or complicated formulas. It is the one that makes your daily work easier.
Start with the basic template, enter your employee information, and adjust the columns according to your requirements.
You can download both Excel templates from the buttons above and customize them for your own work.
You can download both Excel templates from the buttons above and customize them for your own work.
Frequently Asked Questions (FAQs)
1. What is an Excel salary sheet?
An Excel salary sheet is a spreadsheet that helps you calculate and manage employee salaries, including basic pay, allowances, deductions, overtime, and net pay. It automates salary calculations using Excel formulas.
2. What is an employee attendance sheet?
An employee attendance sheet in Excel is a template used to track daily attendance, present, absent, leave, and working hours of employees. It helps in calculating monthly working days accurately.
3. Can I calculate salary automatically in Excel?
Yes, you can automatically calculate salary in Excel using formulas. This Excel salary sheet and attendance template automatically calculates total working days, deductions for absents, and net salary based on attendance.
4. Can this attendance sheet calculate attendance percentage?
Yes, this employee attendance tracker can calculate attendance percentage for each employee. It counts total present days against total working days in a month.
5. Can I customize the Excel salary and attendance template?
Yes, this template is fully customizable. You can add employee names, departments, salary structure, holidays, and company logo as per your business or office needs.
6. Is this Excel salary sheet free to download?
Yes, this Excel salary sheet & employee attendance sheet template is completely free to download. You can download and use it for your small business, office, or team without any cost.
Last Updated: October 5, 2026
0 Comments