SBMS - School Financial Management Platform

SBMS is a comprehensive school financial management platform where Schools create bills for students, Guardians make payments via Paystack integration, and Administrators track revenue, expenses, and analytics. The system handles everything from bill creation and payment processing to expense tracking and financial reporting—all with real-time notifications, virtual accounts, and automated reconciliation.

## Core Value

- *End-to-end financial management*: bill creation → payment processing → expense tracking → reporting → analytics.
- *Multi-role ecosystem*: Schools manage students and bills, Guardians pay via virtual accounts, Bursars track finances, Students view their bills.
- *Trust and transparency*: verified users, automated payment processing, real-time notifications, and comprehensive audit trails.

## Roles and What They Do

- *School Administrator*: manage school setup, create classes, oversee student enrollment, monitor system-wide analytics, and configure school policies.
- *Bursar*: create and manage bills (tuition, development, transport, etc.), track payments, manage expenses, generate reports, and monitor financial health with advanced analytics.
- *Guardian*: view ward's bills, make payments via Paystack virtual accounts or cards, receive payment confirmations, and manage payment preferences.
- *Student*: view personal bills, track payment history, access receipts, and monitor account balance.

## The Financial Workflow

- *Bill Creation*: Bursar creates bills for students (individual or bulk), sets due dates, categories (tuition, development, transport, etc.), and payment terms.
- *Payment Processing*: Guardians receive notifications, pay via Paystack integration (virtual accounts, cards, bank transfers), with automatic allocation to specific bills.
- *Expense Management*: Bursar records school expenses, categorizes them, and tracks against budget allocations.
- *Reporting & Analytics*: Real-time dashboards show revenue trends, payment analytics, expense breakdowns, and financial health metrics.

## Payment Processing & Virtual Accounts

- *Paystack Integration*: Each guardian gets a dedicated virtual account for seamless payments with automatic bill allocation.
- *Payment Methods*: Virtual accounts (primary), card payments, and bank transfers with automatic fee calculation.
- *Auto-Allocation*: Payments automatically allocate to oldest bills first, with configurable allocation strategies.
- *Real-time Updates*: Instant payment confirmations, receipt generation, and balance updates across all roles.

## Bill Management & Categories

- *Bill Types*: Tuition, Registration, Development, Transport, Books, Library, Stationery, ICT, Lab, Exam, Sports, Uniform, Feeding, Medical, and Miscellaneous.
- *Bulk Operations*: Create bills for entire classes, terms, or custom student groups with flexible due dates.
- *Payment Tracking*: Real-time status updates (pending, paid, overdue) with automated notifications.
- *Receipt Generation*: Automatic PDF receipts with school branding and payment details.

## Financial Analytics & Reporting

- *Revenue Analytics*: Payment trends, success rates, fee breakdowns, and revenue forecasting.
- *Expense Tracking*: Categorized expense management with budget vs. actual comparisons.
- *Student Analytics*: Payment patterns, outstanding balances, and class-wise financial performance.
- *Dashboard Insights*: Multi-role dashboards with role-specific metrics and visualizations.

## Feature Highlights

- *Smart Payment Allocation* (oldest first, highest amount, custom rules)
- *Real-time Notifications* (email/SMS/in-app for payments, due dates, receipts)
- *Virtual Account Management* (Paystack integration with automatic account creation)
- *Expense Management* (categorized tracking with approval workflows)
- *Advanced Analytics* (revenue trends, payment analytics, expense breakdowns)
- *Multi-role Dashboards* (role-specific insights and metrics)
- *Automated Reporting* (PDF generation, Excel exports, custom date ranges)
- *Payment Reconciliation* (automatic matching, dispute resolution, audit trails)

## What's Included

