Impact Reports: Solution Proposal v1 - Apr 27, 2026

As a Senior Technical IT Consultant, I have evaluated the proposals from Progressive Byte (Next.js) and Mirkadim (Vue/Laravel). While both developers are promising, neither proposal fully addresses the end-to-end workflow automation and media sustainability required for a global nonprofit like Human Concern USA.

Document synthesizes the strengths of both—Sabbir’s professional architecture and Mirkadim’s workflow efficiency

—into a high-accuracy technical specification.


## Technical Specification: Unified Impact Reporting Ecosystem

1. Executive Summary

Human Concern USA requires a transition from manual, Word-based project reporting to a digital-first "Intake-to-Insight" pipeline. This solution replaces current bottlenecks with a structured workflow: Google Form (Partner) → Google Sheet (Internal Review) → Web Portal (Public Disclosure). The goal is to provide donors with real-time, data-driven transparency while minimizing administrative overhead.

2. Technical Architecture

To ensure both frontend speed for donors and backend power for staff, I recommend a Hybrid Decoupled Architecture.

  • Intake Layer: Google Forms (free, global accessibility, no partner training required).

  • Vetting Layer: Google Sheets + AppSheet (for mobile vetting) or custom Laravel logic to review and "Approve" rows.

  • Backend (The Engine): Laravel (PHP 8.3). Laravel excels at the complex Excel/Google Sheet parsing you require and provides a more robust "Role-Based Access Control" (RBAC) for your backend staff.

  • Frontend (The Face): Next.js (React). To be hosted on Vercel. This ensures the public portal is blazing fast, SEO-optimized for donor searches, and mobile-responsive.

  • Database: PostgreSQL. Superior to MySQL for handling the complex relationships between regions, sectors, and multi-year impact metrics.

3. Risk Assessment & Mitigation

Based on research into nonprofit digital transitions in 2026:

Risk Factor

Impact

Mitigation Strategy

Data Integrity

High

Schema Validation: The system must reject Excel/Sheet uploads if mandatory fields (e.g., "Lives Impacted") are missing or formatted incorrectly.

Media Bloat

Medium

CDN Integration: Do not store images/videos on the web server. Use Cloudinary or AWS S3 with automatic compression to keep site speed high.

Solo Dev Dependency

High

Documentation Mandate: Require a "Developer Handoff Kit" including an API Schema and Environment Variable map.

Privacy (GDPR/CCPA)

Medium

Since reports involve field data, the backend must include a "Redaction Toggle" to hide sensitive beneficiary names before publishing.

4. Scalability Roadmap

The solution is designed to grow in three phases:

  • Phase 1 (MVP): Excel-to-Web bulk upload (Mirkadim’s approach).

  • Phase 2 (Automation): Direct Google Sheets API integration. Once a row is marked "Approved" in the Sheet, it syncs to the portal automatically without a manual upload.

  • Phase 3 (Global Map): Advanced GIS integration using Mapbox to show "Cluster Impacts" where multiple projects overlap in one region.

5. Implementation Milestones

Milestone

Deliverable

Timeline

M1: Data Mapping

Finalized Excel/Sheet Schema & Google Form design.

Week 1

M2: Core API

Laravel Backend with Secure Admin Login & Excel Parser.

Week 2-3

M3: Frontend Build

Next.js Public Portal with dynamic project cards & maps.

Week 4-5

M4: The Bridge

Connecting vetted Google Sheet data to the Live Portal.

Week 6

M5: UAT & Launch

User Acceptance Testing with real partner data.

Week 7-8


### Consultant’s Final Recommendation

For the Backend & Workflow logic (Laravel/Excel) due to superior understanding of your administrative pain points, but insist that the Frontend be built in Next.js (per Sabbir’s stack) for long-term donor engagement.

If you must choose one, the $600 proposal is functionally superior for your specific "Word-to-Web" problem, provided you increase the budget slightly to ensure high-quality documentation and the use of Next.js for the frontend.