1. Your shipment report
Needs a ship date and a delivery date column, and a tracking number or service column. A charge, invoice date, status or exception note and a scheduled-delivery date or transit-days column are used when present. Column names are matched by alias and are unverified against real carrier exports: if a file is not read, the page says which rows were skipped and why.
Choose the report file or paste it, then click Find late parcels.
Result
Late rate by service
| Service | Delivered | Late | Late rate | Claimable |
|---|
The rules, and what they leave out
- Promised day: ship date plus the service's business days: 1 for next-day services, 2 for 2nd Day and 2Day, 3 for 3 Day Select and Express Saver. A promised-date column or a transit-days column in the file overrides this. Ground is judged only with your ground setting or one of those columns.
- Late: delivered on a business day after the promised day. Weekends and the calendar's holidays never count as delivery days.
- Not counted: shipments whose status or note mentions weather, a recipient or address problem, a customer hold or a reschedule; shipments that already have a credit line for the same tracking number; late shipments whose claim window has passed.
- Claim window: the invoice date plus the days you set (15 by default; check your carrier's current terms). Without an invoice date the last day is unknown.
- Duplicates: the same tracking number with the same charge more than once. Rate drift: a charge over 1.75 times its service's median and at least $5 over, for services with six or more lines. There is no weight or zone column, so it cannot say why.
- Amount: the transportation charge column only. Carriers differ on whether fuel and other surcharges are refunded with it, and the total is the most that could be affected, not a refund you are owed.
- Not checked: lost or damaged parcels, the exact guarantee terms in your contract, weekend or Saturday service options, carrier-specific holiday calendars, and delivery times within a day.
- Unverified: column names are matched by alias, the six-holiday calendar is a common pattern rather than a published rule, and no real carrier export was available when this was written.
Common questions
How do I get a refund for a late UPS or FedEx delivery?
Carriers with a money-back guarantee credit the transportation charge on a guaranteed service that arrives after the promised day, unless the delay was caused by something like weather, an address problem or a customer hold. You usually have to ask, within a short window that often starts at the invoice date. Drop in your shipment report here to list the deliveries that look late, the charge on each, the last day to file, and a draft request to send your carrier.
Which services does this check?
Services with a fixed promise: next-day services such as UPS Next Day Air and FedEx Priority Overnight (1 business day), 2nd Day and 2Day services (2), and 3 Day Select and Express Saver (3). Ground services vary by zone, so they are judged only if you enter your typical ground transit days or the file has a promised-date or transit-days column. SmartPost, SurePost, Ground Economy and postal services carry no such promise and are never judged.
Does this prove a refund is owed?
No. It lists shipments that look delivered after the promised day and adds up their shipping charges. Whether each one qualifies depends on the carrier's current guarantee terms, the service you bought, and any exception on the tracking record. The total is the most that could be affected, not a refund you are owed.
What counts as a business day, and what about holidays?
Monday to Friday, skipping New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving and Christmas by default, a calendar large carriers generally follow but that is unverified here. Shipments that would be on time if another federal holiday were a delivery day are set apart as needing a check. Add any closure days you know about, such as a storm day, to the extra dates box.
What file does it read?
Comma, semicolon, tab or pipe separated text with a header row and at least a ship date column and a delivery date column, plus a tracking number or a service column. It uses a charge column, an invoice date, a status or exception note, and a scheduled-delivery date or transit-days column when present. Carrier reports differ and no real UPS or FedEx export was available when this was written, so columns are matched by alias and unverified; a file that is not read says why.
Is my shipment data uploaded anywhere?
No. The file is read in this browser tab and never leaves your device. There are no accounts, cookies or analytics vendors.