Web-Based Factory Management Software Development

KANHA WATERTANKS – SIWANI
1. BASIC DETAILS
Type: Web-based Factory Management Software
Language: English
Users (current): Admin only
Users (future): Admin + Staff (role based)
Backup: Daily automatic backup
Billing Type: Non-GST
2. USER ROLES & ACCESS
Admin (Owner)
Full access to all modules
Backup restore permission
Staff create / enable / disable (future)
Staff (Future – disabled now)
Permission based access:
Production entry
Expense entry
Billing
View reports only
3. MASTER MODULES
3.1 Raw Material Master
Purpose: Powder stock control (color wise)
Fields:
Material Name (LLDPE Powder)
Color Name
Category (Virgin / Regrind / Other)
Opening Stock (kg)
Rate per kg (optional)
Status (Active / Inactive)
Rules:
Stock maintained in kg
Decimal allowed (0.01)
Out-of-stock colors shown as greyed (disabled)
3.2 Product Master
Purpose: Finished goods identity
Fields:
Product Name (e.g. 500 LTR – 5 Layer Tank)
Category / Size
Status (Active / Inactive)
Note:
No fixed formula attached
Production mix always entered manually
3.3 Party Master
Fields:
Party Name
Mobile
Address
Opening Balance
Balance Type (Receivable / Payable)
3.4 Expense Head Master
Examples:
Factory Routine Expense
Labour
Repair & Maintenance
Office Expense
Misc
(Admin can add/edit)
3.5 Vehicle Master
Fields:
Vehicle Number
Type (Pickup)
Assigned Driver
3.6 Driver Master
Fields:
Driver Name
Mobile
Assigned Vehicle
4. PRODUCTION MODULE (CORE FEATURE)
4.1 Production / Inward Entry
Fields:
Date
Product
Quantity Produced (Units)
Powder Usage (Multiple rows):
Color (dropdown from Raw Material Master)
Quantity (kg)
Rules:
Only colors from Raw Material Master allowed
Out-of-stock colors shown greyed (not selectable)
Quantity cannot exceed available stock
Decimal kg allowed
Raw material stock auto deduction
Finished goods stock auto increase
4.2 Template System
Any production mix can be saved as Template
Template Fields:
Template Name
Product (optional)
Powder + kg
Template Actions:
Load
Edit
Delete
Quantities remain editable after loading template
5. STOCK MANAGEMENT
5.1 Raw Material Stock
Opening stock
Inward (purchase)
Used in production
Closing balance
5.2 Finished Goods Stock
Produced quantity
Sold quantity
Closing stock
6. BILLING MODULE (NON-GST)
6.1 Bill Entry
Fields:
Manual Bill Number
Date
Party
Product
Quantity
Rate
Amount
Rules:
No GST fields
Duplicate bill number warning
Finished goods stock auto reduce on billing
6.2 Payment Entry
Payment Modes:
Cash
Bank
UPI
Bank Fields:
Bank Name
Account Type
Reference / UTR
Date
6.3 Bill Output
A4 / Half page print
Company Name: KANHA WATERTANKS – SIWANI
Address & Mobile
Line: “This is a non-GST bill”
PDF download & share option
7. LEDGER & ACCOUNTS
7.1 Party Ledger
Opening Balance
Bills (+)
Payments (–)
Closing Balance
7.2 Cash / Bank Ledger
Separate cash balance
Separate bank balance
Expense & receipt impact
8. EXPENSE MODULES
8.1 Factory Routine Expense
Fields:
Date
Expense Head
Amount
Payment Mode
Remark
8.2 Gas Expense (Cylinder Based)
Fields:
Date
Supplier
Number of Cylinders
Rate per Cylinder
Total Amount
8.3 Vehicle Expense
Diesel (litre + amount)
Toll expense
8.4 Driver Routine Expense
Fields:
Date
Driver
Expense Type
Amount
9. LABOUR ATTENDANCE MODULE
9.1 Labour Master
Fields:
Labour Name
Mobile (optional)
Work Type (optional)
Status (Active / Inactive)
9.2 Daily Labour Attendance
Fields:
Date
Labour Name
In Time
Out Time
System Calculation:
Total Working Hours (auto)
Rules:
Duplicate entry for same labour & date not allowed
In Time must be before Out Time
Out Time can be blank (shift running)
9.3 Labour Attendance Reports
Date-wise Attendance Report
Labour-wise Attendance Report
Monthly Attendance Summary
Export:
Excel
PDF
10. REPORTS
Party Outstanding Report
Sales Summary (date-wise / party-wise)
Raw Material Stock Report (color-wise)
Production Consumption Report
Finished Goods Stock Report
Expense Summary
Profit Idea Report (Sales – Expenses)
11. BACKUP & SECURITY
Daily automatic backup
Multiple restore points
Manual restore by Admin only
Activity log (for future staff tracking)
12. FUTURE READY FEATURES
Staff login activation
Role & permission control
Approval workflow
Mobile app extension (optional)