Shipment-to-credit-resolution completeness scorecard: ten metadata checks with pass, partial and fail guides

Short answer

A shipment-to-credit-resolution trail breaks when a later record stops carrying the key of an earlier one: a claim filed on one reference and paid on another, a status history overwritten, a settlement date that lives only in email, or a write-off with no reason. This scorecard turns those breaks into ten checks a partner can score from one conversation, without seeing a claim file. Each check is pass, partial or fail, and the total tells you how complete the trail is before you promise anything.

Visual briefFull-size diagram
A ten-item checklist grouped into coverage, linkage, timestamps, outcomes and gaps ticks through six passes, three partials and one fail while a completeness meter rises to 15 of 20 points, or 75%.
Illustrative scorecard for a fictional shipper. The one fail is the claim number missing from carrier credits before 2021.

This scorecard is part of the shipment-to-credit-resolution guide. Use it after the company has described its systems, and before you describe the opportunity to anyone else.

Scoring rules

Give each check 2 points for a pass, 1 for a partial and 0 for a fail or unknown. Ten checks make 20 points. Convert to a percentage if that helps the conversation, but keep the per-check marks: a reviewer learns more from "linkage fails before 2021" than from a single number.

Three rules keep the score honest:

  • Score from metadata only. Field names, date ranges, counts, settings and owners. If answering a check would require reading a claim, mark it unknown.
  • Date every pass. A check that passes only from 2021 is a pass from 2021 and a fail before it. Record the year.
  • Name the owner. Each answer should come with the role that gave it, so SourceX knows whom to ask later.

The ten checks

CheckAreaHow to check at metadata levelPassPartialFail
1. System overlapCoverageAsk the years held in the warehouse system, the claims portal and the ledgerAll three overlap for 3+ yearsOverlap under 3 yearsOne system has no history for the period
2. Claim volumeCoverageAsk roughly how many carrier claims are filed a yearKnown within a rangeKnown only for recent yearsUnknown
3. Anchor key on claimsLinkageAsk which reference the claims team types on every claimBill of lading or shipment ID on every claimOn most claimsVaries by person
4. Split listingLinkageAsk whether the portal lists every PRO number against the bill of ladingAlwaysFor some carriersNever
5. Claim number on creditsLinkageAsk what number AP records when a carrier paysCompany and carrier claim numbers bothCarrier number onlyNeither
6. Claim datesTimestampsAsk which dates are fields: filed, acknowledged, offered, paidAll fourFiled and paid onlyPaid date only
7. Status historyTimestampsAsk whether the portal keeps past statuses or only the latestFull historyLatest status plus notesLatest only
8. Amounts agreeOutcomesAsk whether claimed, offered, paid and written-off amounts are separate fieldsAll four, never nettedSeparate, but carriers sometimes net claims against open freight billsOnly the credit amount
9. Shortfall reasonOutcomesAsk how a write-off of an unpaid balance is recordedCoded reason fieldFree-text memoNo reason recorded
10. Declared gapsGapsAsk what history sits outside the systems: email, a former carrier's portal, a retired ERPGaps named with yearsGaps suspected, not datedNobody can say

Check 4 is where repacked units also show up. GS1 assigns a new Serial Shipping Container Code when a logistic unit is broken down and repacked, so a company should also be asked whether its warehouse system keeps the old code beside the new one. Score that inside check 4 rather than adding a check.

The split-shipment test

One case tests most of the scorecard at once: a carrier claim that references a split shipment. The claim names the original shipment and its bill of lading. The carrier moved the freight on two PRO numbers and pays against one of them. An AP clerk matching the credit cannot tell whether it settles the whole claim, part of it, or a different claim on the same lane.

Ask the claims lead to walk through how such a claim would be traced today, in general terms:

Step in the traceWhich check it exercisesWhat a complete answer sounds like
Find the claim from the credit5"Our claim number is on every carrier credit since 2021"
Find both PROs from the claim4"The portal lists every PRO under the bill of lading"
Tell whether the payment covers both8"Offered and paid amounts are separate fields"
Explain any balance9"Write-offs use a reason code from a fixed list"

Multiply that case by a few hundred claims a year and the difference shows. A company that fails checks 4 and 5 has a record of every step but no reliable join for many of them.

Why claim timing stretches the trail

Two timing rules explain why claim records accumulate over months and why checks 6 and 7 matter. A carrier may not set a claim-filing period shorter than 9 months. Carrier claim regulations then require the carrier to pay, decline or make a firm compromise offer within 120 days of receiving a claim, or else send a written status with the reason for delay and repeat it every 60 days while the claim is pending. A single claim can sit open across quarters, through staff changes and sometimes through a system change. If the portal keeps only the latest status, the trail of those letters and offers is gone, which is why status history earns its own check.

A filled scorecard (Illustrative)

A fictional 520-person housewares importer that files about 1,800 carrier claims a year, scored from a 40-minute call with its controller and claims lead.

CheckMarkPointsNote
1. System overlapPass2All three systems overlap from 2018
2. Claim volumePass2About 1,800 a year
3. Anchor key on claimsPass2Bill of lading on every claim
4. Split listingPartial1Two of five main carriers list every PRO
5. Claim number on creditsFail0Neither number on credits before 2021; both since
6. Claim datesPass2Four date fields in the portal
7. Status historyPartial1Latest status plus free-text notes
8. Amounts agreePass2Separate fields; no netting reported
9. Shortfall reasonPartial1Coded since 2023, memo before
10. Declared gapsPass2Pre-2018 claims in a shared mailbox
Total6 pass, 3 partial, 1 fail15 of 2075% complete

The useful output is the sentence it produces: "Strong from 2021 on, linkage partial before; status history partly in notes; reason codes from 2023." That sentence can go into an introduction. The record chain shows how the keys behind checks 3 to 5 connect, and the missing-context comparison shows what a reader loses when they fail.

Before you introduce

The scorecard describes the trail; it does not qualify the company. Confirm the baseline too: 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license the records, and an authorized contact. Since the trail spans warehouse, transportation and finance, that contact is the CEO (in an owner-run company, usually the owner) rather than the claims lead who answered the checks. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English.

What stays unknown until SourceX reviews it: whether carrier and customer contracts allow licensing, how names, addresses and amounts would be de-identified, which years a buyer would want and what the company would be paid. Partners score from metadata and never handle claim files or remittances. Related finance records are described under AR dispute resolution and AP exception handling; freight audit and payment companies often hold the invoice side, and an ERP replacement handoff checklist helps when a system change is coming.

Next step

Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If your scorecard produces a dated sentence the company's owners agree with, register as a partner, check who qualifies and read the terms before you introduce the decision-maker.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Is there a minimum score for an introduction?

No. SourceX does not set a pass mark, and a low score with a long history can still be worth a conversation. The score is a way to describe the trail honestly, so the introduction sets the right expectations.

Who should answer the checks?

Split them by owner: the warehouse manager for dispatch records, the claims lead for the carrier portal, and the AP or AR manager for credits and write-offs. Each can answer from admin screens without exporting anything.

What if nobody knows the answer to a check?

Mark it unknown and score it as a fail for now. An honest unknown is more useful to SourceX's review than an optimistic guess, and it tells the company what to look into before a first call.

Sources

  1. govinfo.gov/content/pkg/CFR-2001-title49-vol4/pdf/CFR-20…
  2. uscode.house.gov/us/usc/t49/s14706
  3. gs1.org/standards/id-keys/sscc
  4. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment