Petrol Pump Management Excel Sheet Free: Download

This calculates the "Dry Stock" profit (profit on lubricants/snacks) and "Wet Stock" profit (fuel).

Key Metrics to Track:

This template is fully unlocked. You can easily:

This is the transaction log. Each row represents a nozzle or a shift. Columns must include: petrol pump management excel sheet free download

While this Excel sheet is powerful, it is not perfect for every scenario.

Use the Excel Sheet if:

Upgrade to a paid ERP (e.g., Petrosoft, NCR Counterpoint) if: This calculates the "Dry Stock" profit (profit on

The Excel sheet is the perfect starting point to understand your metrics before investing $2,000+ in hardware.

As an AI, I cannot generate a .xlsx file, but you can create one in 30 seconds using the text below.

Instructions:

Date	Shift	Fuel Type	Opening Meter	Closing Meter	Sale Qty (Ltrs)	Rate	Total Sales	Cash	Card	Difference	Expense Type	Expense Amt
01/11/2023	Morning	Petrol	10050	10200	150	100	15000	10000	5000	0	Electricity	5000
01/11/2023	Morning	Diesel	5000	5200	200	90	18000	18000	0	0	Salary	0
01/11/2023	Evening	Petrol	10200	10400	200	100	20000	20000	0	0	Maintenance	0

Formulas to apply after pasting:

Q: Will this work on a Mac?
Yes. Apple Numbers can open it, but we recommend Microsoft Excel for full formula support.

Q: Can multiple employees use it without corrupting data?
For a single location, yes. For multiple PCs, save it on a shared drive (OneDrive/Google Drive) but open it one user at a time. This template is fully unlocked

Q: Does it calculate GST on sales?
Yes. The sheet includes separate columns for Taxable Value, CGST, and SGST (Indian model) or single sales tax (international).