Taxi bill format in Word and Excel, and when to stop
· 5 min read
Quick answer
A Word or Excel taxi bill works fine for a few bills a month: put your details at the top, a running bill number and date at the right, the trip details in the middle, and the fare split above the total. It stops working when you need one at a drop point, because a template needs a laptop and the bill is wanted while the passenger is still standing there.
Plenty of drivers run a perfectly good billing system out of one Word file. If you send four bills a month, that is the right amount of technology and you should not let anyone talk you out of it.
This is the layout, and then the honest account of where it stops working.
A layout you can rebuild in ten minutes
The structure below is what an accounts desk expects to see, in the order they scan it.
Top left, your details
RAMESH TRAVELS
KL-07 AB 1234
Kakkanad, Kochi 682030
98470 00000
Top right, the bill's identity
Invoice No: RT-0042
Date: 30 August 2026
Middle, who and what
Billed to: Meridian Software Pvt Ltd
Passenger: A. Nair
Date & time of travel: 30 Aug 2026, 06:40 - 07:35
From: Kakkanad To: Cochin International Airport
Distance: 28 km
Then the money, as a table
| Description | Amount |
|---|---|
| Trip fare, 28 km | ₹720 |
| Toll | ₹90 |
| Parking | ₹40 |
| Waiting, 20 min | ₹90 |
| Total | ₹940 |
Bottom, the close
Payment method, your UPI ID, and a line for a signature.
Add your GSTIN under your name and a separate tax row above the total only if you are registered. If you are not, delete the tax row rather than leaving it showing zero. A blank tax line raises a question nobody needed to ask. There is more on that in what a driver should check about GST.
In Excel, make the total a SUM over the amount column and keep one row per bill
on a second sheet, so you have a register as well as a bill. That register is the
one genuine advantage Excel has here.
The three things both are bad at
None of this is a criticism of the format. It is the right format. These are problems with the tools.
The bill number. It is typed by hand, which means one day it repeats. Usually because you started from last week's file and changed everything except the number. A repeated number is the single most common reason a reimbursement claim comes back, because the company cannot tell whether the same ride is being claimed twice. Read what gets a bill approved for the rest of that list.
The file lives on one device. The laptop at home, usually. When a passenger rings in November about an August bill, you are at a taxi stand and the file is forty minutes away. If the laptop dies, so does the register.
It cannot be made at the drop point. This is the expensive one, and it has nothing to do with the template being badly designed. The moment a bill is worth most is while the passenger is still next to the car. A template needs a laptop, so the bill becomes "I will send it tonight". Some of those never get sent, and the ones that do arrive after the passenger has stopped thinking about you.
How to tell it is costing you
Not everyone needs to move off a template. Some rough signals that you have:
- You are making more than about ten bills a month.
- You have said "I will send it later" more than once this week.
- A passenger has asked for a copy of an old bill and you could not find it quickly.
- Two bills have carried the same number.
- You have company passengers, who need the bill inside their claim window.
- You are trying to work out what the month earned by scrolling through a folder.
One or two of these is normal. Four is a template that has outgrown itself.
The tell that matters most is the third one. A billing system is not only for
issuing bills, it is for answering questions about them months later, and a
folder of files named bill-final-2.docx cannot do that.
What replaces it
A billing app is the same format with the manual parts removed. The number runs by itself and never repeats. Your details print without being retyped. Every bill is searchable months later. And the whole thing happens on the phone that is already in your hand.
In YathraBook, recording the trip is the bill. Passenger, route, distance, then the fare parts you actually used, and saving it produces a numbered invoice with your name, vehicle and contact on it. The app makes the PDF and hands it to your phone's share sheet, so it goes out on WhatsApp or email before the passenger reaches the lift. Your logo, a layout and an accent colour make it look like your business rather than a generic slip.
It works with no signal, because the bill is made on the phone rather than fetched from anywhere. And if the passenger would rather pay now, the same invoice can show a UPI QR with the fare already in it.
If you would rather stay on paper or a template for now, that is a legitimate choice. Just fix the numbering. Keep one running series, write the next number before you write anything else, and never reuse a file without changing it first.