Case Study
Digitising a frontline charity with a secure internal CRM
A custom digital platform that replaced paper records, spreadsheets and manual filing with secure service user management, volunteer compliance tracking and document vaulting.
Executive Summary
A fast, secure platform for every frontline process.
Consiliuma engineered a bespoke web application that digitises the internal operations of a frontline charity. The platform replaces fragmented paper records, spreadsheets and manual filing with a centralised digital ecosystem for service delivery, casework, volunteer compliance and secure document archiving.
Platform type
Secure charity CRM and compliance system
Built for
Frontline staff, support teams and volunteer managers
Architecture & Technology
A decoupled system built for speed, security and scalability.
The platform is built as a decoupled application to keep the experience fast for frontline staff while maintaining tight security controls behind the API.
- Frontend: React and TypeScript SPA bundled with Vite for responsive, tablet-friendly performance.
- UI: Tailwind CSS for a clean, intuitive interface that works reliably in fast-paced operational environments.
- Backend: Custom PHP REST API with strict request validation, role-based authentication and API-gated document access.
- Database: Relational MySQL schema designed to link service users, daily provisions, compliance records and audit logs.
Service User Management
Operational workflows for daily service delivery.
The app is the operational heart of the charity’s day-to-day delivery. Staff can register service users, capture vulnerabilities and quickly record exactly what support was provided.
- Intake & profiling: capture demographics, contact details and vulnerability notes for new service users.
- Resource tracking: record hot meals, emergency food packs, clothing, sleeping bags and other essential provisions.
- Digital signatures: sign-on-glass consent and receipt tracking directly on a tablet or touchscreen.
- Behavioural management: log warnings, temporary bans and status notes so every arrival is managed consistently.
Support Casework
Tools for long-term support and review.
Beyond daily provisions, the platform supports structured casework, safeguarding and incident reporting so that every intervention is recorded and reviewable.
- Case logs: open dedicated support cases with chronological interventions, referrals and progress notes.
- Multi-agency referrals: record housing, addiction support and partner agency actions alongside the service user record.
- Incident reporting: log on-site accidents, behavioural incidents and safeguarding concerns with a permanent audit trail.
Secure Document Vault
Hardened storage for sensitive identity and consent data.
All sensitive documents are stored outside the public web root and served only through authenticated API endpoints, ensuring nothing is exposed by direct URL.
- Proof of identity: securely upload and store passports, licences and other ID documents needed for housing or benefit applications.
- Hardened storage: all files, including signatures and IDs, are stored in a private directory outside public_html.
- API-gated access: documents are released only after clearance checks, never by direct public links.
Volunteer Compliance
A single record for workforce safety and regulation.
The platform manages volunteer onboarding, DBS checks and safeguarding status so everyone is visible, compliant and ready to support work on site.
- Roster management: manage volunteer details, suspensions and workforce status from one private dashboard.
- DBS tracking: capture workforce type, certificate numbers, update service status and renewal deadlines.
- Risk assessments: log disclosures, restrictions and role limitations alongside each volunteer record.
- Visual status: colour-coded badges show quickly whether checks are pending, cleared or due for renewal.
Role-Based Access
Security and privacy enforced at every level.
The app dynamically adapts to each user’s role so sensitive data is visible only to authorised users and routine workflows remain fast for operational staff.
- Tiered permissions: separate clearance for volunteers, caseworkers, management and trustees.
- Conditional UI: standard volunteers can log provisions while management can view restricted documents and safeguarding notes.
Print & Reporting
Ready for audits and physical compliance too.
Even with a digital-first platform, the charity still needs printable records for audits and in-person meetings. Consiliuma built a print engine that produces audit-ready A4 output with a clean layout.
- Print architecture: custom CSS media query printing with React Portals to strip navigation and interface elements.
- A4 output: clean black-and-white portrait format with page-break rules and write-in fields for manual notes.
- Audit-ready: physical records are generated from the same digital data source, so printed copies match the live system.
Conclusion
A unified platform that frees staff from paperwork.
The finished application gives the charity one operational system for resource tracking, casework, safeguarding and compliance. By removing paper and spreadsheets, the team can focus more time on support and less time on administration.
Consiliuma delivered a secure, lightning-fast platform that makes regulatory compliance manageable, protects sensitive records and supports frontline decisions in real time.
That means safer service delivery, better volunteer oversight and a more resilient charity operation overall.
Talk to Consiliuma
Ask us about secure internal systems for charities and care organisations.
If your organisation still depends on paper, spreadsheets or disconnected workflows, we can design a system that keeps sensitive data safe and makes frontline operations more reliable.