Practical PH Local Payroll Experience (Must-Have):
- At least 2+ years of hands-on experience preparing or auditing Philippine local payroll.
- Deep practical knowledge of BIR tax rules (Form 1601-C calculations), SSS/PhilHealth/Pag-IBIG tables, and DOLE labor standards regarding variable pay components.
Key Responsibilities
- High-Volume Data Processing & Input (MS Excel):
- Rapidly collect, normalize, and input raw operational data (timecard logs, overtime sheets, on-call hours, and Sick/Vacation leave filings) into master Excel working papers.
- Perform end-to-end bi-monthly salary calculations (1st and 2nd pay period cutoffs) with strict precision, following established calculation protocols step-by-step.
- Philippine Statutory, Tax & DOLE Premium Calculations:
- Calculate and review employee and employer statutory contributions in compliance with current SSS, PhilHealth, and Pag-IBIG rules.
- Compute monthly withholding taxes on compensation based on current BIR Tax Tables, including proper application of taxable vs. non-taxable income (e.g., De Minimis allowances, 13th-month threshold).
- Apply DOLE Premium Rates & Multipliers according to law and company policy.Instruction Following, Quality Control & Audit.
- Strictly adhere to standard operating guidelines and Mich's payroll processing workflows without skipping verification steps.
- Build and maintain conditional checks, validation rules, and error flags in Excel to catch data discrepancies (e.g., missing time-ins, duplicate entries, negative net pay).
- Perform thorough pre-payroll and post-payroll self-audits prior to submitting work for final approval.
- Workbook Optimization:
- Assist in standardizing, locking, and structuring Excel master templates to streamline data entry, automate cross-referencing (XLOOKUP, SUMIFS), and reduce manual processing friction for future cycles.
Required Skills & Qualifications
- Procedural Discipline & Focus (Must-Have):
- Proven track record of high focus and meticulous attention to detail when working with numbers under repetitive or high-volume conditions.
- Demonstrated ability to follow detailed instructions, SOPs, and DOLE/company calculation logic precisely without making assumptions or unauthorized alterations.
- Technical MS Excel Expertise (Must-Have):
- Advanced mastery of Excel formulas and functions (XLOOKUP, INDEX-MATCH, nested IFs, SUMIFS, dynamic arrays).
- Proficiency in Power Query and Pivot Tables for fast data cleaning, merging, and ingestion.
- Rapid, error-free numerical data entry skills.
- Soft Skills & Work Style:
- Strict adherence to the Data Privacy Act (DPA) when handling sensitive employee pay and personal data.
- Structured, methodical mindset (measure twice, cut once execution).
- High composure and reliability under uncompromising pay-period deadlines.
Work setup: Hybrid (2-3x rto a month)
Working hours: 9am to 6pm
Interested applicant can send CV to [Confidential Information]
