Vendor Portal / Sign in
Vendor Portal Order ORD-58227.pdf Reading document
Vendor A PURCHASE ORDER
VendorVendor A
Order #ORD-58227
Date2026-06-15
Ship-toWarehouse A
SKUDescriptionQtyAmount
SKU-1208Floor lamp — matte120$2,388.00
SKU-2440Accent rug 5x780$3,120.00
SKU-3184Table lamp — brass40$1,040.00
PO total$6,548.00
Extracted order
VendorVendor A
OrderORD-58227
Lines3 SKUs
Total$6,548.00
Distribution ERP
Sales Order Draft
SKUDescriptionQtyAmount
SKU-1208Floor lamp — matte120$2,388.00
SKU-2440Accent rug 5x780$3,120.00
SKU-3184Table lamp — brass40$1,040.00
Inventory reconciliation Stock on hand · vendor vs system
Vendor stock reportReady
Vendor portal · Vendor A
System stock exportReady
Distribution ERP · Z-report
SKUDescriptionVendor on handSystem on hand
SKU-1208Floor lamp — matte——
SKU-2440Accent rug 5x7——
SKU-3184Table lamp — brass——
Inventory Reconciliation Report Generated · daily run
SKUVendorSystemVar.Status
SKU-12081201200Matched
SKU-244060600Matched
SKU-318485100-15Hold
2 of 3 SKUs reconciled clean · 1 variance held · 0 oversell shipped.
Company: Vendor A — Multi-brand User: idw.ops@erp Records: 3 ● Connected
Export the reconciliation report?
Exporting report
Reconciliation-Report.xlsx exported
Reconciliation Workbook Units on hand
fx =RECONCILE("Vendor A","ERP")
SKU
Vendor Stock
System Stock
Variance
Status
SKU-1208
120
120
0
Match
SKU-3184
85
100
Pending
SKU-2440
60
60
0
Match
RReconciliation ChecksStock on hand · vendor vs system
Stock checks Variances 3 SKUs · 1 exception
Reconciliation
Formats standardizedAligned
Compared line by line3 SKUs
Counts that agree
SKU-1208120 / 120
SKU-244060 / 60
Exception — oversell risk
SKU-318485 / 100
Variance −15 · held for investigation
Awaiting warehouse confirmation (human review)
Vendor stock is 15 units under system count — fulfilling would oversell SKU-3184. Line held and routed to the warehouse team.
InboxReady
Select a message
New emailReconciliation summary
Reconciliation-Report.xlsx attached

Reconciliation summary sent

Workflow checklist
  • Vendor portal logged in
  • Vendor order read and extracted
  • Order ORD-58227 posted in the ERP ($6,548.00)
  • Vendor and system stock downloaded
  • Stock reconciled line by line
  • Oversell variance flagged and held
  • Reconciliation report exported
  • Summary emailed to the team
  • Process complete with zero manual entry