The remaining amount that should physically be in the safe.

Yes. Upload the downloaded .XLSX file to Google Drive and open with Google Sheets. Most formulas (SUMIF, VLOOKUP, IF) work perfectly.

Add dropdown menus for your fuel attendants' names and fuel types to ensure consistent data entry.

Running a petrol pump is a high-volume, low-margin business where every drop—and every penny—counts. Between fluctuating fuel prices, credit sales to fleet owners, and daily shift handovers, keeping your books straight can be a nightmare.

= Actual_Closing_Dip_Stock - (Opening_Dip_Stock + Tank_Receipts - Net_Liters_Sold) Use code with caution.

Excel calculates what should be in the tank: = Opening Stock + Purchases - Sales

Our use of cookies

We use necessary cookies to make our site work. We'd also like to set optional analytics cookies to help us improve it. We won't set optional cookies unless you enable them. Using this tool will set a cookie on, your device to remember your preferences.

Necessary cookies enable core functionality such as security, network management, and accessibility. You may disable these by changing your browser settings, but this may affect how the website functions. petrol pump accounting in excel sheet download

We'd like to set Google Analytics cookies to help us to improve our website by collecting and reporting information on how you use it. The cookies collect information in a way that does not directly identify anyone. The remaining amount that should physically be in the safe

I accept all cookies
)