BuiltByEstradaBook a call

Used Car Dealer Kit

Retail and Auto line

Run the lot from one workbook. Track every unit from purchase to sale with recon, days on lot and gross profit. Check each deal jacket, print a bill of sale with the FTC Buyers Guide statement and Texas sales tax, and keep buy here pay here accounts current with a full amortization schedule, late flags and reminder messages in English or Spanish.

Excel and Google Sheets file + 3 Word forms, English and Spanish

Fare

$39

founding price until January 31, 2027 · then $62

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Used-Car-Dealer-Kit.zipSCREENSHOTS · full version
Used Car Dealer Kit: the Inventory tab, with EXAMPLE data
Inventory: tab with EXAMPLE data See the whole tab
Used Car Dealer Kit: the Deal jacket tab, with EXAMPLE data
Deal jacket: tab with EXAMPLE data See the whole tab
Used Car Dealer Kit: the Ledger tab, with EXAMPLE data
Ledger: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

What you do, what the sheet does

YOUTHE SHEET
You log recon on a stock numberIt adds to that unit's cost and gross
You pick the stock number on the bill of saleYear, make, model, VIN, miles, price and tax fill in
You type the contract termsIt builds the payment schedule to the cent
You log a paymentIt shows which installment it paid, if it came in late, and the reminder to send

What the full version has

  • Inventory tab: 150 units with total cost, days on lot, gross profit and aging flags
  • Recon tab: every repair dollar adds to its unit's cost
  • Deal jacket checklist with the FTC and Texas steps
  • Bill of sale: price, documentary fee, trade in, 6.25% Texas motor vehicle tax, Buyers Guide statement and signatures
  • Buy here pay here accounts: 60 accounts, monthly, every 2 weeks or weekly, with status, past due, late fee and a reminder message
  • Payments log and a ledger with the full amortization schedule for any account
  • Word forms: bill of sale, deal jacket checklist, and FTC Buyers Guide and Texas title notes with official links
  • English and Spanish versions of every file

Who it is for

Independent used car lots, including buy here pay here dealers, mostly in Texas.

The units, VINs, buyers and accounts already in the file say EXAMPLE. They are not real people, vehicles or companies.

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.