
Multi-rooftop reporting means seeing every lot you own in one set of numbers, and still being able to drill into any single lot, and any single car. For an independent group of two to five lots, the reports only work if the data underneath is clean: every vehicle carries its own cost, every expense lands on the right lot, and gross is calculated the same way everywhere. Get that base right and the group view takes minutes. Skip it and you are comparing guesses.
If you are running a second or third lot and your reporting is still a pile of spreadsheets, this guide shows what to track, how to compare lots fairly, how often to review, and where Loturn fits.
TL;DR
- A “rooftop” is one dealership location. Multi-rooftop reporting rolls all of them into a group view and lets you drill down to a single lot or a single VIN.
- The group report is only as good as the per-vehicle data beneath it. Capture purchase price, transport, recon and floorplan interest on each unit.
- Compare lots on rates and per-unit figures (gross per unit, days in inventory, recon cost per unit), not raw totals.
- Review sales and inventory weekly, financials monthly, and give each person only the lot they run.
- Loturn tracks profit per car and includes reporting and analytics in every plan, with the Multi-Lot plan at $699 per month.
Table of Contents
- What multi-rooftop reporting actually is
- Why spreadsheets break at the second lot
- The base layer: profit per vehicle
- Metrics to track across rooftops
- Comparing lots fairly
- Timing: why last month’s numbers move
- How often to review, and who sees what
- From reporting to forecasting
- Where Loturn fits
- Our view on multi-rooftop reporting
- FAQ
- Sources
What multi-rooftop reporting actually is
The term comes from large auto groups, where a “rooftop” is a single franchise or store. The idea scales down. If you own two used lots, or a car lot plus an RV or boat location, you have rooftops, and you face the same question: which location is making money, and why?
A good multi-rooftop report does three things:
- Consolidates. One view of revenue, gross, expenses and inventory across the group.
- Separates. The same figures split by lot, so a strong lot cannot hide a weak one.
- Drills down. From a lot to a month to a deal to a VIN, so you can find out what caused a number rather than just see it.
The tools built for big groups usually let you choose which stores to include, then compare them over time or sort them in a table. That selection logic is worth copying even on a small scale: you should always know which lots a number includes. One published guide to a multi-store comparison report notes that the charts are relative to the stores you select, so an average moves when you add or remove a store. Read every group average with that in mind.
Why spreadsheets break at the second lot
One lot can run on memory and a spreadsheet. Two lots cannot, for predictable reasons:
- Costs get scattered. A transport invoice is paid from one account, a recon bill from another, and nobody knows which lot’s car it belonged to.
- Each lot calculates gross its own way. One manager includes transport in cost, another books it as overhead. The group number then means nothing.
- Shared expenses have no rule. Who carries the office manager, the insurance policy or the floorplan line?
- Reports arrive late. If a lot’s numbers show up two weeks after month end, you are managing history.
The fix is not a fancier dashboard. It is one consistent way to record a car’s cost and a deal’s gross, applied the same at every lot. Our guide to unit cost rollup walks through the per-VIN method.
The base layer: profit per vehicle
Every group number is a sum of vehicle-level facts. If those facts are wrong, the sum is wrong. For each unit, record at minimum:
- Purchase price and auction or buyer fees
- Transport in
- Recon, parts and outside repair, assigned to the VIN as it happens
- Floorplan interest accrued, if the unit is financed
- Sale price, plus front-end and back-end gross from the deal
When those land on the car as they occur, you see the true profit before the sale, not three weeks after. That matters more with several lots, because a recon overrun at one location is invisible in a group total but obvious on a single VIN. Per-VIN recon tracking, covered in our piece on recon WIP accounting, lets you catch a unit that is running over budget while it is still in the shop.
Back-end products need the same discipline. If finance and insurance income is booked loosely, lot-to-lot comparisons reward whoever books it most generously. See back-end gross accounting for how to keep it consistent.
Metrics to track across rooftops
Big groups track dozens of measures across sales, service, marketing and customer retention. An independent used-car group needs a short list. Start with these.
Profit and sales
- Gross profit per unit, front-end and back-end, by lot. This is the single most useful comparison number.
- Net profit by lot, after allocated expenses.
- Units sold per month, as a rate against the units on hand.
- Wholesale results, kept apart from retail so they do not blur the picture. See wholesale deal accounting.
Inventory
- Days in inventory per unit and average per lot.
- Aged units, for example everything past 60 or 90 days, whatever threshold fits your market.
- Total inventory cost by lot, versus what the lot sells in a month.
- Recon cost per unit and recon days.
Floorplan and cash
- Floorplan interest per unit and per lot, so you can see which cars cost you the most to hold. Our floorplan utilization analysis shows how to read it per VIN.
- Cash position and a rolling forecast, because a profitable lot can still starve the group of cash. The 13-week cash flow forecast is a practical format.
Leads and follow-up
- Leads by source and lot, and the share that reach a sale.
- Follow-up activity, so a lot with a slow response time shows up. Defined pipeline stages make this comparable; see sales pipeline stages.
A table makes the rule clear: pick figures that divide cleanly by volume.
| Measure | Good for comparing lots? | Why |
|---|---|---|
| Total gross | No | Rewards the bigger lot |
| Gross per unit | Yes | Adjusts for volume |
| Total inventory cost | No | Depends on lot size |
| Days in inventory | Yes | A rate, comparable anywhere |
| Recon cost per unit | Yes | Shows process differences |
| Floorplan interest per unit | Yes | Shows holding cost |
A longer dashboard setup is covered in our profitability dashboard guide.
Comparing lots fairly
Lots are rarely identical. One sells $8,000 commuter cars, another $35,000 trucks, a third RVs. Comparing them on raw totals starts arguments that the numbers cannot settle. A few rules help.
Use rates and per-unit figures. Gross per unit, days in inventory and recon cost per unit adjust for size.
Compare like with like. Split by vehicle type or price band when mix differs. A truck lot and a budget lot should each be measured against their own history first, then against each other.
Watch trends, not one month. A single month with three big wholesale losses can sink a lot’s average. Look at three to six months and the direction of the line.
Keep one definition. Write down what counts in cost, what counts in gross and how shared expenses are split. Apply it to every lot, and do not change it mid-year without restating prior periods.
Allocate shared costs by a stated rule. Common choices are units sold, revenue or headcount. The rule matters less than applying it consistently.
Know what the comparison includes. Averages depend on which lots are in the set, as noted above. If you drop the weakest lot from a chart, every other lot looks worse against the new average.
Timing: why last month’s numbers move
Be careful with fresh numbers. A guide to one multi-store report points out that prior-month figures can change as systems sync, records close and attribution windows are met. In a used-car group the same thing happens for ordinary reasons: a title is still pending, a vendor invoice arrives late, a floorplan payoff has not posted, or a deal is unwound.
Two habits keep this under control:
- Post deals promptly and completely. A deal posting checklist stops gross surprises, and ours is here: deal posting checklist.
- Close each month the same way at every lot. That means reconciling the bank and the floorplan before you read the report. See bank reconciliation and month-end floorplan reconciliation.
At year end, the same consistency saves real time. Our year-end close guide covers the checklist.
How often to review, and who sees what
There is no single correct rhythm, but this one works for small groups.
| Cadence | What to review | Who |
|---|---|---|
| Weekly | Units sold, leads, aged units, recon in progress, cash | Owner and each lot manager |
| Monthly | Gross per unit, net by lot, floorplan interest, expense variances | Owner, controller or bookkeeper |
| Quarterly | Lot-to-lot trends, mix, pricing and buying strategy, forecast | Owner |
| Year end | Final close, inventory costing, retention of records | Owner and accountant |
Access matters as much as cadence. A lot manager needs their own inventory, deals and leads. The owner needs the group view and the books. A salesperson does not need the P&L. Setting this up deliberately is covered in dealership user permissions.
From reporting to forecasting
Once each lot has months of clean per-unit data, forecasting gets simple. You know how many units each lot sells in a month, what each earns, how long cars sit and what they cost to hold. That gives you a realistic buy plan: how many units to acquire for each lot, at what cost, to hit a target. Our sales forecasting guide shows the method for independent lots.
The forecast also exposes the cash cost of growth. A new lot adds inventory, floorplan interest and payroll before it adds profit, and a 13-week cash view shows when that gap is widest.
Where Loturn fits

