Financial Report Template Sslg

STANDARD OPERATING PROCEDURE: SSLG FINANCIAL REPORTING & LIQUIDATION FRAMEWORK

---

1. Document Control Block

---

2. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the operational baseline for standardizing, recording, reconciling, and liquidating financial transactions under the Supreme Secondary Learner Government (SSLG).

The primary objective is to enforce 100% auditability, zero-variance reconciliation, and strict compliance with national learner government fund handling policies and Department of Education (DepEd) operational guidelines. This SOP establishes the single source of truth for generating quarterly, semestral, and end-of-term financial statements.

---

3. Scope & Prerequisites

3.1 Boundaries

• In-Scope: SSLG internal operational budgets, student-led project financing, accredited donations/solicitations, school-subsidized operational funds, and income-generating project (IGP) proceeds.
• Out-of-Scope: School-level MOOE (Maintenance and Other Operating Expenses), general PTA accounts, and external club funds not integrated into the central SSLG budget.

3.2 Required Tools & Infrastructure

• SSLG Standard Financial Ledger Template (Google Sheets / Microsoft Excel with workbook locking).
• Physical Asset: Secured Petty Cash Box with dual-combination access.
• Document Retention: Fireproof archival binder with pre-numbered voucher tabs.
• Software/Access: Secure institutional cloud drive, scanning hardware/mobile scanner (600 DPI PDF output).

---

4. Roles & Responsibilities (RACI Matrix)

Legend: R = Responsible | A = Accountable | C = Consulted | I = Informed

---

5. Standard Financial Architecture (SSLG Template Schema)

The core workbook must maintain strict sheet-level separation:

[SSLG_Financial_Engine.xlsx]
 ├── 01_SUMMARY_DASHBOARD       (Read-Only: KPI roll-ups, Net Position)
 ├── 02_STATEMENT_RECEIPTS_DISB (Formal DepEd Reporting Template)
 ├── 03_JOURNAL_INFLOW          (Cash Inflow: Fees, Grants, Solicitations)
 ├── 04_JOURNAL_OUTFLOW         (Cash Outflow: Line-item expenditures)
 └── 05_AUDIT_LOG_TRACKER       (Immutable validation logs)

---

6. Step-by-Step Procedure

===================================================================================
                   SSLG FINANCIAL REPORTING WORKFLOW PIPELINE
 [Phase 1: Inflow] -> [Phase 2: Disbursement] -> [Phase 3: Reconciliation] -> [Phase 4: Audit]
===================================================================================

Phase 1: Revenue Intake and Inflow Documentation

• 1.1 Issue Official Documentation: For any funds received (IGP, donations, authorized subsidies), issue a Pre-numbered Official Receipt (OR) or Acknowledgment Receipt (AR) immediately to the payor/source.
• 1.2 Classify Fund Code: Tag the intake under one of four approved SSLG Fund Classes:
  • FC-01: Operational Subsidy
  • FC-02: Special Project Allocation
  • FC-03: Accredited Donation / Sponsorship
  • FC-04: Income Generating Project (IGP)
• 1.3 Ledger Entry: Record the transaction in 03_JOURNAL_INFLOW within 24 hours of intake. Populate: Date, Receipt ID, Source, Description, Amount, and Depository Target (Bank Account or Petty Cash Safe).

---

Phase 2: Expense Authorization and Disbursement

• 2.1 Prepare Disbursement Voucher (DV): Draft a standard SSLG-DV before releasing any funds. Populate:
  • Project Reference (Activity Proposal ID)
  • Payee / Requesting Committee
  • Itemized expenditure list matching the approved activity budget
• 2.2 Gather Pre-Approval Signatures:
  • Route DV to the SSLG Treasurer (Funds Availability Certification).
  • Route DV to the SSLG President (Authorization).
  • Route DV to the SSLG Teacher-Adviser (Administrative Concurrence).
• 2.3 Fund Release & Receipt Collection:
  • Disburse approved funds.
  • Require the purchasing officer to return all original tax invoices/sales receipts within 48 hours of transaction completion.
  • Attach all receipts directly behind the authorized DV.
• 2.4 Ledger Entry: Record in 04_JOURNAL_OUTFLOW with DV ID, Invoice Number, Expense Code (e.g., EXP-LOG Logistics, EXP-MAT Materials, EXP-FND Food/Refreshments), and Total Amount.

