العربية
FREE DOWNLOAD · NO SIGN-UP

Free payroll Excel template for Jordan (2026)

A ready payroll sheet for up to 50 employees that calculates Jordanian social security, income tax and net salary with open formulas you can check. Arabic and English versions, free to use and share.

Download the template

About 16 KB. Works in Excel 2010 or later, Google Sheets and LibreOffice. No macros, no external links, nothing to install.

What each row calculates

  • Gross salary
  • Insured wage (capped)
  • Employee social security 7.5%
  • Employer social security 14.25%
  • Annual exemptions
  • Annual taxable income
  • Annual and monthly income tax
  • Net salary
  • Total cost to employer
  • Column totals

Rates last reviewed:

What is inside the template

The workbook has three sheets. Payroll is the monthly sheet: yellow cells are inputs and the other columns are formulas. Settings holds every rate and limit in one place, each with its legal basis, so a change in the law is one cell, not fifty. How to use repeats the steps below and the template's limits.

The formulas, in plain words

  • Insured wage = the smaller of gross salary and the monthly ceiling (3,733 JOD in 2026), only if the employee is covered.
  • Social security = insured wage × 7.5% for the employee and × 14.25% for the employer, rounded to the fils.
  • Exemptions = 9,000 personal + 9,000 if there are dependants + extra exemptions claimed (up to 1,000 for the taxpayer, 1,000 for the spouse and 1,000 per child up to 3,000), capped at 23,000 for the family.
  • Income tax = the brackets of Article 11 on (gross × 12 − exemptions), rounded down to the dinar, then ÷ 12 for the month. The 1% national contribution above 200,000 is included.
  • Net = gross − employee social security − monthly income tax − loans and other deductions.

These are the same rules our free net salary calculator uses, and the template's example rows give exactly the same results. The rates are explained in our guides to social security rates and income tax on salaries.

The example rows

The template opens with five example employees so you can see the formulas work before you type your own data. Amounts in JOD a month.

CaseGrossEmployee SSCMonthly taxNetEmployer cost
Single, no extra exemptions1,00075.00012.500912.5001,142.500
Single50037.5000.000462.500571.250
Dependants, 2 children, 2,000 extra exemptions, 50 loan instalment1,500112.5000.0001,337.5001,713.750
Dependants, 3 children, 5,000 extra exemptions (above the ceiling)4,000279.975312.5003,407.5254,531.953
Minimum wage29021.7500.000268.250331.325

In the 4,000 JOD row, social security stops at the ceiling: 3,733 × 7.5% = 279.975. Taxable income is 48,000 − 23,000 = 25,000, so the tax is 250 + 500 + 750 + 1,000 + 1,250 = 3,750 a year.

What a spreadsheet cannot do for you

The template is honest arithmetic for a simple payroll. It deliberately leaves out what needs data from other places: overtime and absence from attendance, unpaid leave, loans with schedules, end of service, the pre-2009 social security ceiling, bonuses taxed in the month they are paid, and salary transfer files for the bank. It also has no history: next month you copy the file, and last month's figures can be overwritten.

That is usually the point where a company moves to payroll software. Our comparison payroll software vs Excel lists the signs, and Aspirations payroll does the same calculations from the employee file, attendance and leave, keeps every run approved and dated, and produces bank salary files. To check one salary quickly, the social security calculator is enough.

FAQ

Questions about the payroll template

Is the payroll template really free?

Yes. It is a direct download with no sign-up or email, and you may use and share it freely.

Does the template calculate Jordanian social security?

Yes: 7.5% for the employee and 14.25% for the employer on the wage up to the monthly ceiling (3,733 JOD in 2026), for employees you mark as covered.

Does it calculate income tax with dependants?

Yes. It applies the 9,000 personal and 9,000 dependants exemptions, extra exemptions within their legal limits and the 23,000 family cap, then the annual brackets divided by 12.

What do I need to change every January?

The social security ceiling on the Settings sheet, which is linked to inflation every January, and any rate or limit the law changes. The download on this page is updated when the figures change.

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas use only standard functions and named cells.

Are the results official?

No. The template is an estimate based on the law as we read it on the review date. Check specific cases with the Social Security Corporation and the Income and Sales Tax Department.

Ready to stop copying the sheet every month?

Aspirations HR runs the same calculations for every employee, with approvals, payslips and bank files. Plans are being finalised; a free trial is available.