Free Limousine Invoice Template (Excel)
What's in the limousine invoice template
The workbook has two tabs. Trip Invoice is a single-trip document: client and trip details, hours and hourly rate, mileage and rate per mile, and an airport fee, all rolling up to a subtotal - then a gratuity % calculates the tip and the final total.
Trip Log holds up to 40 rows using the same math, so you can keep a running record of every trip - date, client, pickup, drop-off, driver and charges - without re-entering formulas per trip.
Time charge and mileage charge are calculated separately, then combined with your flat airport fee into the subtotal before gratuity is applied - so you can see exactly what each component contributed.
Real trip math competitors don't calculate
invoicequick.com and invoicemaker.com offer real downloadable PDF/Word/XLS templates, but with generic line items you'd have to build the base fare, mileage, wait time and gratuity math into yourself. InvoiceSimple and Billbooks position their limo invoice as a lead-in to their own invoicing SaaS subscription.
This template calculates base fare (time), mileage and gratuity automatically from the numbers you enter - no formulas to build, and no software subscription required to use it.
A trip log, not just a single invoice
None of the top competitors offer a companion log for tracking multiple trips over time - each is a one-off invoice document. The Trip Log tab here uses the identical calculation as the invoice, so a driver or small limo company can keep every trip's date, route and charges in one running file.
Use Trip Invoice to bill a specific client for a specific trip, and Trip Log to keep the ongoing record.
Who this template is for
Independent chauffeurs and small limousine or car service companies who need to bill by the hour and by the mile, with airport fees and gratuity handled automatically instead of by hand.
It's built for straightforward hourly/mileage billing - not for complex zone-based or flat-rate airport pricing structures that a larger dispatch system would handle.
How to use it
- Enter trip details, hours and rate, mileage and rate per mile, and airport fee on Trip Invoice.
- Enter a gratuity % - subtotal, gratuity and total calculate automatically.
- Log every trip on Trip Log, up to 40 rows, for a running record beyond a single invoice.
Download the free Free Limousine Invoice Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
Once trips are invoiced, the paid Bookkeeping template ($19) maps every expense to IRS Schedule C lines and sets aside quarterly estimated tax from your real profit.
See the full versionFrequently asked questions
Does it calculate mileage and gratuity automatically?
Yes. Mileage times your rate per mile, plus time charge and airport fee, becomes the subtotal - gratuity % then applies to that subtotal to reach the final total.
Is there a way to track more than one trip?
Yes. The Trip Log tab holds up to 40 trips using the same charge calculation as the single-trip invoice, so you can keep a running record.
Does gratuity apply before or after the airport fee?
Gratuity % applies to the full subtotal - time charge, mileage charge and airport fee combined - not to any one component alone.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, open it, and choose File > Save as Google Sheets - the formulas keep working.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.