TemplatesType: Spreadsheet/LogFormats: .CSV / Excel & .PDF8 min readUpdated May 2026By Julian Vance

House Bill of Lading Template Excel

Having a well-structured house bill of lading template excel is the single most important step you can take to ensure consistency, reduce errors, and save countless hours. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive House Bill of Lading Template Excel template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.

What is a House Bill of Lading Template Excel?

A house bill of lading template excel is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the automotive-logistics domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as an editable CSV spreadsheet for Microsoft Excel and Google Sheets, alongside a clean printable PDF.

Spreadsheet/Log Preview

Template Registry

Standard Operating Procedure

Registry ID: TR-HOUSE-BI

Master Operations Framework: House Bill of Lading (HBL) Management System

1. System Overview & Purpose

Purpose: This framework serves as the definitive operational model for issuing, tracking, and auditing House Bills of Lading (HBL) within an NVOCC (Non-Vessel Operating Common Carrier) or freight forwarding environment. It ensures compliance with international shipping regulations, tracks cargo milestones, and links master operational data to financial billing.
Scope: Covers origin pickup, port-to-port movement, final destination delivery, container utilization, piece counts, weights, volumetric measurements, and associated commercial parties (Shipper, Consignee, Notify Party).
Data Update Cadence: Real-time transactional updates upon booking confirmation; daily milestone updates for operational status changes (Gate-In, Custom Clearance, Vessel Departure, Vessel Arrival, Pod Delivery).

2. Column Definitions & Validation Rules Table

Column ID	Field Name	Data Format	Req / Opt	Validation Rules & Operational Logic
A	HBL_Number	Alpha-Numeric	Required	Format: `[A-Z]{3}[0-9]{8}` (e.g., `NYC20230001`). Must be globally unique.
B	MBL_Number	Alpha-Numeric	Required	Format matches carrier master bill specifications. Links HBL to Master B/L.
C	Booking_Ref	Alpha-Numeric	Required	Internal operational booking identifier.
D	Shipper_Name	Text	Required	Full legal business name and address of the exporting entity.
E	Consignee_Name	Text	Required	Full legal business name and address of the receiving entity.
F	Notify_Party	Text	Optional	Defaults to Consignee if blank. Entity to receive cargo arrival notices.
G	Port_Of_Loading	Text (3-Locode)	Required	UN/LOCODE standard (e.g., `USNYC`, `SGSIN`).
H	Port_Of_Discharge	Text (3-Locode)	Required	UN/LOCODE standard (e.g., `NLRTM`, `CNSHA`).
I	Vessel_Voyage	Text	Required	Format: `[Vessel Name] [Voyage Number]` (e.g., `MSC OSCAR 2304E`).
J	ETD	Date (YYYY-MM-DD)	Required	Estimated Time of Departure from Port of Loading.
K	ETA	Date (YYYY-MM-DD)	Required	Estimated Time of Arrival at Port of Discharge.
L	Container_Number	Alpha-Numeric	Required	ISO 6346 standard (e.g., `MSKU1234567`).
M	Container_Type	Text	Required	Restricted list: `20GP`, `40GP`, `40HC`, `45HC`, `LCL`.
N	Seal_Number	Alpha-Numeric	Required	Carrier or shipper-applied high-security bolt/cable seal identifier.
O	Total_Packages	Integer	Required	Greater than 0. Total count of handling units.
P	Package_Unit	Text	Required	Restricted list: `Pallets`, `Cartons`, `Crates`, `Drums`, `Bags`.
Q	Gross_Weight_KG	Decimal (2 dec)	Required	Total scale weight including packaging, in kilograms.
R	CBM	Decimal (3 dec)	Required	Cubic Meters (`Length(m) x Width(m) x Height(m)`).
S	Freight_Terms	Text	Required	Restricted list: `Prepaid`, `Collect`.
T	Status	Text	Required	Restricted list: `Draft`, `Booked`, `In Transit`, `Arrived`, `Delivered`, `Cancelled`.

3. Complete Master Data Table

