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

Oct 24, 2025

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.0020
Controller Execution Time ( Jobseekers / Job )  0.0138
Total Execution Time  0.0176
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,504,576 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.0076 seconds)  (Hide)
0.0013   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1498051
 LIMIT 1 
0.0004   SELECT *
FROM `employers`
WHERE `employer_id` = 277097
 LIMIT 1 
0.0010   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.0004   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-17',ej.date_added) duration_daysDATEDIFF('2026-04-17',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-04-17',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1498051' 
0.0003   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-14-2026=1***Apr-17-2026=1' WHERE job_id'1498051'  
0.0008   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=19' WHERE job_id'1498051'  
0.0009   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1498051' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1498051 
0.0005   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '277097'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0002   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)