SKULITECH ERP — XAMPP BULK SPONSOR RECEIPTING VALIDATION REPORT
Date: 14 July 2026

TARGET ENVIRONMENT
------------------
Windows XAMPP
Project folder: C:\xampp\htdocs\college_erp
URL: http://localhost/college_erp/
Database: college_erp
Database host: 127.0.0.1:3306
Default local user: root
Default local password: blank
Minimum PHP version: 8.0

VISIBLE FINANCE MENUS
---------------------
1. Finance > Bulk Sponsor Receipting
2. Finance > Sponsor Receipts
3. Finance > Bulk Student Allocations
4. Finance > Sponsor Control Reports
5. Finance > IPSAS Reports

IMPLEMENTED SPONSOR WORKFLOW
----------------------------
- HELB loans and bursaries.
- County Government bursaries, including separate County/programme records.
- NG-CDF/CDF constituency bursaries.
- Scholarships and other donor/sponsor programmes.
- Optional accrual recognition of an approved sponsor award.
- One official bank transfer or cheque acknowledgement.
- Pending-clearance control for cheques not yet reflected in the institution bank account.
- One uploaded Excel/CSV schedule allocated to many students.
- Separate non-cash allocation advice for each student.
- Receipt-to-allocation reconciliation and unallocated sponsor balances.
- Reversal workflow that preserves the audit trail.

ACCOUNTING FLOW
---------------
Accrued sponsor award:
  Dr Sponsor Bursary and Scholarship Receivables
  Cr Sponsor Funds Unallocated Control

Receipt against accrued award:
  Dr Cash at Bank
  Cr Sponsor Bursary and Scholarship Receivables

Receipt without prior accrual:
  Dr Cash at Bank
  Cr Sponsor Funds Unallocated Control

Bulk allocation to students:
  Dr Sponsor Funds Unallocated Control
  Cr Student Fee Receivables

The bulk allocation is a non-cash transaction and does not increase the bank or
cash collection totals a second time.

XAMPP INSTALLATION/UPGRADE
--------------------------
1. Back up the application and database.
2. Extract the college_erp folder to C:\xampp\htdocs\college_erp.
3. Start Apache and MySQL in XAMPP.
4. Run C:\xampp\htdocs\college_erp\bin\xampp_install.bat.
5. Run C:\xampp\htdocs\college_erp\bin\xampp_validate.bat.
6. Sign in as System Admin, Admin or Finance.
7. Ensure the role has the finance_sponsors privilege.

VALIDATION COMPLETED IN THE BUILD ENVIRONMENT
---------------------------------------------
- 187/187 PHP files passed syntax validation.
- 3/3 JavaScript files passed syntax validation.
- 192 POST forms checked; none lacked CSRF protection.
- No nested HTML forms were detected.
- Main schema contains 109 unique tables.
- Main schema contains 65 unique foreign-key constraints.
- All five sponsor-funds tables are present.
- Seven bulk-workflow upgrade columns are present in the clean schema.
- All three bundled migration checksums match the clean-schema records.
- Bulk sponsor page, menu links, route permissions and print pages are present.
- XLSX and CSV templates both parsed successfully: 2 sample rows, KSh 55,000 total.
- The XLSX template passed ZIP/archive integrity validation.
- The polished XLSX contains a Sponsor Allocations sheet and an Instructions sheet.
- Duplicate bank reference, over-allocation, unknown learner, clearance and posting
  controls are implemented in the transaction logic.

LIVE-TEST LIMITATION
--------------------
The build environment is Linux and does not include PDO MySQL, MariaDB/MySQL or a
Windows XAMPP browser. A live database transaction test was therefore not claimed.
Run bin\xampp_install.bat and bin\xampp_validate.bat on the target XAMPP computer,
then perform the acceptance test in docs\RELEASE_NOTES_2026-07-14_BULK_SPONSOR_RECEIPTING.md.

COMPLIANCE NOTE
---------------
The module is accrual- and IPSAS-oriented. Final account mappings, recognition
policies, financial statement presentation and statutory disclosures must be
reviewed and approved by the institution accountant and auditor.
