Transport Ledger Template — Bilty, Trip Expenses & Profit
One row per trip or bilty — freight, fuel, tolls and driver expenses, with trip profit and the client’s balance due worked out.
Download the template
Free, no sign-up. Opens in Excel, Google Sheets, LibreOffice and Numbers, with the formulas already working.
What’s in the template
16 columns, a row of example entries you can overwrite, and a TOTAL row at the bottom. Columns marked “formula” are calculated for you — don’t type over them.
Column
What to enter
Date
—
Bilty / Trip No
Your bilty (goods receipt) or trip number.
Vehicle
—
Driver
—
Client
—
From
—
To
—
Freight
What the client pays for the trip.
Fuel
—
Tolls
—
Driver expense
Daily allowance, food and loading tips paid to the driver.
Other expense
Loading/unloading labour, repairs on the way, parking.
Total expenseformula
Formula: Fuel + Tolls + Driver + Other.
Profitformula
Formula: Freight − Total expense (before fixed costs such as instalments and salaries).
Payment received
What the client has paid so far for this bilty.
Balance dueformula
Formula: Freight − Payment received.
How to use the transport ledger
Enter a row for every bilty or trip as soon as it is booked, then add the fuel, tolls and driver expenses when the vehicle returns. The sheet shows the trip’s direct profit and how much the client still owes. Filter by Vehicle to see which truck earns the most, by Driver to check expenses, and by Client to prepare a statement of balances due.
Remember that the Profit column is before fixed costs such as vehicle instalments, insurance, salaries, tyres and maintenance. Total those for the month and deduct them from the TOTAL profit to see what the business really made.
Keep receivables under control
Unpaid freight is one of the biggest problems for small transport companies. Sort the Balance due column from largest to smallest every week and follow up the oldest balances first. When a client pays several bilties at once, record the payment against each bilty so the ledger always matches their account. Our guide to transport business accounts covers receivables, driver advances and monthly closing in more detail.
Moving to transport management software
As the number of vehicles and trips grows, a single ledger is hard to keep complete — especially when drivers, the office and accounts all add to it. Transport management software keeps trips, vehicles, drivers, clients, maintenance and fuel together, so you are not rebuilding totals by hand.
In Pakistan, a bilty is the goods receipt a transport company issues when it accepts goods for carriage — it shows the sender, receiver, route, goods and freight. Each bilty usually becomes one row in the ledger.
How do I calculate profit per trip?+
Deduct the trip’s direct expenses — fuel, tolls, driver allowance and other costs on the way — from the freight. The template does this in the Profit column. For true monthly profit, also deduct fixed costs like instalments, salaries and maintenance.
Does it work in Excel and Google Sheets?+
Yes. The file is a standard CSV with formulas, so it opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers. In Google Sheets you can also use “Copy for Google Sheets”, click cell A1 and paste. Save it as .xlsx or keep it in Google Drive so your formatting and new rows are kept.
Is the template free?+
Yes — free to download, change and use in your business, with no sign-up. The file is created in your browser, so nothing you type is sent to us.