Payroll Process Specialist (Documentation & Excel Improvement)

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Gig

SALARY

Please indicate your hourly rate in PHP

HOURS PER WEEK

15

DATE UPDATED

Jul 9, 2026

JOB OVERVIEW

Job Overview

We need someone to review and improve our existing payroll process.
You’ll make our current Excel payroll file more reliable and organized, and document each step of the process clearly so it’s easy to follow in the future.
You will not compute payroll; this project is only about improving and documenting the system.

Main Tasks

* Review our current payroll flow from attendance checking to payout.
* Improve the structure and formulas in our existing payroll Excel file.
* Write a clear step-by-step process document that explains how payroll should be done.
* Suggest simple improvements to make the process faster and more accurate.

Requirements

* Experience with Philippine payroll (SSS, Pag-IBIG, PhilHealth, tax).
* Strong Excel skills (formulas, data validation, layout improvement).
* Able to write clear and organized process documentation.
* Trustworthy with confidential data.

How to Apply

Send a message through OnlineJobs.ph with:

1. Subject line: Payroll Process Specialist
2. Your hourly rate in PHP
3. A short summary (3–5 sentences) of your payroll experience
4. A sample process or documentation you created in the past (can be redacted or anonymized)
5. (Optional) A screenshot or sample of a payroll Excel file you improved

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0300
Total Execution Time  0.0313
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,509,120 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Payroll-Process-Specialist-Documentation-Excel-Improvement-1498051
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0240 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1498051
 LIMIT 1 
0.0016   SELECT *
FROM `employers`
WHERE `employer_id` = 277097
 LIMIT 1 
