The Dealer Composite Report Checklist That Actually Works

Back in 1980, when most dealerships still tracked inventory on notecards and floor plan balances in leather journals, a general manager could know exactly where the business stood by walking the lot and checking the books once a week. No software. No dashboards. Just a sharp eye and a calculator.

Today, you've got more data than ever. Financial statements that run pages deep. Composite reports that look like something from a spreadsheet factory. And yet dealerships still get blindsided by cash flow problems, floor plan creep, and margin erosion that nobody saw coming.

The composite report isn't broken. But the way most dealerships read it? That's where the failure happens.

Myth: The Composite Report Is Too Complex to Review Properly

This one drives me crazy, because it's not true, and it costs dealerships real money every month.

Here's what I see: A controller or office manager gets a 40-page composite report. They glance at the P&L, check that gross profit hit the budget, maybe note the floor plan balance, and move on. They're not wrong to do that quickly. They're just missing the story underneath the numbers.

The myth says composite reports are too dense to review meaningfully. The reality is simpler: most dealerships never built a repeatable system for reading them. They're checking boxes instead of checking facts.

A working checklist changes that. It gives you a sequence. A logic. A reason to look at each section and what it actually means to your business.

The Composite Report Deep Dive Checklist That Works

Section 1: The Cash Position Reality Check (5 minutes)

Start here. Not with gross profit. Not with days to front-line. Cash.

Open the cash flow section of your composite report. You're looking for three numbers:

Cash on hand (bank balance at statement end)
Cash flow from operations (what the business actually generated last month)
Cash flow from financing (floor plan, notes payable, credit lines)

Ask yourself: Is cash on hand higher or lower than last month? If it's lower, did operations generate cash or did floor plan borrowing prop things up?

This is where dealerships miss red flags. A healthy-looking gross profit number doesn't matter if you're burning cash on inefficient operations or inventory that won't move. A typical $75,000 gross profit month can look fantastic until you realize half of it got tied up in aged inventory or extended floor plan costs.

Checklist item: Confirm cash on hand stayed flat or improved. If it dropped more than 5% month-over-month, flag it and dig into why.

Section 2: Floor Plan Reality — The Hidden Margin Killer

Floor plan interest is one of those line items that creeps up so slowly that most people don't notice it until it's eating 2-3% of gross profit.

Pull the floor plan section. Look for:

