---
title: "Fuel surcharge dashboard: what, why, and how"
description: "The fuel surcharge dashboard gives transport teams a real-time, consolidated view of fuel surcharge data across all customers: by customer, by time period, and at order level."
url: https://help.qargo.com/us/articles/618720-fuel-surcharge-dashboard-what-why-and-how
locale: us
updated: 2026-03-25
---

# Fuel surcharge dashboard: what, why, and how

## Summary {#h_ec102ab649}

-   **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, Qargo had no consolidated view of fuel surcharge data. Transport teams had to navigate individual rate cards or process bulk exports to see 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 the **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 {#h_8942df6f6a}

| **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 that updates dynamically based on the 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 the FSC amount divided by the transport charge, calculated across orders where FSC is present |

* * *

## Navigating to the dashboard {#h_05afb84f87}

The fuel surcharge dashboard is located in the **Dashboards** section of Qargo.

1.  **Open** the **Dashboards** section from the main navigation
2.  **Select** **Fuel Surcharge** from the list of available dashboards

![](https://help.qargo.com/media/8d5a389cc8f8-image.png)

* * *

## Filters {#h_972f6f05c1}

The dashboard includes four filters that control all the 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.

![](https://help.qargo.com/media/c70d2f907119-image.png)

* * *

## Summary KPIs {#h_39d360b3bd}

At the top of the dashboard, a row of summary metrics gives an at-a-glance view of the selected period. All values update dynamically when the filters change.

-   **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

![](https://help.qargo.com/media/5fb9d82c731c-image.png)

* * *

## By customer table {#h_94e8a6bdac}

The **By customer** table shows one row per customer and consolidates 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 the customer's orders where FSC is applied |
| **Orders without FSC** | Count and percentage of the 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.

![](https://help.qargo.com/media/6bcab20e329f-image.png)

* * *

## By time table {#h_63e99ae661}

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
-   The columns are identical to those in the **By customer** table, with the first column showing the time period label instead of a customer name

* * *

## Order overview table {#h_46e7101257}

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 {#h_21dc89df2d}

-   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 {#h_540031bad7}

| **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 were picked up/delivered in that period | Widen the **Date** filter or verify that 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 add-on type on the customer's rate card. 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 the KPIs | Check all active filters and reset them to **All** to see unfiltered totals |


## Related articles

- [Dashboards: summary of options](https://help.qargo.com/us/articles/329143-dashboards-summary-of-options.md)
- [Rates - Price index (fuel surcharge)](https://help.qargo.com/us/articles/133795-rates-price-index-fuel-surcharge.md)
- [Dashboards - Using custom dashboards: Walkthrough](https://help.qargo.com/us/articles/890188-dashboards-using-custom-dashboards-walkthrough.md)
- [Rate cards: automatically charge load costs to customer orders](https://help.qargo.com/us/articles/600709-rate-cards-automatically-charge-load-costs-to-customer-orders.md)
- [Rate card: general surcharges](https://help.qargo.com/us/articles/133796-rate-card-general-surcharges.md)
