ACBUY Spreadsheet: Mastering Partial Shipment Tracking
A guide to monitoring split deliveries across vendors for precise accounting and optimized logistics.
The Challenge of Split Deliveries
In modern procurement, receiving a single purchase order across multiple shipments from one or more vendors is commonplace. While often necessary, these partial shipments
What is the ACBUY Partial Shipment Tracker?
The ACBUY Spreadsheet is a dedicated, template-driven tool designed to give procurement and accounting teams real-time visibility into split deliveries. It consolidates data from multiple vendors and shipments into a single source of truth, enabling accurate cost allocation and logistical oversight.
How to Set Up and Monitor with ACBUY
Step 1: Centralized Master Log
Create a master sheet listing every Purchase Order (PO). Key columns should include: PO Number, Vendor Name, Total Order Value, Total Items Ordered, and Critical Status Flags
Step 2: Detailed Shipment Line Tracking
Link each PO to a detailed shipment log. For every partial delivery, record:
- Shipment Date & Carrier/Tracking #
- Items Received
- Shipment Value
- Remaining Balance
Step 3: Vendor Performance Dashboard
Use a summary sheet to aggregate data by vendor. Monitor metrics like:
- Average Split Frequency:
- Fulfillment Delay:
- Cost Accuracy:
- Fulfillment Delay:
Step 4: Integration with Accounting
Dedicate a section to match provisional receipts
Key Benefits for Your Business
Accurate Financial Accounting
Enables precise cost-of-goods-sold (COGS) calculations and ensures liabilities are recorded correctly, even for in-transit inventory.
Optimized Shipping & Receiving
Identifies consolidation opportunities. If multiple vendors ship partially, you can coordinate to combine shipments and reduce freight costs.
Proactive Dispute Resolution
Provides an unambiguous record to quickly resolve invoice or delivery disputes with vendors, protecting your bottom line.
Enhanced Inventory Planning
Gives planners clear visibility into what has actually arrived vs. what is still pending, improving stock level forecasts.
Streamline Your Supply Chain
Partial shipments don't have to mean partial data or fragmented processes. By implementing the ACBUY Spreadsheet
Start by auditing your current POs with pending deliveries and build your first tracking sheet today.