Back

Employee Contracts Report

About the Report

The Employee Contracts Report displays all employee contracts with details for each contract including start and end dates, basic salary, deductions, net salary, and contract status. It is used to review active and expired contracts, track joining dates and probation period end dates, and verify salary details associated with each contract.

How to View the Report

  1. Click on “Reports” from the sidebar menu.
  2. Navigate to the “Employee Reports” section.
  3. Select “Employee Contracts”.
  4. You can apply several filters before viewing the report:
    • Start Date From / Start Date To: Filter contracts by their start date.
    • End Date From / End Date To: Filter contracts by their end date. Useful for identifying contracts expiring within an upcoming time period.
  5. Join Date From / Join Date To: Filter contracts by the employee’s joining date.z
    • Probation End Date From / Probation End Date To: Filter contracts by the employee’s probation period end date.
    • Contract Sign Date From / Contract Sign Date To: Filter contracts by the date they were signed.
    • Status: Filter contracts by their current status:
      • Active: Currently valid contracts.
      • Draft: Contracts that have not yet been completed or signed.
      • Pending: Contracts awaiting approval or review.
      • Expired: Contracts whose duration has ended.
      • Cancelled: Contracts that have been cancelled.
      • Superseded: Contracts that have been replaced by new ones.
      • Terminated: Contracts that have been terminated.
      • If no status is selected, the system will display all statuses.
    • Period of Contracts: Filter contracts by the unit of contract duration:
      • Year: Display contracts with a duration measured in years.
      • Month: Display contracts with a duration measured in months.
      • If no period is selected, the system will display all contracts.
    • Employee: Search for one or more employees by name, code, email, department, or branch. If no employee is selected, the system will display contracts for all employees.
    • Shift: Filter results to display employees of a specific shift only. If no shift is selected, the system will display all shifts.
    • Department: Filter results to display employees of a specific department only. If no department is selected, the system will display all departments.
    • Designation: Filter results to display employees with a specific designation only. If no designation is selected, the system will display all designations.
    • Employment Level: Filter results by the employee’s employment level. If no level is selected, the system will display all employment levels.
    • Employment Type: Filter results by employment type (full-time, part-time, etc.). If no type is selected, the system will display all employment types.
    • Employee Status: Filter results by employee status (Active / Inactive). If no status is selected, the system will display all employees.
    • Branch: Filter results to display employees of a specific branch only. If no branch is selected, the system will display all branches.
    • Currency: Choose how currencies are displayed in the report (All to SAR / Each Separately / SAR only).
  6. Click “View Report” to refresh the results, or click “Clear Filter” to return to the default settings.
  7. You can export the report using the “Export” button to:
    • CSV
    • Excel
    • PDF

Display Mode

The report is available in two display modes, switchable from the top of the page:

  • Summary: Displays an aggregated summary of contract totals.
  • Details: Displays each contract independently with all its details.

Report Columns

The table displays each contract’s data across the following columns:

  • Code — The contract’s sequential number in the system.
  • Employee — Employee name and code with a direct link to their profile page.
  • Start Contract Date — The date the contract comes into effect.
  • End Contract Date — The date the contract expires.

Salaries & Deductions

  • Total Earnings: The total basic salary and fixed allowances specified in the contract.
  • Total Deductions: The total deductions specified in the contract.
  • Net Pay: The net salary due after applying deductions.

Contract Status

  • Status: The current status of the contract — Active / Draft / Pending / Expired / Cancelled / Superseded / Terminated.

Subtotal & Totals Rows

  • Subtotal: Appears below each group and sums the total salaries, deductions, and net salary values for that group.
  • Totals: Appears at the bottom of the table and displays the grand total for all contracts shown in the report.