How to Compute Payroll in Daily Rate or Monthly Rate

Most companies require 8 hours per day from Monday to Friday on a monthly basis and Monday to Saturday for a daily rate. The minimum wage in the Philippines varies in different regions and the hourly rate computation must be based on the DOLE-provided hourly rate table.

Component of Payroll Computation

Adjustment Pay
Add Back Pay
Other Income
Loans
Allowances

Source of payroll process is coming from the timekeeping processing called as work hour distribution that confirmed by employee and approved by head department prior to payroll processing. HR Payroll System automatically computes salary based on their daily rate, allowance, or other benefits assigned in payroll information in employee table. Mandatory contributions like SSS, Philhealth, HDMF, tax deduction, loan deduction, adjustment pay, other income, and add back pay are automatically computed by the system. Employees with a minimum wage are tax-exempt under the TRAIN Law.

DOLE Hourly Rate Table

Regular Day => Reg Hr = 100.00% / OT Hr = 125.00% / ND Hr = 10.00% / OTND Hr = 137.50%
Rest Day => Reg Hr = 130.00% / OT Hr = 169.00% / ND Hr = 10.00% / OTND Hr = 185.90%
Special Holiday => Reg Hr = 130.00% / OT Hr = 169.00% / ND Hr = 10.00% / OTND Hr = 185.90%
Special Holiday & Rest Day => Reg Hr = 150.00% / OT Hr = 195.00% / ND Hr = 10.00% / OTND Hr = 214.56%
Regular Holiday => Reg Hr = 200.00% / OT Hr = 260.00% / ND Hr = 10.00% / OTND Hr = 286.00%
Regular Holiday & Rest Day => Reg Hr = 260.00% / OT Hr = 338.00% / ND Hr = 10.00% / OTND Hr = 371.80%
Double Holiday => Reg Hr = 300.00% / OT Hr = 390.00% / ND Hr = 10.00% / OTND Hr = 429.00%

Daily Rate Computation Sample (payroll period 15th days coverage last cut-off of the month)

Daily Rate = 950.00

Workhour Distribution

Regular Hours = 96
Regular OT Hours = 35
Rest Day Reg. Hours = 8
Rest Day OTND Hours = 4
Regular Holiday Hours = 8

Salary Computation

Regular Pay = (950 / 8) * 96 = 11,400.00
Regular OT Pay = ((950 / 8) * 1.25) * 35 = 5,195.31
Rest Day Regular Pay = ((950 / 8) * 1.30) * 8 = 1,235.00
Rest Day OTND Pay = ((950 / 8) * 1.859) * 4 = 883.03
Regular Holiday Pay = ((950 / 8) * 2) * 8 = 1,900.00

Gross Income = 20,613.34

Monthly Government Deduction

Monthly Basic Pay = 23,400 -> (11,400.00 + Previous Cut-off Basic Pay: 12,000.00)

SSS Contribution = 1,057.50
HDMF Contribution = 100.00
Philhealth Contribution = 936.00

Total Contribution = 2,093

Taxable Income = 18,520.34 -> (Gross Income - Total Contribution)
The taxable income 18,520.34 from Train Law Semi-Monthly Tax Table is under the salary bracket of 16,667 which the tax due is 1,250.00 + 25% over)

Tax Computation

Tax = 18,520.34 - 16,667 = 1,853.34

Over = 1,853.34 * .25 = 463.34

= 1,250.00 + 463.34

Tax Due = 1,713.34

Net Pay = Gross Income - Total Deduction

= 20,613.34 - (2,093.00 + 1,713.34)

= 16,807.00

Take Home Pay: 16,807.00

Monthly Rate Sample Computation

Monthly Rate: 38,000.00
Hourly Rate = (38,000.00 / 26) / 8 = 182.6923
Constant Total Hours for every cut-off of semi-monthly is 104 hours.
Regular Hours = 104 - (late + under time + (No. of Absent * 8))

Workhour Distribution same above sample

Regular Hours = 96
Regular OT Hours = 35
Rest Day Reg. Hours = 8
Rest Day OTND Hours = 4
Regular Holiday Hours = 8

Salary Computation

