Free Carrier Scorecard Template (Excel)
What's in the carrier scorecard
The Carrier Scorecard sheet holds up to 60 carriers, one row each: on-time delivery %, damage rate %, cost per mile, and a 1-5 responsiveness rating, plus a weight for each KPI.
A weighted score calculates automatically for every carrier - cost per mile is normalized against the highest cost/mile in your list, so cheaper carriers score better regardless of your lane mix, and damage rate is inverted so a lower rate always helps the score.
Rank calculates automatically from the weighted score, and the summary below the table shows how many carriers you've evaluated, the average and top score, and how many fall below a 0.50 threshold.
A downloadable file, not just a concept explainer
Search results for carrier scorecards are dominated by logistics SaaS blogs - DataDocks, Beacon, Turvo - that explain the idea of scoring carriers while promoting their own shipment-tracking software. None of them offer an actual Excel file to download.
This template gives you the working spreadsheet: freight-specific KPIs, automatic weighted scoring, and a rank column, ready to fill in with your own carriers today.
It's built for transportation and freight KPIs specifically - on-time delivery, damage rate, cost per mile - not a generic supplier scorecard.
Who this scorecard is for
Logistics coordinators and supply chain managers comparing freight carriers on delivery performance, damage rates and cost, not just price alone.
For scoring generic vendors or suppliers on quality, delivery, price and service instead of freight-specific KPIs, see the Vendor Scorecard template.
How to use it
- Enter on-time delivery %, damage rate %, cost per mile and responsiveness (1-5) for each carrier.
- Enter the same four weights (on-time, damage, cost, responsiveness) in every row - they should add up to a total you're comfortable comparing against.
- Weighted score and rank calculate automatically; check the summary below the table for the average and top score.
Download the free Free Carrier Scorecard Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How is cost per mile scored when a lower cost is better?
Cost per mile is normalized against the highest cost/mile in your list and then inverted, so the cheapest carrier always scores best on that KPI.
Do I set the weights once for the whole sheet?
Enter the same four weights (on-time, damage, cost, responsiveness) in every row you fill in - that keeps every carrier scored on the same basis.
Is this the same as a vendor or supplier scorecard?
No. This scorecard is built for freight and carrier-specific KPIs. For a generic vendor or supplier scorecard (quality/delivery/price/service), see the Vendor Scorecard template instead.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The scoring and rank formulas keep working.
How many carriers can I track?
Up to 60 carriers on the Carrier Scorecard sheet, with a summary of average score, top score and count below the threshold.
What's the usage license?
Personal or single-company use. It's not meant to be resold or redistributed as a template product.