Petrol Pump Accounting In Excel Sheet Download May 2026

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

let expensesData = [ date: "01-Apr-2026", category: "Electricity", amount: 5500 , date: "05-Apr-2026", category: "Staff Salary", amount: 28500 , date: "10-Apr-2026", category: "Maintenance", amount: 3200 , date: "15-Apr-2026", category: "Misc", amount: 1750 ];

container.innerHTML = html;

function getTotalClosingStockValue() return stockData.reduce((sum, st) => sum + (st.closing * st.unitPrice), 0);

function deleteHandler(e) const btn = e.currentTarget; const type = btn.getAttribute('data-type'); const idx = parseInt(btn.getAttribute('data-idx')); if (type === 'sales') salesData.splice(idx, 1); else if (type === 'expense') expensesData.splice(idx, 1); else if (type === 'stock') stockData.splice(idx, 1); renderTables(); petrol pump accounting in excel sheet download

// 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;

function attachAddRowButtons() const addSalesBtn = document.getElementById('addSalesRowBtn'); if (addSalesBtn) addSalesBtn.replaceWith(addSalesBtn.cloneNode(true)); document.getElementById('addSalesRowBtn')?.addEventListener('click', () => salesData.push( product: "New Fuel", liters: 0, rate: 100, amount: 0 ); renderTables(); ); const addExpenseBtn = document.getElementById('addExpenseRowBtn'); if (addExpenseBtn) addExpenseBtn.replaceWith(addExpenseBtn.cloneNode(true)); document.getElementById('addExpenseRowBtn')?.addEventListener('click', () => expensesData.push( date: "New Date", category: "Other", amount: 0 ); renderTables(); ); const addStockBtn = document.getElementById('addStockRowBtn'); if (addStockBtn) addStockBtn.replaceWith(addStockBtn.cloneNode(true)); document.getElementById('addStockRowBtn')?.addEventListener('click', () => stockData.push( product: "New Product", opening: 0, received: 0, sold: 0, closing: 0, unitPrice: 100 ); recomputeStock(); renderTables(); ); let expensesData = [ date: "01-Apr-2026"

function attachInputEvents() // Sales liters & rate document.querySelectorAll('.sales-lit, .sales-rate').forEach(inp => inp.removeEventListener('input', salesChangeHandler); inp.addEventListener('input', salesChangeHandler); ); // Expenses amount document.querySelectorAll('.exp-amt').forEach(inp => inp.removeEventListener('input', expenseChangeHandler); inp.addEventListener('input', expenseChangeHandler); ); // Stock fields: opening, received, sold, price document.querySelectorAll('.stock-opening, .stock-received, .stock-sold, .stock-price').forEach(inp => inp.removeEventListener('input', stockChangeHandler); inp.addEventListener('input', stockChangeHandler); );