{"product_id":"purchase-order-delivery-tracker-excel-and-google-sheets-shipment-log-receiving-checklists","title":"Purchase Order \u0026 Delivery Tracker | Excel and Google Sheets Shipment Log + Receiving Checklists","description":"\u003cp\u003eOnly part of the order arrived—what is still missing, and who needs to follow up? Track ordered items, accepted and rejected quantities, partial shipments, replacements, and returns in one manually updated workbook, with Excel and Google Sheets versions included.\u003c\/p\u003e\u003cp\u003eYour digital download includes a 2-sheet workbook for 200 ordered item rows and 500 delivery or return entries, a 3-page printable US Letter PDF, and a Start Here guide, available in a complete ZIP and as separate files. Use Microsoft Excel for the .xlsx file or a free Google account for the included Google Sheets version. Software is not included.\u003c\/p\u003e\u003cp\u003ePDF pages are printable, not fillable. This records deliveries; no supplier integration or payment tracking is included.\u003c\/p\u003e\u003cp\u003eINCLUDED\nTwo-sheet Excel workbook: 200 ordered item rows and 500 delivery or return entries. Three-page printable US Letter PDF: Shipment Receiving Checklist, Item Quantity \u0026amp; Condition Record, and Missing Item \u0026amp; Replacement Follow-Up. Start Here guide and complete ZIP. A separate Google Sheets access PDF includes a link to make your own editable copy in Google Drive.\u003c\/p\u003e\u003cp\u003eOpen the PDF, click its button, sign in to Google and select Make a copy.\u003c\/p\u003e\u003cp\u003eTRACK\nOrder numbers, vendors, item IDs, units, quantities, expected dates, destinations, action owners and follow-up dates. Record accepted and rejected quantities separately, partial shipments, replacement deliveries and returns. Calculates outstanding quantities and item cost after cancellations. Flags overdue deliveries, overdue follow-ups and records needing data review.\u003c\/p\u003e\u003cp\u003eEach ordered item has its own Line ID. Deliveries link to that ID, so several shipments can belong to the same item. Rejected or damaged pieces do not count as accepted. Received is a quantity status; unresolved issues remain separate follow-ups.\u003c\/p\u003e\u003cp\u003eCream input cells and sage calculations, table filters and frozen headings. Fixed capacity; use another working copy for additional records. This is a manually updated order tracker, not inventory valuation, payment tracking or a supplier integration. Item cost excludes tax, shipping and refunds.\u003c\/p\u003e\u003cp\u003eDigital download only. No physical product. Excel and Google Sheets versions included. Desktop Excel testing was unavailable; representative partial-delivery and return calculations were checked in Google Sheets. PDF pages are printable, not fillable. Sample preview entries demonstrate the workflow; customer workbook is blank. Cover illustration is styled marketing imagery; additional photos show actual workbook and PDF pages.\u003c\/p\u003e\u003cp\u003eFor internal use within the purchasing business. Do not resell or redistribute the blank templates. Created with AI assistance and reviewed by Keys \u0026amp; Keep Property.\u003c\/p\u003e","brand":"Keys and Keep Property","offers":[{"title":"Default Title","offer_id":46108723707973,"sku":null,"price":9.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0771\/3767\/4309\/files\/efe8d8c7-il_fullxfull.8610253580_a3r1.jpg?v=1792789615","url":"https:\/\/keysandkeepproperty.com\/products\/purchase-order-delivery-tracker-excel-and-google-sheets-shipment-log-receiving-checklists","provider":"Keys and Keep Property","version":"1.0","type":"link"}