FuelFlow Analytics

Today's Submissions

Total Sales Today

£0

0 of 11 sites

Total To Bank

£0

After MFG deductions

Gross Variance

£0

Cash over / short

Sites Reported

0/11

0 pending

Total Sales by Site

Revenue Breakdown

Fuel

—

Shop

—

Other

—

All Sites — Today's Status

Site	ID	Status	Total Sales	Sales %	To Bank	Fuel	Shop	Gross Variance

Select Date

All Submissions

📅

Select a date to view submissions

Last 12 months of data available

Today's Submissions

Loading today's data from Google Sheets...

Site	ID	Total Sales	To Bank	Fuel	Shop	Variance	Status	Action

Select Date

Select Site

📅

Select a date to view submissions

Use the filter above to look up any day's sales data

Add New User

Full Name

Email Address

Assign Site

Temporary Password

How it works: Enter the details and click Add User. Then go to Firebase Console → Authentication → Add User with the same email and password. The app will automatically assign them to the selected site when they log in.

Current Users

Name	Email	Site	Action
Click Refresh to load users

Daily Sales Submission

POS / till system MFG application manually counted auto-calculated

⛽

Site & Date

Site

Date

Today

Daily Sales Form — Rows 3 to 92

Same row order as Copy of Final Template

▼

