LR Format Excel & Word: Free Lorry Receipt Template
Last Updated: October 2026 | Free Transport Documentation Format
Download an official LR format in Excel or generate bilties online. Whether you manage full truckloads (FTL) or part load parcels (PTL), using a standard lr format excel template with pre-built freight formulas prevents delivery disputes, ensures GST Rule 54(3) compliance, and speeds up customer payment collection.
Summary
An LR format in Excel (Lorry Receipt / Bilty format) provides Indian road transport operators with a standardized, 4-copy consignment note template. Pre-configured with automatic calculation formulas for basic freight, hamali, toll charges, GST GTA rates (5% RCM vs 12% FCM), and Section 194C TDS deductions, this spreadsheet template standardizes billing across consignor, consignee, driver, and account records.
Format Type
Standard 4-Copy Indian Lorry Receipt (LR / Bilty)
File Formats
Excel (.xlsx), Word (.docx), PDF & Digital TMS
Compliance
GST Act, Carriage by Road Act 2007, E-Way Bill Rule 138
Download LR Format in Excel
Free, editable LR format Excel (.xlsx) sheet with built-in auto-sum formulas for freight, GST (5% RCM vs 12% FCM), and TDS 194C withholding.
Make Lorry Receipt Online (No Excel Needed)
Skip Excel formatting issues. Generate, print 3 authentic copies, and dispatch direct PDF WhatsApp links in 30 seconds.
XYZ ROAD CARRIERS (INDIA) PVT. LTD.
Fleet Owners & Transport Contractors | Head Office: Transport Nagar, Mumbai - 400037
GSTIN: 27AABCT9999Z1Z5 | PAN: AABCT9999Z | Phone: +91 98765 43210
LR No: LR-2026-MUM-01948
Booking Date: 01-10-2026
Truck / Vehicle No: MH 04 GP 8421
Driver Name & Mobile: Ramesh Kumar (+91 98210 11223)
From (Origin): Bhiwandi, Maharashtra
To (Destination): Jaipur, Rajasthan
E-Way Bill No: 2314 9876 5432
Payment Term: TO-PAY / PAID / TBB
CONSIGNOR (Sender Details):
M/s: Supreme Industrial Components
Address: Plot 42, MIDC, Bhiwandi, Thane, Maharashtra
GSTIN: 27AAACS1234F1Z1
CONSIGNEE (Receiver Details):
M/s: Rajasthan Auto Spares Traders
Address: 15, Transport Nagar, Jaipur, Rajasthan
GSTIN: 08BBBRA5678K1Z3
| Pkg Count | Packing Type | Description of Goods | Actual Wt (Kg) | Charged Wt (Kg) | Rate Basis | Amount (₹) |
|---|---|---|---|---|---|---|
| 120 | Wooden Crates | Automotive Clutch Plates & Gears | 3,450 | 3,600 | ₹6.50 / Kg | ₹23,400.00 |
| Value of Goods: ₹4,85,000 | Invoice Ref: INV-2026-4412 | Bilty / LR Fee: | ₹100.00 | ||||
| Insurance Status: Owner's Risk (Insured by Consignor) | Hamali / Labor: | ₹450.00 | ||||
| Delivery Type: Godown Delivery / Door Delivery | Toll / Surcharge: | ₹350.00 | ||||
| TOTAL FREIGHT CHARGES: | NET (TO-PAY): | ₹24,300.00 | ||||
________________________
Consignor Signature
________________________
Driver Signature
________________________
Authorized Transporter Sign & Stamp
Mandatory Fields on a Valid Lorry Receipt (LR)
Under the Carriage by Road Act 2007 and GST documentation standards, every valid lorry receipt must record:
Header & Consignment Details
- Unique Sequential LR No: Pre-printed or auto-generated by software.
- Date of Booking: The day cargo enters transport custody.
- Origin & Destination: Specific loading and unloading points.
- Consignor & Consignee Details: Name, address, contact, and 15-digit GSTIN.
- Vehicle & Driver: Assigned truck registration and driver license details.
Cargo & Billing Columns
- Package Count & Description: Bags, drums, cartons, crates.
- Actual vs Charged Weight: Accounts for volumetric weight.
- Invoice & E-Way Bill: Customer invoice value and 12-digit EWB number.
- Freight Breakdown: Basic freight, hamali, bilty charge, detention.
- Payment Mode: Explicitly marked as Paid, To-Pay, or TBB.
The 4 Copies of an LR: Colors and Purpose
| Copy Name | Traditional Color | Held By | Purpose / Legal Importance |
|---|---|---|---|
| Consignor Copy | White / Pink | Shipper / Consignor | Proof of dispatch for the seller to collect bank payments or show tax officers. |
| Consignee Copy | Yellow | Buyer / Consignee | Document of title presented to the destination hub to release goods. |
| Driver / Lorry Copy | Blue | Truck Driver | Carried inside the cabin along with E-Way Bill for road checking by RTO or GST squad. |
| Transporter / Accounts | Green / White | Booking Office | Signed by the receiver as POD (Proof of Delivery) to authorize driver payout and bill freight. |
Why Manual Excel LR Templates Create Costly Headaches
While many small transporters start by downloading free LR templates in Excel, running multiple trucks or branches on spreadsheets quickly leads to critical errors:
- Duplicate LR Numbers: Branch A and Branch B accidentally print the same serial numbers, causing audit chaos.
- No Direct Link to GST Invoices: Accounts staff must retype cargo details from paper LRs into Tally or Excel, losing hours daily.
- Lost Proof of Delivery (POD): Paper bilty copies get lost or soiled in transit, delaying client payments for weeks.