Free Logistics KPI Excel Template
What's in the Logistics KPI template
The KPI Log sheet holds one row per period (weekly or monthly, your choice), with columns for shipments total, shipments on-time, total shipping cost and damaged/lost shipments.
Three calculated columns turn those raw counts into rates: on-time delivery % (on-time divided by total), cost per shipment (total cost divided by total shipments), and damage rate (damaged divided by total).
Two target columns - target on-time % and target damage rate % - let you set your own goals per period, and two flag columns - an on-time flag (OK / BELOW TARGET) and a damage flag (OK / ABOVE TARGET) - mark each period automatically.
Why targets are per-row, not a fixed company number
Most free logistics KPI dashboards compute a rate and stop there - they don't compare it to anything, so you're left eyeballing whether 91% on-time is good or bad this month.
Because the target columns live on the same row as the actuals, you can tighten your on-time goal as your carrier network improves, or loosen a damage-rate target during a known-risky peak season, without breaking any earlier period's flag.
The summary block below the table then rolls this up: average on-time delivery, average cost per shipment, average damage rate, and two separate counts - how many periods fell below the on-time target, and how many exceeded the damage-rate target.
Who this template is for
Small to mid-size logistics operations, 3PLs, and internal supply-chain teams who need a lightweight KPI tracker without a full warehouse-management or TMS platform.
It's built for a person who owns the shipping/logistics function to log period numbers themselves - not for automatic data feeds from a carrier API.
How to use it
- Log each period's shipments total, on-time count, shipping cost and damaged shipments on the KPI Log sheet.
- Set your target on-time % and target damage rate % for that period.
- Check the summary below the table for averages and how many periods missed a target.
Download the free Free Logistics KPI Excel Template
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How is on-time delivery % calculated?
Shipments on-time divided by shipments total for that period. It's blank, not an error, on any row where shipments total is empty or zero.
Can I change my target mid-year?
Yes. Targets are entered per row, so raising or lowering your on-time or damage-rate goal for a new period doesn't change how earlier periods were flagged.
Does this pull data from my carrier or TMS automatically?
No. You enter shipment counts and costs yourself each period - there's no live connection to a carrier API or warehouse system.
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. All formulas and flags keep working.
How many periods can I track?
Up to 52 rows - enough for a full year of weekly periods, or over four years of monthly periods.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.