Day End — Rows 2–8
3	Total Payments (Day End)	C3 — Day End = C3 View reference E3 G3
4	Total EFT Payments (Day End)	C4 — Day End = C4 View reference E4 G4
5	Remaining Payment Amount	C5 — Calculated = C3−C4 E5 G5
6	Other Payments If any (Day End)	C6 — Day End = C6 View reference E6 G6
7	Coupons (Day End)	C7 — Day End = C7 View reference E7 G7
8	Cash Payments for the Day	C8 — Calculated = C5−(C6+C7) E8 G8
Overall Sales — Rows 10–23
11	Shop Sales	C11 — Day end = C11 View reference E11 G11
12	Fuel Sales	C12 — Day end = C12 View reference E12 G12
13	Bunkered Sales	C13 — Day end = C13 View reference E13 G13
14	Total = Fuel Sales + Bunkered Sales	C14 — Calculated = C12+C13 E14 G14
15	Paid Out	C15 — Day end = C15 View reference E15 G15
16	Total Sales	C16 — Calculated = SUM(C11+C14)−C15 E16 G16
17	Charity Paymnets	C17 — Day end = C17 View reference E17 G17
18	Total Payments = Total Sales	C18 — Calculated = C3=C16+C17 E18 G18
19	Bunkered Sales (Fuel Cards Payments) Orange → Fuel Bunkering → Bunkered Sales Sum of all bunkered values	C19 — Orange = C19 View reference E19 G19
20	Bunkered Non-Metered Orange → Fuel Bunkering → Non Metered Sales	C20 — Orange = C20 View reference E20 G20
21	Bunkered Sales Total	C21 — Calculated = C19+C20 E21 G21
22	Current Variance Orange → Fuel Inventory → Combined Variance → This Reports Variance	C22 — Orange = C22 View reference E22 G22
23	Total Fuel Sales	C23 — Calculated = (C14−C19)+C22 E23 — Orange Orange → Summary → Summary of Takings → Total Fuel Sales View reference G23 — Calculated = C23−E23
Takings (+) — Rows 25–46
26	Total Fuel Sales	C26 — Calculated = =E23 E26 G26
27	Valet Sales Orange → Summary → Summary of Takings → Valet Sales - VC Due	C27 — Orange = C27 View reference E27 G27
28	Shop Facility Charge Orange → Summary → Summary of Takings → Shop Facility Charge	C28 — Orange = C28 View reference E28 G28
29	Work Facility Charge Orange → Summary → Summary of Takings → Work Facility Charge	C29 — Orange = C29 View reference E29 G29
30	Valet Facility Charge Orange → Summary → Summary of Takings → Valet Facility Charge	C30 — Orange = C30 View reference E30 G30
31	Marketing Services Orange → Summary → Summary of Takings → Marketing Services	C31 — Orange = C31 View reference E31 G31
32	Insurance Recharge Orange → Summary → Summary of Takings → Insurance Recharge	C32 — Orange = C32 View reference E32 G32
33	Subway Facility Fee Orange → Summary → Summary of Takings → Subway Facility Fee	C33 — Orange = C33 View reference E33 G33
34	Costa Facility Fee Orange → Summary → Summary of Takings → Costa Facility Fee	C34 — Orange = C34 View reference E34 G34
35	Pret Facility Fee Orange → Summary → Summary of Takings → Pret Facility Fee	C35 — Orange = C35 View reference E35 G35
36	Greggs Facility Fee Orange → Summary → Summary of Takings → Greggs Facility Fee	C36 — Orange = C36 View reference E36 G36
37	Burger King Facility Orange → Summary → Summary of Takings → Burger King Facility	C37 — Orange = C37 View reference E37 G37
38	Coco Di Mama Facility Orange → Summary → Summary of Takings → Coco Di Mama Facility	C38 — Orange = C38 View reference E38 G38
39	Miss Millies Facility Orange → Summary → Summary of Takings → Miss Millies Facility	C39 — Orange = C39 View reference E39 G39
40	Car Park Income Orange → Summary → Shop Sales → Car Park Income	C40 — Orange = C40 View reference E40 G40
41	Charity Tins (Macmillan) Orange → Summary → Shop Sales → Charity Tins (Macmillan)	C41 — Orange = C41 View reference E41 G41
42	Online Lottery Sales (500+) Orange → Summary → Shop Sales → Online Lottery Sales (500+)	C42 — Orange = C42 View reference E42 — Day end View reference G42 — Calculated = C42−E42
43	Paypoint Orange → Summary → Shop Sales → Paypoint	C43 — Orange = C43 View reference E43 — Day end View reference G43 — Calculated = C43−E43
44	Pennies - Charity Orange → Summary → Shop Sales → Pennies - Charity	C44 — Calculated = =C17 E44 — Orange View reference G44 — Calculated = C44−E44
45	Costa Coffee MK4 Orange → Summary → Shop Sales → Costa Coffee MK4	C45 — Orange = C45 View reference E45 G45
46	Total Charges	C46 — Calculated = SUM(C26:C45) E46 G46
Deductions (−) — Rows 48–68
49	Esso Nectar Loyalty Discount Orange → Summary → Deductions → Costa Coffee MK4	C49 — Orange = C49 View reference E49 G49
50	EV Site Visit Incentive Orange → Summary → Deductions → EV Site Visit Incentive	C50 — Orange = C50 View reference E50 — Manually Add View reference G50 — Calculated = C50−E50
51	Z-Lottery Online Paid Out Orange → Summary → Deductions → Z-Lottery Online Paid Out	C51 — Orange = C51 View reference E51 G51
52	Z-Paypoint Paid Out Orange → Summary → Deductions → Z-Paypoint Paid Out	C52 — Orange = C52 View reference E52 G52
53	Z-Scratch Cards Paid Out Orange → Summary → Deductions → Z-Scratch Cards Paid Out	C53 — Orange = C53 View reference E53 G53
54	Paid Outs if any in Day End	C54 — Calculated = SUM(C51:C53) E54 — Day end = SUM(E51:E53) View reference G54 — Calculated = C54−E54
55	Valet Commission - VC Orange → Summary → Deductions → Valet Commission - VC	C55 — Orange = C55 View reference E55 — Calculated = C27%×10 G55 — Calculated = C55−E55
56	Fuel Commission Orange → Summary → Deductions → Fuel Commission	C56 — Orange = C56 View reference E56 G56
57	Promotion Reimbursement - 20% VAT Orange → Summary → Deductions → Promotion Reimbursement - 20% VAT	C57 — Orange = C57 View reference E57 G57
58	Non Bunkered Sales Orange → Summary → Deductions → Non Bunkered Sales	C58 — Orange = C58 View reference E58 — Calculated = =C20 G58 — Calculated = C58−E58
59	Car Park Income Commission Orange → Summary → Deductions → Car Park Income Commission	C59 — Orange = C59 View reference E59 G59
60	Charity Tins (Macmillan) Commission Orange → Summary → Deductions → Charity Tins (Macmillan) Commission	C60 — Orange = C60 View reference E60 G60
61	Online Lottery Sales (500+) Commission Orange → Summary → Deductions → Online Lottery Sales (500+) Commission	C61 — Orange = C61 View reference E61 — Calculated = C42%×2 G61 — Calculated = C61−E61
62	Paypoint Commission Orange → Summary → Deductions → Paypoint Commission	C62 — Orange = C62 View reference E62 — Calculated = C43%×0.3 G62 — Calculated = C62−E62
63	Pennies - Charity Commission Orange → Summary → Deductions → Pennies - Charity Commission	C63 — Orange = C63 View reference E63 G63
64	Costa Coffee 1 Commission Orange → Summary → Deductions → Costa Coffee 1 Commission	C64 — Orange = C64 View reference E64 G64
65	Costa Coffee Large 1 Commission Orange → Summary → Deductions → Costa Coffee Large 1 Commission	C65 — Orange = C65 View reference E65 G65
66	Costa Coffee MK4 Commission Orange → Summary → Deductions → Costa Coffee MK4 Commission	C66 — Orange = C66 View reference E66 G66
67	Total Deductions	C67 — Calculated = C49+C50+C54:C66 E67 G67
68	Total To Bank	C68 — Calculated = C46−C67 E68 G68
Summary of Takings from MFG — Rows 70–81
71	Total Card Payments Shop	C71 — Calculated = =C4 E71 G71
72	Card Payments FTG1	C72 — FTG1 Day End = C72 View reference E72 G72
73	Card Payments FTG2	C73 — FTG2 Day End = C73 View reference E73 G73
74	Valet Payments via Nayax Orange → Credit Card Banking → Auto (View) → Valet Tenders (Nayax-Contactless Valet Value)	C74 — Orange = C74 View reference E74 G74
75	Grand Total Card Payments	C75 — Calculated = SUM(C71:C74) E75 G75
76	Total Bunkering Amount	C76 — Calculated = =C21 E76 G76
77	GTCP - TBA = Final Card Amount	C77 — Calculated = C75−C76 E77 G77
78	Card - To Bank = Balance Amount	C78 — Calculated = C77−C68 E78 G78
79	Valet Payments as Cash	C79 — Calculated = C27−C74 E79 G79
80	FTG1 Cash (e.g. Greggs Cash)	C80 — Manually Add View reference E80 G80
81	FTG2 Cash (e.g. Burger King)	C81 — Manually Add View reference E81 G81
82	Total Cash	C82 — Calculated = SUM(C78:C81) E82 G82
Store Cash — Rows 84–92
85	Day End Cash Payments Value	C85 — Calculated = =C8 E85 G85
86	Safe Drop value on Day End	C86 — Day End = C86 View reference E86 G86
87	Variance / Short	C87 — Calculated = C86−C85 G87 — Calculated = SUM(G19:G72)
89	Cash Remaining at Store	C89 — Calculated = C86+C82 E89 G89
92	Gross Varience	C92 — Calculated = SUM(C87:G87) E92 G92

Additional Information

Overall Suspended Sales Current Day

C94 — Manually Add

View reference

50's at Store

C95 — Manually Add

View reference

Remarks / Notes