Quick answer: A bilty (lorry receipt / LR) is the receipt a transporter gives when it takes goods for carriage. It should show:
- LR no., date, truck no. and driver
- from and to, consignor and consignee with GSTINs
- the party’s invoice no., invoice value and e-way bill no.
- goods, packages, actual and charged weight, and rate
- freight and charges, advance and balance, and whether freight is To Pay, Paid or To Be Billed (TBB)
Download a free bilty format in Excel below. The freight, total and balance are worked out. It also has a truck trip register that shows the profit on each trip.
Key takeaways
- Printable bilty / LR on A4, with your company header and terms.
- Freight terms drop-down: To Pay, Paid or TBB. Detention, hamali and shortage are added or deducted.
- Trip register for 50 trips: freight minus diesel, toll and bhatta gives the trip profit, with losses in red.
- Free, with no macros. Works in Excel or Google Sheets.
What goes on a bilty
| Field | Why it matters |
|---|---|
| LR no. and date | Your reference for the trip, the bill and any claim. |
| Truck no. and driver | Who is carrying the goods; checked at police and GST checkpoints. |
| Consignor and consignee (with GSTIN) | Who sends and who receives. Delivery is made only to the consignee. |
| Invoice no., value and e-way bill | Goods above the e-way bill limit must travel with an e-way bill. |
| Goods, packages, weight and rate | Freight is usually charged weight × rate per MT, or a fixed amount for the trip. |
| Freight terms, advance and balance | To Pay = the consignee pays on delivery. Paid = paid at booking. TBB = billed to the party later. |
Copies of a bilty
A bilty is usually made in three copies:
- Consignor copy, for the party who sent the goods
- Consignee copy, which travels with the goods and is given at delivery
- Driver / office copy, which comes back signed as proof of delivery (POD)
Change the copy name in the yellow cell at the top right and print each one.
Truck trip register
Write every trip on the same day. At the end of the month the register tells you:
- which routes pay
- how much went on diesel
- which party gave you advances
Download the free Bilty (LR) Format & Trip Register
There are two sheets: Bilty (LR) and Trip Register. Change the company header once, then fill the yellow cells for each trip.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Was this template useful?
Related free templates Free Excel files people download with this one
FAQs
What is the difference between a bilty and an e-way bill?
The bilty (LR) is the transporter’s receipt for the goods. The e-way bill is a GST document generated on the government portal. Write the e-way bill number on the bilty.
Bilty kaise banaye?
Download the Excel file. Enter the LR no., truck, consignor, consignee, goods, weight and rate. Freight and balance will come automatically, then print it.
What does TBB mean on a bilty?
To Be Billed: the freight is not collected at loading or delivery. The transporter adds it to the party’s monthly freight bill.
