Calculate received and open quantity by PO line
Sum partial receipts by exact supplier, PO and line. Identify open or excess quantities while flagging unit mismatches and duplicate receipt keys.
How many units remain open after partial receipts?
Subtract the sum of recorded receipts from the ordered quantity for each PO line. If 100 units were ordered and distinct receipts record 40 and 35 units, 25 remain open. This arithmetic does not prove that 25 units were short-shipped; they may be due later.
Input requirements and report limits ↓Inputs
Copy a table from Excel or Google Sheets, including its header row, and paste it below. CSV/TSV files also work. Use “Map your columns” for different headers. IDs stay as text.
Free: UTF-8 CSV/TSV · 200 KB / 500 rows per input · 5 successful reviews per browser per day. CSV calculations run locally.
Need larger files or repeat batches? View editions →
Reuse a column profile
A profile stores column names only. It does not store your file contents.
Review report
Before you use this review
| Bring | PO lines and separate receipt events, including supplier, PO, line ID, quantities, units and receipt IDs. |
|---|---|
| Match | Exact supplier + PO + line; identical units only. Repeated receipt ID + supplier + PO + line keys are rejected. |
| Calculate | 100 ordered − (40 received + 35 received) = 25 open. Do not add cumulative received totals. |
| Cannot establish | Short shipment, lateness, returns, cancellations, invoicing or payment. Different IDs can still describe the same delivery. |
Required inputs
Orders need supplier, po, line_id, sku, ordered_qty, unit. Receipts need receipt_id, supplier, po, line_id, received_qty, unit. Matching uses exact supplier + PO + line keys. Duplicate receipt ID + supplier + PO + line keys are rejected.
Interpret the report
Only identical units are summed. Quantities support up to six decimal places; boxes are not automatically converted to individual units. Different receipt IDs can still represent the same real delivery, so check the underlying records.
Returns, reversals, cancellations and amended order quantities need separate treatment. This does not close a PO, approve an invoice or establish a supplier claim. Reproduce the 100 ordered, 75 received, 25 open example using downloadable synthetic CSV files.
Should I enter each delivery or a running received total?
Enter separate receipt quantities, not cumulative snapshots. If the first delivery is 40 units and the running total later becomes 75, the second receipt is 35, not 75. Entering 40 and 75 would count the first delivery twice. Check receipt documents before converting a running total into separate events.
How do I distinguish an open quantity from a late shipment?
This report establishes only the arithmetic difference in the supplied files. It has no promised-date or actual-delivery timing test. To review how planned dates moved across saved reports, use Date Trail for observed supplier ETA changes; that also does not establish actual on-time performance.
Prepared by Supplier Desk Team · Updated . Examples are synthetic.
Who this is for
Small retail and wholesale operations teams reviewing supplier exports before changing catalog, stock or purchasing records. This is a focused review worksheet; it does not connect to your store or post transactions.
Related background
Read the source discussion or documentation. This describes the broader workflow. Use the input requirements and calculation rules above to decide whether this particular check fits your task.
Free tools with optional offline batch editions. Higher file limits, saved batch configurations and grouped report exports. No automatic store changes.