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
Running more than one truck? XploreFleet – Transport & Truck Fleet Manager in Excel prints the bilty from the trip row, with two copies on one page. It also makes a monthly freight bill for each party, shows party outstanding with WhatsApp reminders, and tracks diesel and mileage and profit per truck after EMI and repairs. It keeps a driver khata showing the cash with each driver, and alerts you before insurance, permit, PUC or a licence runs out.
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.
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.
