Contract Reporting

Overview

The Contract Reporting menu displays complete reports regarding employee contracts in the company. This feature allows you to monitor contract statistics, view contract lists based on status, and analyze contract summaries by project.

Page Navigation

The Contract Reporting page is located in the menu: Dashboard » Reporting » Contract

Contract Statistics

At the top of the page, a summary of contract statistics is displayed in card form:

Tabs Navigation

There are several tabs for viewing contract data:

Filter Options

Search Bar

A search column is available to help find contracts based on:

• Employee name
• Employee Code
• Contractor Number
• Document Type
• Position

Contract List Table

Table Structure

Contract List Table Data

Summary by Project Table

Summary Table Structure

Summary Table Data

Expiring Soon Tab

The Expiring Soon tab displays contracts that will expire in the near future (usually < 30 days). The table structure is the same as the Contract List, but only displays contracts with Expiring Soon status.

Contract Status

Days Until Expira

The Days Until Expira column shows:

• Positive numbers: Number of days until the contract expires
• Negative numbers: Number of days past the expiration date

Examples:

• -397 days = Contract expired 397 days ago
• -32 days = Contract expired 32 days ago
• +15 days = Contract will expire in 15 days

Other Features

Columns

Click the Columns button to arrange which columns appear in the table:

Available columns:

• No
• Employee Code
• Employee Name
• Contractor Number
• Document Type
• Position
• Start Date
• End Date
• Status
• Days Until Expira
• Project Code
• Is Active
• Created Date
• Updated Date

Filters

Click the Filters button to filter data based on:

Filter by:

• Status (Active, Warning, Expiring Soon, Expired)
• Document Type (PKWT, PKWTT, Unknown)
• Project Code
• Date Range (Start Date, End Date)
• Position
• Is Active

Export

Click the Export button to export table data to:

Data Analysis

From Statistics:

• Total Contracts: 27 contracts
• Active: 19 (70.4% of total)
• Warning: 3 (11.1% of total)
• Expiring Soon: 1 (3.7% of total)
• Expired: 4 (14.8% of total)

From Summary by Project (Project 6900B181220100):

• Total Employees: 27
• Active Contracts: 19
• Warning: 3
• Expiring Soon: 1
• Expired: 4
• Is Active (Employees): 23
• Is Inactive (Employees): 2

Interpretation:

• 4 contracts have expired (need immediate follow-up)
• 1 contract will expire soon (< 1 month)
• 3 contracts are in warning status (1-3 months)
• 19 contracts are still active (> 3 months)
• 23 employees are still active, 2 are inactive

Usage Tips

1. Monitor Expired Contracts - Immediately process expired contracts (4 contracts) to avoid legal issues.
2. Pay Attention to Expiring Soon - Contracts that will expire soon (1 contract) need to be prioritized for extension.
3. Follow Up Warning - 3 contracts in warning status need follow-up for extension preparation.
4. Use Filters - Utilize status filters to focus on contracts that need follow-up.
5. Check Days Until Expira - Pay attention to negative numbers to know how long contracts have been expired.
6. Review Summary by Project - Analyze contract distribution per project for resource planning.
7. Export Data - Export reports for meeting purposes or documentation.

Common Scenarios

Scenario 1: Monthly Review

At the beginning of each month, conduct a contract review:

1. Open the Contract List tab
2. Filter by Expiring Soon status for contracts that need processing this month
3. Filter by Warning status for next month's preparation
4. Filter by Expired status for evaluating past contracts

Scenario 2: Extension Planning

For project 6900B181220100:

• 1 Expiring Soon contract → process extension this week
• 3 Warning contracts → prepare extension documents next month
• 4 Expired contracts → evaluate whether to extend or terminate

Scenario 3: Management Report

Create a report for management:

1. Open the Summary by Project tab
2. Export data to Excel
3. Create a chart of contract status distribution
4. Add follow-up recommendations

Troubleshooting

Data Not Appearing

• Check year and month filters
• Ensure the selected tab is appropriate
• Refresh the page
• Check internet connection

Numbers Don't Match

• Verify filter period
• Check data consistency in the Contract menu
• Ensure no duplicate data

Days Until Expira Incorrect

• Check date format (dd/mm/yyyy)
• Ensure End Date is filled correctly
• Check server timezone

Export Failed

• Ensure no popup blockers
• Limit the amount of data if too much
• Try CSV format if Excel has issues

Integration with Related Menus

Contract Management

Data comes from the Contract Management menu.

Employee Database

Employee information is integrated with Employee Database.

Project Management

Summary by project is related to Project Management.

Termination Management

Expired contracts can be processed in Termination Management.

Next Steps

• Contract Management
• Employee Database
• Project Management
• Termination Management