# Vendor Invoice Layout Registry Worksheet > Source: https://netray.co/tools/vendor-invoice-layout-registry-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A registry of supplier invoice layouts with format, language, volume and capture status, so you know which vendors need template work. ## Category ai-automation ## Industry Discrete Manufacturing ## Audience - AP analyst - Capture administrator - ERP admin ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Vendor **Key:** vendor **Type:** text #### ERP vendor ID **Key:** vendor_id **Type:** text #### Country **Key:** country **Type:** text #### Invoice language **Key:** language **Type:** select **Options:** - English - German - Spanish - French - Chinese - Hindi or English - Arabic - Other #### Format **Key:** format **Type:** select **Options:** - Text PDF - Scanned PDF - XML e-invoice - Image - Mixed #### Invoices per month **Key:** monthly **Type:** number #### Avg lines per invoice **Key:** lines **Type:** number #### Monthly line volume **Key:** line_vol **Type:** number **Expr:** monthly * lines **Format:** integer #### Capture status **Key:** tmpl **Type:** select **Options:** - Not started - Template built - Tested - Live - Needs rework #### Last reviewed **Key:** last_review **Type:** date **Rows:** **Vendor:** Northfield Metals Inc **Vendor id:** V10021 **Country:** US **Language:** English **Format:** Text PDF **Monthly:** 40 **Lines:** 3 **Tmpl:** Live **Last review:** 2026-09-12 **Vendor:** Shenzhen Rongda Electronics **Vendor id:** V10388 **Country:** CN **Language:** Chinese **Format:** Scanned PDF **Monthly:** 25 **Lines:** 8 **Tmpl:** Needs rework **Last review:** 2026-08-30 **Vendor:** Kalyan Castings Pvt Ltd **Vendor id:** V10544 **Country:** IN **Language:** Hindi or English **Format:** Mixed **Monthly:** 60 **Lines:** 2 **Tmpl:** Tested **Last review:** 2026-10-01 **Vendor:** Rheinwerk Antriebe GmbH **Vendor id:** V10612 **Country:** DE **Language:** German **Format:** XML e-invoice **Monthly:** 18 **Lines:** 12 **Tmpl:** Live **Last review:** 2026-09-25 **Vendor:** Lone Star Freight **Vendor id:** V10907 **Country:** US **Language:** English **Format:** Image **Monthly:** 90 **Lines:** 1 **Tmpl:** Not started **Last review:** 2026-10-10 **Totals:** #### Total invoices per month **Key:** monthly **Agg:** sum **Format:** integer #### Total monthly lines **Key:** line_vol **Agg:** sum **Format:** integer **Summary:** #### Average lines per vendor invoice **Key:** avg_lines **Expr:** sum_line_vol / sum_monthly **Format:** decimal **Primary:** true **Notes:** Prioritise vendors with high volume and status Not started or Needs rework. Re-review layouts at least yearly, since suppliers change their invoice template without notice. ## Content **Intro:** Template-based capture and AI extraction both behave differently per supplier. A simple registry shows where your volume sits, which layouts are covered, and where work is still needed. **Sections:** #### How to use the registry **Body:** List suppliers by volume, starting with the ones that send the most invoices. Record format and language, because scanned Chinese invoices and XML e-invoices need very different handling. Set a capture status for each vendor and a review date. Sort by monthly line volume to decide which vendor to fix first, since line items cost far more to key than headers. #### Status definitions **Body:** Use the same meanings across your team. Not started means no template or training sample exists. Template built means a configuration exists but has not been tested against real documents. Tested means a sample set was checked for accuracy. Live means the vendor posts with the expected rate of touchless invoices. Needs rework means exceptions have risen after a layout change. **Bullets:** - Keep five to ten sample invoices per vendor - Record the date of the last layout change - Note whether the vendor sends credit notes in a different layout #### Regional and ERP considerations **Body:** Suppliers in India, China, the Middle East and Africa may mix scripts, local tax fields and handwritten stamps. Add a column for the local tax number format if your ERP validates it, such as GSTIN in India. In SAP, Oracle, Infor and Epicor the vendor ID in this sheet should match the vendor master key so exports can be joined to AP data. #### Common mistakes **Body:** The registry fails when it is built once and never updated. Assign an owner and review monthly. Another mistake is tracking suppliers by name only, which breaks when the same vendor has several remit-to entities, so use the ERP vendor ID as the key. **Cta:** Netray builds extraction agents that adapt to layout changes without a template per vendor. We can show how this would work with your ERP vendor master. **Faq:** #### Do I need a registry if I use AI extraction? **Answer:** Yes, still useful. Even without templates you need to know which vendors produce low accuracy, which formats appear, and where to focus review. The registry becomes a monitoring list rather than a configuration list. #### How many sample invoices per vendor? **Answer:** Five to ten recent invoices usually cover the normal variation, including a credit note and a multi-page invoice if the vendor sends them. Use more samples for vendors with several remit-to entities. #### What is monthly line volume? **Answer:** It is invoices per month multiplied by average lines per invoice. It estimates how many line items must be captured, which is the main driver of effort for goods invoices with PO line matching. #### How often do layouts change? **Answer:** Suppliers change layouts when they upgrade accounting software or merge entities, often without notice. A monthly review of exception counts by vendor is the practical way to catch this. ## Search terms vendor invoice template registry, invoice layout tracking, ocr vendor template list, supplier invoice format log, invoice capture vendor onboarding, ap vendor layout excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json