Almost everything a decision needs is already in your system. It was recorded to complete a transaction, not to answer a question — and that gap is where most of the frustration comes from.
When people get frustrated with the information coming out of their business, one of the first thoughts is often: maybe we need a different system.
Sometimes that is true. There are legitimate reasons to change a dealer management system, and an older DMS really can create limits you can’t work around.
But replacing the software that runs the business is not a purchase. It is a conversion, a retraining of every department, and six months from start to finish at the very best. Three months happens, but it’s rare enough to be remarkable. A year isn’t unusual. Before you commit to that, there’s a much cheaper question worth asking: are we getting everything we can out of the system we already have?
In a lot of businesses the answer is no — and not because the staff can’t use it, and not because the software is poor.
Your system already records more than you’re asking it
Think about what passes through the system in a normal month: sales, purchase orders, inventory receipts, parts sales, work orders, customer records, labor, pricing, inventory adjustments, payments, credits, and accounting entries.
Most businesses have years of that history stored in the same place. It tells a very detailed story about how the operation runs.
The difficulty is that almost all of it was recorded in order to complete a transaction. It wasn’t organized around the next management decision. That’s a real distinction, and it’s where most of the frustration comes from.
What are we trying to decide?
The easiest way to get more out of an existing system is to stop asking “what reports do we have?” and start asking “what are we trying to decide?”
Those sound like the same question. They lead in completely different directions.
A parts manager may not need another inventory report. The real question may be: which items are tying up enough money that we should take a closer look? A service manager may not need another open-work-order report. The real question may be: which jobs have stopped progressing, and what are they waiting on? An owner may not need another margin report. The real question may be: where are we selling enough volume that small pricing problems have become meaningful? A controller may not need another month-end report. The real question may be: which recurring problems could we catch during the month instead of cleaning them up afterward?
Once the question is clear, you can work backward from it.
Working backward from the decision
01
What information would help answer it?
02
Does it already exist in the system?
03
Who needs to look at it?
04
How often?
05
What happens after they see it?
Most of the time, the answer to step 02 is yes.
Recording a transaction and managing a business are different jobs
The system has to be dependable. It has to process the transaction correctly and preserve the record. That’s its first responsibility, and a good one does it well.
Management has a different job: interpreting what those records are telling you.
The system can show you the current retail price, the cost, the units sold, the last sale date, and the quantity on hand. Those are facts. The management question is something else — are there products where the current price no longer makes sense, given cost, sales activity, and how we run this category?
That takes more than putting fields on a screen. It takes context. Sometimes a person supplies it. Sometimes a process does. Sometimes training helps the team recognize it, and sometimes a tool makes the review faster. But the underlying data is usually already there.
Things that look like a software problem
A surprising number of problems that seem to need new technology get better by using existing information differently.
Looks like a software problem
A useful field isn’t being entered the same way twice.
The report exists, but nobody owns the review.
The report runs 500 lines when 25 of them need attention.
Nobody has shown one department how its entries affect another.
A monthly review should really be a weekly one.
You’re measuring activity when you should be looking for exceptions.
None of these are solved by a conversion. All of them are solved by deciding what matters and building a habit around it.
What makes the information trustworthy
There’s a practical limit here. You can only get value from information you can reasonably trust.
If manufacturer codes are entered six different ways, reporting gets harder. If work-order statuses don’t mean the same thing from one employee to the next, you can’t tell where work is actually stalled. If customer records are duplicated constantly, follow-up stops being dependable. If costs or categories aren’t maintained, the analysis on top of them is worth less.
That doesn’t mean the data has to be perfect. Nobody has perfect data. But consistency improves everything downstream of it, and cleaning up a few important habits often creates more value than adding another report.
The other half of trustworthy information isn’t in the database at all. The parts counter knows which oddball item the largest commercial customer always needs. The service writer knows which job is waiting because the customer is out of town. The salesperson knows a particular quote isn’t really lost. The controller knows why a balance looks strange this month.
Good management combines both — what the system knows, and what the people know. You need both, and neither one substitutes for the other.
Ask a better first question
If you’re frustrated with your reports, or you can’t get the answers you need, resist the urge to jump straight to “what software are we missing?”
Look first at what your current system already knows.
You may find that the next improvement isn’t a replacement at all. It may be a better question, a clearer process, some training, or a better way of getting the right information in front of the right person.
Your existing system probably knows a great deal more about your business than you’re asking it to tell you.
How this connects
Area: Foundations — getting value out of what’s already in place.
Applies across: Revenue, Operations, Administration and Executive.
Read next: Freeing Cash Trapped in Dead Stock — the same approach applied to one decision, start to finish.
ProfitEdge Systems helps independent retailers and dealers improve profitability and operating performance through consulting, training, and intelligence tools. See how we help →
Free checklist
The Physical Inventory Planning Checklist
Two pages. Everything to do six weeks, two weeks and one week out, the count-day rules, and a review sheet that shows the gross variance, not just the net. One email address, nothing else.
Free follow-up kit
The Follow-Up Kit
Four printable pieces: a short huddle playbook for managers, the huddle form, a one-page field job aid, and a guide to turning the reports you already have into working lists. One email address, nothing else.
Free self-check
The Exit-Readiness Self-Check
Two pages. What still runs through you, the four questions a buyer or successor will ask, and a place to name your first three gaps. One email address, nothing else.
Free worksheet
The Shrink Investigation Worksheet
Two pages. A five-step check for every significant variance, an item log, where shortages hide in an equipment and hardware store, and how to spot a pattern before anyone is accused. One email address, nothing else.
Free self-check
The Small-Office Controls Self-Check
Two pages. Who does what on a payment, the five control activities, first fixes for a two-person office, and a login review. One email address, nothing else.
Free counter log
The Missed-Sale Log
Two pages. A counter log for every request you couldn’t fill, a weekly review that gives each signal an owner, and a place to track patterns across the month. One email address, nothing else.
Free account review
The Commercial Account Review
Two pages. A snapshot of your five most important commercial, fleet, municipal or farm accounts: what they run, the terms on file, and what each account really earns. One email address, nothing else.
Free planning sheet
The Before-the-PO Planning Sheet
Two pages. Why you’re buying it, four questions to answer before the cash goes out, the program on one page, and how to run a controlled test when the evidence is thin. One email address, nothing else.
Free template
The Customer Deposit Policy Template
Two pages. Write your deposit terms once, set how deposits are handled at the counter, and reconcile open deposits every month. One email address, nothing else.
Free worksheet
The Revenue Leak Worksheet
Two pages. Check warranty, co-op and programs, labor, vendor terms and floorplan, put a yearly dollar figure on each leak, and rank them against shrink with an owner for every fix. One email address, nothing else.
Free morning review
The Work Order Stage Review
Two pages. A morning sheet for every open job, with its stage, what it’s waiting on, the next step and who owns it, plus a stage-by-stage count of where work stalls. One email address, nothing else.
Free monthly review
Monthly Margin Questions
Two pages. The four questions an owner should be able to answer every month, set out as a sheet to fill in when the statement arrives, with a checklist of where margin drifts. One email address, nothing else.
Free planning sheet
The Decision-First Report Request
Two pages. Before asking for a new report or a new system, write down the decision, who makes it, how often, what counts as an exception and whether the data can be trusted. One email address, nothing else.
Free notebook
The Takeover Notebook
Two pages. The questions to ask the previous owner while you still can, the five things to check first, and a sheet for deciding what to change now and what to leave alone. One email address, nothing else.
Free worksheet
The New Line Readiness Worksheet
Two pages. Owner, setup and measures for machines, parts, service and warranty, a check that each one can be measured on its own, and the questions to settle before the first season. One email address, nothing else.
Free template
The Job Aid Template and Training Plan
Two pages, plus an editable Word version. A one-page job aid for writing up your own routines, and a training plan by role with a date to check whether it stuck. One email address, nothing else.
Free kit
The Conversion Readiness Kit
Three pages. The six phases with what has to be true before each one, a data cleanup list, a decision log and real-week test scenarios. One email address, nothing else.
Free worksheet
The Effective Labor Rate Worksheet
Two pages. Paid hours, billed hours and labor dollars by technician, the three ratios worked out, a checklist of where the hours go, and a line to track it every month. One email address, nothing else.
Free tracker
The Warranty Claim Tracker
Two pages. A claim log from the bay to the payment, what every claim needs at the work order, a four-question monthly review and a place for each manufacturer’s rules. One email address, nothing else.
Free planning calendar
The Preseason Planning Calendar
Two pages. Six questions about last season, the buying, staffing, service and cash plans month by month, and each step with an owner and a date. One email address, nothing else.
Free checklist
The New Item Setup Checklist
Two pages. Eight steps for every new item, a place to write down your own house rules, and a monthly review that catches manual prices, missing reorder settings and empty bins. One email address, nothing else.
Free working sheet
The Month-End Exception Review
Two pages. The five questions worth settling before you build anything, and a daily / weekly / before-the-close sheet with the owner column left blank for your own names. One email address, nothing else.
Set the Item Up Right the First Time
A new item gets set up once, in a hurry, and is rarely looked at again. Every price, reorder and report built on it inherits whatever went in that first time.
Plan the Season Before It Arrives
A seasonal business makes most of its money in a few busy months, and most of the decisions that shape them are made in the slow ones. Preseason planning is where the season is won.
Warranty Claims Are Money You’re Owed
Warranty work is done, the customer leaves happy, and the claim gets filed late, short or never. Treat warranty claims as receivables and the money stops slipping away.
Effective Labor Rate: What It Is and How It Compares to Your Posted Rate
The rate on the wall is what you charge for an hour that gets billed. What the shop actually earns per hour is a different number, and the gap between them is where service profit goes.
Bring the problem you keep re-solving
Most of what ends up in these articles started as a question from a shop owner or a dealer principal. If something here sounds like your month, say so and we will look at it together.
