Stock Tracking & Reporting System Objective: The goal of this project is to build a simple, web-based Stock Tracking & Reporting System that replaces manual registers and helps the school owner: View the current stock of every product Add incoming stock received from suppliers Record stock sold to retailers Record stock returned back by retailers Automatically track available stock (In – Out + Returns) See low-stock indicators and plan purchases in advance Access date-wise, month-wise, and product-wise reports Export reports to CSV/Excel Get quick insights through an easy dashboard The system is designed for extremely easy usage by the staff member who currently maintains handwritten registers. Proposed Solution: We will develop a lightweight, browser-based web application hosted on Google Firebase. This version includes: Full product inventory tracking Supplier stock-in entry Stock-out entry for items sold to retailers Stock return entry when retailers return items Automatic available stock calculation Low-stock alerts Date filters, month filters, and product-wise filters Comprehensive reports + CSV export Simple and clean dashboard Key Features A. Product Management Manage all products offered by the school. Features: Add Product Edit Product Delete Product Product Fields: Product Name SKU (Unique Code) Class Year MRP Quantity Low Stock Limit Low Stock Indicators Products that fall below their low-stock limit will automatically be highlighted. (Shown clearly on a separate Low Stock page.) B. Stock Management: 1. Stock Out (Sales Entry) Select Product Enter Quantity Sold Select Date System automatically deducts the quantity from available stock Entry saved to sales history 2. Stock Returned (Add-Back Entry) Select Product Enter Quantity Returned Select Date System adds this quantity back into stock Entry saved to stock-return history C. Reports & Trend Analytics 1. Product Stock Report Shows current available stock Shows low-stock alerts CSV export available 2. Stock Out (Sales) Report — Date & Date Range View all sales for a selected date Or select a date range to see total sales per product 3. Stock Returned (Add-Back) Report — Date & Date Range View all returned stock for a selected date Or select a date range 4. Month-Wise Sale Report Select any month to view total sales Product-wise sale breakdown Helps plan which items need restocking 5. Product-Wise Sale Report Select product + date range View complete sale history Monthly and daily trends 6. Date-Range Sale Summary Select From–To dates View total units sold Product-wise breakdown 7. CSV/Excel Export All reports can be exported to CSV/Excel. D. Dashboard (Summary View) Total Products Products in Low Stock Recent Sales Recent Stock Returned Top Selling Products (current month) E. Authentication & Security Firebase Authentication for secure login Role: Admin access Firebase Firestore as database Real-time updates and cloud storage Technology Used Frontend: ReactJS Backend / Database: Firebase Firestore Hosting: Firebase Hosting