Yawmy guide8 min read

Payslip Template for Egyptian SMEs: Fields and Example

A payslip template for private-sector teams in Egypt: the fields to include, where each number comes from, a copy-ready layout and a worked example.

Nada HassanHR-Tech Strategist, YawmyCanonical link

A payslip template is a one-page layout that shows an employee how their net pay for a given month was built: what they earned in salary, allowances and overtime, what was taken off for social insurance, tax, absence and loans, and what reached their account. A good payslip answers three questions without a phone call to accounts. How much did I earn? What was deducted, and why? How much was I paid? This guide lists the fields a private-sector company in Egypt should include, gives you a layout you can copy, and traces every number back to its source so you stop rebuilding the slip each month.

Quick summary. A payslip has five blocks: employee and period details, earnings, deductions, net pay, and the company's sign-off. The variable numbers (absence, lateness, overtime) come from the attendance record. The statutory numbers (social insurance and salary tax) are calculated by your accountant under the rules in force that month. This is general information, not legal or tax advice.

This article belongs to our series on employee attendance software for companies in Egypt.

Payslip, payroll sheet or salary certificate?

Egyptian offices use three documents that are often confused. In Arabic the payslip is usually called mofradat morattab, which is the term your staff will use when they ask for it.

Document Written for What it shows When it is issued
Payslip The employee, or a body the employee hands it to One person's pay for one month, line by line Monthly, or on request
Payroll sheet Management and the accountant Every employee in one table with totals Once a month at payment
Salary certificate A bank, an embassy or a government office A short statement of job title, hire date and salary Only on request

The working rule is simple. The payroll sheet is the source, and each payslip is one row of it written out in detail. If a figure differs between the two, there is an error, and you want to find it before the employee does.

The fields a payslip needs

Keep the same five blocks in the same order every month, so people know where to look.

1. Identification. Company name, the employee's name as it appears on their national ID, employee number, job title, department or branch, hire date, and the month the slip covers.

2. Earnings. Everything added this month, one line each:

  • Basic salary as stated in the contract.
  • Fixed allowances, such as transport or nature-of-work allowance.
  • Variable incentives and commissions.
  • Overtime pay, with the number of hours beside it.

3. Deductions. Everything taken off, again one line each:

  • The employee's share of social insurance.
  • Salary tax.
  • Unpaid absence, with the number of days.
  • Lateness deductions, if your written policy applies them.
  • Loan instalments and any penalty applied under your regulations.

4. Net pay. Total earnings minus total deductions, in figures and in words, plus the payment method: bank transfer, wallet or cash.

5. Sign-off. Who prepared the slip, the approver's signature, the company stamp and the issue date.

A single line called "other deductions" invites questions. Name each deduction, even if the page grows by two lines.

A payslip template you can copy

Paste this table into Word, Excel or Google Sheets and rename the lines to match your contracts.

Field Entry
Company name ................
Employee name / employee number ................
Job title / branch ................
Pay period (month) ................
Days attended / unpaid absence days ...... / ......
Approved overtime hours ......
Earnings
Basic salary ......
Fixed allowances (named) ......
Incentives and commissions ......
Overtime pay ......
Total earnings ......
Deductions
Employee social insurance share ......
Salary tax ......
Absence and lateness ......
Loan instalment / penalties ......
Total deductions ......
Net pay (figures and words) ......
Prepared by / approved by / stamp / date ................

Keep the "days attended" and "approved overtime hours" lines even if other templates leave them out. Those two numbers cause most payslip disputes, and printing them on the slip shortens the argument.

Where each number comes from

A payslip is not written from memory. Every line has a source, and the source tells you who answers for it.

Number Source Owner
Basic salary and fixed allowances Employment contract and its annexes HR
Incentives and commissions Management decision or sales report Line manager
Absence days and late minutes Attendance record Supervisor, then HR
Overtime hours Attendance record plus manager approval Line manager
Social insurance and salary tax The rules in force on the payment date Accountant
Loans and penalties Loan register and written penalty decisions Accounts and HR

The first two rows barely change. The real monthly variable is attendance. So close the monthly attendance report first and start payroll second. Teams that do it the other way round issue every corrected slip twice.

Social insurance rates, tax brackets and their thresholds change by official decision. We do not quote any rate here, because an outdated number on a stamped document is worse than no number. Check them with the National Organization for Social Insurance and the Egyptian Tax Authority, or ask your accountant to refresh them before the first payroll of each year.

