A beginner-friendly system for calculating salaries, Social Security, employee income tax, bank transfers, and statutory reporting—without buying payroll software.
Payroll is not simply “basic salary minus deductions.” A reliable payroll file must preserve employee master data, document every monthly movement, apply current legal rates, reconcile totals, and produce evidence for payment and government reporting.
1. Build the workbook around five controlled sheets
Employees: Employee ID, English and Arabic names, national number, hire/termination dates, job title, tax status, Social Security number, bank name, IBAN, SWIFT/BIC, and payment method.
Monthly Input: Basic salary, fixed allowances, taxable benefits, overtime, bonuses, unpaid leave, additions, deductions, and approved adjustments.
Settings: Payroll year, current Social Security rates and ceilings, income-tax brackets, exemptions, and any company-specific rules. Lock this sheet and document the official source and effective date of every rate.
Payroll Calculation: Gross pay, Social Security employee share, taxable income, income-tax withholding, other deductions, employer Social Security share, and net pay.
Reports: Monthly payroll journal, employee payslips, bank-transfer schedule, Social Security movement log, monthly tax-withholding statement, and annual employee totals for the current official AR/3 or payroll withholding process.
2. Enter data once, then validate it
Give every employee a unique ID and use it in every sheet. Add drop-down lists for status and payment method. Validate IBAN length and format, prevent duplicate national or Social Security numbers, and never overwrite a prior month after approval. Instead, post a dated adjustment with a reason and approver.
3. Use transparent Excel formulas
Gross Pay = Basic Salary + Allowances + Taxable Benefits + Overtime + Bonus + Other Additions − Unpaid Leave
Employee SSC = MIN(SSC-Eligible Wage, Current SSC Ceiling) × Current Employee Rate
Employer SSC = MIN(SSC-Eligible Wage, Current SSC Ceiling) × Current Employer Rate
Taxable Income = MAX(0, Taxable Pay − Employee SSC − Applicable Exemptions)
Income Tax = the sum of the portions of taxable income falling within the current progressive tax brackets.
Net Pay = Gross Pay − Employee SSC − Income Tax − Other Employee Deductions
Do not hard-code rates inside monthly formulas. Reference named cells on the protected Settings sheet so a legally effective change can be applied consistently and audited.
4. Prepare a bank-transfer file
Export only approved payroll. The transfer table should contain the employee’s English name, net salary to transfer, IBAN, SWIFT/BIC, bank name, and payment reference. Reconcile its total to approved net payroll before sending it to the bank. Access to this file must be restricted because it contains personal and banking data.
5. Close payroll with a monthly checklist
Confirm joiners, leavers, salary changes, leave, overtime, bonuses, advances, court or administrative deductions, tax status, SSC eligibility, and bank details. Compare current payroll with the previous month, investigate unusual movements, approve totals, generate reports, pay employees, remit deductions, and archive the approved workbook and supporting documents.
6. Jordan compliance calendar
Employee salaries and overtime: Pay no later than seven days after the due date, in line with the Ministry of Labour’s published guidance.
Employee income-tax withholding: Remit withheld tax within 30 days from the payment date. The monthly employee-withholding Excel statement should be uploaded through ISTD e-services before the end of the following month.
Social Security contributions: Pay during the first fifteen days of the following month.
SSC additions and removals: Notify the Corporation through its electronic services no later than the end of the month following the event.
January SSC wage data: The SSC has published notices requiring establishments to submit January wage data by the end of March. Check the notice for the relevant year before relying on this date.
Annual payroll/AR/3 reporting: ISTD provides electronic annual payroll-withholding services and tax forms, but the applicable deadline and portal instructions should be verified from the current-year announcement. Do not copy an old deadline into a permanent payroll calendar.
7. What late filing or payment can cost
Income tax: The Income Tax Law provides additional compensation of 0.4% of the amount due for every week or part of a week of delay, capped at the tax due. Failure to withhold and remit may also attract additional tax of JOD 200–500, doubled for repetition. Deliberate non-remittance may create more serious tax-evasion exposure.
Social Security: The Social Security Law provides late interest of 1% per month on unpaid contributions. Late submission of employee data can lead to an additional 1% per month of the relevant contributions, and failure to include workers or incorrect data may expose the establishment to 30% of the contributions concerned, subject to the law and the facts of the case.
Wages and minimum wage: In addition to paying the wage difference, published Ministry of Labour guidance states that violations of minimum-wage obligations may result in a fine of JOD 500–1,000 for each case, doubled for repetition.
8. Official references
Jordan Income and Sales Tax Department — monthly employee withholding statement:
Jordan Income Tax Law:
https://istd.gov.jo/EBV4.0/Root_Storage/AR/QRCODE/income2.pdf
Jordan Ministry of Labour — wage payment guidance:
Social Security Law:
This guide is educational and is not a substitute for legal or tax advice. Rates, ceilings, forms, and deadlines can change. Verify the current official rules before filing or payment. If your payroll has grown beyond a simple controlled workbook, contact Kayan Advisory for a scalable payroll and compliance setup.