# EDI Vendor Compliance Scorecard Worksheet > Source: https://netray.co/tools/edi-vendor-compliance-scorecard-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Score each trading partner on ASN timeliness, acknowledgment acceptance, invoice accuracy and label compliance with calculated rates. ## Category supply-chain ## Audience - EDI coordinator - Supply chain manager - Customer service manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Trading partner **Key:** partner **Type:** text #### Shipments **Key:** shipments **Type:** number #### ASNs on time **Key:** asn_ontime **Type:** number #### Docs sent **Key:** docs_sent **Type:** number #### Docs accepted first pass **Key:** docs_acc **Type:** number #### Invoices **Key:** invoices **Type:** number #### Invoices with no dispute **Key:** inv_clean **Type:** number #### Cartons audited **Key:** labels **Type:** number #### Cartons label OK **Key:** labels_ok **Type:** number #### ASN on-time % **Key:** asn_pct **Type:** number **Expr:** asn_ontime / shipments * 100 **Format:** percent #### First-pass accept % **Key:** acc_pct **Type:** number **Expr:** docs_acc / docs_sent * 100 **Format:** percent #### Clean invoice % **Key:** inv_pct **Type:** number **Expr:** inv_clean / invoices * 100 **Format:** percent #### Label OK % **Key:** lbl_pct **Type:** number **Expr:** labels_ok / labels * 100 **Format:** percent #### Weighted score **Key:** score **Type:** number **Expr:** 0.35 * (asn_ontime / shipments * 100) + 0.25 * (docs_acc / docs_sent * 100) + 0.25 * (inv_clean / invoices * 100) + 0.15 * (labels_ok / labels * 100) **Format:** decimal **Rows:** **Partner:** Northwind Retail **Shipments:** 420 **Asn ontime:** 401 **Docs sent:** 1650 **Docs acc:** 1598 **Invoices:** 410 **Inv clean:** 388 **Labels:** 200 **Labels ok:** 188 **Partner:** Fabrikam Auto **Shipments:** 180 **Asn ontime:** 177 **Docs sent:** 720 **Docs acc:** 709 **Invoices:** 176 **Inv clean:** 170 **Labels:** 90 **Labels ok:** 88 **Partner:** Contoso Aerospace **Shipments:** 64 **Asn ontime:** 58 **Docs sent:** 260 **Docs acc:** 244 **Invoices:** 60 **Inv clean:** 52 **Labels:** 40 **Labels ok:** 35 **Partner:** Adventure Distribution **Shipments:** 310 **Asn ontime:** 295 **Docs sent:** 1210 **Docs acc:** 1180 **Invoices:** 300 **Inv clean:** 281 **Labels:** 150 **Labels ok:** 141 **Totals:** #### Total shipments **Key:** shipments **Agg:** sum **Format:** integer #### Average weighted score **Key:** score **Agg:** avg **Format:** decimal #### Lowest weighted score **Key:** score **Agg:** min **Format:** decimal **Summary:** #### Overall ASN on-time **Key:** overall_asn **Expr:** sum_asn_ontime / sum_shipments * 100 **Format:** percent #### Overall first-pass acceptance **Key:** overall_accept **Expr:** sum_docs_acc / sum_docs_sent * 100 **Format:** percent **Notes:** The weights (35, 25, 25, 15) are a starting point. Edit the formulas in your exported copy to match your own priorities or the partner's scorecard. ## Content **Intro:** You cannot manage EDI performance by feel. This scorecard turns counts you already have, such as shipments, ASNs sent on time, accepted documents, clean invoices and audited cartons, into rates and a single weighted score per trading partner. **Sections:** #### How to use the scorecard **Body:** Pull the counts for a period, usually a month, from your ERP shipment history, your translator or VAN reports and your invoice dispute records. Enter them per partner. The sheet calculates the on-time ASN percentage, the first-pass acceptance rate for documents, the clean invoice rate and the label audit rate, then combines them into a weighted score. Sort by score to see which partners need attention first. **Bullets:** - On time means the 856 was received by the partner before the goods arrived or by the time their guide requires - First pass means accepted with no 997 error and no manual correction - Clean invoice means no price, quantity or tax dispute #### Choosing the weights **Body:** ASN timeliness gets the most weight here because late or missing advance ship notices drive most penalties. Acceptance and invoice accuracy follow because they affect rework and cash. Label compliance is weighted lower but matters heavily for retail distribution centers. If a customer publishes its own scorecard, copy its weights so your internal numbers match theirs. #### Reading the result **Body:** Use the individual rates before the score. A partner with a good overall score but low label compliance has a warehouse problem, not an EDI problem. A low acceptance rate points at map or master data defects. A low clean invoice rate suggests price list or tax setup in the ERP. Review monthly and trend the score, since single months can be noisy for low-volume partners. #### Common mistakes **Body:** Small samples distort percentages, so be careful with partners that have only a handful of shipments. Counting a resent document as accepted first pass inflates the rate. Mixing periods between columns, for example shipments for October but invoices for September, makes the ratios meaningless. Keep the same cut-off date for every column. **Cta:** If you are rebuilding these counts by hand every month, Netray can help set up a read-only report on your ERP and EDI logs that produces them automatically. **Faq:** #### What is a good on-time ASN rate? **Answer:** Many retail and OEM programs expect very high compliance, often above 98 percent, though the target is set in each partner's vendor guide. Use your own contract numbers. The trend matters as much as the level. #### Can I change the formula weights? **Answer:** Yes. Export to Excel and edit the weighted score formula, or change the percentages in your own copy. Keep the weights summing to 100 so the score stays on a 0 to 100 scale. #### Where do I get first-pass acceptance counts? **Answer:** Your translator, VAN or integration platform reports show documents sent and the 997 or 999 status. Count documents with an accepted acknowledgment and no later correction. #### Should every partner be scored the same way? **Answer:** Use the same method for fairness, but note partner-specific requirements. If one partner has no label audit, enter a small audit sample or leave the label weight out in your copy. ## Search terms edi compliance scorecard, vendor compliance scorecard excel, asn accuracy scorecard, edi performance metrics template, trading partner scorecard, edi kpi worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json