Regular Pay = ((38,000.00 / 26) / 8) * 96 = 17,538.46
Regular OT Pay = ((38,000.00 / 26) / 8) * 1.25) * 35 = 7,992.79
Rest Day Regular Pay = ((38,000.00 / 26) / 8) * 1.30) * 8 = 1,900.00
Rest Day OTND Pay = ((38,000.00 / 26) / 8) * 1.859) * 4 = 1,358.50
Regular Holiday Pay = ((38,000.00 / 26) / 8) * 2) * 8 = 2,923.08

Gross Income = 31,712.83

Monthly Government Deduction

Monthly Basic Pay = 36,538.46 -> (17,538.46 + Previous Cut-off Basic Pay: 19,000.00)

SSS Contribution = 1,125.00
HDMF Contribution = 100.00
Philhealth Contribution = 1,461.54

Total Contribution = 2,686.54

Taxable Income = 29,026.29 -> (Gross Income - Total Contribution)

The taxable income 29,026.29 from Train Law Semi-Monthly Tax Table is under the salary bracket of 16,667 which the tax due is 1,250.00 + 25% over)

Tax Computation

Tax = 29,026.29 - 16,667 = 12,359.29

= 12,359.29 * .25 = 3,089.82

= 1,250.00 + 3,089.82

Tax Due = 4,339.82

Net Pay = Gross Income - Total Deduction

= 31,712.83 - (2,686.54 + 4,339.82)

= 24,686.47

Take Home Pay: 24,686.47

LATEST BLOG POST

HRIS: Payroll Process

The payroll process involves calculating and disbursing employee salaries, wages, and benefits on a regular basis. Stay updated with employment laws, tax regulations, and other relevant compliance requirements to ensure accurate payroll processing and avoid penalties or legal issues.

HRIS: Timekeeping Process

Implementing an effective timekeeping process helps ensure accurate payroll calculations, compliance with labor laws, and fair compensation for employees' work hours. It also provides valuable data for analyzing workforce productivity and resource allocation.

HRIS: Recruitment and Training

Recruitment and training should be ongoing processes to attract and retain top talent and ensure the team is equipped with the necessary skills and knowledge to meet organizational goals.

HRIS: Human Resources

Human resources (HR) is a crucial department within an organization that focuses on managing and developing the people who work for the company. The HR department is responsible for various functions related to employee recruitment, hiring, training, performance management, benefits administration, and employee relations.

Understanding the Basics of Payroll Processing

Payroll processing is the administrative task of calculating and distributing employee salaries and benefits. It involves several steps, including collecting and verifying employee time and attendance data, calculating wages and deductions, and generating paychecks or direct deposits.

DTR Timekeeping Tips: Do's and Don'ts

Employers must keep accurate records of non-exempt employees work hours to comply state and local laws. This straightforward process can become complex when employees start work early or leave late, travel for business, participate in company trainings, and use mobile devices to remain connected to work after-hours.

Employee Timekeeping: Tool to Improve Efficiency and Accuracy

Overall, implementing a reliable timekeeping tool can significantly improve efficiency and accuracy in employee time tracking. It streamlines processes, reduces errors, ensures compliance, and provides valuable data for decision-making.

Automate Loans Deduction using Payroll Setup

By following these steps, you can automate loan deductions using payroll setup, saving time and ensuring accuracy in loan repayments for your employees.

Transforming HR into Digital Through Technology

By embracing technology and digitizing HR processes, organizations can streamline operations, improve employee experience, and enable HR professionals to focus on strategic initiatives that drive business success.

Timekeeping and Attendance Setup

Specific setup and configuration of your timekeeping and attendance system will depend on the unique needs and requirements of your organization. It's important to adapt these steps to fit your specific circumstances and consult with HR professionals or software providers for guidance.

Tips how to start?

Create an account.
Verify the account via email sent by the system after registration is completed.
Fill-up the form available in your dashboard account and wait for admin approval.
After your account is approved the first step to do is create a department located at HRD -> Tools -> Department.
Now ready to create employee master data located at HRD -> Employees.
Steps How to Test and Explore HRIS and Payroll System.
Explore the HR Payroll user guide manual as reference for self-testing.

Free Online Tools

Contact Us, those organizations need to modernize HR Management Tools and a paperless solution to speed-up the entire process of human resources and the automation of timekeeping to payroll processing that every process module has approvals.