HBL_Number	MBL_Number	Booking_Ref	Shipper_Name	Consignee_Name	Notify_Party	Port_Of_Loading	Port_Of_Discharge	Vessel_Voyage	ETD	ETA	Container_Number	Container_Type	Seal_Number	Total_Packages	Package_Unit	Gross_Weight_KG	CBM	Freight_Terms	Status
HBL230001	MBL988101	BKG-8801	Apex Global Mfg	EuroTrade GmbH	Same as Consignee	USNYC	NLRTM	MSC OSCAR 2304E	2023-10-01	2023-10-15	MSKU7843920	40HC	SL-992011	48	Pallets	12450.00	68.500	Prepaid	Delivered
HBL230002	MBL988102	BKG-8802	TechnoParts Inc	Asia Tech Ltd	Logistics Hub HK	USLAX	SGSIN	CMA CGM ZHEN 412W	2023-10-05	2023-10-24	CMAU4029112	40GP	SL-992012	120	Cartons	4850.50	28.200	Collect	In Transit
HBL230003	MBL988103	BKG-8803	Midwest Grain Co	Tokyo Foods KK	Japan Bank Logistics	USCHI	JNTKO	ONE APUS 088E	2023-10-10	2023-10-28	TCLU8830192	20GP	SL-992013	400	Bags	21500.00	31.000	Prepaid	In Transit
HBL230004	MBL988104	BKG-8804	BlueRidge Apparel	London Retail PLC	Same as Consignee	USSAV	GBSOU	EVER GIVEN 102N	2023-10-12	2023-10-26	EISU9019283	40HC	SL-992014	85	Pallets	9200.75	71.200	Prepaid	Arrived
HBL230005	MBL988105	BKG-8805	LoneStar Chem	Santos Ind Brazil	PetroChem Agent	USHOU	BRSSZ	HMM ALGECIRAS 003	2023-10-15	2023-10-30	HMMU2091823	20GP	SL-992015	32	Drums	18400.00	24.500	Collect	Booked
HBL230006	MBL988106	BKG-8806	Cascade Lumber	Sydney Build Co	Aussie Port Svcs	USTIW	AUSYD	OOCL SPAIN 012E	2023-10-18	2023-11-12	OOLU7726152	40HC	SL-992016	24	Crates	24100.25	74.000	Prepaid	Draft
HBL230007	MBL988107	BKG-8807	Pacific Seafood	Busan Imports KR	Same as Consignee	USSEA	KRPUS	HAPAG EXPRESS 55	2023-10-20	2023-11-02	HLBU5519203	40GP	SL-992017	150	Cartons	6700.00	33.400	Collect	Booked
HBL230008	MBL988108	BKG-8808	NewEng Pharma	Swiss Med AG	Zurich Freight	USBOS	NLRTM	MSC ANNA 902W	2023-10-22	2023-11-05	MEDU1092831	20GP	SL-992018	10	Pallets	3200.00	14.200	Prepaid	In Transit
HBL230009	MBL988109	BKG-8809	GreatLakes Auto	Durban Motors SA	African Logistics	USDET	ZADUR	MAERSK MC-KINNEY 1	2023-10-25	2023-11-18	MRKU6619201	40HC	SL-992019	60	Crates	15800.50	69.100	Prepaid	Draft
HBL230010	MBL988110	BKG-8810	SunBelt Textiles	Cairo Fabrics SAE	Nile Clearing	USMIA	EGMER	CMA CGM SYMI 023	2023-10-28	2023-11-14	CGMU4491029	40GP	SL-992020	200	Bales	11100.00	52.000	Collect	Draft

4. Formulas & Calculation Logic

This section outlines standard spreadsheet calculation strings mapped to operational columns (assuming data begins at row 2 and extends to row 101).

Total Gross Weight Calculation (Aggregate): =SUM(Q2:Q101)
Total Volume Calculation (CBM Aggregate): =SUM(R2:R101)
Container Utilization Ratio Check (Weight vs Standard Max for 40HC - 29,000 KG): =IF(AND(M2="40HC", Q2>29000), "OVERWEIGHT", "COMPLIANT")
Dynamic Status Count (Active Shipments: In Transit & Arrived): =COUNTIF(T2:T101, "In Transit") + COUNTIF(T2:T101, "Arrived")
Lookup HBL Details by Container Number: =XLOOKUP(L2, L2:L101, A2:A101, "Not Found")
Transit Days Estimation: =K2 - J2

5. Summary KPI Dashboard

Metric Label	Calculation / Formula Reference	Target / Threshold	Health Status Flag
Total Active HBLs	`=COUNTIF(T2:T101, "<>Cancelled") - COUNTIF(T2:T101, "Delivered")`	N/A	`INFO`
Total Cargo Weight (KG)	`=SUM(Q2:Q101)`	`< 500,000 KG / Wk`	`=IF(SUM(Q2:Q101)<500000, "OPTIMAL", "CAPACITY ALERT")`
Total Volume (CBM)	`=SUM(R2:R101)`	`< 2,500 CBM / Wk`	`=IF(SUM(R2:R101)<2500, "OPTIMAL", "VOLUME ALERT")`
Exception Rate (Overweight)	`=COUNTIF(V2:V101, "OVERWEIGHT") / COUNTA(A2:A101)`	`0.00%`	`=IF(COUNTIF(V2:V101, "OVERWEIGHT")=0, "PASS", "CRITICAL")`
Pending Drafts	`=COUNTIF(T2:T101, "Draft")`	`< 5 Shipments`	`=IF(COUNTIF(T2:T101, "Draft")<5, "NORMAL", "BACKLOG")`

6. Standard Operating Workflow

Booking Intake & Validation:
- Input the commercial booking details received from the Shipper.
- Ensure HBL_Number auto-generates or is manually assigned following the strict regex pattern ([A-Z]{3}[0-9]{8}).
- Verify UN/LOCODEs for Port_Of_Loading and Port_Of_Discharge.
Cargo Consolidation & Container Assignment:
- Assign container numbers (Container_Number) and matching high-security Seal_Number elements upon gate-in at the container freight station (CFS) or container yard (CY).
- Enter physical metrics: Total_Packages, Gross_Weight_KG, and CBM. Verify that metrics do not exceed ISO container weight ceilings.
Documentation & Compliance Generation:
- Review the Summary KPI Dashboard to confirm zero "OVERWEIGHT" or data validation flags.
- Lock down financial terms (Freight_Terms set to Prepaid or Collect).
- Update the Status field from Draft to Booked once documentation is verified against the Master Bill of Lading (MBL_Number).
Milestone Tracking & Lifecycle Management:
- Update ETD and ETA dates as communicated by the ocean carrier.
- Progress the Status field sequentially: Booked -> In Transit -> Arrived -> Delivered.
- Archive records post-delivery for auditing and financial reconciliation.

Official Standardized Document

Download this Template

View all