A systematic approach to monitor split deliveries across vendors for precise accounting and optimized shipping logistics.
The Challenge of Split Deliveries
In global procurement, a single purchase order often results in multiple partial shipments
Core Benefits of the ACBUY Tracking Method
- Accurate Financial Reconciliation:
- Proactive Logistics Management:
- Enhanced Vendor Accountability:
- Real-Time Inventory Forecasting:
- Proactive Logistics Management:
Key Spreadsheet Components for Effective Tracking
A robust ACBUY tracking spreadsheet should include the following essential columns and sections:
Primary Tracking Table
| Column Header | Purpose |
|---|---|
| Master PO Number | The original purchase order identifier linking all split shipments. |
| Vendor Name | Specific supplier for each shipment segment. |
| Item SKU / Description | Detailed product information. |
| Total Quantity Ordered | Baseline quantity from the original PO. |
| Shipment Instance | E.g., "1 of 3", tracking the sequence of partial deliveries. |
| Quantity Shipped (This Instance) | Amount dispatched in this specific shipment. |
| Cumulative Quantity Received | Running total received against the Master PO. |
| Balance Due | Automated calculation: (Total Ordered - Cumulative Received). |
| Shipment Date / ETA | Key dates for logistics coordination. |
| Tracking Number & Carrier | Essential for real-time shipment monitoring. |
| Invoice Number & Amount | Critical for matching payments to specific deliveries. |
| Status | E.g., In Transit, Received, Checked-In, Invoiced. |
Best-Practice Workflow
- Initial Setup:
- Daily/Weekly Update:
- Receival & Reconciliation:
- Analysis & Optimization:
- Daily/Weekly Update:
Turning Data into Optimization
The true power of the ACBUY spreadsheet lies in leveraging its data:
- Consolidated Shipping:
- Cash Flow Management:
- Vendor Performance Dashboards:
- Cash Flow Management: