You want to work out your employees' salaries at month-end accurately, without adding up absences, overtime and advances for each one on a calculator. You want a printed statement each employee can sign, and you want to know how much you will pay this month before you pay it. The free employee payroll and attendance sheet does that: you record what happened in the month and it works out each employee's net pay. The template and its page are in Arabic.
The problem it solves
Payroll is easy for one person and gets tangled with ten: two days absent here, three hours of overtime there, an advance taken early in the month, scattered lateness, a bonus, someone who left. One wrong number means an argument with an employee or a loss for the business. Then you start again next month, and sometimes you need to review an old one.
How the sheet solves it, step by step
- In Employees you write each person's basic pay and allowances, and the sheet works out the daily and hourly rate.
- In Attendance you record exceptions only: one row per absent day, and one row for overtime or late hours.
- In Advances and deductions you record every advance, deduction or bonus with its date.
- In Settings you choose the year and month, and the calculation takes only the records dated inside that month.
- Payroll gathers it all into one row per active employee with the net pay and a signature column.
- Summary shows the month's cost, total deductions and the amount to pay.
A walkthrough with the sample data
The names and figures below come from the sample inside the sheet, not from real people. The chosen month is October 2026, with 30 days for the calculation:
- Mohamed Ali (accountant): basic 9,000 plus allowances 1,500, so a daily rate of 350 and an hourly rate of 43.75. One day absent (deduction 350) and 5 overtime hours at 1.5 (worth 328.13). Net pay 10,478.13.
- Karim Adel (technician): two days absent (deduction 533.33) and a 300 deduction, so net 7,166.67 from entitlements of 8,000.
- Amr Hosny (driver): 6.5 overtime hours (195) and a 500 advance, so net 4,495.
- Nadia Fathy (sales): a paid leave day that is not deducted, two overtime hours and a 400 bonus.
The statement covers 7 active employees: total entitlements 46,791.88, total deductions 3,805.83, and net payroll to pay 42,986.05. The sample also has a "stopped" employee who does not appear in the statement, an absence and an advance dated September that are left out of October, and two records with an unknown code that the summary flags.
Features and why they matter
- You choose the month, so any month can be recalculated without copying the file.
- Paid leave is recorded but not deducted, so the attendance log stays complete.
- An unknown-code warning stops an advance from vanishing because of a typo.
- A printable statement with a signature column and totals at the top.
- A cost summary separating entitlements from deductions.
- Works in Excel 2016 and later, Google Sheets and LibreOffice; free, no sign-up. It holds 200 employees, 2,000 attendance records and 1,000 advance records.
Using the online version
The template page opens directly on this example. Type in the white cells on the page and the grey ones update immediately, and add an absence or advance with a form instead of typing into the grid. You can import your own .xlsx made from this template, export to .xlsx, or download the original Excel file. Your data stays in your browser and is not sent to the server. Open the template page or the template list.
Who it suits
A small or medium business (an office, workshop, shop or service company) with up to a few dozen employees on fixed monthly pay. If your workers are paid per piece see the piece-rate payroll sheet, and to follow the business's spending the business expenses sheet may help.
Common mistakes, and when a sheet stops being enough
Typical mistakes: a wrong employee code (a red warning appears), an advance dated in a different month from the one you want it deducted in, recording the same absence twice, and forgetting to mark a leaver as stopped. The sheet also does not calculate insurance or tax, so add them as a "deduction" record if you need them. It does not import fingerprint-clock data either, so you copy the exceptions in by hand, and one person edits at a time. If you need a link to the attendance device and permissions per manager, Softwiro can build a program around your process. To weigh ready-made options first, read how to compare business software.
FAQ
How is net pay calculated? Basic plus allowances, overtime and bonuses, minus absence, lateness, advances and deductions.
How do I calculate another month? Change the year and month in Settings.
What about someone who left? Set their status to stopped.