Loturn is a financial management platform built for independent used-vehicle dealers. It tracks every cost on each vehicle, from purchase price to transport and recon, so you see profit per car before it sells. Accounting is native double-entry with an automotive chart of accounts, and reporting and analytics, floorplan interest tracking, inventory management and a CRM are part of the same platform. Inventory can include cars, RVs, boats, bikes and trailers, which suits a group that spans vehicle types.
Pricing is flat and monthly, with every tool included and no add-on modules or per-transaction fees: Flipper is $99 per month, Dealer is $349 per month and Multi-Lot is $699 per month. Setup includes free data import and onboarding support. See Loturn pricing for what each plan covers.

For a group of lots, the Multi-Lot plan is the one built for that size of operation. If your reports today depend on someone merging spreadsheets, start from the per-car data and let Loturn carry it forward.
Our view on multi-rooftop reporting
Most dealers who struggle with multi-lot reporting think they have a dashboard problem. They almost never do. They have a cost-capture problem.
When transport, recon and floorplan interest are attached to the car as they happen, the lot report and the group report are just different slices of the same data. When they are not, no dashboard can fix it, because the number was wrong before anyone looked at it.
That is why we built Loturn around profit per vehicle first. Real accounting, an automotive chart of accounts, reporting and inventory live in one place for one flat monthly price, so a second or third lot does not mean a second or third system or a stack of add-on fees. Our goal is that you know what a car really earned before you sell the next one, at any lot you own.
Eric Dosset
FAQ
What is a rooftop in a dealership?
A rooftop is one dealership location or store. A group with three lots has three rooftops. The word is simply the industry’s way of counting selling locations, whatever the brand or vehicle type.
What should a small dealer group report on first?
Start with gross profit per unit and days in inventory by lot, then add recon cost per unit and floorplan interest per unit. These adjust for lot size, so they are fair to compare. Add leads and cash forecasting once those are reliable.
How often should I review reports for each lot?
Review sales, aged inventory, recon and cash weekly, and review gross, net profit and expenses monthly after the books are reconciled. Look at lot-to-lot trends quarterly. Lot managers should see their own lot, and the owner should see the group.
Why do last month’s numbers change after I run the report?
Late invoices, pending titles, floorplan payoffs and unwound deals can all post after a month closes. Reports that pull from systems still syncing can shift too. Posting deals promptly and reconciling the bank and floorplan before you read the report keeps the changes small.
Do I need a different system for each lot?
No. A single system with consistent definitions makes lots comparable. Separate systems mean separate definitions of cost and gross, which is what makes group reporting unreliable in the first place.