If you sell through distributors or big-box retailers, the amount you invoice is rarely the amount that lands in your bank account. Between the purchase order and the final remittance, a stream of deductions, allowances, shortages, and chargebacks quietly chips away at your revenue. Distributor and EDI reconciliation is the discipline of matching what you shipped, what you invoiced, and what you were actually paid, so those gaps are caught instead of absorbed.
Why the gaps appear
Electronic Data Interchange (EDI) standardizes the documents that flow between you and your trading partners: purchase orders, advance ship notices, invoices, and remittance advices. That standardization is a huge efficiency gain, but it also means deductions arrive in bulk and in codes. A single remittance can net dozens of line-item adjustments against your invoices: promotional allowances, freight differences, unsalable goods, compliance fines, and pricing discrepancies among them.
Individually, many of these are small. In aggregate, and month after month, they can represent a meaningful share of gross sales. The businesses that protect their margin are not the ones that avoid deductions entirely, which is impossible, but the ones that see every deduction clearly and dispute the ones that are not valid.
What good reconciliation looks like
Sound distributor reconciliation ties three data sets together on a regular cadence:
- What you shipped: order and fulfillment records, including ship notices and confirmed quantities.
- What you invoiced: your billed amounts, prices, and terms.
- What you were paid: the remittance detail, with every deduction code itemized.
When those three do not agree, the difference is investigated and classified. Was the deduction contractually valid, such as an agreed promotional allowance? Was it an error, such as a duplicate freight charge or a price the partner applied incorrectly? Was it a shortage claim that your ship records contradict? Each answer leads somewhere different: accept and record it, or document and dispute it within the partner's deadline.
The accounting side
Clean reconciliation also keeps your books honest. Deductions should be recorded against the right accounts rather than buried in a single miscellaneous line, so your financial statements show the true cost of selling through each channel. Valid trade spend is not the same as a billing error, and lumping them together hides where margin is actually going.
Where to start
If deductions feel like a black box today, begin by capturing remittance detail in a consistent format and categorizing deduction codes for a few recent months. Patterns emerge quickly: one partner may drive most of your chargebacks, or one deduction type may be recurring and disputable. From there, a monthly reconciliation routine turns a reactive scramble into a predictable process.
Distributor and EDI reconciliation is one of the core services we handle for CPG clients, including work with tools such as SPS Commerce. If you would like a second set of eyes on your deductions, get in touch.
Back to Insights