Bill of Lading Template (Excel)
A free Excel bill of lading with shipper, consignee and carrier details, package lines, total pieces and weight, and a hazardous flag.
What is in this template
A single printable sheet called BOL plus a How to use tab. It is a simple record of what is being shipped, who is sending it, who receives it and which carrier is moving it.
BOL
At the top enter the BOL number, date, shipper and ship-from address, consignee and ship-to address, carrier, PO or reference number and the freight terms. Below, list up to 15 shipment lines with a package type from a drop-down (Carton, Pallet, Crate, Drum, Bag, Roll or Other), the number of pieces, a plain description of the goods, the weight in pounds and a Hazardous? flag. Any line marked Yes turns red. Under the table you get total pieces, total weight, the number of hazardous lines and the heaviest line. The sheet prints on one portrait page.
How to use
Steps with a link back to the sheet.
The sample data
The sample shipment is from a made-up supplier in Texas to a builder in Florida. It has three lines: 24 cartons of floor tiles (1,850 lb), 4 pallets of vanity units (620 lb) and 10 cartons of grout and adhesive (250 lb). Total pieces are 38 and total weight is 2,720 lb. No line is marked hazardous.
How to use it
- Enter the BOL number, date and PO or reference.
- Fill in the shipper, consignee, addresses, carrier and freight terms.
- List each line with package type, pieces, description and weight.
- Mark hazardous goods Yes. They turn red.
- Print the sheet. The shipper, driver and consignee sign the printed copy.
Tips
- Describe the goods in plain words that the carrier and the receiver will understand.
- Weigh the shipment honestly. The carrier may check it.
- Match the PO number on the BOL with the paperwork the receiver holds.
- Keep a signed copy with your records.
This is a simple record sheet, not a legal document. Many carriers require their own bill of lading form, and hazardous goods have extra rules. Check with your carrier.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
Is this a legal bill of lading?
No. It is a record sheet for your own use. Ask your carrier whether they need their own form.
What does the hazardous flag do?
It marks the line in red and counts it, so it is not missed. It does not replace the extra paperwork hazardous goods need.
How many lines can I list?
Fifteen. Insert rows inside the table if you need more.
Are the companies real?
No. They are invented.
Need a custom calculator or spreadsheet built for your business?
Talk to usMore free tools: All free calculators · Inventory template · Shipping label template · How to fill out a bill of lading