Average floor plan balance for the month
Floor plan interest expense (YTD and month-to-date)
Days supply of inventory (used and new, separated)
Turn rate (how many times you've cycled inventory)

Here's the thing: High days supply isn't always bad. But high days supply plus rising floor plan interest means you're holding vehicles longer, paying more to hold them, and not selling them fast enough to offset the cost. That math gets broken real quick.

Say you've got a used vehicle lot averaging 65 days supply at a 9.5% floor plan rate. A $250,000 average balance on used vehicles costs you about $1,984 per month in floor plan interest. Now bump that to 75 days supply (not unusual in a slow market) and you're pushing $2,269. That's $285 extra you're throwing at the bank that could've been in your pocket if you'd moved those cars five days faster.

Checklist item: Compare this month's floor plan interest to last month and the same month last year. If it's trending up while turn rate is flat or declining, you've got a real problem. Document it, then pull your reconditioning workflow to see where the bottleneck is.

Section 3: Gross Profit Deep Dive — Which Department Is Actually Pulling Its Weight?

Don't just look at the total gross profit number. Break it down by department.

Most dealerships have these buckets: new vehicle sales, used vehicle sales, parts and service (fixed ops), F&I, and sometimes admin/other.

Look at:

Gross profit by department (dollar amount and percentage)
Gross profit margin percentage by department
How that compares to last month and same month previous year

This is where you find the truth. Maybe your used car gross profit is down 12% from last month. Parts and service is up 8%. New vehicles are exactly on budget but F&I just tanked.

Each of these tells a different story. Used car margin pressure might mean auction prices are up or your reconditioning costs are drifting. Parts and service strength might be CSI-driven (a good thing) or it might be price-driven (fine short-term, dangerous long-term). F&I weakness could be market conditions, product mix, or a gap in your closing process.

Checklist item: For any department down more than 5% from last month, write down the reason. Don't guess. Actually talk to that department manager and document what changed.

Section 4: The Operating Expense Creep Check

Operating expenses are the termites of dealership profitability. They're small, they work quietly, and by the time you notice them, they've eaten through your structure.

Pull your P&L section and look at operating expenses as a percentage of gross profit. Most healthy dealerships run 65-75% depending on size and market. If you're running 78% or higher, something's off.

Don't just check the total. Actually scan the line items:

Payroll and benefits (including management bonuses)
Facility costs (rent, utilities, insurance)
Marketing and advertising
Office and administrative supplies
Technology and software
Reconditioning and preparation costs

Any category up more than 10% from last month without a clear reason gets flagged.

Payroll creep is the sneaky one. You hire a part-time CSR in month three to handle overflow. Month four, they're full-time. Month five, you've added two more because the first one worked out. By month nine, you're carrying 30% more labor cost than you budgeted. That's not bad management, that's just how it happens unless you're actively watching it.

Checklist item: Year-to-date operating expenses as a percentage of year-to-date gross profit. If that number is higher than your target by more than 2 percentage points, pull a detailed expense report and find the culprit.

Section 5: Receivables and Payables Health

This is the part dealerships skip and regret later.

Look at your accounts receivable aging report and accounts payable aging report.

For receivables, ask: How much money is sitting with customers that you haven't collected? Is the aging bucket (past due 30, 60, 90+ days) growing or shrinking? A healthy dealership has less than 3% of receivables over 30 days past due.

For payables, ask: Are you paying vendors on time? Are you taking early pay discounts where available (usually 1-2% if you pay in 10 days instead of 30)? That might sound small, but a $500,000 annual parts spend with a 1.5% discount you're leaving on the table is $7,500 of free money every year.

If your payables are aging out past 60 days regularly, your vendors are noticing. And they're not going to give you price breaks or priority supply when you need it.

Checklist item: Confirm receivables aging is stable or improving. Confirm payables are being managed within your stated terms (most dealerships do net-30 with vendors). If either is creeping, assign ownership to someone on your team.

The System That Makes This Work

Building a checklist is one thing. Using it consistently is another.

The dealerships that actually get value from their composite reports do this: They schedule a 30-minute composite report review on the same day each month (usually two business days after the statement closes). Same person every time. Same checklist every time.

They don't try to memorize findings month to month. They document it. Create a simple one-page summary: cash status, floor plan trend, gross profit by department, expense outliers, receivables/payables health. That becomes the executive summary they share with ownership and the general manager.

Tools like Dealer1 Solutions can help here, because they give your team a real-time view of financial health instead of waiting for a monthly statement. Daily cash reports, parts-risk alerts that flag aging inventory before it becomes a floor plan problem, and parts ETAs that show exactly where reconditioning bottlenecks are. But the checklist discipline matters more than the software.

And here's the honest take: Most dealerships don't do this. They get the composite report, assume somebody read it, and move on. Then they wonder why cash flow surprised them, floor plan costs spiraled, or gross profit dropped without warning.

One More Thing: Make It Yours

This checklist is a starting point. Your dealership is different. Maybe you have a captive finance operation that matters more. Maybe your parts-and-service department is 40% of gross profit instead of 25%. Maybe you've got a wholesale operation that deserves its own section.

Build from this. Add what matters to your business. Remove what doesn't. But build the discipline of actually reviewing the report with a system, not just eyeballing it.

The composite report isn't too complex. The problem is we've treated it like a compliance document instead of a management tool. Fix that, and you'll see things about your dealership you've been missing all along.

Your accountant will thank you. Your cash position will too.