Petrol Pump Accounting In Excel: Sheet Download

function salesChangeHandler(e) 0; let rate = parseFloat(document.querySelector(`.sales-rate[data-idx='$idx']`)?.value)

function getNetProfit() return getTotalSales() - getTotalExpenses();

<div class="excel-table" id="excelTableContainer"> <!-- dynamic table will be injected --> </div> <div class="footer"> * Double-click any cell to edit. Sales & expenses auto update profit. Stock closing = Opening + Received - Sold. </div> </div> petrol pump accounting in excel sheet download

function attachDeleteButtons() document.querySelectorAll('.delRowBtn').forEach(btn => btn.removeEventListener('click', deleteHandler); btn.addEventListener('click', deleteHandler); );

let stockData = [ product: "Petrol (MS)", opening: 5200, received: 8000, sold: 1250, closing: 11950, unitPrice: 102.50 , product: "Diesel (HSD)", opening: 4300, received: 7000, sold: 980, closing: 10320, unitPrice: 94.80 , product: "Premium Petrol", opening: 1100, received: 2000, sold: 320, closing: 2780, unitPrice: 115.00 , product: "Engine Oil (Lube)", opening: 180, received: 120, sold: 45, closing: 255, unitPrice: 850.00 ]; product: "Diesel (HSD)"

// Recompute stock closing & stock value function recomputeStock() for (let i = 0; i < stockData.length; i++) let s = stockData[i]; s.closing = s.opening + s.received - s.sold;

// 3. Stock Management Table html += `<h3 style="margin:25px 0 5px 0; color:#1e4a2f;">📦 Stock Summary (Liters / Units)</h3>`; html += `<table id="stockTable"><thead><tr><th>Product</th><th>Opening (Ltr)</th><th>Received (Ltr)</th><th>Sold (Ltr)</th><th>Closing (Ltr)</th><th>Unit Price (₹)</th><th>Stock Value (₹)</th><th></th></tr></thead><tbody>`; for (let i = 0; i < stockData.length; i++) let st = stockData[i]; let stockValue = (st.closing * st.unitPrice).toFixed(2); html += `<tr data-type="stock" data-index="$i"> <td style="background:#faf3e0;">$st.product</td> <td><input type="number" step="0.01" class="stock-opening" value="$st.opening" data-idx="$i"></td> <td><input type="number" step="0.01" class="stock-received" value="$st.received" data-idx="$i"></td> <td><input type="number" step="0.01" class="stock-sold" value="$st.sold" data-idx="$i"></td> <td class="stock-closing">$st.closing.toFixed(2)</td> <td><input type="number" step="0.01" class="stock-price" value="$st.unitPrice" data-idx="$i"></td> <td class="stock-value">$stockValue</td> <td><button class="delRowBtn" data-type="stock" data-idx="$i" style="background:#b33;">🗑️</button></td> </tr>`; html += `<tr><td colspan="7"><button id="addStockRowBtn" style="background:#3c8c40;">+ Add Stock Product</button></td><td></td></tr>`; html += `</tbody></table>`; product: "Premium Petrol"

let salesData = [ product: "Petrol (MS)", liters: 1250, rate: 102.50, amount: 128125 , product: "Diesel (HSD)", liters: 980, rate: 94.80, amount: 92904 , product: "Premium Petrol", liters: 320, rate: 115.00, amount: 36800 , product: "Engine Oil (Lube)", liters: 45, rate: 850, amount: 38250 ];