Docs · File formats
Supplier Rebate & Contract Price Recovery CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Vendor | Yes | vendor, vendor name, supplier, supplier name, seller, manufacturer | Midwest Industrial Supply |
| Invoice number | Yes | invoice number, invoice, invoice no, invoice num, invoice #, inv # | INV-50112 |
| Invoice date | invoice date, inv date, bill date, document date, doc date, posting date | 2026-04-06 | |
| Item / SKU | Yes | item, item number, item no, item #, item code, sku | 4471-A |
| Description | description, item description, line description, product description, material description, short text | Nitrile gloves, case of 1000 | |
| Line type | line type, line type lookup code, line type code | ITEM | |
| Quantity | Yes | quantity, qty, quantity invoiced, qty invoiced, invoice qty, invoiced quantity | 40 |
| Unit price billed | Yes | unit price, unit price billed, billed price, invoice price, invoice unit price, price billed | 52.80 |
| Line amount | line amount, extended price, extended amount, ext price, extended cost, line total | 2112.00 | |
| Contract unit price | contract price, contract unit price, agreement price, contracted price, contract cost, negotiated price | 48.00 | |
| Contract / agreement | contract number, contract, contract id, contract no, agreement, agreement number | MIS-2025-114 | |
| Rebate period | rebate period, period, program period, fiscal period, quarter | 2026-Q2 | |
| Tier 1 threshold | tier1 threshold, tier 1 threshold, tier 1 min, tier 1 spend, tier1 min, tier 1 minimum | 10000.00 | |
| Tier 1 rate % | tier1 rate, tier 1 rate, tier 1 %, tier1 %, tier 1 rebate, tier 1 pct | 2 | |
| Tier 2 threshold | tier2 threshold, tier 2 threshold, tier 2 min, tier 2 spend, tier2 min, tier 2 minimum | ||
| Tier 2 rate % | tier2 rate, tier 2 rate, tier 2 %, tier2 %, tier 2 rebate, tier 2 pct | ||
| Tier 3 threshold | tier3 threshold, tier 3 threshold, tier 3 min, tier 3 spend, tier3 min, tier 3 minimum | ||
| Tier 3 rate % | tier3 rate, tier 3 rate, tier 3 %, tier3 %, tier 3 rebate, tier 3 pct | ||
| Tier 4 threshold | tier4 threshold, tier 4 threshold, tier 4 min, tier 4 spend, tier4 min, tier 4 minimum | ||
| Tier 4 rate % | tier4 rate, tier 4 rate, tier 4 %, tier4 %, tier 4 rebate, tier 4 pct | ||
| Tier 5 threshold | tier5 threshold, tier 5 threshold, tier 5 min, tier 5 spend, tier5 min, tier 5 minimum | ||
| Tier 5 rate % | tier5 rate, tier 5 rate, tier 5 %, tier5 %, tier 5 rebate, tier 5 pct | ||
| Rebate % | rebate %, rebate pct, rebate percent, rebate percentage, rebate rate | 2 | |
| Rebate threshold | rebate threshold, rebate minimum, minimum spend, rebate min spend | 10000.00 | |
| Rebate received | rebate received, rebate credit, rebate credited, rebate paid, rebate amount received, rebate credit received | 0.00 | |
| Payment terms | payment terms, terms, terms code, pay terms, discount terms, terms name | 2/10 Net 30 | |
| Contract payment terms | contract terms, contract payment terms, agreement terms, agreed terms | 2/10 Net 30 | |
| Payment date | payment date, paid date, date paid, pay date, check date, clearing date | 2026-04-14 | |
| Discount taken | discount taken, disc taken, cash discount, discount amount, discount | 0.00 | |
| Freight billed | freight, freight amount, freight billed, freight charge, shipping, shipping charge | 85.00 | |
| Freight terms | freight terms, contract freight terms, shipping terms, fob, fob terms, incoterms | FOB Destination, Freight Prepaid | |
| Price-break quantity | break qty, price break qty, price break quantity, break quantity, scale quantity, moq | 100 | |
| Price-break unit price | break price, price break price, price break, scale price, volume price, break unit price | 2.85 | |
| Base price | base price, baseline price, original price, prior price | 0.84 | |
| Escalator cap % | escalator cap, escalator, price cap, escalation cap, max increase, price increase cap | 3 |