The Bill of Lading (B/L or BL) is one of the central documents in maritime transport. For operational control, the goal is not to copy the entire document into Excel. It is to capture the fields that help your team identify the shipment, check consistency and connect the document with the physical movement.
What is a Bill of Lading?
A Bill of Lading is a transport document issued in connection with carriage of goods by sea. Depending on the type and terms, it can perform several legal and operational functions. From a tracking perspective, it is also a useful source of shipment references, parties, routing and cargo details.
Key BL fields to track
A practical import spreadsheet can include:
- Bill of Lading number
- Carrier or shipping line
- Shipper
- Consignee
- Notify party, where relevant
- Port of loading
- Port of discharge
- Vessel and voyage
- Container number
- Seal number
- Number of packages
- Gross weight
- Goods description
- Freight terms when operationally relevant
Why the BL number should be a searchable field
The BL number is often used in carrier portals, arrival notices and internal email chains. Keeping it in a dedicated column lets your team search one reference across documents, tracking tools and communication history.
Cross-check the BL with other documents
Do not review the Bill of Lading in isolation. Compare relevant fields against the commercial invoice, packing list, booking information and any document instructions used for the shipment. Typical checks include party names, package counts, weight, marks, container details and route information.
A mismatch does not always mean an error, but it should be understood before the shipment reaches a critical deadline.
Connect documents to shipment status
A useful spreadsheet does more than show whether the BL exists. Add a document status such as Pending, Draft received, Under review, Final received or Not applicable. You can also record the date received, who reviewed it and any outstanding correction.
The ImportVista Import & Export Document Checklist is designed for this type of control across multiple operations.
Keep document and transport references together
Where possible, use the same shipment reference across your tracker and document checklist. That makes it easier to connect ETA/ETD changes with documentation status and reduces the risk of treating documents as a separate workflow.
For a broader document structure, read the import/export document checklist guide. If you also want shipment, cost and free-days control, see the PRO Pack.
This guide is operational and general. Document requirements and the legal effect of a Bill of Lading depend on the shipment, contract, carrier and applicable law.