A worked example with illustrative figures

These figures are for illustration only. They are not statutory rates or market averages. An employee has a basic salary of EGP 8,000 and a transport allowance of EGP 600. This month they earned an incentive of EGP 400 and approved overtime pay of EGP 300. They took one day of unpaid absence and owe a loan instalment of EGP 500.

  1. Total earnings: 8,000 + 600 + 400 + 300 = EGP 9,300.
  2. Value of the absence day: 8,000 ÷ 30 = EGP 266.67. Egypt's Labour Law No. 14 of 2025 treats a month as thirty days unless agreed otherwise (Article 2).
  3. Loan instalment: EGP 500.
  4. Social insurance and salary tax: calculated by the accountant under current rules. We mark them here as (SI) and (T).
  5. Net pay: 9,300 − 266.67 − 500 − SI − T.

Step 2 hides a choice. Is the absence day valued on basic salary alone, or on basic plus allowances? Your contract and internal regulations decide that. What matters is using the same base for every employee, every month. If you deduct for late minutes, read our guide to a late arrival deduction policy first. To turn raw punches into hours, see how to calculate working hours.

Payslips for a bank or an official body

Many requests do not come from curiosity. A bank is reviewing a loan, or an office wants proof of income. Requirements differ from one institution to the next, so ask the employee for the checklist before you print. In general, requests come down to four things:

  • The slip is recent and dated.
  • It carries the approver's signature and the company stamp.
  • Gross and net are clearly separated.
  • The details match what is registered for the employee with official bodies.

The last point is the serious one. Never issue a slip showing a figure that differs from what you pay or from what is officially registered, however hard the employee pushes. The document carries your stamp, and the liability is yours.

Five mistakes that repeat every month

  1. One lump deduction line. Employees object less to a deduction than to not understanding it.
  2. Unapproved attendance numbers. Issuing slips before supervisors review the month means correcting them later.
  3. Overtime without approval. An hour no manager approved does not belong on the slip. Settle it before payment, not after.
  4. A different layout per branch. One layout makes cross-branch review possible.
  5. No copy kept. File a copy of every slip with the payroll sheet it came from. For how long records must be kept, ask your accountant or check the current text on the Ministry of Labour site.

How Yawmy fits

Yawmy is an attendance and employee task management app. What it contributes to a payslip is the variable part. Employees check in and out from their phones, and managers get attendance reports that show who was absent or late during the month. Absence days then reach whoever prepares payroll from one record, instead of three sheets from three supervisors. Social insurance and tax stay with your accountant. To see what the app covers today, visit the Yawmy site. To compare payroll tools themselves, read our guide to payroll software in Egypt.

FAQ

What is the difference between a payslip and a salary certificate?

A payslip is detailed and covers one month, with every earning and deduction on its own line. A salary certificate is a short statement addressed to an outside body, giving job title, hire date and salary. Ask the requesting institution which one it wants before you issue anything.

Do I have to give every employee a payslip each month?

We do not state a legal rule here. Check the current text of the Labour Law and your own regulations. In practice, handing over pay details monthly reduces objections and surfaces errors in the same month rather than a year later.

Should I build the payslip in Word or Excel?

Excel suits you better once you pay more than a handful of people, because formulas add and subtract without manual slips. Word is enough for a one-off document for an outside body. Either way, give the employee a PDF or a stamped page, not an editable file.

How do I value an unpaid absence day on the payslip?

The common method divides the monthly wage by thirty, and Labour Law No. 14 of 2025 treats a month as thirty days unless agreed otherwise. Which wage elements go into the base is set by the contract and your regulations. Apply the same rule to everyone.

Should overtime appear on the payslip?

Yes, on its own line under earnings, ideally with the number of hours beside it. That lets the employee match the figure against their attendance record. It also prevents arguments about hours that were never approved.

Written by Nada Hassan, HR-Tech Strategist at Yawmy. This is general information, not legal or tax advice.

To have absence and lateness numbers ready before payroll closes, open Yawmy and start recording your team's attendance.

Still chasing absence and overtime numbers on payroll day?

Tell us your company name and headcount and the Yawmy team will get in touch.

Your details go to the sales team only.
Start here

Turn attendance and payroll into a clean system in minutes.

Try Yawmy for free, add your team, and connect Telegram check-ins, GPS proof, and payroll-ready reports without Excel or WhatsApp chaos.

Yawmy
GPS attendance
Payroll reports
Teams & branches
No hardware