RentalNowStart free
RentalNow › Guides › Car Rental Invoice Format (Free Excel Template)

Car Rental Invoice Format (Free Excel Template)

A rental invoice should show the rent, extra km, late charges, GST and the deposit balance on one page. Download the template, or copy the format below.

Download Excel templateFree · formulas built in · no sign-up

12 November 2026 · 6 min read

What a rental invoice should show

A rental invoice does two jobs. It tells the customer what they are paying for, and it gives you a record for your accounts and for any later dispute. For a car or bike rental, put these on every invoice:

  • Your details: business name, address, phone and GSTIN if you are registered.
  • Invoice number and date: run the numbers in one unbroken series, for example INV-001, INV-002.
  • Customer details: name, phone and driving licence number. For a business customer, add their name, address and GSTIN.
  • Vehicle and period: make, model, registration number, pickup time, return time and odometer readings.
  • Charges, line by line: rent, extra kilometres, late return, fuel, delivery and any damage charge with its bill.
  • Tax: the service code (SAC), the GST rate, and CGST and SGST (or IGST) as separate amounts.
  • Total and payment: invoice total, security deposit held, balance due or refund, and how it was paid.

A GST-registered business must follow the tax invoice rules. Ask your CA to confirm the exact fields for your case, since details such as place of supply matter for business customers.

Car rental invoice format with a worked example

This is a sample for a 3-day self-drive hatchback rental. The rates and the 18% GST rate are examples, not a recommendation. Change them to your own.

ChargeQtyRate (₹)Amount (₹)
Vehicle rent3 days1,200.003,600.00
Extra kilometres (80 km over the limit)80 km8.00640.00
Late return (2 hours)2 hours150.00300.00
Taxable value4,540.00
CGST at 9%408.60
SGST at 9%408.60
Round off-0.20
Invoice total5,357.00
Less: security deposit held5,000.00
Balance the customer pays357.00

Extra kilometres come from the odometer readings: 12,380 at return minus 12,000 at pickup is 380 km. With 100 km a day included over 3 days (300 km), 80 km are chargeable. Write both odometer readings on the invoice so the customer can see where the figure comes from.

The template does these sums with formulas, so you only enter quantities and rates. Download it from the button at the top of this page.

GST on vehicle rentals

GST on vehicle rentals is not one flat rate for everyone. It depends on whether you rent the vehicle with or without a driver, on the type of vehicle, and on whether you are registered. In August 2025 the Kerala Authority for Advance Ruling held that a self-drive car rental is taxed at the rate that applies to the same type of vehicle sold as goods, not at a flat 18%. An advance ruling binds only the applicant, but it shows that the answer can differ by vehicle.

The template therefore has one editable GST cell. Enter the rate your CA confirms for your service. If your turnover is below the registration limit, you may not need to charge GST at all. For suppliers of services, the usual limit is ₹20 lakh a year (₹10 lakh in some special category states). The limits and rates change, so check the current position before you set up your invoices.

The deposit is not part of the invoice total

A security deposit is money you hold, not money you have earned. Do not add it to the taxable value. Show it as a separate line, so the customer sees the invoice total, the deposit and the balance. If the vehicle comes back damaged, deduct only the repair cost on an actual bill and show it as its own line, as described in our rental vehicle damage policy guide. Our guide to security deposits shows how to set the amount.

If you are not registered for GST

If you are not registered, you should not charge or show GST. Issue a simple bill with the same details but without the tax lines. In the template, set the GST rate cell to 0% and leave the GSTIN blank. This keeps the numbering and the records tidy, and it makes the move to GST easier if you register later.

How to use the Excel template

  1. Download the car rental invoice template and open it in Excel, Google Sheets or LibreOffice.
  2. Fill the yellow cells: your business, the customer, the vehicle, the pickup and return times.
  3. Enter each charge as quantity × rate and leave unused rows blank.
  4. Set the GST rate to the one your CA confirmed.
  5. Enter the deposit held and check the balance line.
  6. Save one file per invoice and keep invoice numbers in running order, or print the sheet and give it to the customer with the vehicle papers.

The example values are samples. Overwrite them before you use the file. Pair the invoice with a signed agreement from our free rental agreement generator, and use the documents checklist to confirm what you collected at pickup.

If you rent out many vehicles, a sheet per invoice becomes slow. RentalNow records the licence number, odometer, deposit and charges for every rental and sends the bill to the customer on WhatsApp when the vehicle comes back. To see how the money adds up across the fleet, read how to track rental fleet yield.

Invoice FAQ

Is this invoice format only for cars?

No. The same format works for bikes and scooties. Change the vehicle description, the rate unit (hour or day) and the extra-kilometre rate.

Should the security deposit be included in the invoice amount?

No. Show it as a separate line below the total, as the template does. It is refundable money, not income, until you deduct dues from it.

Do I charge GST on a car rental?

It depends on your registration status, whether a driver is included and the vehicle. Ask your CA which rate applies to your service, then enter it in the template.

What should I do about late returns?

State the late charge in your rental agreement, record the actual return time, and show the late hours as a separate invoice line.

Can I edit the template?

Yes. The yellow cells are inputs and the rest are formulas. You can add your logo and your own terms below the totals.

This is a general template, not tax or legal advice. Confirm GST rates and invoice rules with your CA.

More for rental business owners

Run your rental shop from one phone

Bookings, fleet, deposits, km-based billing and daily earnings — for bike, scooty and car rental shops. Fourteen days free, no card.

+91
We send a one-time code by SMS. No card · No Play Store · Works on any phone. Already a customer? Open the app