Summary
What is the Fuel Surcharge Dashboard?
A reporting dashboard in Qargo that consolidates fuel surcharge (FSC) data across all customers into a single, filterable view
The dashboard shows which customers have FSC applied, the amounts charged, and how FSC compares to total transport charges — broken down by customer, by time period, and per order
Why does it exist?
Previously, there was no consolidated view of fuel surcharge data in Qargo. Transport teams had to navigate individual rate cards or process bulk exports to understand which customers had FSC configured and what amounts were being charged
The dashboard replaces those manual processes with a real-time, filterable report available directly in Qargo's reporting section
How does it work?
Open the Fuel Surcharge dashboard from Qargo's reporting section
Apply Date and Customer filters to scope the data
Review the three data tables — by customer, by time unit, and at order level — alongside the summary KPIs at the top of the page
Terminology
Term | Definition |
Fuel Surcharge (FSC) | An additional charge applied to orders to cover fuel costs, calculated as a percentage of the transport charge or based on a price index |
Surcharge Index | The add-on type used for fuel surcharges linked to a price index. The Fuel Surcharge Dashboard only covers charges of this type |
KPI | Key Performance Indicator — a summary metric shown at the top of the dashboard, updating dynamically based on active filters |
Time unit | The period used to group rows in the By-time table. Determined by the unit selected in the Date filter (e.g., days, weeks, months) |
Avg FSC % | The average of FSC amount divided by transport charge, calculated across orders where FSC is present |
Navigating to the Dashboard
The Fuel Surcharge dashboard is located in the Dashboards section of Qargo.
OPEN the Dashboards section from the main navigation
SELECT Fuel Surcharge from the list of available dashboards
Filters
The dashboard includes four filters that control all data displayed, including the summary KPIs and all three tables.
Date — A rolling window filter using the format "in the last [N] [unit]". The unit can be set to days, weeks, completed weeks, months, completed months, quarters, completed quarters, years, or completed years. Selecting a completed unit excludes the current partial period (e.g., completed months excludes the current month in progress). The selected time unit also determines how rows are grouped in the By time table.
Customer — Filters all tables to a single customer account. When applied, the By customer table shows a single row for that customer.
Order name — Filters the Order overview table to a specific order.
Has FSC — A toggle to show only orders with FSC applied, or only orders without FSC.
Summary KPIs
At the top of the dashboard, a row of summary metrics provides an at-a-glance view of the selected period. All values update dynamically when filters are changed.
Total orders — The total number of orders in the selected period
Orders with FSC — The count and percentage of orders where a fuel surcharge add-on is present
Orders without FSC — The count and percentage of orders where no fuel surcharge add-on is present
Average FSC amount — The average fuel surcharge amount (€) across orders where FSC is present
Average FSC % — The average FSC as a percentage of the transport charge, across orders where FSC is present
By Customer Table
The By customer table shows one row per customer, consolidating all order data for the selected period. All columns are sortable.
Column | Description |
Customer | The customer account name |
Total orders | Total number of orders for this customer in the selected period |
Orders with FSC | Count and percentage of that customer's orders where FSC is applied |
Orders without FSC | Count and percentage of that customer's orders where no FSC is applied |
Total transport charge | Sum of all transport charges across the customer's orders |
Total FSC amount | Sum of all fuel surcharge amounts across the customer's orders with FSC |
Avg FSC % | Average of FSC amount ÷ transport charge, across the customer's orders with FSC |
CLICK any column header to sort the table by that column.
By Time Table
The By time table groups the same data by time period rather than by customer, showing consolidated totals across all customers per period. The table title and first column header update dynamically to reflect the active date unit.
Rows represent individual time periods within the selected date range (e.g., four rows for "in the last 4 weeks")
Rows are displayed newest first
Columns are identical to the By customer table, with the first column showing the time period label instead of a customer name
Order Overview Table
The Order overview table provides order-level detail, with one row per order.
Column | Description |
Order name | The unique order identifier |
Customer | The customer account associated with the order |
Transport charge | The transport charge amount for the order |
FSC amount | The fuel surcharge amount applied to the order (blank if no FSC is present) |
Limitations
The Fuel Surcharge Dashboard only covers surcharges of type SURCHARGE_INDEX — charges linked to SURCHARGE_GENERAL add-ons are not included in the dashboard data
Troubleshooting
Issue | Likely cause | What to check |
A customer does not appear in the By customer table | No orders exist for that customer in the selected date range, or no orders have been collected/delivered in that period | Widen the Date filter or verify the customer has orders in the selected period |
FSC amounts are unexpectedly low or missing | The customer's fuel surcharge may be configured as SURCHARGE_GENERAL rather than SURCHARGE_INDEX | Check the customer's rate card add-on type — only SURCHARGE_INDEX charges are included in this dashboard |
The By time table shows fewer rows than expected | Completed period units exclude the current partial period | Switch from a completed unit (e.g., completed months) to a standard unit (e.g., months) to include the current period |
KPI totals don't match the sum of the table rows | A filter is applied that scopes the visible table but still affects KPIs | Check all active filters and reset to All to see unfiltered totals |