# Transport Bill Format in Excel (Create in 4 Simple Steps)

## What Is an Excel Transport Bill Format?

A transport bill is a type of receipt provided by a transport service. The overview of a bill template is in the image below.

## Main Details of Transport Bill Format in Excel

1. Company Name
2. Customer’s Information
3. Transport Invoice
4. Description of Services
5. SUBTOTAL Calculation

## 4 Steps of Creating a Transport Bill Format in Excel

### Step 1 – Input the Details of a Company

• Create the segment for Company Name. This section will consist of the Address, Phone, Email, and Website of the company.

### Step 2 – Customer Details in the Transport Bill Format

• Make the Billing section. Input the customer’s details in this section, which will contain the Name, Company, Address, Phone, Email, etc.
• Add the Transport Invoice section. This section contains bookkeeping information.

### Step 3 – Describe the Services Provided

• We can add different transportation methods in the TRAVEL DESCRIPTION section.
• We have added a numerical value for determining whether the journey is one way or two-way, which correlates to the number of times the cost will be added to the total.
• ONE WAY AMOUNT and the TOTAL transportation cost will be prices.

### Step 4 – Calculate the SUBTOTAL

• This section contains the Service Tax, Total, and Paid amount.
• We get the information for the Total Due amount from this section.

## Additional Segments

• Add the Comments section.

• Insert the section to input signatures for suppliers and customers. When the sheet is printed or saved as a PDF, the signatures can be filled in.

## Demo Calculations of the Transport Bill Format in Excel

• Insert some values for the transportation details.
• For ONE WAY/RETURN, insert 1 for one way trip and 2 for a return trip.

• Insert the following formula in the first cell of the TOTAL column for calculating the total transportation cost By Road.
`=IFERROR([@[ONE WAY/RETURN]]*[@[ONE WAY AMOUNT]], "")`
• Add the corresponding formula for the other cells in the Total column.
• We get the total transportation cost in the SUBTOTAL section.
• Add the Service Tax to the SUBTOTAL amount to get the actual transportation cost.
• Subtract the paid amount from TOTAL to get the amount of Total Due.

How Does the Formula Work?

• [@[ONE WAY/RETURN]]: This part takes the value 1 under the column ONE WAY/RETURN.
• [@[ONE WAY AMOUNT]]: This part takes the value \$550 under the column ONE WAY AMOUNT.
• IFERROR([@[ONE WAY/RETURN]]*[@[ONE WAY AMOUNT]], ” “): Returns the product of ONE WAY/RETURN and ONE WAY AMOUNT. It will return blank if any we any invalid value.

Download the Template

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Mukesh Dipto

Mukesh Dipto is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, HTML, CSS, JavaScript, and WordPress. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF