Bill of Lading Excel Template

If you are a forwarder or a carrier, the chances are that you need to create lots of shipping documents including transport bills. We prepared a bill of lading template in Excel just for this need.

With our waybill template, you don’t have to waste any time generating your cargo receipts. You also won’t need any other installation other than Excel. You can easily input your data in Excel and export it as a PDF or print it instantly.

What’s a Bill of Lading?

A bill of lading (BOL) is a legal document that a carrier gives to a shipper that lists the goods being carried, how many there are, and where they are going.

And what are the purposes of Bill of Lading?

It is mostly used for three things:

• Received Goods: It’s like a receipt that shows the goods were received and are in good condition.
• Contract of Carriage: This document spells out the terms and conditions of the shipping deal between the shipper and the carrier.
• Title Document: This document can be used as a title for the goods and can be given to someone else. It is necessary for the transfer of ownership of the goods.

Let’s look at the BoL Template in detail.

How to use Someka’s Bill of Lading Template in Excel?

This template consists of a generic bill of lading form. It has the shipping information, Customer Order Information, and Carrier Information sections.

Firstly, you will fill in the Ship from and Ship to sections at the top of the page. After that, you can also fill in the transportation information such as the carrier’s name and freight charge terms. Because it is Excel, all you need to do is write the text in the related cells.

Then, you can move forward to the Customer Order Information and the Carrier Information sections.

Also, the total weight and number of packages will be calculated by the generic bill of lading template in Excel.

Also, you can select the checkboxes by clicking on them.

What does FOB mean?

FOB stands for Free On Board, and it is a term used in shipping to indicate when the responsibility and ownership of goods are transferred from the seller to the buyer. There are two common terms related to FOB:

• FOB Origin: The buyer takes responsibility for the goods once they leave the seller’s premises.
• FOB Destination: The seller retains responsibility until the goods reach the buyer’s location.

Printing the BoL:

After you fill in all your information, you can simply press CTRL+P and print the consignment document directly.

Moreover, if you are not connected to any printers, the print to pdf will appear and you will be able to export the bill of lading document as PDF.

How to Create a Bill of Lading in Excel?

If you want to create your own bill of lading in excel:

1. Open a blank Excel sheet
2. Prepare your format
3. Add your logo
4. Input shipper, consignee, carrier information
5. Add items with descriptions
6. Add terms and conditions

But you do not need to care for preparing the format. Someka’s Bill of Lading Template in Excel will give your ready and professional looking format.

Does Excel have a bill of lading template?

You can check the Microsoft template gallery to find the best format for your bill of lading. But if you want a more professional looking and fillable tool, then download Someka’s Bill of Lading Template.

Who prepares the bill of lading?

A bill of lading is usually made by the shipping company or the carrier. The shipper gives the carrier information about the goods, such as their names, amounts, and where they are going. The carrier uses this information to make the bill of lading.

Who pays for bill of lading?

Most of the time, either the shipper or the consignee pays for the bill of lading. This depends on the terms of the shipping contract. Some of the payment duties that can change are:

• The person sending the package pays the carrier before the package is sent.
• If the shipment is collect, the recipient pays when the package is delivered.

Someka’s Bill of Lading Template Excel Features Summary:

• Simple bill of lading template for overseas shipping
• Professional Bill of Lading Template Excel format
• Print ready Waybill Template
• Ready-to-use in Excel
• No need for any installation
• Works both in Mac and Windows
• Informational notes included