Skip to main content

FBO Dashboard

The FBO Dashboard provides a real-time snapshot of your operation, combining financial performance and activity tracking into a single view.

Written by Jessi McCombs

📊 Dashboard Tabs

Volume Tab

The Volume tab provides a 12-month view of fuel performance.

You can use this tab to:

  • Track gallons sold by fuel type

  • Monitor average margin trends

  • Review MTD summaries by fuel bucket

Activity Tab

The Activity tab displays operational activity across your FBO.

You can use this tab to:

  • View arrivals, departures, and fuelings

  • Analyze hourly activity for the current day

  • Track monthly and yearly totals

Revenue Tab

The Revenue tab shows income trends for fuel and services.

You can use this tab to:

  • Compare revenue for today, this month, and last month

  • Monitor fuel vs. service revenue performance

  • Review revenue per departure


How Margin is Calculated

The dashboard displays gross product margin, not net profit.

✅ Formula

For each invoice line:

(Customer Price – Taxes – Product Cost) × Quantity

✔️ Included

  • Sales taxes

  • Product cost

  • Cost-side taxes

❌ Not Included

  • Salaries

  • Utilities

  • Credit card fees

  • Depreciation

  • Overhead

  • Into-plane fees

⚠️ Important: The dashboard will not match your accounting system’s P&L. This is expected.


⛽ Fuel Bucket Definitions

Each fuel transaction is categorized into a specific bucket:

Bucket

Description

Avgas

All Avgas sales

Government

Transactions paid with AIRCard

Contract

Paid by a third party (fleet/program account)

Retail

Paid at or above retail price

Discount

Paid below retail price


📄 Included Invoices

Only invoices that meet all of the following criteria are included:

✅ Requirements

  1. Invoice is active (not deleted)

  2. Belongs to your FBO location

  3. Status is not Draft, Cancelled, or Refund

  4. Created using the pricing engine (v2)

  5. Falls within the selected date range (based on local airport time)


Common Questions

Why doesn’t the dashboard match accounting reports?

This is expected due to:

  • Gross margin vs. net profit differences

  • Refunds and cancellations are excluded

  • Legacy (v1) invoices are excluded

  • Local airport time is used for calculations

Why is a sale marked as “Discount”?

If the final price is below the retail price, the system automatically classifies it as Discount.

Why are AIRCard transactions labeled “Government”?

All AIRCard transactions are treated as government/military fueling, regardless of customer.

Why is a transaction categorized as “Contract”?

If the payer differs from the aircraft operator, it is categorized as Contract.

What does the MTD dollar value represent?

It shows:

➡️ Average margin per gallon for the month
➡️ Calculated as total margin ÷ total gallons


🛠️ Troubleshooting

If dashboard data appears incorrect, follow these steps:

  1. Confirm invoice uses pricing engine v2

  2. Verify invoice status is not:

    • Draft

    • Cancelled

    • Refund

  3. Confirm the invoice is not deleted

  4. Verify fuel type:

    • Jet A

    • Jet A+

    • Avgas

  5. Check:

    • Payment method

    • Who paid

    • Price vs. retail price

  6. Confirm the airport time zone settings

  7. Review expected differences vs. accounting reports


⚠️ Known System Limitations

  • The dashboard does not reflect net profit

  • Legacy invoices (pre-v2) are excluded

  • Refunds and cancelled invoices are not shown

  • Only AIRCard transactions appear as Government

  • New fuel types require system configuration


✅ Summary

The FBO Dashboard helps you quickly:

  • Monitor fuel sales and margins

  • Track daily operations and activity

  • Identify trends without needing accounting reports


Need more help? Contact X‑1FBO Support for further assistance

Did this answer your question?