Cody's Sales
Build 2026-09-01-i
Leads and “find me a vehicle” requests live here. Inventory and past deals load from your Google Sheet / CSV. Commissions still post on Bonus & Payroll.
Fill this at the desk, or send the customer this link to do it on their phone. When they submit, it emails Adam, Cody, and Jameson.
2026 at a glance. Click a month. Loading Past sales copies each row into the matching month here.
Cody's Sales KPIs from the 24–26 Sales Sheet. Click a year. Spent = purchase + RO cost. Profit % = profit ÷ sold. 2026 Jul–Aug from month tabs (blank on the year board).
Goal is 30 days from date received — through recon, list, and sold. Green = on goal. Amber = past 30. Orange = 60+. Red = 90–120+.
Add a unit when you buy it today — no need to reload the whole Sheet. CSV load still replaces the list if you want a full refresh.
Won the bid? Upload the Manheim / ADESA receipt or PDF. We pull VIN, vehicle, and hammer price onto the lot as Process.
Or dump the Sheet:
Williamson / Franklin. State 7% + local 2.75% on the first $1,600 + single-article 2.75% on $1,600–$3,200. Type the Sheet TAX column in “Collected” to compare.
| Car purchase price | |
| Trade-in amount | |
| Warranty / service contract | |
| Collected on the deal (Sheet TAX column) |
| State tax 7.00% | — |
| Local tax 2.75% (first $1,600) | — |
| Warranty / service contract tax | — |
| Other tax 2.75% (single article) | — |
| Formula total — should collect | — |
| Collected — Sheet TAX | — |
- SA-S00 — Vehicle sales SOP (title, DCS, jacket, EZ tags)
- SA-S01 — Vehicle request & lead follow-up
- Bonus & Payroll — Auto Sales Commission (Jameson / Judah)
- Staff & Pay — sales roster
- Shop Library
Rule: no unit leaves the lot without the deal on this board and commission noted for the pay period.