Contact person: Full Petrol Pump Management Web App Development

Phone:Show

Email:Show

Location: Mysore, India

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Summary

Build a **production-grade**, mobile-friendly web app (PWA) for a single petrol pump, future-ready for multi-site. Simple English UI, IST timezone.

**Key Outcomes**

* Accurate **fuel stock** and **tank reconciliation** (DIP→liters), nozzle meter readings, and price change logs.
* Daily **sales** (liters/₹) with payment mix; **variance** vs physical DIP.
* **VIP credit** customers billed monthly (SOA, aging); non-VIPs pay Cash/UPI/Card.
* **Employee** shifts, attendance, hours, overtime, and shift settlements.
* **Expenses** (OpEx/CapEx) and **daily net profit**.
* Nightly **instant messaging DSR to owner only** (after last shift close) with retries and no duplicates.
* Full **audit trail**, backups, and PDF/CSV exports.

**Modules & Features**

1. **Masters & Setup**: Products (MS/HSD/Lubes), Tanks (with strapping table), Dispensers/Nozzles (link to tanks), time-stamped Prices, Vendors, Sites (multi-outlet later).
2. **Daily Operations**:

* **Shift Open/Close**: nozzle totalizers (open/close), tank DIP (mm), optional density/water.
* **Sales**: nozzle-wise liters/₹; payment modes (Cash/UPI/Card/Credit).
* **POS for lubes** (SKU stock & billing).
* **Purchases/GRN**: supplier, invoice, liters, rate, charges → post to tank.
* **Cash Settlement**: expected vs counted; UPI/Card totals; deposit refs.
3. **Reconciliation & Variance**: system closing = opening + purchases − sales; physical from DIP; variance (L/%) with tolerance alerts; price change log.
4. **Customers (VIP Credit Only)**: VIP flag, credit limit, monthly billing day (+ Dept/PO); monthly **SOA PDF**, aging, receipts; non-VIPs cannot use credit.
5. **Employees**: roster (assign attendants to nozzles), attendance in/out, working hours, overtime, leaves; productivity (L/hour), cash variance by user; payroll inputs export.
6. **Expenses & Profit**: categories (Service/Renovation/Food/Electricity/Misc), modes (Cash/UPI/Bank), **isCapex**; **Daily Gross Margin** (by effective buy cost), **OpEx**, **CapEx (separate)**, **Daily Net Profit**.
7. **Reports & Exports**:

* **DSR**: product/nozzle sales (L/₹), payment mix, purchases, closing stock, variance, expenses, deposits, **net profit**.
* Tank stock ledger, DIP trend, price change log, purchase register.
* Customer ledger & monthly SOA, employee attendance/productivity.
* **PDF & CSV** exports.
8. **Instant Messaging (Owner-Only, Nightly)**:

* Trigger after last shift closes; provisional at cut-off if unclosed.
* Content: MS/HSD sales (L/₹), payment mix, purchases, closing stock, variance, expenses, deposits, alerts.
* **Idempotent** with retry/backoff (e.g., via Meta instant messaging Cloud API or BSP).
9. **Account, Audit & Safety**:

* Start with **single Admin login** (RBAC-ready for later).
* **Audit log** (who/when/before→after) for all edits/deletes; shift **lock** after approval.
* Scheduled **daily backups**; IST everywhere.

**Tech Preferences (open to proposals)**

* **Frontend**: [login to view URL] (App Router) or ASP.NET Core + React; Tailwind + shadcn/ui; **PWA/offline**.
* **Backend**: Node.js (Next API/NestJS) or ASP.NET Core.
* **DB**: PostgreSQL (Prisma/EF Core), object storage for PDFs.
* **PDF**: Server-side generator (PDFKit/iText/QuestPDF).
* **Instant Messaging**: Meta Business **instant messaging** (Cloud API) or BSP.
* **Deploy**: Docker; .env configuration.

**Core Data (minimum)**
products, price\_changes, tanks, **tank\_strapping(dip\_mm, liters)**, dispensers, nozzles;
shifts, meter\_readings, dips, sales, shift\_cash, purchases, expenses;
employees, attendance; customers (**is\_vip\_credit**, limit, billing\_day, gstin, dept/po), receipts;
audit\_log, report\_logs, messaging\_queue.

**Deliverables**

* Source repo with README, schema/migrations, **seed data**.
* **.[login to view URL]**, Docker setup.
* Nightly **instant messaging DSR** (owner only) with logs/idempotency.
* PDF/CSV exports; backup script; error handling & toasts.
Short admin guide + 1h handover call.

Acceptance Criteria

* Shift open/close with nozzle+DIP; correct **variance** & **closing stock**.
* Sales/expenses reflected on Dashboard and **DSR**; **Daily Net Profit** correct.
* Only **VIP** customers billed on credit; monthly **SOA PDF** generated.
* Owner receives nightly **instant messaging** DSR (provisional handling).
* All edits in **audit log**; shifts lock post-approval.
* Exports (PDF/CSV) and backup job working as documented.

**What to Include in Your Proposal**

* Tech stack & brief architecture idea (2–4 sentences).
* Relevant examples (inventory/fuel/retail/reporting/messaging).
* Estimated timeline & cost (fixed or milestones).

You will be asked to answer the following questions when submitting a proposal:

1. Include a link to your GitHub profile and/or website
2. What frameworks have you worked with?
3. Describe your recent experience with similar projects" (client-provided description)