Keep one row per PO line so a partial receipt does not hide the remaining order. Download the blank CSV for Excel or Google Sheets, then use the example below to reconcile price changes, deliveries, and supplier follow-ups. No signup required.
Download CSV TemplateThis is an illustrative order, not a customer result or a screenshot of LineNow. All values are USD, before tax and freight.
Download the populated example CSV to compare against your own tracker.
Import the CSV with PO numbers and item identifiers treated as text. Enter quantities as numbers, dates as YYYY-MM-DD, and the currency explicitly. The CSV contains values and blank fields, not formulas or automatic reminders.
Open quantity = approved quantity − received quantity − cancelled quantity. In this example: 12 − 8 − 0 = 4 cases. A negative result is a reconciliation issue to investigate, not a value to hide. Open value is open quantity multiplied by approved unit price.
Update the row after each approved change or accepted receipt. Keep a separate dated receipt log when a line has several deliveries; cumulative totals alone are not an audit trail. For split delivery dates, record the quantity due on each date in the exception field. Retain approval references to the supporting record.
Use the same unit throughout a line. Do not subtract individual units from a case quantity without converting the pack size. Quarantine damaged goods separately until you decide whether they count as accepted receipts, returns, or a supplier claim.
The $208 received value is not proof that an invoice is correct or payable. Compare the invoice with the approved price and accepted receipts, and investigate discrepancies through your payment process. Track invoice references and credit requests separately; do not close a supplier claim merely because the delivery row is complete.
A tracker can work when one owner keeps it current. If approvals live in email, receivers overwrite quantities, or buyers cannot explain an open balance, test software with this same exception. Ask who can change the order, where the supplier reply is retained, how partial receipts appear, and what history remains after the next edit.
When several people are updating the same order, evaluate LineNow purchase order tracking for supplier conversations and order history. Bring a partial-delivery example to your demo and check how your team would resolve it. 90-day free trial, then $100/month per business unit.