---

Phase 3: Periodic Reconciliation & Report Generation

• 3.1 Physical Cash vs. Ledger Balance Check:
  • Execute a physical count of the cash box.
  • Verify bank balance via latest official bank statement (if operating an institutional student fund account).
  • Confirm that: $$\text{Physical Cash} + \text{Bank Balance} \equiv \sum \text{Inflow} - \sum \text{Outflow}$$
• 3.2 Populate Statement of Receipts and Disbursements (SRD):
  • Run automatic rollup to 02_STATEMENT_RECEIPTS_DISB.
  • Ensure zero variance in the reconciliation row: $$\text{Variance} = \text{Ending Balance}{\text{Computed}} - \text{Ending Balance}{\text{Actual}} = 0.00$$
• 3.3 Compile Supporting Documentation Binder:
  • Tab 1: Approved Activity Proposals and Approved Project Budgets
  • Tab 2: DVs arranged sequentially with matching original receipts
  • Tab 3: Monthly/Quarterly Reconciliation Printouts

---

Phase 4: Audit, Liquidation, and Public Disclosure

• 4.1 Auditor Review:
  • The SSLG Auditor must perform an independent line-by-line verification of all journal entries against physical receipts.
  • Check for missing receipts, non-allowable expenses, or mathematical errors.
  • Execute the Audit Sign-off Form inside the workbook.
• 4.2 Administrative Liquidation:
  • Submit the finalized Financial Report package to the SSLG Teacher-Adviser.
  • Submit to the School Head / Principal for formal notation and institutional liquidation clearance.
• 4.3 Transparency Compliance (Public Disclosure):
  • Print the verified STATEMENT_RECEIPTS_DISB (Summary Level).
  • Post the signed report on the official SSLG Transparency Board and the school’s verified public channel within 5 business days of quarter end.

---

7. Quality Assurance, Compliance Metrics & Pro-Tips

Key Performance Indicators (KPIs)

• Reconciliation Accuracy: $0.00$ discrepancy between General Ledger and physical/bank balances.
• Receipt Capture Rate: $100%$ compliance. No DV marked liquidated without attached BIR-registered receipts or signed official Acknowledgment Receipts (for market items lacking formal receipts).
• Liquidation Turnaround: Total liquidation processed $\le 5\text{ days}$ after project execution.

Common Failure Modes & Mitigations

• Pitfall 1: "Lost" receipts for cash purchases.
  • Mitigation: Issue an immediate Affidavit of Loss with Itemized Proof of Purchase, co-signed by two independent committee witnesses and endorsed by the SSLG Adviser. Limit usage of this mitigation to $< 2%$ of total project expenses.
• Pitfall 2: Commingling personal funds with SSLG funds.
  • Mitigation: Absolute prohibition against transferring SSLG funds to personal digital wallets (GCash, Maya) without documented approval from the SSLG Adviser.
• Pitfall 3: Retroactive approvals.
  • Mitigation: Zero disbursements without an approved DV. Any expense incurred prior to DV approval must be classified as an unauthorized personal expense.

---

8. Frequently Asked Questions (Operational Troubleshooting)

Q1: What constitutes valid documentation for expenses where suppliers cannot issue Official Invoices (e.g., local market, transport)?

Answer: Prepare a standard SSLG Acknowledgment Receipt (AR) containing the vendor's full legal name, contact number, date, exact goods/services rendered, unit cost, and physical signature. The purchaser must also sign as the certifying officer.

Q2: How should unexpected leftover petty cash from an activity advance be recorded?

Answer: The remaining balance must be returned to the SSLG Treasurer within 24 hours of event completion. The Treasurer records a Disbursement Adjustment (Credit Outflow) referencing the original DV number, reducing the net expense of the project to match actual receipts and restoring the cash-on-hand total.

Q3: What happens if there is an unresolvable cash shortage during audit?

Answer: The primary custodian (SSLG Treasurer) is held personally accountable for the variance. The SSLG Auditor and Adviser must freeze further cash advances, file an Audit Discrepancy Notice, and mandate full restitution of the missing amount within 72 hours before forwarding the report to the School Principal.