Setting Individual Salaries

Home > Management Mode > HR > Personal Information > Any Employee > Hourly Wage, Daily Wage, Monthly Wage

Administrators can click on "HR" in the "Management Mode" homepage, select "Personal Information," and then click on "Any Employee" to access the personal information editing page. Here, administrators can set hourly, daily, and monthly wages for employees individually. Salary Calculation will use the set hourly, daily, and monthly wage values to calculate salaries for a specific month.

Current salary calculations are based solely on punch-in records. They have not yet integrated scheduling, leave, and other information. Comprehensive salary calculations based on personal attendance will be available in the future.

Example of Personal Information

  • Group: Administration Department
  • Position: Administrative Assistant
  • Remaining Punch-In Adjustments: 5 times
  • Hourly Wage: 200
  • Daily Wage: 1600
  • Monthly Wage: 48000
  • Date of Employment: 2023-05-15
  • Official Entry Date: 2023-06-01

Salary Calculation

Home > Management Mode > HR > Salary Calculation

Administrators can click on "HR" in the "Management Mode" homepage, select "Salary Calculation," and enter the salary calculation page. Salaries can be calculated here. When hourly, daily, or monthly wages are filled in employee personal information, the system can calculate the salary for a specified month based on punched-in hours multiplied by the set wage rates.

Selecting Month

Choose the month for salary calculation.

Hourly Wage Calculation

  • Example: 160 hours (total) × 200 (hourly wage) = 32000 (salary)
  • Total: The total punched-in hours, calculated as the end time minus the start time.
  • Hourly Wage: The hourly wage set in personal information.
  • Salary: Total hours multiplied by the hourly wage to get the salary for the specified month.

Daily Wage Calculation

  • Example: Daily wage of 1600 converted to hourly wage 200, 160 hours (total) × 200 (hourly wage) = 32000 (salary)
  • Total: The total punched-in hours, calculated as the end time minus the start time.
  • Daily Wage: The daily wage set in personal information, converted to an hourly wage based on an 8-hour workday.
  • Salary: Total hours multiplied by the converted hourly wage to get the salary for the specified month.

Monthly Wage Calculation

  • Example: Monthly wage of 48000 converted to hourly wage 200 (48000 ÷ 8 ÷ 30), 160 hours (total) × 200 (hourly wage) = 32000 (salary)
  • Total: The total punched-in hours, calculated as the end time minus the start time.
  • Monthly Wage: The monthly wage set in personal information, converted to an hourly wage assuming an 8-hour workday and 30 days per month.
  • Salary: Total hours multiplied by the converted hourly wage to get the salary for the specified month.

Example Calculation (April 2025)

  • Total Hours: For April 2025, working five days per week, eight hours per day, totaling 160 hours
  • Hourly Wage Calculation: 160 hours × 200 = 32000
  • Daily Wage Calculation: Daily wage of 1600 converted to hourly wage 200, 160 hours × 200 = 32000

If salary calculations here do not meet the administrator's needs, administrators can also directly export punch-in and overtime records to Excel files and manually add formulas to calculate employee salaries.

Export Punch-in Records for Salary Calculation

Home > Management Mode > Punch-in Records and Management > Export Punch-in Records

Administrators can click on "Punch-in Records and Management" from the "Management Mode" homepage and select "Export Punch-in Records" to access the export page. Punch-in records can be exported here, and the exported files can be opened with Excel to calculate salaries.

Excel Operation Steps

  1. Open the exported Excel file.
  2. Enter a formula in a blank cell, such as: =SUM(End Time Column - Start Time Column)*24, note: Excel's default time unit is "days," multiplying by 24 converts it to "hours," to calculate each punch-in duration.
  3. Sum the calculated hours to get the total monthly working hours.
  4. Multiply by the employee’s hourly wage or converted hourly wage to obtain the total salary.

Export Overtime Records for Salary Calculation

Home > Management Mode > Punch-in Records and Management > Export Overtime Records

Administrators can click on "Punch-in Records and Management" from the "Management Mode" homepage and select "Export Overtime Records" to access the export page. Overtime punch-in records can be exported here, and the exported files can be opened with Excel to calculate overtime pay.

Excel Operation Steps

  1. Open the exported Excel file.
  2. Enter a formula in a blank cell, such as: =SUM(Overtime End Time Column - Overtime Start Time Column)*24, note: Excel's default time unit is "days," multiplying by 24 converts it to "hours," to calculate each overtime duration.
  3. Sum the calculated overtime hours to get the total monthly overtime hours.
  4. Multiply by the employee’s overtime hourly wage or according to the regulated overtime rate to obtain the total overtime pay.
This manual strives for accuracy and completeness, but we do not assume any liability for errors, omissions, or updates. The content may be modified at any time without prior notice. We are not responsible for any damages arising from the use of this manual or downloading its contents, including but not limited to system failures, data loss, or infringement of rights. Users assume full responsibility and risk.