The MSME (Micro, Small, and Medium Enterprises) Management System is a comprehensive web application designed to streamline the operations of small businesses. Built with Flask and integrated with tools for inventory, sales, expense, and financial reporting, the platform provides an all-in-one solution for managing day-to-day business operations.
Link: https://msme-management-system.onrender.com/
Test: https://msme-management-system.onrender.com/test-config
- Quick overview of business metrics
- Daily sales summary
- Low stock alerts
- Monthly expense tracking
- Real-time business status
- Product tracking
- Stock level monitoring
- Reorder level alerts
- Product details management (name, quantity, price)
- Stock update history
- Record new sales
- Daily/weekly/monthly sales tracking
- Product-wise sales history
- Transaction records
- Sales performance metrics
- Expense categorization
- Expense recording
- Monthly expense tracking
- Expense type management
- Expense history
- Financial summaries
- Sales trends visualization
- Expense distribution charts
- Top-selling products
- Profit/loss analysis
- Excel export functionality
- Framework: Flask (Python)
- Database: SQLite
- Data Processing: Pandas
- File Handling: Excel export with openpyxl
msme-management-system/
|-- app/
| |-- static/ # CSS, JS, Images
| |-- templates/ # HTML Templates (Jinja2)
| |-- routes.py # Application Routes
| |-- models.py # Database Models
| |-- utils.py # Utility Functions (Excel Export, etc.)
|-- migrations/ # Database Migrations
|-- database.db # SQLite Database
|-- requirements.txt # Project Dependencies
|-- config.py # Configuration File
|-- run.py # Application Entry Point
|-- README.md # Project Documentation
The system uses a well-structured SQLite database with the following key tables:
- Products: Product details, stock levels, and price.
- Sales: Transaction history with timestamps and amounts.
- Expenses: Expense records categorized by type.
- Reports: Financial summaries and exportable data.
The MSME Management System can be deployed easily with the following steps:
git clone https://github.com/your-username/msme-management-system.git
cd msme-management-systempython3 -m venv venv
source venv/bin/activatepip install -r requirements.txtpython run.py- Access the app at
http://127.0.0.1:5000
- Set up the project on Render for production hosting.
- Configure Environment Variables and Database Initialization.
- Automatic stock updates upon sales.
- Low stock notifications and history tracking.
- Revenue and expense monitoring.
- Profit/loss calculation and monthly summaries.
- Export reports to Excel format using openpyxl.
- Supports custom date ranges for:
- Inventory status
- Sales history
- Expense records
- Visualized data trends using Chart.js.
- Insights into sales, expenses, and performance.
- User authentication
- Customer and supplier management
- Advanced analytics
- Mobile optimization
- Email notifications
- PDF report generation
- Multi-currency support
| Category | Tools/Technologies |
|---|---|
| Backend | Flask, Python |
| Database | SQLite |
| Frontend | Bootstrap |
| Data Handling | Pandas, openpyxl |
| Deployment | Render |
| Icons & Styling | Font Awesome, CSS |
- Python 3.8+
- Flask
- SQLite
- Pandas
- openpyxl
- Bootstrap 5
- Chart.js
Install all dependencies with:
pip install -r requirements.txtThis project is licensed under the MIT License. See LICENSE for more details.
Contributions are welcome! To contribute:
- Fork the repository.
- Create a feature branch:
git checkout -b feature-branch. - Commit your changes:
git commit -m "Add feature". - Push to the branch:
git push origin feature-branch. - Open a pull request.
For questions or collaboration:
- Name: Job Kiprotich Busienei
- Email: [email protected]
- GitHub: My github profile
Thank you for checking out the MSME Management System! 🚀