Standard Operating Procedure: DepEd Payroll Verification

Standard Operating Procedure: Department of Education (DepEd) Payroll Generation & Institutional Verification

---

1. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the institutional engineering standard for compiling, auditing, and executing payroll samples for the Department of Education (DepEd). Operating under strict compliance with the Philippine Government Accounting Manual (PGAM), Government Service Insurance System (GSIS) guidelines, Home Development Mutual Fund (Pag-IBIG), Philippine Health Insurance Corporation (PhilHealth), and Bureau of Internal Revenue (BIR) statutory matrices, this document ensures deterministic calculation of gross earnings, mandatory deductions, net take-home pay, and generation of the electronic remittance file (ERF) to eliminate variance and fiscal leakage.

---

2. Scope & Prerequisites

2.1 Scope

This protocol applies to all payroll systems, human resource information systems (HRIS), and financial processing units generating school-division, district-level, or institutional-wide payroll registries for DepEd teaching and non-teaching personnel.

2.2 Prerequisites & Tools

• Software Suite: Enterprise HRIS, Microsoft Excel 365 (with macros enabled for validation scripts), SAP ERP Financials (or equivalent public sector ledger), and PhilGEPS-integrated banking gateways (Land Bank of the Philippines Link.BizPortal).
• Access Credentials: Active Government Enterprise Network (GEN) credentials, Bureau of Treasury Cash Management System token, and multi-factor authentication (MFA) keys for Regional Payroll Services (RPSU) portals.
• Reference Tables: Current BIR withholding tax tables (TRAIN Law compliant), updated GSIS premium contribution schedules (9% Personal Share, 12% Government Share), PhilHealth premium rates, and Pag-IBIG Fund I/II contribution matrices.

---

3. Roles & Responsibilities

---

4. Step-by-Step Procedure

Phase 1: Data Ingestion and Attendance Validation

• 1.1 Export the monthly consolidated Electronic Personnel and Records System (EPRS) data dump to verify active status, salary grade step increments, and plantilla item numbers.
• 1.2 Reconcile the Daily Time Records (DTR) and Form 48 submissions against approved Leave Applications (Civil Service Form No. 6) to compute fractional attendance or absence-without-official-leave (AWOL) deductions.
• 1.3 Validate all newly promoted or newly appointed personnel against the authorized Plantilla of Personnel (PSIPOP).

Phase 2: Gross Pay Computation

• 2.1 Calculate the basic monthly salary (BMS) corresponding to the approved Salary Grade and Step Increment under the prevailing Salary Standardization Law (SSL).
• 2.2 Aggregate authorized allowances and incentives, including Personnel Economic Relief Allowance (PERA), Additional Compensation (ADCOM), and hazard/special hardship pay (where applicable).
• 2.3 Compute overtime pay, night differential, or honoraria strictly backed by pre-approved administrative authorities and actual output logs.

Phase 3: Statutory and Voluntary Deductions

• 3.1 Compute the GSIS Life and Retirement Insurance contributions ($9%$ of Monthly Basic Salary).
• 3.2 Compute PhilHealth contributions based on current statutory percentage brackets applied to the monthly basic salary floor/ceiling.
• 3.3 Compute Pag-IBIG (HDMF) Regular Savings contributions (typically $1%$ or $2%$ depending on the monthly salary threshold).
• 3.4 Calculate the BIR Withholding Tax on Compensation using the annualized or current graduated tax table, ensuring tax exemptions for minimum wage earners (MWE) are isolated.
• 3.5 Process institutional loan deductions (GSIS Policy/Consolidated Loans, Pag-IBIG Multi-Purpose Loans, First Valley Bank, or accredited provincial cooperative amortizations) verifying that the net take-home pay does not drop below the statutory floor (PHP 5,000.00) per General Appropriations Act (GAA) mandates.

Phase 4: Net Pay Calculation and Registry Generation

• 4.1 Execute the net pay equation: $$\text{Net Pay} = (\text{Basic Salary} + \text{Allowances}) - (\text{GSIS} + \text{PhilHealth} + \text{Pag-IBIG} + \text{Tax} + \text{Loans})$$
• 4.2 Populate the Standard DepEd Payroll Register template, ensuring explicit separation of columns for Personal Services (PS) cost items.
• 4.3 Run the verification macro script to check for NaN, negative net values, or duplicate Permanent Account Numbers (PAR).

Phase 5: Certification, Authorization, and Disbursement

• 5.1 Route the compiled payroll registry to the Accountant III for certification of financial availability and budgetary allocation.
• 5.2 Secure the formal approval signature from the Schools Division Superintendent (SDS) or authorized Regional Director.
• 5.3 Generate the Advice to Debit Account (ADA) and Electronic Remittance File (ERF) packages for direct transmission to the servicing government depository bank (Land Bank of the Philippines).

---

5. Quality Assurance & Pro-Tips

Best Practices

• Deterministic Checksums: Always verify that the sum of all individual net pays plus total deductions equals the grand total gross pay before routing for signatures.
• Segregation of Duties: Ensure the personnel compiling the payroll (HRMO/Accountant) do not possess authorization to upload the ADA file to the banking portal.

Common Pitfalls

• Net Take-Home Pay (NTHP) Violation: Failing to trap loan deductions that breach the mandatory statutory take-home pay floor, resulting in automatic rejection by the COA pre-audit.
• Outdated Contribution Tables: Utilizing legacy GSIS or PhilHealth percentage brackets following a national policy update.

Metric Thresholds

• Processing Error Rate: $\le 0.00%$ variance across statutory deduction calculations.
• Disbursement Cycle Time: Complete execution from data ingestion to bank transmission within $\le 5$ business days prior to the scheduled pay date (15th and 30th of the month).

---

6. Frequently Asked Questions (FAQ)

Q1: What happens if an employee's net take-home pay falls below the statutory minimum due to multiple overlapping loans?
A: Under the General Appropriations Act, priority is given to mandatory government deductions (GSIS, PhilHealth, Pag-IBIG, BIR). Voluntary institutional loans and cooperative amortizations must be systematically deferred or structurally reduced in hierarchy order until the net take-home pay equals or exceeds the PHP 5,000.00 statutory floor.

Q2: How are salary adjustments for mid-month promotions processed within the payroll sample?
A: The system calculates prorated pay based on the effectivity date stated in the approved appointment letter. Days worked prior to the effectivity date use the old salary grade step; days following use the new step, merged into a single consolidated line item with accompanying adjustment remarks in the payroll register notes.

Q3: What is the mandatory protocol if an electronic remittance file (ERF) fails bank validation?
A: Immediately halt the disbursement queue. Isolate the error logs generated by the depository bank gateway, correct the anomalous records (such as mismatched TIN, incorrect GSIS BP Number, or truncated account titles) in the staging environment, regenerate the checksum hash, and re-submit with an amended transmittal letter countersigned by the Accountant.