Set Individual Salary

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

From the Management Mode home page, an administrator can select Personnel, open Personal Information, and then choose any employee to edit their personal information. The administrator can set the employee's hourly, daily, or monthly wage here. Salary Calculation uses the configured wage to calculate salary for a selected month.

Salary is currently calculated only from the difference between the employee's start-work and end-work clock-in times. Schedules, leave, and similar information are not yet included. Breaks within work hours are not deducted automatically. SwipePoint will continue improving its individual attendance and salary calculation features.

Personal Information Example

  • Group: Administration Department
  • Position: Administrative Assistant
  • Remaining Missed Clock-In Quota: 5
  • Hourly Wage: 200
  • Daily Wage: 1,600
  • Monthly Wage: 48,000
  • Hire Date: 2023-05-15
  • Official Onboarding: 2023-06-01

Salary Calculation

Home > Management Mode > Personnel > Salary Calculation

From the Management Mode home page, an administrator can select Personnel and then Salary Calculation to open the salary calculation page. If an employee's personal information includes an hourly, daily, or monthly wage, the system converts that wage and calculates salary from the clock-in hours in the selected month.

Select a Month

Select the month for which you want to calculate salary.

Hourly Wage Calculation

  • Example: 160 hours (total) × 200 (hourly wage) = 32,000 (salary)
  • Total: The sum of all clock-in hours. Each entry's hours are calculated by subtracting the start-work clock-in time from the end-work clock-in time.
  • Hourly Wage: The employee's hourly wage configured in Personnel > Personal Information.
  • Salary: The total hours multiplied by the hourly wage for the selected month.

Daily Wage Calculation

  • Example: A daily wage of 1,600 converts to an hourly wage of 200; 160 hours (total) × 200 (hourly wage) = 32,000 (salary)
  • Total: The sum of all clock-in hours. Each entry's hours are calculated by subtracting the start-work clock-in time from the end-work clock-in time.
  • Daily Wage: The employee's daily wage configured in Personnel > Personal Information. The system assumes an eight-hour workday and divides the daily wage by 8 to calculate the hourly wage.
  • Salary: The total hours multiplied by the converted hourly wage for the selected month.

Monthly Wage Calculation

  • Example: A monthly wage of 48,000 converts to an hourly wage of 200 (48,000 ÷ 8 ÷ 30); 160 hours (total) × 200 (hourly wage) = 32,000 (salary)
  • Total: The sum of all clock-in hours. Each entry's hours are calculated by subtracting the start-work clock-in time from the end-work clock-in time.
  • Monthly Wage: The employee's monthly wage configured in Personnel > Personal Information. The system assumes an eight-hour workday and 30 days per month, then divides the monthly wage by 8 and by 30 to calculate the hourly wage.
  • Salary: The total hours multiplied by the converted hourly wage for the selected month.

Calculation Example (April 2025)

  • Total Hours: Five days per week and eight hours per day in April 2025, totaling 160 hours
  • Hourly Wage Calculation: 160 hours × 200 = 32,000
  • Daily Wage Calculation: A daily wage of 1,600 converts to an hourly wage of 200; 160 hours × 200 = 32,000

If the built-in salary calculation does not meet the administrator's needs, the administrator can export clock-in and overtime records as Excel files and add formulas manually to calculate employee salaries.

Calculate Salary from Exported Clock-In Records

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

From the Management Mode home page, an administrator can select Clock-in Records and Management and then Export Clock-in Records to open the export page. The administrator can export clock-in records and open the exported file in Excel to calculate salary.

Excel Instructions

  1. Open the exported Excel file.
  2. Enter a formula in a blank cell, such as =SUM(End Time Cell-Start Time Cell)*24. Excel stores time in units of days, so multiplying by 24 converts days to hours and calculates the hours for each clock-in record.
  3. Add the calculated hours to obtain the employee's total work hours for the month.
  4. Multiply the total work hours by the employee's configured or converted hourly wage to obtain the total salary.

Calculate Salary from Exported Overtime Records

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

From the Management Mode home page, an administrator can select Clock-in Records and Management and then Export Overtime Records to open the export page. The administrator can export overtime records and open the exported file in Excel to calculate overtime pay.

Excel Instructions

  1. Open the exported Excel file.
  2. Enter a formula in a blank cell, such as =SUM(Overtime End Time Cell-Overtime Start Time Cell)*24. Excel stores time in units of days, so multiplying by 24 converts days to hours and calculates the hours for each overtime record.
  3. Add the calculated overtime hours to obtain the employee's total overtime hours for the month.
  4. Use the employee's overtime hourly wage or the required overtime multiplier to calculate the total overtime pay.

Frequently Asked Questions

Q1: How does an administrator set an employee's salary in the system?

A: From the Management Mode home page, select Personnel, then Personal Information, and choose any employee to open that employee's personal information page. The administrator can set an hourly, daily, or monthly wage on this page. The system uses these values for salary calculations.

Q2: What is the current salary calculation based on, and how will it improve?

A: Salary is currently calculated only from employee clock-in records. The system calculates total work hours from the clock-in times and applies the configured wage. Future improvements will provide more complete individual attendance and salary calculations by incorporating schedules, leave, and similar information.

Q3: How do I calculate salary in the system?

A: From the Management Mode home page, select Personnel and then Salary Calculation to open the salary calculation page. Select the month you want to calculate. The system uses the employee's configured hourly, daily, or monthly wage and the clock-in hours for that month to calculate the salary.

Q4: How does the system calculate salary from an hourly, daily, or monthly wage?

A: The system ultimately uses an hourly wage for every calculation. For an hourly wage, it multiplies the configured wage by the total clock-in hours. For a daily wage, it assumes an eight-hour workday, divides the daily wage by 8, and multiplies the result by the total clock-in hours. For a monthly wage, it assumes an eight-hour workday and 30 days per month, divides the monthly wage by 8 and then by 30, and multiplies the result by the total clock-in hours. Total clock-in hours are the sum of each end-work clock-in time minus its corresponding start-work clock-in time.

Q5: What can an administrator do if the built-in salary calculation does not meet their needs?

A: The administrator can export clock-in and overtime records as Excel files, then add formulas manually in Excel for more detailed or customized salary calculations.

Q6: How do I export clock-in records for a manual salary calculation?

A: From the Management Mode home page, select Clock-in Records and Management and then Export Clock-in Records to open the export page. Open the exported Excel file and use a formula such as =SUM(End Time Cell-Start Time Cell)*24 to calculate the hours for each record. Add the results to obtain the total work hours, then multiply that total by the employee's configured or converted hourly wage.

Q7: How do I export overtime records to calculate overtime pay?

A: From the Management Mode home page, select Clock-in Records and Management and then Export Overtime Records to open the export page. Open the exported Excel file and use a formula such as =SUM(Overtime End Time Cell-Overtime Start Time Cell)*24 to calculate the hours for each overtime record. Add the results to obtain the total overtime hours, then apply the employee's overtime hourly wage or the required overtime multiplier.

Q8: Why do Excel formulas for clock-in or overtime hours multiply by 24?

A: Excel stores time in units of days. Multiplying the result by 24 converts it from days to hours because one day contains 24 hours. This makes the formula return the correct number of hours.

Subscribers receive faster support. If you encounter an error or need help while using SwipePoint, contact the SwipePoint team through the official LINE account. We will prioritize your request to help keep attendance management running smoothly. LINE ID: @nka7729y　Contact Us

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.