Every dealership manager I know starts the day the same way. Log into the CRM. Screenshot the dashboard. Open vAuto. Export inventory. Pull NPS. Check the desk log. Copy numbers into a spreadsheet. Try to turn all of that into something useful before the floor opens.

That's 30 to 45 minutes. Five different systems. Multiple logins. And by the time you've got your numbers, the first customer is already on the lot and you haven't talked to a single rep about yesterday's misses.

I did this for years. Then I stopped. Built a one-page morning report that pulls from every system automatically and lands in my inbox before I walk in the door. Twenty-one metrics. Five minutes to read. Zero minutes to build.

Here's the framework.

The Problem with Manual Reports

The data you need already exists. It's in VinSolutions. It's in vAuto. It's in the desk log. It's in the OEM portal. The problem isn't access. The problem is assembly.

Most managers are the human API between five different systems. You're logging in, reading screens, copying numbers, and pasting them somewhere else. That's not management. That's data entry.

And because it takes so long, you cut corners. Skip the NPS check. Don't cross-reference the visit log. Forget to pull aged inventory. Walk into the morning meeting with half the picture and hope nobody asks about the other half.

The cost isn't just your time. It's the deals you miss because you didn't catch them. The rep who skipped three T/Os yesterday that nobody flagged. The pending finance deal that's been sitting for four days. The be-back customer who should've gotten a call this morning but didn't because she was buried in a CSV nobody sorted.

The 21 Metrics

I spent months figuring out which numbers actually drive decisions. Started with 40+. Cut it down to 21. The rule is simple: if a metric doesn't change what I do today, it's off the report.

Here's what made the cut, organized by category.

Column 1: MTD Performance

This column answers one question: are we on track?

Column 2: Daily Activity

This column tells you what happened yesterday and whether the process is working. Low T/O count with high traffic? You've got a process problem. High demos but low write-ups? Reps aren't landing customers on numbers.

Column 3: Inventory and Flags

This column catches problems before they cost money. Every aged unit is a carrying cost. Every open customer issue is a potential NPS hit.

The Format

Single page. Landscape orientation. Three columns. Everything fits without scrolling, clicking, or flipping pages.

I print mine. One sheet of paper. I can hold it in my hand during the morning meeting, glance at any number in two seconds, and circle things I want to talk about.

Could it be a dashboard on a screen? Sure. But paper forces brevity. If it doesn't fit on one page, you're tracking too much.

Color coding is minimal. Green means ahead of pace. Red means behind or flagged. Everything else is neutral. If the whole page is red, you've got a bad month. If it's mostly green, keep doing what you're doing.

Where the Data Comes From

Here's the collection breakdown for each source:

Five sources. That's why doing it manually takes 30+ minutes. Each system has its own login, its own export process, its own format.

The automation handles all of this. Browser scripts log into each system, pull the data, and pass it to the AI for formatting. The AI reads everything, calculates the derived metrics (pace, per-unit averages, track vs. objective), and renders the PDF.

The Five Metrics That Matter Most

If 21 feels like a lot, start with five. These are the ones that move the needle on any given day.

Close rate. Yesterday's sold divided by yesterday's total ups. When this drops, something changed on the floor. Find out what.

Gross per unit. Front plus back, new and used separated. This tells you if you're holding gross or giving it away to move metal.

Aged inventory count. Units over 60 days. Every one of these is bleeding money. This number should go down week over week.

T/O percentage. T/Os divided by total ups. If reps aren't turning customers to a manager before they walk out, you're leaving deals on the table. A properly executed T/O recovers 20 to 30 percent of walks.

NPS vs. district. Your score compared to your peers. OEM money is tied to this at most manufacturers. Don't let it slip below district average.

Start with these five. Build the report around them. Add more as the system matures and you figure out which other numbers change your behavior.

What This Actually Changes

The report itself isn't magic. It's what it replaces that matters.

Before: 30 to 45 minutes of manual data collection, an incomplete picture, and a morning meeting where half the opportunities get missed because you didn't have time to prep.

After: five minutes reading a report that's already done, walking into the meeting knowing exactly which reps need coaching, which customers need callbacks, and which deals need saving.

The morning report is the foundation. Everything else I've automated builds on it. The Save-a-Deal meeting. The CRM task cleanup. The performance reviews. They all start with the same question: what does the data say? And the morning report is how the data gets to me without me spending half my shift pulling it together.