Petrol Pump Accounting In Excel Sheet Download Verified

Since most fuel sales are paid via digital modes (cards, UPI) or cash, this sheet matches daily sales registers with actual bank deposits and cash-in-hand. It helps detect theft or accounting errors.

The most critical sheet. It records the tank’s physical dip in centimeters, converts it to liters (using a tank calibration chart lookup), adds received stock, subtracts sales, and calculates the expected closing stock. A variance column ( =Physical Stock - Theoretical Stock ) immediately flags shortages or overages. petrol pump accounting in excel sheet download

Excel calculates what should be in the tank: = Opening Stock + Purchases - Sales Since most fuel sales are paid via digital

Before you download the template, let’s analyze if Excel is right for your station. UPI) or cash