Insurance & Risk · Excel template

Free Freight Claim Log

A numbered log of cargo claims filed against your authority, carrying the 30-day acknowledgement and 120-day disposition clocks 49 CFR 370 sets.

Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.

  • Editable CSV — yours to keep
  • Print or save as PDF
  • No spam · unsubscribe anytime

What you get

  • A successive claim file number per row, assigned at receipt, that every document and letter traces back to
  • A Date Received column, because every clock in 49 CFR 370 runs from the date of receipt and nothing else
  • An acknowledgement column with the 30-day date computed, and a disposition column with the 120-day date
  • A rolling 60-day status column for claims still open past 120 days, with the reason for the delay recorded
  • A worked example covering a damage claim inside the window, a shortage claim past 120 days, and a declined claim

How to use it

  1. 1

    Open a row the moment a written claim arrives, assign the next claim file number, and record the date of receipt.

  2. 2

    Check the claim actually asserts liability and names a specified or determinable amount — a bad order report on its own is not a claim.

  3. 3

    Acknowledge in writing within 30 days, state what further documentation you need, and put the receipt date in the acknowledgement.

  4. 4

    Pay, decline, or make a firm compromise settlement offer in writing by the 120-day date in its column.

  5. 5

    For anything still open at 120 days, write to the claimant with the status and the reason for the delay, then repeat every 60 days and keep a copy in the file.

Preview the template

Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.

Preview

Freight Claim Log

Every date here is counted from the date of receipt recorded on the face of the claim document. 49 CFR 370.5 requires a separate file with a successive claim file number per claim, and written acknowledgement within 30 days unless the claim was paid or declined in writing in that time. 49 CFR 370.9(a) requires payment, declination, or a firm compromise settlement offer in writing within 120 days, and a written status with the reason for delay at 120 days and at each succeeding 60-day period the claim stays open.

Claim File #Date ReceivedClaimantPro / BOL #Shipment & CommodityType (Loss / Damage / Delay)Amount Claimed ($)Ack Sent (due +30d)Disposition Due (+120d)Status / Next 60-Day Letter
2026-01842026-09-18Harbert Foods (consignee)PRO 884-2107712 pallets canned goods, 2 crushedDamage4,280.002026-09-24 (due 10-18)2027-01-16Open — inspection report requested
2026-01512026-05-02Ridgeline Supply (shipper)PRO 881-40355Shortage, 3 of 40 cartonsLoss1,145.002026-05-092026-08-30 (passed)Open past 120d — 60-day letter sent 10-29, next due 12-28

Free unlock

Unlock the full template

Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.

  • Editable CSV
  • Every row & section
  • Branded PDF

Where should we send it?

Add your name and email — we'll unlock the full template right here and email you the editable spreadsheet so it's easy to find later.

No spam. Unsubscribe anytime. We never sell your data. See our privacy policy.

Frequently asked questions

Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.

A

Under 370.3(b), a written communication from the claimant, filed with a proper carrier within the time limits in the bill of lading or contract of carriage, that contains facts sufficient to identify the shipment, asserts liability for the loss, damage, injury or delay, and makes claim for payment of a specified or determinable amount of money. 370.3(c) is explicit that a bad order report, a shortage or damage notation on a freight bill or delivery receipt, or a carrier inspection report, standing alone, is not sufficient — so the log should record when a real claim arrived, not when a damage note did.

A

370.5(b) requires the carrier, at the time the claim is received, to create a separate file, assign it a successive claim file number, note that number on every document filed in support of the claim and on all records and correspondence including the acknowledgement, and record the date of receipt on the face of the claim document — a date that also has to appear in the acknowledgement. The claim file number also goes on the shipping order and delivery receipt, unless the carrier instead keeps an orderly and consistent internal procedure of the kind 370.5(b)(1)–(3) describes.

A

370.9(a) gives 120 days from receipt to pay the claim, decline it, or make a firm compromise settlement offer, in writing. If the claim cannot be processed and disposed of in that time, the carrier advises the claimant in writing of the status and the reason for the delay at 120 days and at the expiration of each succeeding 60-day period the claim remains pending, retaining a copy of each such advice in the claim file.

A

No. 370.1 applies the part to claims for loss, damage, injury or delay to property transported or accepted for transportation in interstate or foreign commerce. A purely intrastate movement runs on state law and the contract of carriage instead, so check those before applying these clocks to it. Logging the receipt date either way is still how you prove when a claim arrived.

Sources

Every figure, section number and deadline on this page was read at a primary source on the date shown. Regulations are amended — check the source before you rely on it.

Related guides & tools

Looking for more? Browse all fleet templates or run a fleet calculator.