SKULITECH ERP BUILD VALIDATION REPORT
Payments, Expenses and Payroll Controls Upgrade
Date: 2026-07-24

SOURCE PACKAGE
- Uploaded package SHA-256:
  22a46a8a202f8576f7c9a4dcbbfd2b9f2ac4acb79b8f37fa4f5d05300ca13b7c

SCOPE CONTROL
- Existing student payments, sponsor/HELB allocation, unallocated receipts,
  bank reconciliation, supplier payment vouchers, procurement three-way
  matching, imprests, general ledger, budgets, assets, payslips and P9
  functions were retained.
- New code was limited to missing staff expense, recurring expense,
  accrual/prepayment, petty-cash, payroll-batch, payroll-rule, statutory
  remittance and integration controls.
- Posted legacy Income/Expense entries now use reversal plus replacement
  corrections. Posted accounting journals are not deleted or overwritten.

STATIC VALIDATION
- PHP files checked: 210
- PHP syntax errors: 0
- Literal app_url targets checked: 427
- Missing literal app_url targets: 0
- Literal __DIR__ include/require targets checked: 1062
- Missing include/require targets: 0
- Required new module/helper/migration files missing: 0
- Destructive accounting-journal DELETE statements in corrected legacy
  Income/Expense flow: 0

DATABASE ARTIFACT VALIDATION
- Migration: 20260724_011_payments_expenses_payroll_controls.sql
- Migration statements parsed: 42
  * CREATE TABLE statements: 11
  * ALTER TABLE statements: 27
  * INSERT statements: 4
- Unclosed SQL quotes or block comments: 0
- Compiled current-schema statements parsed: 317
- Migration SHA-256:
  ea5599fc9f14266d30b86fa4400f1151426d557c9218b7cce51565289157c8e7
- Matching migration record included in database/schema/college_erp_current.sql: Yes

FUNCTION TEST
- Payroll calculation test: PASS
- Verified explicit earnings and deductions, taxable gross, non-cash benefit
  treatment, total deductions, and net cash = cash earnings - deductions.

INTEGRITY CHECK COVERAGE ADDED
- Expense-claim totals, missing approval/payment journals and reversals
- Recurring expense and accrual/prepayment balances
- Petty-cash overdrafts, maximum-float breaches and missing journals
- Payroll batch totals, net-cash formula, row/batch consistency and locks
- Effective statutory-rule and PAYE-band overlaps/validity
- Salary payment and statutory-remittance postings
- Posted legacy Income/Expense entries without source journals
- Reversed legacy Income/Expense entries without reasons/reversal journals

ARCHIVE VALIDATION
- Final ZIP structure: college_erp/ top-level directory
- Final ZIP integrity test: PASS
- SHA-256 checksum file generated for the final archive

LIMITATION
A live MySQL/MariaDB migration and browser transaction test could not be run
in this build environment because no MySQL/MariaDB server or PDO MySQL driver
was available. Before production use, back up the database, apply the numbered
migration on staging, run bin/check_integrity.php, and test maker-checker,
posting, payment, reversal and export workflows with authorised test users.

DEPLOYMENT COMMANDS (XAMPP WINDOWS)
cd C:\xampp\htdocs\college_erp
C:\xampp\php\php.exe bin\migrate.php
C:\xampp\php\php.exe bin\check_integrity.php
