Companion to "How to Get Car Rental Referrals From Local Repair Shops." Print what you need. Each sheet stands on its own.
Spreadsheet versions: referral-tracker.csv (blank), referral-tracker-example.csv (hypothetical rows only, marked EX- and "Hypothetical"), shop-contact-log.csv (blank). The tracker CSV has the same 15 columns as sheet 7, with "dates needed" split into from and to. They hold no formulas; add your own totals.
Follow your local email marketing rules. This isn't legal or insurance advice.
Fill in the blanks, print on your letterhead, and leave one with the shop's front desk.
When your customer needs a car while theirs is in your shop, give them our card or booking link:
Booking link:
Call or text:
We check availability, confirm the renter qualifies, quote the price, take the deposit, check coverage, sign the rental agreement, and handle extensions and the return.
Hand out our card. Or, with your customer's OK, send us only their first name, phone number and the date they need a car.
Collect driver's licenses, insurance papers, claim numbers or payment details. Promise that a car is free. Promise that insurance will pay.
We also won't share your customer's rental details unless the customer says it's OK.
Vehicles:
Pickup address or delivery area:
Hours:
Questions: Phone:
Email:
No referral fee is offered on this sheet. If you later want to offer a fee or perk, first ask whether the shop has agreements with insurers that limit it.
Use in person at a quiet time, or on the shop's published business phone number. One visit or call, then at most one follow-up.
Do not send this as a cold email. Send it once, to the address the shop gave you, and only after they asked for it. Write in your shop log who asked and when.
Subject: The one-page sheet you asked for, from
Hi ,
You asked me to email our one-page sheet when we talked on . Here it is. If a customer needs a car while theirs is in your shop, they can book at or call . We handle availability, the quote, the deposit and the paperwork directly with the customer.
This is a promotional message from (business name).
(your name)
(business name)
Postal address:
Phone:
To stop hearing from us, reply "stop" or call the number above. We will not contact you again.
Why the template has these parts:
One row per shop. Never contact a shop marked "do not contact."
| Shop name | Type | Published phone or email | Where published | First contact (date, method) | Contact role | Preferred method | Email requested? (who, date) | Offer left? | Follow-up date / done? | Response | Do not contact? |
|---|---|---|---|---|---|---|---|---|---|---|---|
Print one per referral. Referral ID: Shop:
Share the shop column with partners. Keep the rest for your team.
| Task | Shop | You (operator) | Renter | Insurer or adjuster |
|---|---|---|---|---|
| Share your contact details | Yes | |||
| Confirm availability | Yes | |||
| Qualify the renter | Yes | Provides documents to you | ||
| Quote the rate | Yes | |||
| Take the deposit | Yes | Pays | ||
| Pay for the rental | Collects | Pays you | Pays you only under a written direct-billing agreement | |
| Check coverage | Yes | Provides proof | Tells the renter what the claim covers | |
| Sign the agreement | Yes | Yes | ||
| Approve an extension | Yes | Asks you | May approve more claim days | |
| Run the return | Yes | Returns the car |
Use for insurance renters. Part A is the default. Fill in Part B only if the insurer or adjuster signed a separate written direct-billing agreement with you. Never fill it in from a phone promise or the shop's estimate.
Referral ID: Renter:
Our daily rate: $ Days booked:
If no direct-billing agreement: the renter pays the full rate. An approval of a daily amount and days is what the insurer told the renter it will cover. It is not an agreement to pay us.
Direct-billing agreement on file? (Y/N): Where it is filed:
Insurer: Claim number:
Adjuster or billing contact (name, phone or email):
Bill to (address or portal):
Payment terms (when the insurer pays):
Daily amount the insurer agreed to pay us: $ Days agreed:
Daily difference the renter agreed in writing to pay: $
| Date | Extra days requested | Car still free? | Updated quote sent? | Direct billing only: extra days confirmed in writing? |
|---|---|---|---|---|
Rental charges before tax = our daily rate × days = $
Renter pays (default): renter is billed the full rental charges above.
Direct billing only: insurer bill = agreed daily amount × agreed days = $
Direct billing only: renter bill = rental charges − insurer bill = $
Coverage, daily limits and approved days depend on the renter's policy, fault and location. An insurer may pay late, pay less or deny part of a bill. Your written rental agreement should say what the renter owes then. Deposits are not earnings.
Log every referral the day it arrives. Record rental charges before tax. Do not count deposits.
Outcome options: Completed, Canceled, No availability, Not qualified, No reply, Open (still in progress). Payment path: Renter pays (default) or Direct billing (separate written agreement on file). Same columns as referral-tracker.csv, which splits "dates needed" into from and to.
| ID | Date received | Shop | How it arrived | Self-pay or insurance | Dates needed (from / to) | Car free? | Quoted in writing? | Outcome | Days | Daily rate | Charges before tax | Payment path | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Shop | Referrals | Bookings made | Completed | Canceled | No availability | Not qualified | No reply / open | Charges before tax (completed) |
|---|---|---|---|---|---|---|---|---|
Made up to show how the tracker works. Not results from a real business.
| Ref | Shop | Type | Outcome | Days | Rate | Charges before tax | Payment path |
|---|---|---|---|---|---|---|---|
| 1 | Shop A | Self-pay | Completed | 5 | $60 | $300 | Renter pays |
| 2 | Shop A | Insurance | Completed, extended 3 days | 10 | $60 | $600 | Renter pays |
| 3 | Shop A | Self-pay | Booked, then canceled when the repair finished early | 0 | $60 | $0 | Renter pays |
| 4 | Shop B | Self-pay | No car available | 0 | $0 | ||
| 5 | Shop B | Insurance | Did not meet age rule | 0 | $0 |
| Period | Days | Rate | Renter pays us |
|---|---|---|---|
| First booking | 7 | $60 | $420 |
| Extension after parts delay (car still free, updated quote sent) | 3 | $60 | $180 |
| Total | 10 | $600 |
The renter said their insurer would pay them back up to $45 a day. That part was between the renter and the insurer.
| Days | Insurer bill ($45/day, under the written direct-billing agreement) | Renter bill ($15/day, by written agreement) | Total ($60/day) |
|---|---|---|---|
| 10 | $450 | $150 | $600 |
If the insurer paid less, the rental agreement would say what the renter owes.
| Shop | Referrals | Bookings made | Completed | Canceled | No availability | Not qualified | No reply / open | Charges before tax (completed) |
|---|---|---|---|---|---|---|---|---|
| Shop A | 3 | 3 | 2 | 1 | 0 | 0 | 0 | $900 |
| Shop B | 2 | 0 | 0 | 0 | 1 | 1 | 0 | $0 |
| Total | 5 | 3 | 2 | 1 | 1 | 1 | 0 | $900 |
Five referrals are far too few to judge either shop or draw conclusions. Shop B's two referrals may point to a fleet gap and a rules mismatch, not a bad partner. Keep tracking for several months.