Free Car Rental Invoice Template (Excel)
What's in the free car rental invoice template
Enter rental days and the daily rate, and the rental subtotal calculates itself. Enter miles driven, miles included in the rate, and the price per extra mile, and the mileage overage charge calculates automatically - it's zero if the renter stayed under the cap.
Fuel gallons and price per gallon produce the fuel charge, and a tax rate cell produces TOTAL DUE from the combined subtotal. A separate deposit section reconciles what was held at pickup against what was returned to the renter.
Every calculation is wrapped so a blank or zeroed-out field never throws an error - the invoice always shows a clean number, even before you've filled in every line.
Automatic charges, not a static fill-in-the-blank invoice
Six dedicated invoice-template vendors compete on this exact search term - InvoiceQuick, Smartsheet, QuickBooks, InvoiceMaker, InvoiceSimple - but every single one, including the strongest (InvoiceQuick), ships a static layout with fields for mileage and fuel but no formula that actually computes the charge.
This template automates the three calculations every one of those competitors lists as a billing scenario but doesn't automate: mileage overage, fuel refill cost, and deposit reconciliation.
How mileage overage and deposit reconciliation work
Mileage overage only charges for miles above your included cap - it uses MAX(miles driven minus miles included, 0), so a renter who stayed under the limit is charged nothing, never a negative number.
Deposit retained (held minus returned) is calculated as a separate, informational line - it doesn't reduce TOTAL DUE, because a security deposit is normally a hold on the card, not part of the rental charge itself.
Who this template is for
Independent car rental operators, small fleet owners, and peer-to-peer car-sharing hosts who need to bill mileage overage and fuel charges without a full rental-management SaaS subscription.
It's a billing tool for a single rental at a time - for managing an entire fleet's availability and bookings, you'll want dedicated fleet software.
How to use it
- Enter rental days and daily rate for the rental subtotal.
- Enter miles driven, miles included, and price per extra mile for the mileage overage charge.
- Enter fuel gallons, price per gallon, and tax rate for TOTAL DUE.
- Enter deposit held and deposit returned - deposit retained calculates automatically.
Download the free Free Car Rental Invoice Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Does the mileage overage charge ever go negative?
No. It uses a MAX formula that floors the overage at zero, so a renter who stayed under the included-miles cap is charged nothing for mileage.
Does the deposit reconciliation reduce the total due?
No. Deposit retained (held minus returned) is shown as a separate, informational line - the security deposit is typically a hold on the renter's card, not part of the invoiced rental charge.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the calculations keep working.
Does it handle weekly rates automatically for longer rentals?
No. This version calculates on a single daily rate x days basis - for a rental with a separate weekly rate, use the daily rate that applies to your rental length.
Can I add a one-way drop fee or damage waiver line?
Not built in as a separate line by default, but you can add a row and fold it into the subtotal following the same pattern as the other charges.
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.