Payroll Template for Sk Honorarium

Standard Operating Procedure: SK Honorarium Payroll Template Generation & Disbursement

---

1. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the institutional framework for designing, validating, and executing payroll templates for Sangguniang Kabataan (SK) honoraria. In compliance with Republic Act No. 10742 (SK Reform Act of 2015) and pertinent Commission on Audit (COA) circulars, this document ensures the accurate computation, statutory deduction alignment, and auditable disbursement of monthly allowances for SK officials.

Adherence to this protocol mitigates financial non-compliance, prevents disbursement suspensions, and establishes an immutable, transparent paper trail for municipal budget audits.

---

2. Scope & Prerequisites

Scope

This procedure applies to all Chief Financial Officers, Municipal Accountants, SK Treasurers, and Template Registry systems engineers responsible for configuring, deploying, or auditing SK payroll templates across Local Government Units (LGUs).

Prerequisites & Required Tools

• Software Environment: Microsoft Excel 2019+, Google Sheets (Enterprise Workspace), or local LGU-approved financial management information systems (FMIS).
• Legislative References: RA 10742, Local Budget Memorandum (LBM) current issuances, and pertinent DILG-DBM-NYC Joint Memorandums.
• Data Inputs:
  • Approved annual SK budget allocation (maximum of 25% of the SK Fund for personnel services, inclusive of honoraria).
  • Official roster of SK officials (Chairperson, 7 Councilors, Treasurer, Secretary).
  • Official attendance logs for regular and special plenary sessions (mandatory verification for honoraria entitlement).
• Security & Access: Role-Based Access Control (RBAC) tokens for financial database writes; encrypted template storage.

---

3. Roles & Responsibilities (RACI Matrix)

• R - Responsible (The role that performs the activity)
• A - Accountable (The role with final approval and ownership)
• C - Consulted (The role providing advisory input)
• I - Informed (The role kept updated on progress)

---

4. Step-by-Step Procedure

Phase 1: Template Architecture & Schema Setup

• Initialize a secure, version-controlled spreadsheet workspace utilizing the Template Registry financial ledger standard.
• Configure header metadata fields: LGU Name, Barangay, Applicable Month/Year, and SK Fund Source Code.
• Establish tabular data columns with strict data typing:
  • Column A: Employee/Official ID
  • Column B: Full Legal Name (Last Name, First Name, Middle Initial)
  • Column C: Official Designation (Chairperson, Councilor, Treasurer, Secretary)
  • Column D: Maximum Authorized Monthly Honorarium (PHP)
  • Column E: Session Attendance Multiplier / Proration Factor
  • Column F: Gross Honorarium Earned
  • Column G: Mandatory Deductions (PhilHealth, Pag-IBIG, tax withholdings if applicable)
  • Column H: Net Amount Payable
  • Column I: Disbursement Reference / Voucher Number
  • Column J: Sign-off / Acknowledgement Receipt Flag

Phase 2: Data Population & Attendance Cross-Verification

• Import verified roster data into Columns A through C, ensuring zero typography variances against official appointment papers.
• Input the baseline authorized honorarium rates in Column D, confirming they do not exceed the statutory cap relative to the LGU income class and total SK funds.
• Cross-reference Column E with the certified SK Secretary session logs; apply proration formulas for unexcused absences pursuant to internal SK internal rules.
• Execute formula checks for Gross Honorarium ($Gross = Rate \times Attendance_Factor$).

Phase 3: Compliance & Statutory Validation

• Verify that the sum of all gross honoraria does not breach the 25% statutory ceiling for Personnel Services under the SK Fund ($Total_PS \le 0.25 \times Total_SK_Funds$).
• Apply applicable statutory contributions (e.g., GSIS, PhilHealth, Pag-IBIG) dynamically via locked formula cells in Column G to prevent manual override errors.
• Calculate Net Amount Payable via protected algorithmic subtraction ($Net = Gross - Deductions$).
• Run an automated error check script to flag negative net values, duplicate IDs, or missing data strings.

Phase 4: Authorization, Sign-Off, & Export

• Generate the summary block displaying Total Gross, Total Deductions, and Total Net Disbursement.
• Route the draft sheet to the SK Treasurer for initial data validation and certification of fund availability.
• Submit the verified template to the Municipal Accountant for pre-audit and Obligation Request and Status (ORS) generation.
• Export the final validated template into a read-only, digitally signed PDF format alongside the native calculation file for the municipal disbursement voucher package.

---

5. Quality Assurance & Pro-Tips

Best Practices

• Immutable Formulas: Lock all computation cells (Gross, Net, Totals) with strong administrative passwords to prevent unauthorized cell alterations during data entry.
• Dynamic Date Validation: Implement dynamic date dropdowns to prevent retroactive or post-dated payroll cycle generation.
• Audit Trail Maintenance: Retain historical template versions in a dedicated, read-only directory for a minimum of ten (10) years in compliance with COA retention schedules.

Common Pitfalls to Avoid

• Pitfall: Disbursing honoraria without verifying quorum and session attendance sheets. Mitigation: Hardcode a dependency cell that requires an attendance validation code before the net pay formula populates.
• Pitfall: Exceeding the 25% Personnel Services cap due to mid-year honorarium rate adjustments. Mitigation: Embed an automated ceiling-alert conditional formatting rule that turns the total budget row red if the threshold exceeds 24.5%.

Performance Metrics & Thresholds

• Error Rate: Target 0% mathematical discrepancy upon initial municipal pre-audit.
• Processing Velocity: Template generation to final disbursement voucher routing must not exceed 3 business days post-month-end.

---

6. Frequently Asked Questions (FAQ)

Q1: What happens if an SK official fails to attend the mandatory monthly plenary sessions? A: Pursuant to internal rules and standard administrative guidelines, unexcused absences result in a proportional reduction of the honorarium. The template's Attendance Multiplier (Column E) must be adjusted downward using the formula: $Factor = Sessions_Attended / Total_Mandatory_Sessions$.

Q2: Can the template be modified to include hazard pay or year-end bonuses? A: No. SK honoraria are strictly regulated. Unless explicitly authorized by national legislative amendments or DBM-NYC issuances specific to extraordinary circumstances, adding unauthorized line items will trigger an immediate COA audit suspension.

Q3: How are system lockouts managed if the SK Treasurer inputs incorrect data? A: The Template Registry Architect or Municipal Accountant holds master override credentials. Corrections require an official adjustment log entry, signed by both the SK Treasurer and Municipal Accountant, prior to unlocking the targeted cells.