How to calculate overtime pay is the determination of wages paid to workers when working outside normal working hours, based on wages, hours, type of time do more. As a rule, increase the day shift often pay at least 150%, weekends 200%, holidays, new year, 300% hourly wage; overtime at night, plus a minimum of 30%. Business needs determine the right salary as a base and apply the correct rate to avoid errors legal risks.
How to calculate salary increase ca is content to be more interested in business when construction wage policy, particularly in the context of checks, labor disputes wage is increasing.
Lac Viet SureHCS will provide complete instructions, easy to understand formula for calculating the amount increased ca in accordance with current legislation, with illustrative examples, Excel worksheets, and solutions to help businesses calculate salary accurate – transparent – automatically.
1. What is overtime pay? Why do businesses need to understand it correctly?
1.1 The concept of overtime pay as stipulated by law.
In personnel administration salary increase ca (or wage for overtime work) is the amount of money a business must pay to employees when they work outside normal working hours agreed in the labor contract or the rules of the company.
Follow The Labour code 2019overtime is understood as employee time worked in excess of:
- Number of normal working hours by day or week by week;
- Or exceeds the number of working hours in shifts was business regulation legal.
Salaries overtime is not paid items arbitrary, which is the law stipulates the minimum level required to protect the rights of workers and ensure fairness in the employment relationship.
In fact, management, business 3 common groups increased ca downloads:
- Increased ca normal working day: do more hours.
- Overtime vacation days every week (usually Sunday).
- Overtime night: work in the time frame night, popular is after 22h.
The clear distinction between each type of overtime is the foundation to apply the formula for calculating salary overtime correctly, to avoid confusion between the level of influence different.
Legal grounds business need to reference include:
- The Labor code 2019 – rules principle, the level of paid overtime.
- Decree 145/2020/ND-CP detailed instructions about conditions, overtime work, how to apply in practice.
The text was published officially on the Portal of electronic government and the Ministry of Labour – invalids and Social affairs, is the reference standard for businesses to apply.
1.2 Why is the wrong wage increase ca cause risks for your business?
In fact, many organizations and businesses are looking for information about how to calculate salary increase of ca not only because he wanted to pay the right for workers, but also to avoid legal risk and costs incurred in the future.
Firstly, the risk of arrears and administrative penalties.
According to regulations, labor laws, prevailing, if the business underpayment of wages overtime than the minimum level, when is labor inspection check, businesses can:
- Be the difference for the entire workers;
- Sanctioned for administrative violations with fines can be up to hundreds of millions, depending on the number of workers, the level of violation.
Monday, increasing labor disputes, complaints internally.
Salary is always a sensitive issue. When how to calculate salary increase ca not transparent, the labor of comparison, questions and complaints. This:
- Time-consuming processing of the personnel department;
- Causes of stress in labor relations;
- Affect the engagement of employees with the business.
Tuesday, influence corporate reputation and experience staff.
Many studies on hrm suggests, transparent salary is one of the important factors affecting the satisfaction level, the cohesion of the workers. Business mistake or lack of money overtime will be very difficult to build images prestigious employers, particularly in the context of competitive human resources is increasingly high.
2. General principles that businesses need to understand when calculating overtime pay
2.1 wage base increased ca, including the account?
One of the most common errors when calculating salary overtime is defined wrong wage base. In fact, not the entire income of workers are used to calculate overtime.
According to legal provisions, wage base increased ca salaries are according to the job or titles indicated in the contract labor is often understood as:
- Wage agreement according to the contract;
- Does not include the benefits, rewards, support is not fixed.
In fact, management, business often calls this clause is the basic salary used to calculate overtime. This is why when applying cash overtime according to the basic salary, the business must get the concept right from the start.
To avoid confusion, can be distinguished as simple as follows:
- Basic salary: the salary stated in the contract, base, overtime, insurance.
- Food received: the amount of money the workers get after allowances, overtime, bonus and minus the deductions.
- Total income: salary actually received plus other benefits (health care, support, reward, so...).
Work out properly and consistently using basic salary to calculate the wage increase ca help business building formula clear, easy to control, easy to give explanations when needed.
2.2 The salary paid overtime according to current regulations
According to The Labour code 2019, wages, overtime is paid higher than normal working hours, depending on each specific case:
- Do more on the normal working day: at least 150% of the unit price of wage or salary by the hour.
- Do more on days off every week (for example Sunday): at least by 200%.
- Do more on holidays and new year: at least equal to 300%, not including salaries holidays if salaried workers day.
- Do more in the night: in addition to the above, employees are paid more allowances night as prescribed.
The rate this is the minimum level required, businesses can pay higher but not lower. Applying the correct rate this business:
- Avoid mistakes when building formula for calculating salary overtime;
- Ensure compliance with the law;
- Create transparency and trust for employees.
In fact, many businesses are still calculated using Excel calculating salary overtime, leading to confusion between the proportions, especially when an employee has increased day shift often, just increase the ca night in the same pay period. This is also the reason increasingly more businesses turn to standardize processes and automate payroll to reduce the risks.
3. Methods for calculating overtime pay based on common situations in businesses.
In fact operate, businesses rarely arises only a tank ca. Hr can add 1-2 hours after administration, increased ca on Sunday, or do extra night in ca production. Therefore, the separation each case and apply the correct formula for calculating salary overtime is the key element to payroll accurate transparency.
3.1 How to charge overtime 1 hour
This is the most common case, common among office workers, support or production when needed to complete the work folding.
Formula for calculating the amount increased ca 1 hours (normal working day):
Money overtime 1 hour =
Salary actual hours × 150%
In which:
- Salary actual hours = monthly Salary under the contract / Total number of hours worked standard in January
- 150% is the minimum level stipulated in The Labour code 2019 for working overtime on a normal working day
For example illustrated easy to understand:
An employee has:
- Salary under a contract: 9.600.000/month
- Working time standard: 26 days × 8 hours = 208 hours
Hourly wage = 9.600.000 / 208 ≈ 46.154/hour
Money overtime 1 hour = 46.154 × 150% ≈ 69.231 dong
Real value for business in this is: just standardized way to determine hourly and apply the right rate, businesses can avoid errors right from the smallest unit is “1 hour overtime”, which is the source of many complaints wages.
3.2 How to calculate salary increase day shift often
Rose day shift is usually the extension of overtime 1 hour, but usually applied to hours in a row, especially in the plant, manufacturing enterprise, or peak period.
Principles apply:
- Apply for overtime hours, in addition to ca normal working
- The minimum: 150% of the hourly wage
How to calculate salary increase day shift is usually as basic salary:
Money increase ca =
Wage-hour × Number of hours of overtime × 150%
Practical example:
Staff A more 3 hours after administration:
- Hourly wage: 46.154 dong
- The number of hours overtime: 3 hours
Money increase ca = 46.154 × 3 × 150% ≈ 207.693 dong
In fact manage, if the business is calculated by Excel calculating salary overtime, just the wrong recipe or wrong wage-hour in a cell, the entire pay table may be misaligned. So many businesses choose to standardize available formulas and key input data to reduce risk.
3.3 How to calculate salary increase ca on Sunday
Overtime Sunday (or weekends) have the benefit level higher than normal days, but also is the business or confused the most.
The benefit provided by law:
- Do more on weekends: at least 200% of salary hours
A quick comparison with overtime on normal day:
- Normal days: 150%
- Sunday: 200%
How to calculate salary increase ca Sunday:
Money overtime Sunday =
Wage-hour × Number of hours of overtime × 200%
Illustrative examples:
B do 4 more hours on Sunday:
- Hourly wage: 46.154 dong
Money increase ca = 46.154 × 4 × 200% ≈ 369.232 dong
Enterprise value received when properly applied, payroll overtime Sunday is:
- Easy to explain to workers because of the high clear
- Avoid controversy when employees compare between increased ca weekdays, holidays
3.4 How to calculate salary increase in ca night (after 22h)
As a rule, night work is work in the time frame from 22h to 6am the following morning. This is the part many businesses or confused between “the increasing shift of the night,” and “allowance night shift”.
Distinguish simple:
- Allowance night shift: apply when working properly, ca night schedule
- Overtime night: took an extra hour, just fall into the night
When workers overtime after 22h, businesses have to pay:
- Money overtime according to the type of day (weekdays, Sundays, and holidays)
- Plus the amount of night work in accordance
For example, overtime, night-day, usually:
- 150% (increase ca weekdays)
- Plus at least 30% of the hours for night work
3.5 How to calculate salary increase in ca date night casual
This is the case, accrued many factors, need to clear formula to avoid errors.
Formula for calculating salary overtime day and night, often:
Money raised on the night shift =
Wage-hour × Number of hours of overtime × (150% + 30%)
The total effect minimum = 180% hourly
Specific example:
Staff C for another 2 hours from 22h to 24h in a normal working day:
- Hourly wage: 46.154 dong
Money increase ca = 46.154 × 2 × 180% ≈ 166.154 dong
With the business have shifts, complex, if only based on the File Excel calculating salary overtime, the hr department is very easily confused ratio or forget to add the night. The standardized formula for calculating salary overtime under each scenario to help businesses:
- Right from the start
- Reduce test time, for projection
- Easy explanations when the labor or management agency requirements
4. How to calculate wage night shift 8-hour and 12-hour – business case production
In the business of producing, operating in shifts, are popular models to guarantee the progress of orders, optimal capacity machinery. However, salary, night shift, especially for ca 8 hours and 12 hours, the back is content that many business most awkward due to confusion between normal working hours, night hours, overtime hours.
The application of the right not only to help businesses comply with the law, but also limited the dispute, stable staff, good control of wage costs.
4.1 How to calculate wage night shift 8 hours
When considered on the night shift?
According to The Labour code 2019, working hours at night is determined in the period of time from 22 hours to 6 hours the next morning.
Thus, a shift work is considered to be the night shift when full or part time work within this time frame.
With night shift 8 hours in manufacturing enterprises, the most common are:
- Ca from 22h to 6am the following day; or
- Ca from 21h to 5 (in which the time from 22h to 5h is the night hours).
In the case of workers who do enough for 8 hours according to the schedule, night shift, and not exceeding the duration of normal working hours, then this is not considered as overtime, which is working the night shift.
How to calculate wage night shift 8 hours
Principle paid:
- Workers work night to be paid at least 30% of the salary calculated according to the unit price of wage or salary according to the job of working days normal.
- This clause is added to the salaries of normal working hours.
Formula for calculating pay night shift 8 hours:
Wage night shift =
(Wage-hour × 8 hours) + (Wage-hour × 8 hours × 30%)
In which:
- Hourly wage = Salary under the contract / Total number of hours worked standard in January
Illustrative examples easy to understand
A production worker may:
- Salary under a contract: 7.800.000/month
- Working time standard: 26 days × 8 hours = 208 hours
Hourly wage = 7.800.000 / 208 ≈ 37.500/hour
Wage night shift 8 hours:
- Basic salary: 37.500 × 8 = 300,000
- Allowances night (30%): 300.000 × 30% = 90.000 copper
Total wage night shift = 390.000 dong
Real value for business:
- A clear distinction between night shifts and overtime help to avoid paying the wrong cost
- Easy to explain to workers because of how clear, transparent
- Limit confusion when applying File Excel calculating salary overtime for many different shifts
4.2 How to calculate wage night shift 12 hours
Night shift 12 hours often arise in the peak stage of production or when the business of labor shortages. This is case sensitive on the legal, if not well controlled very easy to violation of regulations on working hours.
Note about hours of work and overtime
According to the regulations:
- Time normal working hours no more than 8 hours/day or 48 hours/week
- Part-time work in excess of 8 hours/day is considered overtime
So, with the night shift 12 hours:
- 8 hours start: 's normal working hours, at night
- 4 hours remaining: is working overtime at night
Therefore, businesses have to pay:
- Wages for night work for 8 hours early
- Salary increase ca night for 4 hours worked
Formula for calculating pay night shift 12 hours
Part 1: 8-hour night work normal
- Wage-hour × 8 hours
- Plus 30% of hourly
Part 2: 4 hours overtime night (weekdays)
- Wage-hour × 4 hours × 150%
- Plus 30% of hourly pay for night work
General formula:
Wage night shift 12 hours =
(Hourly wage × 8 × 130%) + (hourly Wage × 4 × 180%)
In which:
- 130% = 100% of salary + 30% night
- 180% = 150% increase in ca normal days + 30% night
Illustrative examples practical
Still with hourly rate 37.500 co:
- 8 hours night shift:
37.500 × 8 × 130% = 390.000 dong - 4 hours overtime night:
37.500 × 4 × 180% = 270,000 dong
Total wage night shift 12 hours = 660.000 dong
Risk if the business exceeds legal limits
If the business is held the night shift 12 hours often but:
- Does not track the total number of overtime hours in the month/year
- No separation is normal working hours and overtime
- Applying the wrong formula for calculating salary overtime
it is very easy to deal with:
- The risk of being sanctioned when labor inspectors check
- Arrears of wages for workers
- Increase in disputes, the rate of absenteeism in the produce department
Under the guidance of the Ministry of Labor – invalids and Social affairs and the report on labor relations, wages and working time are the two content arises complaints in manufacturing enterprises. The standardized calculation of wages, overtime, especially with the night shift 12 hours, help businesses significantly reduce this risk.
5. Examples of how overtime pay is actually calculated in a business
In fact, many businesses understand the rules, but still the wrong money overtime because of the lack of specific examples for reference. The following simulation, the most common situation in commissioning help businesses easily check out, apply the correct formula for calculating salary overtime.
5.1 Example of how to calculate overtime pay for office workers
Real-life situations: office worker, often overtime after hours to complete reports, handle project or customer support. Duration increased ca popular is 1-3 hours on a normal working day.
Assume employee information
- Salary under a contract: 10.400.000/month
- Working time standard: 26 days × 8 hours = 208 hours
- The number of hours of overtime during the day: 2 hours (normal working day)
Step 1: Determine the hourly
- Hourly wage = 10.400.000 / 208 = 50,000/hour
Step 2: Apply formula calculator salary increase ca
- Overtime days often: at least 150%
Money increase ca =
50.000 × 2 × 150% = 150,000
Real value for business
With office workers, the number of hours of overtime is not big, but arise often. If the business is false hourly or pressure, wrong rate, wrong can last for months without detection. The standardized calculation of salary increases, shifts right from the simple case help:
- Easy to explain to employees
- Reduce complaints wages
- Create transparency in the policy paid
5.2 Example of how to calculate overtime pay for production workers
Real-life situations
In manufacturing, workers are often increased ca consecutive hours, including weekdays and holidays. This is the group to develop dispute if the business is gay, teen or gross wrong type of overtime.
Assume information workers
- Salary under a contract: 7.800.000/month
- Working time standard: 26 days × 8 hours = 208 hours
- Increased ca 4 hours on Sunday
Step 1: Determine the hourly
- Hourly wage = 7.800.000 / 208 ≈ 37.500/hour
Step 2: Apply the increased ca weekends
- Overtime Sunday: at least 200%
Money increase ca =
37.500 × 4 × 200% = 300,000
Real value for business
In production, just confused 150% and 200% the amount increase ca has significant errors. When the number of workers, big, small flaws will lead to:
- The total cost of salaries, the large
- The risk of arrears when labor inspectors check
- Directly affect labor relations
Having for example a standard help the hr department to internal training, control how consistency.
5.3 Example of synthesis of many types of increased ca in the same month
Real-life situations
An employee can just:
- Overtime days usually
- Overtime Sunday
- Overtime all night in the same pay period. Here is the case File Excel calculating salary overtime to develop flaws most.
Assume information
- Hourly wage: 40,000
- Month available:
- 6 hours overtime on normal day
- 4 hours overtime Sunday
- 2 hours overtime, night-day, often
Calculation details
- Overtime days often: 40.000 × 6 × 150% = 360.000 dong
- Overtime Sunday: 40.000 × 4 × 200% = 320.000 dong
- Overtime the night on often: 40.000 × 2 × 180% = 144.000 dong
Total cash increased ca in January
= 360.000 + 320.000 + 144.000
= 824.000 dong
If not separated clearly each type of overtime, business is very easy:
- Gross wrong rate
- Overlook the plus night
- Confusing for workers when comparing payroll
Example synthesis to help businesses test fast-true – false of the formula for calculating the salary increase is applied.
6. Use File Excel calculating salary overtime – Business need to note what?
In fact, Excel calculating salary overtime is still popular tool in many small and medium enterprises because of its low cost, easy to deploy. However, Excel only really effective when businesses understand the advantages and limitations of this tool.
Advantages when using Excel calculating salary overtime
- Flexible, easy-to-edit: Businesses can build formulas according to internal policies.
- Low cost: No need to invest in software right from the start.
- Suitable small scale business: Number of personnel less, ca work simple.
In the early stages, Excel help businesses get acquainted with the payroll, overtime, and cost control basic salary.
Limitations and risks when calculating overtime in Excel
When the enterprise scale increases, Excel revealed many limitations pronounced:
- Easy wrong recipe: Just edit the wrong one cell or copy the formula wrong, the entire pay table may be deviation that difficult to detect.
- Difficult to control big data: With the hundreds or thousands of workers, the cross-check by hand almost not feasible.
- Not affiliated attendance data – insurance: Excel does not automatically contact the data, attendance, leave, overtime, lead to the data entry manually many times.
According to the report, practical guide of the Ministry of Labor – invalids and Social affairs, wages and working time are the two content arises complaints labour best in the business, especially in mass production. The majority of errors came from the calculations, lack of control recipe data input.
Excel not wrong, but the risk lies in how to use. When the number of scenarios increases ca lot (weekdays, Sunday, night, ca 12 hours...), businesses should:
- Standardized available the formula for calculating salary overtime
- Lock the car important formulas
- Or consider automation solution to reduce the dependence on manual action
Download free File Excel calculating salary overtime the full case here
7. Automate payroll process with LV SureHCS C&B
In the context of business increasingly have to handle many scenarios wages as complex as salary according to ca salary increases, shifts, night shifts, shifts of 12 hours or the policy pay flexible according to each department, the payroll manually. in Excel, potential risks of errors and time-consuming to control. LV SureHCS C&B is designed as an in-depth solutions to help businesses automate the entire payroll process, from data timekeeping, overtime to deductible and aggregate income.
Instead of having to handle many file discrete and check out the recipe crafts, LV SureHCS C&B allows enterprises standardized formula for calculating salary overtime, flexible configuration, according legal regulations, internal policies, at the same time automatically calculated exactly for each employee. This not only helps the hr department significantly reduce the time, payroll processing, but also increase transparency, easy to control and limit the maximum wage dispute, particularly with businesses large-scale or operate in shifts, complex.
LAC VIET SUREHCS – A CUSTOMIZED, IN-DEPTH HUMAN RESOURCE MANAGEMENT AND COMPENSATION & BENEFITS PLATFORM FOR BUSINESSES
Lac Viet SureHCS is software HRM personnel management comprehensive, developed by Lac Viet – unit more than 30 years of experience in the field of management software business in Vietnam with international standards such as CMMI Level 3, ISO 9001:2015 and ISO 27001:2013.
SureHCS not only meet the professional personnel standards, which are designed to handle the hr – C&B – wages complex, large-scale, multi-company, multi-sector, in particular in accordance with FDI enterprises, corporations, factory, logistics, aviation, hotel, trade – in service.
The system is flexible deployment On-premise or as a custom model in depth, to help businesses automate the entire process hr – attendance – payroll – benefits – insurance, complete replacement job management using Excel discrete.
Feature highlights:
- The Recruit – Training: Management throughout the recruitment, integration, training, hr support and build the Talent Pipeline for large-scale enterprise.
- Port information & records Management personnel: Store personnel records, electronic focus, portal self-service for employees and contract labor power on the system.
- The timekeeper: Dots, multi-form (fingerprint, face recognition, Face ID, GPS, Wifi, online), connect many types of timekeeper, support attendance by the hour, shift flexibility for the plant, and hotels.
- The payroll & C&B: Automatic salary calculation according to many models (hour, shift, product, 3P, KPI performance...), link directly attendance data – performance – welfare, completely replace the salary calculator using Excel.
INTEGRATED AI ACCELERATION CONVERTER OF PERSONNEL
Lac Viet has officially launched The 3 AI assistant hr deeply integrated into the LV SureHCS including LV-AI.Docs, LV‑AI.Resume and LV‑AI.Help to automate the task administration, standardized data enhanced experience personnel
- LV‑AI.Docs: automatic dissection transfer data from documents such as CCCD, windows, SOCIAL insurance, by level of digital records, standardized
- LV‑AI.Resume: analysis of CV auto, construction, candidate profile, find people with the right criteria by prompt intelligent data mining candidate pool efficiency
- LV‑AI.Help: chatbot internal support, answer questions HR 24/7 access form process quick contextual user
TYPICAL CUSTOMERS ARE DEPLOYING LV SUREHCS
SureHCS are trusted and used by many large enterprises and leading corporations such as: Coca-Cola, Takashimaya, Textile Successful Plastic, Long Thanh, Phu Hung Life, the airports of Vietnam (ACV), the enterprise division of SGCthe FDI enterprises in the fields of production, logistics, trade – in service.
- Coca-Cola Vietnam: System deployment LV SureHCS to digitize comprehensive human resource management group has standardized the data, the optimal operating HR according to international model.
- Textile company Success (TCM): Application LV SureHCS to manage hr, payroll, benefits, timekeeping and capacity profile for nearly 5,000 employees across 5 areas of activity – from textiles and fashion to real estate.
- Total company air Port, Vietnam (ACV): Choose to trust LV SureHCS to operate the system large-scale personnel with over 10,000 employees, 24 subdivisions, solved the problem of complex business of modeling state-owned companies.
SureHCS particularly suitable for:
- Large-scale enterprise, from 300 to over 10,000 personnel
- Corporations, businesses, multi-subsidiary, multi-branch
- FDI, manufacturing, factory, logistics, aviation should attendance – analysis ca – salary calculator complex
- Businesses are C&B peculiarities, need custom depths according to the actual operating
- Businesses are personnel management using Excel, many types of timekeeper, need to automate the entire process
SIGN UP TO RECEIVE DEMO NOW
WHY BUSINESSES SHOULD CHOOSE TOUCH THE SUREHCS?
- Customized according to the actual business, no pressure mold as packaged software.
- Handle the personnel – salaries complex that many software HRM other does not respond.
- Deep understanding operated business English & FDI, ensure compliance with legal Vietnam (labour, SOCIAL insurance and personal income tax).
- Ecosystem integration strength: attendance – payroll – bank – SI – electronic contract.
See details, feature & get FREE Demo
CONTACT INFORMATION:
- Hotline: 0901 555 063
- Email: [email protected] | Website: https://www.surehcs.com/
- Office address: 23 Nguyen Thi Huynh, Phu Nhuan, ho chi minh CITY.CITY
Can see, how overtime is not merely applied a formula which is both a process related to determining the right type of overtime, the right frame, working hours, properly applied according to the law, the right wage base. Just the wrong one of these factors, businesses can face risks arrears, internal complaints or disputes prolonged labor.
