Medical Inventory Billing Final Year Python Project

• Admin dashboard for this final year project with KPIs, shortcuts, and recent activity summaries
• Brand CRUD with list, create, detail, edit, and delete
• Category CRUD with same management pattern
• Supplier CRUD with contact and company fields
• Medicine CRUD with brand, category, supplier, batch, MFG date, expiry date, prices, quantity, minimum stock, and description
• Customer CRUD with bill history
• Consolidated stock index
• Low-stock, out-of-stock, and expired medicine views
• Manual stock add and stock level update actions
• Expired stock removal based on route business rules
• Purchase record management with supplier, medicine, quantity, price, and date
• Expiry-focused listing and tools
• Bill list, create bill, bill detail, and print view
• Sales overview with medicine-wise, daily, and monthly breakdowns
• Return record listing and new return flow
• Dynamic reports for stock, low stock, expired stock, purchases, sales, customers, suppliers, profit, and billing
• Analytics dashboard with revenue, estimated profit, stock value, expiry loss, best sellers, and low rotation lists
• Staff user create, detail, edit, active toggle, and delete where allowed
• Admin password change

• Staff dashboard in this final year project with SKUs available, today’s bill count, revenue, recent own bills, and low-stock watch
• Read-only medicine catalogue with search, brand filter, and category filter
• Medicine detail page with supplier, prices, batch, expiry, stock, and notes
• Customer directory with search
• Customer creation
• Customer profile with own issued bills and revenue
• Customer profile editing
• POS-style billing with customer, multi-line medicines, discount, tax, and notes
• Automatic stock decrement on bill save
• Own bill detail with line items, totals, and notes
• Printable receipt for own bills
• Personal sales history with bill number, customer name, and date filters
• Stock views for all, low, expired, and expiring within 60 days
• Return log for own returns
• New return flow using own bill, bill line API, quantity, and reason
• SKU restocking and refund record creation during returns
• Staff profile update
• Staff password change

• Public landing page included in this final year project
• Role-based redirection after login
• SQLite database created automatically
• Auto-created default admin if missing
• Optional demo seed data loader
• Bill numbers generated with daily prefix
• Indian rupee formatting in templates
• Bootstrap 5 and Bootstrap Icons UI
• Chart.js visual analytics
• Internal JSON API for return and billing helpers
• Pagination helpers for admin and staff lists
• Printable bill and receipt pages
• Suitable for final year project demo, viva, source code review, and report preparation

• Open the final year project folder:
  cd "path/to/Medical Inventory & Billing System with Analytics"
• Create a virtual environment:
  • Windows: python -m venv .venv
  • macOS/Linux: python3 -m venv .venv
• Activate the environment:
  • Windows: .\.venv\Scripts\Activate.ps1
  • macOS/Linux: source .venv/bin/activate
• Install dependencies:
  pip install -r requirements.txt
• Optional: load demo data:
  python seed_data.py
• Start the final year Flask project:
  python run.py
• Open the application at:
  http://127.0.0.1:5000
• Open /login and use admin or staff credentials.

Auto-created Administrator

• Username: admin
• Password: admin123

Demonstration Staff
Only after running seed_data.py:

• Username: staff1
• Password: staff123
• Display name: Riya Sharma
• Username: staff2
• Password: staff123