0.0027   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1498051
AND `misc`.`idIS NULL 
0.0005   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-08-12',ej.date_added) duration_daysDATEDIFF('2026-08-12',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-08-12',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1498051' 
0.0007   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1498051 
0.0009   UPDATE employer_jobs SET hit_counts '***Oct-24-2025=358***Oct-25-2025=42***Oct-26-2025=28***Oct-27-2025=37***Oct-28-2025=12***Oct-29-2025=9***Oct-30-2025=6***Oct-31-2025=4***Nov-01-2025=7***Nov-02-2025=4***Nov-03-2025=6***Nov-04-2025=8***Nov-05-2025=11***Nov-06-2025=5***Nov-07-2025=3***Nov-08-2025=3***Nov-10-2025=18***Nov-11-2025=16***Nov-12-2025=13***Nov-13-2025=1***Nov-14-2025=3***Nov-16-2025=2***Nov-17-2025=4***Nov-18-2025=3***Nov-19-2025=1***Nov-20-2025=3***Nov-21-2025=3***Nov-22-2025=1***Nov-23-2025=2***Nov-25-2025=1***Nov-26-2025=2***Nov-27-2025=4***Nov-28-2025=2***Nov-29-2025=1***Nov-30-2025=1***Dec-01-2025=3***Dec-02-2025=3***Dec-03-2025=1***Dec-05-2025=2***Dec-06-2025=2***Dec-08-2025=1***Dec-09-2025=5***Dec-10-2025=2***Dec-11-2025=5***Dec-14-2025=1***Dec-15-2025=2***Dec-16-2025=1***Dec-17-2025=2***Dec-18-2025=1***Dec-19-2025=1***Dec-20-2025=3***Dec-21-2025=1***Dec-22-2025=6***Dec-23-2025=1***Dec-26-2025=1***Dec-27-2025=2***Dec-28-2025=2***Dec-29-2025=2***Dec-30-2025=2***Jan-01-2026=1***Jan-02-2026=3***Jan-03-2026=2***Jan-05-2026=2***Jan-06-2026=1***Jan-09-2026=2***Jan-12-2026=1***Jan-15-2026=3***Jan-16-2026=8***Jan-17-2026=2***Jan-18-2026=1***Jan-19-2026=1***Jan-20-2026=1***Jan-22-2026=1***Jan-23-2026=1***Jan-24-2026=3***Jan-25-2026=1***Jan-27-2026=2***Jan-28-2026=1***Jan-31-2026=2***Feb-01-2026=1***Feb-02-2026=1***Feb-03-2026=4***Feb-04-2026=1***Feb-05-2026=4***Feb-06-2026=2***Feb-07-2026=1***Feb-10-2026=2***Feb-11-2026=2***Feb-12-2026=1***Feb-13-2026=2***Feb-15-2026=1***Feb-16-2026=1***Feb-18-2026=1***Feb-21-2026=1***Feb-22-2026=1***Feb-23-2026=2***Feb-24-2026=2***Feb-25-2026=2***Feb-26-2026=4***Feb-27-2026=2***Feb-28-2026=1***Mar-01-2026=2***Mar-02-2026=3***Mar-05-2026=1***Mar-06-2026=5***Mar-07-2026=1***Mar-10-2026=4***Mar-12-2026=4***Mar-13-2026=5***Mar-15-2026=1***Mar-16-2026=3***Mar-17-2026=1***Mar-18-2026=3***Mar-19-2026=2***Mar-20-2026=1***Mar-21-2026=2***Mar-23-2026=2***Mar-24-2026=1***Mar-25-2026=2***Mar-27-2026=6***Mar-30-2026=1***Mar-31-2026=2***Apr-01-2026=4***Apr-02-2026=1***Apr-05-2026=1***Apr-06-2026=2***Apr-08-2026=1***Apr-10-2026=6***Apr-11-2026=2***Apr-12-2026=1***Apr-14-2026=2***Apr-15-2026=1***Apr-16-2026=2***Apr-17-2026=2***Apr-18-2026=2***Apr-20-2026=5***Apr-21-2026=4***Apr-22-2026=2***Apr-24-2026=5***Apr-25-2026=2***Apr-27-2026=4***Apr-29-2026=1***Apr-30-2026=2***May-01-2026=1***May-02-2026=1***May-03-2026=2***May-04-2026=1***May-05-2026=3***May-06-2026=3***May-09-2026=1***May-11-2026=1***May-12-2026=1***May-13-2026=3***May-14-2026=1***May-16-2026=2***May-17-2026=1***May-18-2026=2***May-19-2026=1***May-20-2026=1***May-21-2026=2***May-22-2026=2***May-24-2026=1***May-26-2026=2***May-27-2026=2***May-28-2026=1***May-29-2026=1***May-30-2026=1***May-31-2026=1***Jun-02-2026=2***Jun-03-2026=1***Jun-04-2026=2***Jun-06-2026=1***Jun-07-2026=1***Jun-09-2026=1***Jun-10-2026=1***Jun-12-2026=1***Jun-14-2026=1***Jun-15-2026=1***Jun-16-2026=1***Jun-17-2026=2***Jun-18-2026=2***Jun-19-2026=1***Jun-20-2026=2***Jun-22-2026=4***Jun-23-2026=1***Jun-24-2026=1***Jun-25-2026=1***Jun-26-2026=1***Jun-28-2026=6***Jun-29-2026=1***Jul-01-2026=2***Jul-03-2026=1***Jul-04-2026=1***Jul-09-2026=838***Jul-10-2026=56***Jul-11-2026=40***Jul-12-2026=26***Jul-13-2026=33***Jul-14-2026=13***Jul-15-2026=13***Jul-16-2026=15***Jul-17-2026=24***Jul-18-2026=12***Jul-19-2026=6***Jul-20-2026=15***Jul-21-2026=12***Jul-22-2026=8***Jul-23-2026=10***Jul-24-2026=2***Jul-26-2026=3***Jul-27-2026=7***Jul-28-2026=14***Jul-29-2026=7***Jul-30-2026=15***Jul-31-2026=13***Aug-01-2026=3***Aug-02-2026=3***Aug-03-2026=7***Aug-04-2026=3***Aug-05-2026=16***Aug-06-2026=5***Aug-07-2026=4***Aug-08-2026=1***Aug-12-2026=1' WHERE job_id'1498051'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Oct-2025=496***Nov-2025=128***Dec-2025=52***Jan-2026=39***Feb-2026=39***Mar-2026=52***Apr-2026=52***May-2026=38***Jun-2026=35***Jul-2026=1184***Aug-2026=43' WHERE job_id'1498051'  
0.0027   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1498051' AND status LIKE 'sent%' ORDER BY id DESC  
0.0004   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1498051 
0.0124   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '277097'
AND `date_added` >= '2022-06-08' 
0.0004   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)