Custom Inventory Management System
Budget: ₹600 – ₹1,500 INR
1. Stock Entry Page (Main Interface)
This acts like an app-style entry form.
Fields:
Item Name (Dropdown if already exists, or allow new)
Category
Quantity Added
Purchase Price
Selling Price
Minimum Stock Level
Features:
Adds or updates existing stock in Inventory
Automatically adjusts totals
Timestamp for entry
Optional: Buttons (via macro or Form Controls) to “Add Stock” or “Update Stock”
---
2. Inventory Sheet
Tracks current stock status.
Columns:
Item Name
Category
Quantity Available
Minimum Stock Level
Purchase Price
Selling Price
Total Stock Value (Qty × Purchase Price)
Alert (shows “Low Stock” if below minimum)
Features:
Auto-updates when billing or estimate is made
Conditional formatting to highlight low-stock items
---
3. Billing Page
Handles finalized sales.
Fields:
Customer Name
Bill Number (Auto)
Date
Item Name (Dropdown from Inventory)
Quantity
Price (Auto)
Tax / Discount (optional)
Total (Auto)
“Submit Bill” Button (macro)
Features:
On billing, deducts quantity from Inventory
Generates a printable bill
Logs bill to a Billing Log sheet for history
---
4. Estimate Page
Handles quotations.
Same as Billing Page, with:
“Submit Estimate” Button
Deducts quantity (or optionally flags it as reserved)
Can be converted to a bill
---
5. Dashboard
Visual insights & controls.
Includes:
Total Stock Value
Number of Low Stock Items
Top Selling Items (via Billing Log)
Quick Buttons to:
Add Stock
View Estimates
View Bills
Export Report
---
6. Logs & Records
Billing Log: Stores every finalized bill
Estimate Log: Stores all estimates
Stock Change Log: Records every addition/removal
This acts like an app-style entry form.
Fields:
Item Name (Dropdown if already exists, or allow new)
Category
Quantity Added
Purchase Price
Selling Price
Minimum Stock Level
Features:
Adds or updates existing stock in Inventory
Automatically adjusts totals
Timestamp for entry
Optional: Buttons (via macro or Form Controls) to “Add Stock” or “Update Stock”
---
2. Inventory Sheet
Tracks current stock status.
Columns:
Item Name
Category
Quantity Available
Minimum Stock Level
Purchase Price
Selling Price
Total Stock Value (Qty × Purchase Price)
Alert (shows “Low Stock” if below minimum)
Features:
Auto-updates when billing or estimate is made
Conditional formatting to highlight low-stock items
---
3. Billing Page
Handles finalized sales.
Fields:
Customer Name
Bill Number (Auto)
Date
Item Name (Dropdown from Inventory)
Quantity
Price (Auto)
Tax / Discount (optional)
Total (Auto)
“Submit Bill” Button (macro)
Features:
On billing, deducts quantity from Inventory
Generates a printable bill
Logs bill to a Billing Log sheet for history
---
4. Estimate Page
Handles quotations.
Same as Billing Page, with:
“Submit Estimate” Button
Deducts quantity (or optionally flags it as reserved)
Can be converted to a bill
---
5. Dashboard
Visual insights & controls.
Includes:
Total Stock Value
Number of Low Stock Items
Top Selling Items (via Billing Log)
Quick Buttons to:
Add Stock
View Estimates
View Bills
Export Report
---
6. Logs & Records
Billing Log: Stores every finalized bill
Estimate Log: Stores all estimates
Stock Change Log: Records every addition/removal