- *Polished responsive UI* with: Multi-role authentication (login/register/verify/forgot/reset), role-based onboarding; Bill creation/management with bulk operations; Payment processing with Paystack integration; Expense tracking and approval workflows; Advanced analytics dashboards; Real-time notifications and messaging.
- *Paystack payment engine* with virtual accounts, card processing, and automated fee calculation.
- *Comprehensive reporting system* with PDF generation, Excel exports, and custom analytics.
- *Real-time notification system* with email/SMS/in-app messaging and WebSocket integration.

## Images & Screenshots Checklist

- *Authentication flow* (login, registration, email verification, password reset)
- *Role-based dashboards* (Admin, Bursar, Guardian, Student views)
- *Bill management* (creation, bulk operations, categories, due dates)
- *Payment processing* (Paystack integration, virtual accounts, payment methods)
- *Expense management* (categorization, approval workflows, budget tracking)
- *Analytics dashboards* (revenue trends, payment analytics, expense breakdowns)
- *Reporting interfaces* (PDF generation, Excel exports, custom reports)
- *Notification system* (real-time updates, email/SMS confirmations)

## Tech Stack

- *Frontend*: React 19, Vite, Tailwind CSS, Framer Motion, Recharts, React Router
- *Backend*: Node.js/Express, MongoDB, Mongoose, Socket.io
- *Payment Processing*: Paystack API integration with virtual accounts
- *Authentication*: JWT with role-based access control
- *Real-time*: Socket.io for live updates and notifications
- *File Processing*: PDF generation (jsPDF), Excel exports (ExcelJS)
- *Security*: Helmet, CORS, rate limiting, input sanitization

## Installation

1. *Clone repository* and install dependencies for both client and server.
2. *Environment setup*: Copy .env templates; configure MongoDB URI, Paystack keys, email/SMS credentials.
3. *Database setup*: Run school setup wizard, create classes, seed development data (optional).
4. *Start services*: Launch server and client; create admin account; configure school settings.
5. *Payment setup*: Configure Paystack integration; test payment flows with development data.

## Key Features

### Multi-Role System

- *School Admin*: Complete system oversight with analytics and user management
- *Bursar*: Financial management with bill creation, payment tracking, and expense management
- *Guardian*: Payment processing with virtual accounts and bill management
- *Student*: Bill viewing and payment history tracking

### Payment Processing

- *Paystack Integration*: Virtual accounts, card payments, bank transfers
- *Automated Allocation*: Smart payment distribution across multiple bills
- *Fee Calculation*: Automatic Paystack fee computation and display
- *Receipt Generation*: PDF receipts with school branding

### Financial Management

- *Bill Categories*: 15+ predefined categories (tuition, development, transport, etc.)
- *Bulk Operations*: Create bills for entire classes or custom groups
- *Expense Tracking*: Categorized expense management with approval workflows
- *Budget Management*: Track expenses against allocated budgets

### Analytics & Reporting

- *Revenue Analytics*: Payment trends, success rates, revenue forecasting
- *Expense Analytics*: Categorized spending with budget comparisons
- *Student Analytics*: Payment patterns and outstanding balances
- *Real-time Dashboards*: Role-specific metrics and visualizations

### Notification System

- *Multi-channel*: Email, SMS, and in-app notifications
- *Real-time Updates*: WebSocket integration for live updates
- *Payment Confirmations*: Automatic receipts and status updates
- *Due Date Reminders*: Automated bill payment reminders

## Licensing & Notes

- *Paystack Integration*: Requires Paystack account and API keys for payment processing
- *Email/SMS*: Configure SMTP and SMS provider credentials for notifications
- *Production Deployment*: Includes security hardening, rate limiting, and monitoring recommendations

## Support

- *Setup Assistance*: Complete installation and configuration guidance
- *Payment Integration*: Paystack setup and testing procedures
- *Custom Features*: Role-based customizations and third-party integrations available on request
- *Documentation*: Comprehensive API documentation and user guides included

---

*SBMS* transforms school financial management with automated payment processing, comprehensive analytics, and multi-role collaboration—making school finance management efficient, transparent, and scalable for Nigerian educational institutions.