ModvenRun an Opportunity ID →

Hunch library · Rebates · Electrical distribution

Unclaimed SPA rebates in electrical distribution

“We claim every SPA we are owed. The claims team is good.”

The hunch, as a team usually says it, before anyone opens the data.

Justin Jarvinen · Reviewed October 10, 2026

The short answer

Special pricing agreements let an electrical distributor sell below normal cost on a specific job or customer and claim the difference back from the manufacturer. The money leaks in three places: lines that qualified but were never claimed, claims filed after the window closed, and claims calculated on the wrong cost. Match twelve months of invoice lines against active SPAs and your submitted claims, and the unclaimed amount shows up line by line.

Where it hides in electrical distribution

Lines that qualified and were never claimed

A counter sale or a branch transfer goes out at the SPA price, but the order never gets the agreement number attached, so nothing flags it for a claim.

Expired and renewed agreements

Manufacturers reissue SPAs with new numbers and dates. Orders shipped in the gap between an old agreement and its renewal often fall through.

Claims on the wrong cost

When the into-stock cost moves after the SPA is written, the claim amount can be calculated on the old cost and come back short.

Rejected claims nobody refiles

A rejection for a missing field is easy to fix and easy to forget. The rejection report is often the quickest money in the building.

The records to pull

Twelve to twenty-four months of each. Nothing needs to be installed or connected; a spreadsheet export is enough.

Invoice lines

Invoice date, branch, customer, job, SKU, manufacturer, quantity, sell price, cost, and any SPA or agreement number on the line.

SPA register

Agreement number, manufacturer, customer or job, SKUs, agreement cost, start and end dates, and claim window.

Claim history

Every claim submitted, its lines, amount claimed, amount paid, rejection codes, and dates.

The ten-day test

Days 1–2

Write down what the team believes the unclaimed amount is, as a number with a range. Load the three exports and set the last three months aside as a holdout.

Days 3–5

Join invoice lines to agreements by customer, job, SKU, and date. Flag every line sold at or below agreement cost with no claim against it.

Days 6–8

Size the gap by manufacturer and branch, and separate lines still inside the claim window from those already lost.

Days 9–10

Confirm the pattern holds in the holdout months, then hand over the claimable list and the rule that would have caught it.

Specimen · illustrative figures

A $140M electrical distributor with nine branches matched 2.1 million invoice lines against 3,400 active SPAs. About 1.6 percent of lines sold at agreement cost had no claim attached, concentrated in two branches and three manufacturers. Lines still inside the claim window were worth an estimated $180K to $260K, and the same rule applied going forward was worth a similar amount each year.

Stop condition, written first

Stop if fewer than one percent of qualifying lines are unclaimed in both the search period and the holdout, or if the claimable amount still inside the window is below the cost of filing it.

What gets built if it holds

A nightly check that matches new invoice lines to active agreements, attaches the agreement number, and queues the claim before the window closes. It runs inside your operation, belongs to you, and is measured weekly against the dollar range the test produced.

Specimen figures are illustrative and do not describe a Modven client. Reviewed October 10, 2026.

Questions

Asked often, answered plainly.

What is an SPA in electrical distribution?

A special pricing agreement between a manufacturer and a distributor that lowers the distributor’s cost on specific products for a specific customer or job. The distributor sells at the agreed price and claims the cost difference back from the manufacturer, usually as a ship-and-debit claim.

Why do distributors miss SPA claims?

Because the claim depends on the agreement number reaching the invoice line. Counter sales, branch transfers, renewals with new numbers, and cost changes all break that link without anyone noticing.

How far back can we recover?

Only as far as each manufacturer’s claim window allows. The test separates lines still inside the window from those already lost, so the recoverable amount is stated honestly.

More from the hunch library

See every hunch →

Start here

Where do you suspect the value is hiding? Tell us your hunch. Ten days later it comes back with numbers on it.

10 business days · $500, credited against any build