Bert's Group Dashboard

Loading dashboard data…

Daily Manager View

Live · refreshes 4:00 AM nightly

Department pacing — all stores

October MTD (as of Oct 14) from the Bert's Daily sheets & deal logs · dept $, units and F&I/unit vs monthly goal. Green on pace, amber behind, red well behind. Click any cell to open that store’s actual source sheet — Service/Parts/Motorclothes open the daily grid; Sales/F&I open the deal log, deal by deal. Rebuilt from the nightly pull.

Monthly Composite

Re-estimates after each payroll · final at month-end

Store comparison — ranked by net

Flags mark expense ratio ±10% off the group line (95.6% of GP). Click a store for its summary.

Store	Net profit	Gross profit	Expenses % GP	Personnel % GP	Status

F&I product penetration — Buccaneer vs goal

Marker shows the goal; bar shows actual. The VSC gap repeats at every store.

October top-line — all four stores

From each store's final P&L / income statement (Lightspeed + Talon), reconciled to the composite. Normalized GP & expense ratios for October land when the month-end group rollup is built.

Group performance — 2026 by month

Expense & Profit

Normalized composite · final at month-end

P&L by store — gross to net

Where the gross goes — group expense mix

Each expense category as a share of group gross profit. Total expense eats 95.6% of gross, leaving a 4.4% operating margin before other income.

Reading profit mid-month — payroll timing

Territory Map

All four stores by same-brand registrations in their assigned territory, from the monthly DMV cross-sell (Sept) — HD counts HD, Indian counts Indian. Open the Deal Map for the dealer-by-dealer breakdown of every lost sale.

Monthly · from the DMV cross-sell report

Territory heat map

Same-brand registrations by owner city · dot size = units, color = our capture. Labels show ours / total. Full geography & dealer detail on the Deal Map.

We hold Contested Leaking Bigger dot = more HD units registered

Leakage by territory

Competitor registrations inside each territory = missed opportunity to chase in the CRM.

Territory	Our units	Comp. in	Capture	Read

DMV cross-sell (MTC AutoTrac) runs monthly and isn't 100% accurate — out-of-state and unfinalized deals slip through. Trend builds as history accrues.