Guide ยท Loading and special shipments
Consolidated packing list for multiple suppliers: merging without losing traceability
A consolidated packing list merges several suppliers' lists into one document for a single shipment. The merge is easy; keeping each row traceable to its supplier and PO is the work. Add supplier and source columns, keep each supplier's carton numbers, and subtotal every supplier before the grand total.
One shipment, several sources
When goods from several suppliers ship in the same container or LCL consignment, the forwarder or the buyer's agent often prepares a consolidated packing list: one list for the whole load, used by the carrier, customs and the consignee. Each supplier normally still issues its own packing list and invoice. The consolidated list sits on top of them and shows the load as a whole.
The risk is traceability. Two suppliers may both number cartons from 1, use the same SKU code for different products, or write weights in different units. Merged without a supplier column, those become apparent duplicates, and a query about one carton cannot be traced back to its source list.
General information, not customs or legal advice. Customs entries and invoices are often filed per supplier or per consignment; whether one consolidated list is acceptable depends on the destination, so confirm with your broker.
Merge the lists in six steps
Collect the final versions
One list per supplier and PO, each with its date or revision. A list revised after the merge is the commonest cause of totals that stop tying.
Put every list on the same units
Weights in kg, volume in CBM, carton size in cm, converted before merging so the rows can be added.
Add the traceability columns
Supplier, source list number and PO on every row. Keep each supplier's own marks and carton numbers; see shipping marks and carton numbers.
Decide the carton numbering
Either keep each supplier's numbers in its own scope, or add a consolidated number in a separate column when the consignee wants one sequence. Never overwrite the originals.
Subtotal each supplier, then total
Cartons, quantity, N.W., G.W. and CBM per supplier, and a grand total equal to the sum of the subtotals.
Tie the result to the booking
Each subtotal equals that supplier's own list and invoice, and the grand total equals the booking. The grand totals also feed the container load plan.
Example: three suppliers, one container
Subtotals per supplier and the grand total they must add up to.
| Supplier | Source list | Cartons | Gross weight (kg) | CBM |
|---|---|---|---|---|
| Supplier A | PL-A | 120 | 1,480.00 | 11.250 |
| Supplier B | PL-B | 80 | 910.50 | 6.840 |
| Supplier C | PL-C | 45 | 520.00 | 3.015 |
| Grand total | 245 | 2,910.50 | 21.105 |
A worked trace
Take carton 14 on Supplier B's list, PO 2207. On the consolidated list it keeps its own number (14), its supplier (B), its source list (PL-B) and its PO (2207), and gets a consolidated number, 134, in a column of its own: 120 cartons from Supplier A come first, then 14. A broker's question about that carton leads straight back to the supplier's list and invoice, and Supplier B's subtotal is unchanged.
Order the rows by supplier, then by carton number, so each supplier's block stays whole and its subtotal sits directly beneath it. Sorting by SKU helps the warehouse, but do it on a copy and keep the supplier-ordered version as the record.
What goes wrong
- Carton numbers collide. Two suppliers both start at 1, and without a supplier column the rows look like duplicates.
- The supplier column is dropped. The merged sheet is tidier, but a query on one carton cannot be traced to its list or invoice.
- Units are mixed in the merge. One supplier's lbs and another's kg are added as if they were the same.
- Totals stop tying. A supplier revises a list after the merge, so the grand total and the subtotals disagree. It bites hardest when the load feeds a plan that must match box by box, as in packing lists for Amazon FBA shipments.
- Same SKU code, different product. Two suppliers use the same internal code. Keep the supplier next to the SKU.
How CargoSheet helps
CargoSheet converts one supplier PDF at a time, so each list gets its own tie-out of rows against that supplier's declared totals. It merges the pages of a single list, not several files, and it does not build the consolidated list. Combine the converted spreadsheets yourself, adding the supplier and PO columns. Try the packing list to Excel converter. Free: 1 file per day, up to 10 pages, no account. Files over 10 pages are converted up to page 10 on the free allowance; a page code converts the whole file, up to 150 pages. See pricing.
Questions
- What is a consolidated packing list?
- One packing list that covers the goods of several suppliers shipping together in one container or LCL consignment. It usually sits alongside each supplier's own list and invoice.
- Do I still need each supplier's packing list?
- Usually yes. The supplier lists are the source documents, and customs, a bank or the buyer may ask for them. The consolidated list summarises them and keeps them traceable.
- How do I number cartons across suppliers?
- Keep each supplier's numbers in a clear scope, such as supplier plus PO. If the consignee wants one sequence, add a consolidated number in its own column instead of overwriting the originals.
- Which columns should a consolidated list add?
- Supplier, source list number and PO, and optionally a consolidated carton number. The remaining columns follow your usual layout, for example the one in the packing list template.
- Can customs accept one list for several suppliers?
- That depends on the country and on how the entries are filed. Some entries are per supplier invoice. Ask your broker whether they also need the individual supplier lists.
- How do I check the merged totals?
- Compare the grand total with the sum of the supplier subtotals and with the booking. A mismatch usually comes from a list revised after the merge or a unit slip.
Check a packing list against its own totals
Free: 1 file per day, up to 10 pages, no account.