Which UNFI file to upload
- Your remittance (easiest): the check remittance or direct deposit advice UNFI emails with each payment. Its columns are Invoice Date, Invoice Number, Description, Gross, Discount and Net. The deductions are the rows with a negative net; the discount column is your early-pay terms, not a deduction.
- Your Dispute Center adjustments (everything at once), downloaded as below.
- A UNFI Natural Debit Balance list, if UNFI has sent you one: every open item across East and West, with a category on each line.
How to download your adjustments from the Dispute Center
- Open the Dispute Center. Log in at myunfi.com and click Go To Dispute Center (the Submit & Track Deduction Disputes widget).
- Search adjustments. Open Advanced Search and choose Adjustments.
- Set the date range. Set Adjustment Date to a range from 12 months ago to today. Without a range, results stop at 90 days, and UNFI allows 12 months to dispute.
- Download Data. Click Download Data (the grey button at the bottom left). The Dispute Center saves a CSV.
- Upload it as is. Upload the CSV without editing it. The analyzer reads UNFI's own columns.
The file has UNFI's columns: Adjustment Number, Adjustment Date, Adjustment Reason, PO Number, Invoice Number, Payment Number, Adjustment Total Amount and Adjustment Item Amount. We count Adjustment Total Amount once per adjustment. The item amount is a share of the same total, so adding both would count it twice.
The Dispute Center export is one of five UNFI files worth pulling. For the rest (remittances, backup, the weekly MCB backup and the Debit Balance list), see how to pull your complete UNFI Natural deduction data.
What the analyzer reads in a UNFI number
UNFI Natural files have no reason column. The deduction type is written into the number, and the Dispute Center adds the type and region to the adjustment number: <n>-0-West is a deduction, <n>-111-East an invoice chargeback. Some of the codes we decode:
| Number | What it is |
|---|
<invoice #> + -111 | Invoice chargeback: shortage, mis-ship, damage at receipt or price |
MCB<date>, WE<date> | Weekly MCB (promotion chargeback), West and East |
SO…, ##OVP… | Show-order MCB, overpull |
SECMQ…, CMQ… | Quality chargeback: unsaleable product reclaimed |
LCBOL, LCBC, LCP, LCF, LCO, LCPV | Fines: BOL, barcode, pallet label, load securement, UPC, pallet build |
AVL, AVR, AVNCNS | Appointment fines: late, rescheduled, no-call no-show |
WRSLOFE, ERSLOFE | Slotting: new item, pack change, reactivation |
WRDC, ERDC | Advertising (regional ad programs) |
WRTTS, ERTTS | Trade show sales billed back |
FBB…WK | Freight billback |
<invoice #>SP, <invoice #>CV | Spoilage or ClearVue allowance not taken on the invoice |
…PTY<retailer> | A retailer's charge passed through |
SAS… | Post audit by SAS Recovery: dispute with the auditor |
…PB | Payback: money returned on a won dispute |
The meanings come from UNFI's Supplier Deduction Key (as published by SPS Commerce), the Dispute Center Training Manual, and the categories UNFI itself prints on real Debit Balance lists. Where a code's meaning isn't published (SSA, WRDTCE), we say so instead of guessing. More in the UNFI deduction codes library.
12 months to dispute, 60 days recommended
UNFI's Dispute Center Training Manual gives you 12 months from the date a deduction is taken; after that it's final under UNFI's Supplier Policy. UNFI recommends filing within 60 days, and older claims are harder to win, so the analyzer flags lines past 60 days to file first. See the UNFI dispute window.
Not everything goes through the Dispute Center
- Dispute Center: MCBs, -111 invoice chargebacks, fines, slotting, advertising, allowances and pass-throughs.
- Email [email protected]: cash terms and early-pay discounts, short payments, prepayments and unpaid invoices.
- The audit firm: post-audit claims from SAS Recovery or PRGX.
The Dispute Center also holds no backup: UNFI emails it with your check remittance. Missing backup comes from [email protected], subject BACKUP REQUEST.
Dispute it yourself, or hand it over
Step by step: how to dispute a UNFI deduction and how to read a UNFI remittance. Or let us recover them: you only pay when UNFI pays you back. Selling through KeHE too? Use the KeHE KSolve analyzer.