$Benchline · Dealership P&L + KPI Dashboard
$199 · one-time Get instant access
For GMs, dealer principals & owners · the flagship

One monthly view of gross, expenses and operating profit.

A simplified dealer P&L, fourteen scored ratios and a separate profit headline. Enter mutually exclusive expenses, compare definitions and test independent operating scenarios.

Downloadable .xlsx workbooks with a buyer guide
Manual inputs · one-time purchase · review imported formulas
Illustrative exampleNot a forecast
Department gross$873,960
Operating expenses$613,000
Operating profit$260,960
Fixed absorption37.61%
Replace the sample with your own records. Results depend on your inputs.
See inside

This is the actual tool.

Dealership P&L + KPI Dashboard

Current sample workbook view. Read the buyer guide for definitions, setup and limitations.

Make the assumptions visible

Potential gross is a scenario, not money earned. Set targets you can justify, account for implementation costs, and compare actual results with your saved starting point. Annualized amounts use an unchanged monthly run-rate; no income or timeline is promised.

What's inside

Six tabs. Your month, end to end.

Enter the store once. Read a real P&L, score fifteen KPIs against benchmarks, and see the consolidated money in reach — all from one workbook.

Tab · P&L

A real monthly statement

Dashboard: fourteen scored ratios plus the operating-profit headline; zero-volume ratios are marked unavailable.

Tab · Scorecard

15 KPIs vs. benchmark

P&L: manually entered department gross less mutually exclusive operating expenses. Other income and tax are outside this simplified model.

Tab · What-If

The money, consolidated

What-If and references: independent scenarios, historical sources and clearly labeled editable targets. No automatic links between product files.

The workflow

From a month-end close to a manager-meeting agenda

01

Enter the store

Type your new, used, F&I, service, parts and expense totals into the input cells.

02

Read the P&L

See gross by department and net profit — a clean statement, no accountant required.

03

Score the KPIs

Fifteen metrics flagged against benchmark. See exactly where the store is soft.

04

Work the gaps

Model an explicit target and assumed attainment. This is a planning scenario, not a forecast or guaranteed gain. Overlapping scenarios must not be added.

Where the numbers come from

Sourced where it matters, editable everywhere

NADA2026 Slide Guide: match the exact numerator and denominator. Read source.
JM&AHistorical F&I context, not a current-quarter average. Read source.

Other targets and example numbers are illustrative assumptions. No benchmark updates automatically.

Historical references and editable assumptions are labeled separately. Use comparable local data where available.

Who it's for

Anyone who owns the store's number

GMs Dealer principals & owners Controllers & office managers 20-Group members Multi-store operators Buy-side / dealer groups

Use your own product mix and enter zero for required categories with no activity. Review every unavailable result.

Questions

Straight answers

Is this a subscription?+
No. One-time $199 — yours to keep.
Excel or Google Sheets?+
Delivered as a standard .xlsx workbook. Open in Excel, or import a copy into Google Sheets and verify calculations, dropdowns and formatting. Native application compatibility is not fully certified.
Do I need my DMS connected?+
No. You type in month-end totals from your financial statement — no integration, no IT, no consultant.
How is this different from the department tools?+
This is the store-level roll-up: a full P&L and a 14-KPI scorecard plus profit headline. The F&I, Fixed-Ops and Used-Car tools go deep on each department. They pair well — and come together in the bundle.
Are the benchmarks trustworthy?+
The Benchmarks tab labels every figure as sourced or industry-typical, and all of them are editable — so you steer by numbers you trust.
What if it's not for me?+
30-day money-back guarantee — no questions asked.

Run the whole store from one page. Start with a number you can defend.

XLSX workbook + buyer guide · One-time $199 · 30-day guarantee

Get the Dealership P&L + KPI Dashboard — $199