Fuel Station Excel Workbook Creation -- 2

Job ID: 40240453

Budget: ₹600 – ₹1,500 INR

I’m looking for a well-structured Excel workbook that mirrors the screenshot I’ll share and streamlines our daily paperwork at the forecourt. The sheet has to accommodate two MPDs with eight nozzles in total—four dispensing Petrol (MS) and four Diesel (HSD). I’ll key in the opening and closing meter readings manually, so the template must automatically calculate volume sold, deduct any testing quantity, and extend totals, all driven by a per-litre rate I can change each day. Colour-coded sections are important to me: one colour for MS, another for HSD, and a clearly separated collection panel. The collection area needs columns for Cash, Paytm, PhonePe, Swipe Card, DG, Credit, Coin and Tiffin, with a grand total that feeds into a Status/Difference line comparing money collected against fuel sold. Beyond the main sales sheet, I also want space to note daily expenses, record staff shift details and keep an eye on inventory levels. No direct pump integration is required—everything will be typed in manually—so focus on user-friendly data entry points and locked-down formulas to prevent accidental overwriting. Deliverables • Excel file (.xlsx) matching the layout in my sample image • Automatic calculations for every metric described above • Colour-coded formatting for quick visual checks • Separate tabs/sections for expenses, shifts and inventory, linked where useful • Formula protection and a clean print-ready view I’ll provide the screenshot as soon as we start so you can replicate the look precisely.