Skip to main content
This page lists every column and Key Metric in Loads Report and Trips Report, with the same definition you see in the app. Use it to check what a number means, how Alvys calculates it, and why a column or metric is missing.

How current is the data?

Loads Report and Trips Report read the Alvys reporting warehouse, not the live app database. This makes reports faster, also when you report over a large date range. The reports refresh about every 30 minutes, so a change can take up to about an hour to show. If you change a load or trip after the last refresh, the report shows the old values until the next refresh. The Legacy Report reads live data. The Data as of time in the report toolbar shows the date and time of the last update. If the Data as of time is more than an hour old, contact Alvys Support.
For live, minute-by-minute work, use the Loads page or Dispatch Planner. Use Loads Report and Trips Report for analysis and end-of-day work.

Why can’t I see a column or a Key Metric?

Some columns need a permission. If you do not have it, the column is not in the Columns panel, and a Key Metric that uses the column does not show. The Permission column in the tables below names the permission. When it lists two, either one is enough.
  • Users with the Admin, Biller, Office Admin or Partner Admin role see every column.
  • The Key Metrics section needs the View Summary Financial Report permission or one of the roles above.
  • A column marked Billing only needs the Billing permission (or one of the roles above). Other permissions do not unlock it.
  • An Admin can change permissions in Settings → Organization → Users.
Your company’s custom reference fields also appear as columns, in their own group at the end of the Columns panel. They are not listed here because they are different for each company.

How is gross margin calculated?

Gross Margin is customer revenue minus total carrier cost. It is blank on cancelled loads.
  • Customer revenue is the customer linehaul, plus the fuel surcharge when it is turned on, plus all customer accessorials on the load.
  • Total carrier cost is the cost of each trip on the load, added together. A cancelled trip costs 0.
    • Brokered trip: the carrier rate plus all carrier accessorials, including carrier payment fees such as QuickPay. The carrier rate is the overridden carrier rate when one was entered, otherwise the trip value. Advances are not counted again, because an advance is part of the carrier rate paid early.
    • Own-fleet trip: the pay for Driver 1, Driver 2 and the owner-operator on the trip.
  • Not in the cost: fuel-card charges, toll charges, and the fee your factoring company charges you (the Factoring Fee column).
Known limitation: own-fleet cost counts only the driver and owner-operator pay that is tied to a trip. Pay by day, per diem, minimum-pay top-ups and bonuses on the driver statement are not included, so the gross margin on those trips reads higher than it is. Margin % is gross margin divided by customer revenue. It is blank when revenue is 0. Gross Margin and Margin % are only in Loads Report. The definition in the Gross Margin column of Loads Report says the same in short form.

Loads Report: Key Metrics

The Key Metrics cards add up the rows that match your current filters. Hover the info icon on a card to see the same definition in the app.

Loads Report: columns

Loads Report has one row per load. Columns marked Default are in the report’s standard layout. Add the others from the Columns panel.

Core Identifiers & Status

People & Organization

Assets & Fleets

Dates & Times

Geography

Financial - Customer Side

Financial - Carrier/Driver Side

Financial - Margin & Mileage

Trips Report: Key Metrics

The Key Metrics cards add up the rows that match your current filters. Hover the info icon on a card to see the same definition in the app.

Trips Report: columns

Trips Report has one row per trip. Columns marked Default are in the report’s standard layout. Add the others from the Columns panel.

Core Identifiers & Status

People & Organization

Assets & Fleets

Dates & Times

Geography

Financial - Customer Side

Financial - Carrier/Driver Side

Financial - Margin & Mileage