Plan vs Actuals: Building a Fuel Station Budget That Drives Profit

What should a gas station budget actually do?

A gas station budget should explain how a site intends to earn profit, not simply predict its sales. Start with the operating drivers managers can influence: fuel litres or gallons sold, retained margin, store gross profit, paid hours and controllable expenses. Then connect those drivers to a monthly petrol station P&L. The result should make an unexpected outcome explainable and give someone responsibility for the next decision.

Keep the budget, latest forecast and actual results separate. The budget records the original commitment; the forecast records the latest expectation; actuals record what happened under agreed accounting policies. Replacing the budget every time trading changes destroys accountability. Equally, treating an outdated budget as the only useful view hides emerging cash and staffing pressures. Review all three together, using the same account definitions and reporting periods.

How do you build the budget from operating drivers?

Start with volume and retained margin

Build fuel volume by grade and month, using the site’s own trading history, known opening hours and documented operational changes. Identify abnormal closures or temporary traffic disruption rather than carrying them forward mechanically. Budget margin on a consistent basis after the relevant product costs, discounts and contractual adjustments. Separate fuel revenue from retained fuel gross profit: high pump prices can inflate turnover without improving what the operator keeps.

Use one measurement basis throughout each calculation. A gallon-based business should not compare its unit margin directly with a litre-based model without conversion and matching currency. Decide whether delivery charges and supplier rebates belong in landed product cost, then apply that policy consistently. Where rebates depend on thresholds, show the eligibility assumption explicitly rather than assuming the most favourable outcome will arrive automatically.

Model the shop and the cost base separately

For the convenience store, budget net sales and gross margin by category rather than applying one blended rate to everything. For labour, model paid hours and the full employer cost per hour, including relevant payroll burdens. Split utilities into consumption and tariff assumptions where data permits. Treat card fees as a function of eligible card turnover and the effective fee structure, not as an arbitrary percentage of total site profit.

Build seasonality into the drivers before allocating annual totals across months. Longer trading hours may affect staffing, refrigeration and sales together; planned maintenance may reduce fuel throughput while adding expense. Record each assumption with its owner and evidence. A budget becomes much easier to challenge when the manager can distinguish a deliberate operating change from a spreadsheet allocation that has no operational explanation.

How should plan versus actual variance analysis work?

Close and reconcile the underlying records before explaining performance. Match pump sales, point-of-sale totals, stock movements, payroll and supplier invoices to the reporting period. Accrue material costs when invoices arrive late, and flag estimates clearly. Otherwise, an apparently favourable month can simply reflect missing expenses. Andrils Daily connects reconciliation and operating analysis so unresolved exceptions are visible before they distort the management discussion.

Use a fixed sign convention: positive variances improve EBITDA and negative variances reduce it. EBITDA means earnings before interest, tax, depreciation and amortisation; it is not cash available to the owner. Define the treatment of rent, owner remuneration and unusual operating items before comparing periods. Do not present a favourable expense variance as an improvement until you know whether the underlying service was delivered or merely deferred.

For example, an illustrative monthly plan assumes one million litres and a retained fuel margin of $0.10 per litre. Actual volume is 950,000 litres and actual margin is $0.12 per litre. The volume effect is negative $5,000, while the margin effect is positive $19,000. Together they explain fuel gross profit rising from $100,000 to $114,000. Calculate these effects by grade when changing product mix would otherwise obscure the explanation.

In this illustrative bridge, other operating expenses include all remaining expenses within the stated EBITDA definition. The table reconciles to the waterfall: fuel volume and margin together explain the fuel gross-profit change, while the remaining lines explain the rest. Never add those two driver effects to the fuel gross-profit variance again. That double counting is a common way for an apparently detailed bridge to become mathematically wrong.

Which variances deserve management attention first?

Prioritise variances by financial impact, controllability and recurrence, not simply by percentage change. A large percentage movement in a minor account can distract from a small deterioration in fuel margin across substantial volume. Establish local review thresholds and an exception route for control failures regardless of value. A cash discrepancy, missing delivery record or unexplained stock movement needs investigation even when the monthly P&L still looks healthy.

Separate activity changes from execution problems

Ask whether an expense moved because activity changed, the purchase rate changed or resource use became less efficient. Higher card fees may follow stronger card-funded sales rather than worse payment terms. Higher labour expense might reflect extra opening hours, overtime or a different staffing mix. A flexible budget recalculates expected variable costs at actual activity, helping distinguish the cost of serving additional demand from avoidable overspending.

Keep timing differences separate from permanent changes. A late supplier credit might reverse next month; a changed supply term may affect every future delivery. Update the forecast when evidence changes, while preserving the original budget comparison. Where several causes interact, state the allocation method and retain supporting calculations. A manager should be able to reproduce the explanation without relying on the person who prepared the spreadsheet.

How do you turn the budget into a daily operating routine?

Translate monthly assumptions into a short operating scorecard rather than expecting staff to manage an entire financial model. Review fuel volume and retained margin, shop gross profit, rostered versus paid hours, and unresolved reconciliation exceptions. Compare equivalent trading days and account for holidays or closures. Daily results are signals, not a substitute for a properly closed monthly P&L, particularly when rebates, accruals and inventory adjustments remain outstanding.

Before approving the annual plan, run a downside case that changes the drivers together rather than adjusting EBITDA directly. Consider what happens if fuel volume weakens while wages and essential maintenance remain committed. Identify which responses are genuinely available, who can authorise them and how quickly they take effect. A sensitivity model is useful only when its assumptions are operationally possible; cutting staffed hours below safe coverage is not a credible management response.

Build a short assumptions register alongside the financial model. For every material driver, record the source period, the calculation, the responsible manager and the next review date. Mark uncertain inputs separately from contracted rates. When actual results differ, this register helps distinguish a flawed original assumption from a failure to execute an agreed plan. It also makes handovers more reliable when a site manager or finance colleague changes role during the year.

Give the monthly review a clear close process. Set submission deadlines for stock counts, payroll corrections and supplier claims, then track adjustments made after the initial report. Persistent late changes are themselves a process issue worth fixing. A stable reporting calendar reduces arguments about which version is correct and leaves more meeting time for commercial decisions. Keep the supporting detail accessible, but put the main profit bridge and agreed actions at the front of the review.

Hold a weekly action review focused on exceptions with a named owner. Agree what will change in pricing, staffing, ordering or controls, and state which measure should respond. Avoid instructions such as “improve margin” without a specific operating decision. Review whether the last action worked before adding another. This creates a connection between the finance team’s explanation and the site manager’s next shift plan.

Finally, reconcile EBITDA to cash planning through inventory purchases, supplier payment timing, tax, debt service and capital expenditure. A profitable forecourt can still face liquidity pressure when stock requirements rise. Use daily performance support to maintain the operating evidence behind the budget, while keeping cash forecasts and investment approvals distinct. The objective is a repeatable management process: dependable actuals, transparent assumptions and decisions that can be checked against subsequent results.