How I Automated My Morning Report as a Dealership Manager

January was the month I almost lost it.

I'm the new car manager at a high-volume Kia store in San Antonio. We push 200+ units a month. And every single morning, I was waking up at 5:45am to build a morning report by hand. VinSolutions for sales data. vAuto for inventory numbers. kDealer for manufacturer stuff. Then I'd open the desk log spreadsheet and start copying yesterday's deals in.

45 minutes. Every morning. Before I even got to the store.

My wife noticed before I did. She said something like "you're on your laptop before you brush your teeth." She wasn't wrong. I was sitting at the kitchen counter in my boxers, squinting at VinSolutions on a 13-inch screen, eating cereal with one hand and typing with the other. Real glamorous stuff.

What the report actually needed

My morning report isn't complicated. It's just annoying. Here's what goes into it:

• MTD new car sales (units and gross, broken down by rep)
• Used car numbers (same breakdown)
• Finance penetration and product averages
• Inventory levels from vAuto (days supply, aging, incoming units)
• Manufacturer scorecard data from kDealer (KFA allocations, CSI, NPS)
• Yesterday's sold log (who sold what, front gross, back gross)
• Pace to objective (are we ahead or behind, and by how much)

None of this data lives in one place. That's the whole problem. VinSolutions has the CRM side. vAuto has inventory. kDealer has manufacturer metrics. The desk log is a Google Sheet I manually update. Four tabs, four logins, forty-five minutes of copying and pasting.

And the worst part? Nobody even reads the full thing. My GM glances at the topline. My reps look at their own numbers. I'm the only person who looks at all of it, and I'm the one building it.

I just wanted it done before I woke up

That was the bar. Not "make it pretty." Not "build a dashboard." Just: can this PDF be sitting on my phone when my alarm goes off at 6:45?

I started messing with AI automation in February. Not the ChatGPT-write-me-an-email kind. The kind where you connect an AI assistant to your actual tools and let it do work for you. Browser automation that logs into your systems, pulls the data, and assembles the report.

Took me about two weeks to get it working the first time. Honestly, the hardest part wasn't the AI. It was figuring out how to get data out of VinSolutions reliably. Their interface isn't exactly designed for automation. You're clicking through like eight screens just to get to the sold log export.

What it does now

Every morning at 6:15am, this thing wakes up and starts working. Nobody has to touch it.

Step 1: It logs into VinSolutions. Pulls the MTD sales data, rep-by-rep. Gets the sold log from yesterday. Grabs any pending deals in finance.

Step 2: Logs into vAuto. Pulls current inventory counts, days supply, aging buckets. Checks incoming units that are in transit.

Step 3: Hits kDealer for manufacturer data. KFA allocations, CSI scores, any flags or alerts from Kia.

Step 4: Opens the desk log Google Sheet. Reads yesterday's entries (which the AI also filled the night before, but that's a different article).

Step 5: Assembles everything into a formatted PDF. Clean layout. Sections for each department. Pace calculations. Comparison to same day last month.

Step 6: Sends it to my phone via Telegram. I get a notification at 6:30am.

By the time my alarm goes off, it's done.

It catches stuff I missed

This is the part I didn't expect. When I was building the report manually, I was rushing through it. Copying numbers, not really analyzing them. I'd miss stuff.

The automated report does math I never bothered with. It calculates daily run rate and compares it to where we need to be. It flags any rep who's been on the board for three days without a deal. It shows me if our days supply on a specific model jumped overnight (usually means a transport came in).

Last Tuesday it caught that our Sportage days supply went from 22 to 41 overnight because a rail shipment hit. That's the kind of thing I would've noticed at the lot by Wednesday. Now I see it Tuesday morning before I leave the house.

It also tracks trends I was too lazy to track manually. Like week-over-week gross averages, or which days of the month we historically sell the most. That data was always there. I just didn't have time to look at it when I was busy copying and pasting.

The math on 45 minutes

I'm a numbers guy, so I did the math because of course I did.

45 minutes a day. I work about 26 days a month (car business, you know). That's 19.5 hours a month on morning reports. 234 hours a year.

Actually, it's worse than that. The 45 minutes assumes everything works. VinSolutions loads fast, kDealer doesn't time out, I don't fat-finger a number and have to go back and fix it. On a bad day it was over an hour. On the 1st of the month when I'm also resetting the desk log tabs, more like 90 minutes.

Call it 195 hours a year to be conservative. That's basically five 40-hour work weeks. A month of my life, every year, copying numbers between browser tabs.

Gone.

What I do with that time now

Honestly? The first week, I just slept later. That alone was worth it.

But after the novelty of sleeping until 6:45 wore off (two days), I started using the mornings differently. I get to the store earlier but calmer. I already know the numbers. I can walk the lot with fresh eyes instead of rushing from my laptop to my car. I actually eat breakfast sitting down now, which my wife appreciates more than the automation itself.

The bigger thing is what happens at the store. When I walk in already knowing that Joel is three deals behind pace, or that we're heavy on Fortes and light on Sportages, I can start the day with a plan instead of spending the first hour figuring out where we stand.

My GM noticed within a week. He said something like "you seem less frantic in the mornings." I told him a robot does my homework now. He laughed but then asked me to build him one too.

What would break

I'm not going to pretend it's bulletproof. VinSolutions changes their UI every few months. When they do, the automation breaks until I update it. Happened twice since February. Both times it took me about 20 minutes to fix. Annoying but not a dealbreaker when you're saving 45 minutes a day.

kDealer is actually the most stable. Their interface barely changes. vAuto is somewhere in the middle.

The other thing is it needs a computer that stays on. I have a Mac Mini at my house that runs 24/7. If your dealership has a back-office computer that nobody turns off, that works too. It doesn't need to be powerful. It just needs to be on.

Could you build this yourself?

Maybe. If you're technical and you've got two weeks to mess with it, yeah. I'm not going to gatekeep.

But most managers I know don't have two weeks. They barely have two hours. You're managing a team, working deals, sitting in meetings, trying to hit a number. The last thing you want to do at 9pm is debug why your VinSolutions scraper broke.

That's why I started offering to build this for other managers. I already figured out all the annoying parts. The login flows, the data extraction, the edge cases where VinSolutions shows you a different page depending on your permissions. I can set up the same system at your store in about a week.

What's next

The morning report was the first thing I automated. Since then I've added CRM task cleanup, email triage, desk log automation, and a bunch of other stuff. The morning report was the gateway drug. Once you see what 45 minutes of free time looks like, you start looking at every repetitive task differently.

I'm writing about all of it on this blog. Not theory. Not "10 ways AI can transform your dealership." Just what I actually built, how it works, and whether it's worth your time.

If you're a manager waking up early to build reports by hand, you don't have to. That era is over. Your phone should be doing that for you.