Cylinder Management System Development -- 2
Budget: ₹1,500 – ₹12,500 INR
1. Login System
Admin Login
(Optional future roles: Branch Office, Delivery Agent)
Secure login
Admin dashboard access
Role-based access (future scaling)
---
2. Master Setup
a. Branch Management
Add/Edit/Delete branches
Assign branch managers (optional)
b. Delivery Agent Management
Add/Edit/Delete agents
Assign agent to branch
Contact info, active status
c. Cylinder Type & Pricing
Define cylinder types (e.g., 14.2kg, 19kg)
Set price for full cylinder
Deposit/Refund price setup (optional)
d. Customer Master
Add/Edit/Delete customers
Name, address, mobile
Link to branch
Credit limit, opening balance
---
3. Godown Stock Management
a. Opening Stock Setup
Full & empty cylinder count per type
b. Daily Refill Load Entry
Record cylinders received from supplier
Increases full cylinder stock
Stock auto-updated
---
4. Sales (Retail / Distributor Sale)
a. Create Sale Invoice
Select Customer (cash/credit)
Select Cylinder Type(s)
Qty, Rate, Remarks
Delivery Mode: Agent / Self
Payment: Cash / Credit
Auto-stock deduction of full cylinders
Auto-add of empty cylinders (assumed returned)
b. Download/Print Invoice
Print-ready invoice with branding
Tax details (if applicable)
---
5. Payment Collection
View due customers
Record customer payment
Payment mode: Cash, Bank, UPI
Update balance
Receipt downloadable
---
6. Expenses Management
Add daily expenses
Category: Diesel, Salary, Misc.
Attach receipts (optional)
Track branch-wise
---
7. Cash Handover to Owner
Daily or periodic handover
Record handover amount
Linked to sales and payment collections
Print handover summary
---
8. Reports Module
a. Daily Sales Report
Sale summary: customer, quantity, amount
Filter by date, branch, agent
b. Due Report
All customers with outstanding balances
Filter by duration: today, 7 days, 30 days, all
c. Godown Closing Stock
Full & empty cylinder status
Real-time inventory
d. Expense Report
Category-wise or branch-wise
Filter by date/month
e. Cash Flow Report
Cash in (sales + payments)
Cash out (expenses + handover)
f. Customer Ledger
All transactions per customer
Sale, payment, current balance
---
9. Backup / Export
Export all reports to Excel/PDF
Daily auto-backup (optional)
---
10. Settings
Business info (Agency Name, GSTIN, Logo)
Cylinder prices
User settings
Password change
Branch-wise permissions (future)
---
Example Workflow:
1. Admin logs in
2. Enters today's refill load
3. Creates 10 sales invoices
4. Collects 3 cash payments
5. Records diesel expense
6. Views daily stock and cash report
7. Handover ₹10,000 to owner
8. Downloads customer due report
Admin Login
(Optional future roles: Branch Office, Delivery Agent)
Secure login
Admin dashboard access
Role-based access (future scaling)
---
2. Master Setup
a. Branch Management
Add/Edit/Delete branches
Assign branch managers (optional)
b. Delivery Agent Management
Add/Edit/Delete agents
Assign agent to branch
Contact info, active status
c. Cylinder Type & Pricing
Define cylinder types (e.g., 14.2kg, 19kg)
Set price for full cylinder
Deposit/Refund price setup (optional)
d. Customer Master
Add/Edit/Delete customers
Name, address, mobile
Link to branch
Credit limit, opening balance
---
3. Godown Stock Management
a. Opening Stock Setup
Full & empty cylinder count per type
b. Daily Refill Load Entry
Record cylinders received from supplier
Increases full cylinder stock
Stock auto-updated
---
4. Sales (Retail / Distributor Sale)
a. Create Sale Invoice
Select Customer (cash/credit)
Select Cylinder Type(s)
Qty, Rate, Remarks
Delivery Mode: Agent / Self
Payment: Cash / Credit
Auto-stock deduction of full cylinders
Auto-add of empty cylinders (assumed returned)
b. Download/Print Invoice
Print-ready invoice with branding
Tax details (if applicable)
---
5. Payment Collection
View due customers
Record customer payment
Payment mode: Cash, Bank, UPI
Update balance
Receipt downloadable
---
6. Expenses Management
Add daily expenses
Category: Diesel, Salary, Misc.
Attach receipts (optional)
Track branch-wise
---
7. Cash Handover to Owner
Daily or periodic handover
Record handover amount
Linked to sales and payment collections
Print handover summary
---
8. Reports Module
a. Daily Sales Report
Sale summary: customer, quantity, amount
Filter by date, branch, agent
b. Due Report
All customers with outstanding balances
Filter by duration: today, 7 days, 30 days, all
c. Godown Closing Stock
Full & empty cylinder status
Real-time inventory
d. Expense Report
Category-wise or branch-wise
Filter by date/month
e. Cash Flow Report
Cash in (sales + payments)
Cash out (expenses + handover)
f. Customer Ledger
All transactions per customer
Sale, payment, current balance
---
9. Backup / Export
Export all reports to Excel/PDF
Daily auto-backup (optional)
---
10. Settings
Business info (Agency Name, GSTIN, Logo)
Cylinder prices
User settings
Password change
Branch-wise permissions (future)
---
Example Workflow:
1. Admin logs in
2. Enters today's refill load
3. Creates 10 sales invoices
4. Collects 3 cash payments
5. Records diesel expense
6. Views daily stock and cash report
7. Handover ₹10,000 to owner
8. Downloads customer due report