Real Estate Management System – Software Requirements Document (Updated) 1. Project Overview Company: AL Masriya for Housing and Touristic Development Scope: Develop a professional, centralized web-based internal system for managing all real estate operations, including sales, clients, contracts, payments, maintenance, handover, cancellations, and marketing companies/commissions. Users: Single primary user (company operations manager). Objectives: Centralize all data of projects, units, and clients. Automate calculations for payments, maintenance, resale commissions, and marketing commissions. Generate contracts, reports, and official documents (PDF/Excel) automatically. Enable tracking of all financials, unit status, and project progress in real-time. 2. System Requirements 2.1 Dashboard Centralized dashboard showing: Projects overview: total sales, available units, sold units, delivered units. Upcoming payments, maintenance, and marketing commission notifications. Quick access to units, clients, and contracts. Interactive charts and summary tables. 2.2 Projects & Units Management Add/Edit/Delete projects: name, location, delivery year, status. Add/Edit/Delete units: unit number, type (Studio, 1BR, 2BR, 3BR, Villa), floor, size, price, currency, status (available / reserved / sold / delivered / cancelled). Upload unit plans and images. Track unit history and changes. 2.3 Clients & Contracts Management Client profile: personal info, contact details, passport, nationality. Link client to purchased or reserved units. Record contracts (Cash or Installment), including: Payment plan: number of installments, amount, due dates, currency. Automatic calculation of remaining balance. Generate PDF contracts with all details. Handle resale transactions: Record seller, buyer, and unit transfer. Calculate company commission (default 5%) with exceptions. Update unit ownership. 2.4 Payments & Maintenance Record all payment types: deposit, installment, maintenance, utility connection fees, resale fees, penalties. Support multi-currency (EUR, USD, GBP, EGP). Automatic maintenance calculation every 5 years, with 10% increase over the previous 5-year payment. Handle exceptions (fixed amount or one-time 15% payment). List upcoming payments and overdue balances. 2.5 Handover Management Track unit handover status: ready, delivered, delayed. Prevent handover if client has pending payments. Upload handover documents and unit photos. Generate PDF handover certificates. 2.6 Contract Cancellation Management Record cancellation reasons. Calculate refunds or penalties automatically. Reset unit status to available. Store all official cancellation documents. 2.7 Marketing Companies & Commissions Register Marketing Companies: Add/Edit/Delete marketing companies. Record contact info (phone, email), default commission percentage or fixed amount, and notes. Link Sales to Marketing Companies: Assign marketing company to each sale (if applicable). Automatically calculate commission based on predefined percentage or fixed amount. Ability to adjust commission manually for exceptions. Commission Payments: Record payment of commissions (date, amount, currency). Track pending and paid commissions per marketing company. Reports: Sales associated with marketing companies. Outstanding and paid commissions. Export reports to PDF or Excel. 2.8 Reporting Generate reports filtered by project, client, unit, payment type, marketing company, or date range: Sales summary Payments collection Maintenance due Units status Cancelled contracts Marketing commissions Export all reports to Excel or PDF. 2.9 System Features Web-based internal system (desktop-focused). Single user (operations manager) with full access. Data backup (daily or weekly). Modern, user-friendly interface for managing large-scale projects. Audit log: track all changes to units, clients, payments, contracts, and commissions. 3. Optional Future Enhancements Add multiple user roles (sales, accounting, management). Automated email/SMS notifications for upcoming payments, maintenance, handovers, or commission payments. Cloud deployment for multi-device access. 4. Deliverables Fully functional web application (desktop-focused). Database of projects, units, clients, contracts, payments, maintenance, and marketing commissions. PDF/Excel generation for contracts, handover certificates, commission reports, and financial reports. User manual and installation guide. Daily/weekly backup setup. 5. Technologies (Suggested) Frontend: ReactJS, VueJS, or similar. Backend: Python (Django/Flask), NodeJS, or similar. Database: MySQL, PostgreSQL, or SQLite. PDF/Excel generation library integrated. Hosted on company server or secure cloud server.