Find the money hiding in your repair orders.
This is the report your shop gets every month. Flip through the sample: what's growing, what's slipping, who stopped coming in, and exactly who your team should call this week.
01The month at a glance
SAMPLE REPORT
Monthly Sales Report
Sample Truck & Trailer Repair | September 2026
The month at a glance
What the numbers say
- 1Best month in six. Revenue grew 6.8% to $186,420, led by engine and drivetrain work (up 12%) and roadside calls (up 73%).
- 2PM is slipping. Preventive maintenance fell 12% while every other major category grew. PM is what keeps fleets coming back, so this is an early warning.
- 3Too much depends on a few fleets. Your top 5 accounts are 42% of revenue, and two of them are declining.
- 489 customers have gone quiet. They spent $177,200 with you over the last 12 months and haven't been back in 30+ days.
Top 3 actions for October
- Call Fleet Account C this week. PM visits dropped from 9 to 3 a month. Find out why before the account is gone.
- Send PM reminders to 12 overdue fleets. Est. $14,400 in repair work.
- Win back the 23 customers inactive 90 to 179 days. Est. $10,200 recoverable.
Revenue and sales trends
Revenue for the last six months. September was your strongest month of the six.
Month by month
| Month | Revenue | Repair orders | Avg order | Vs prior month |
|---|---|---|---|---|
| Apr | $161,200 | 281 | $574 | |
| May | $168,900 | 290 | $582 | +4.8% |
| Jun | $172,400 | 296 | $582 | +2.1% |
| Jul | $165,300 | 284 | $582 | -4.1% |
| Aug | $174,600 | 297 | $588 | +5.6% |
| Sep | $186,420 | 312 | $598 | +6.8% |
September, week by week
| Week | Revenue | Repair orders | Avg order |
|---|---|---|---|
| Sep 1 to 7 | $38,940 | 64 | $608 |
| Sep 8 to 14 | $47,210 | 80 | $590 |
| Sep 15 to 21 | $51,380 | 85 | $604 |
| Sep 22 to 30 | $48,890 | 83 | $589 |
The first week of the month was the slowest, about 16% below the weekly average. That's the best window for a promotion.
Repair category analysis
Where the money comes from and how often each service brings customers back.
Revenue by category
| Category | Revenue | Share | Vs Aug | |
|---|---|---|---|---|
| Engine & drivetrain | $52,880 | 28% | +12.3% | |
| Brakes & air systems | $34,110 | 18% | +2.0% | |
| Preventive maintenance (PM) | $27,960 | 15% | -12.1% | |
| Electrical & diagnostics | $22,370 | 12% | +10.7% | |
| Tires & wheel end | $18,640 | 10% | +10.3% | |
| Trailer repair | $15,830 | 8% | +13.6% | |
| DOT inspections | $8,400 | 5% | +10.5% | |
| Roadside & mobile calls | $6,230 | 3% | +73.1% | |
| Total | $186,420 | 100% | +6.8% |
Frequency and repeat business
| Category | Jobs | Customers | Avg ticket | Repeat rate | Days between visits |
|---|---|---|---|---|---|
| Engine & drivetrain | 41 | 33 | $1,290 | 38% | 140 |
| Brakes & air systems | 68 | 51 | $502 | 61% | 75 |
| Preventive maintenance (PM) | 96 | 58 | $291 | 82% | 64 (was 58) |
| Electrical & diagnostics | 39 | 34 | $574 | 44% | 120 |
| Tires & wheel end | 34 | 29 | $548 | 52% | 95 |
| Trailer repair | 22 | 15 | $720 | 47% | 110 |
| DOT inspections | 70 | 52 | $120 | 71% | 360 (annual) |
| Roadside & mobile calls | 18 | 18 | $346 | 11% | Rare |
Customer activity and revenue concentration
Top 5 accounts
| Account | Sep revenue | Share | 3-month trend |
|---|---|---|---|
| Fleet Account A (regional hauler, 42 trucks) | $24,860 | 13.3% | Growing |
| Fleet Account B (dump & aggregate) | $18,720 | 10.0% | Growing |
| Fleet Account C (refrigerated freight) | $14,390 | 7.7% | Declining |
| Fleet Account D (local delivery) | $11,270 | 6.0% | Steady |
| Fleet Account E (oilfield services) | $8,930 | 4.8% | Declining |
| Top 5 combined | $78,170 | 41.9% |
Customers who stopped coming in
| Last visit | Customers | Spent in prior 12 months | |
|---|---|---|---|
| 30 to 59 days | 21 | $38,400 | |
| 60 to 89 days | 14 | $29,700 | |
| 90 to 179 days | 23 | $61,200 | |
| 180+ days | 31 | $47,900 | |
| Total | 89 | $177,200 |
The 90 to 179 day group is the priority: still winnable, and the highest spend. The full list is on page 6.
Sales opportunity scoring
Every customer is scored from 0 to 100 on how much additional business they're likely to bring and how urgent it is. These are the top 15 for October.
| Customer | Score | Why | Est. value | Next step | |
|---|---|---|---|---|---|
| 1 | Fleet Account C | 94 | PM visits down from 9 to 3 a month since June | $9,800 | Owner call this week |
| 2 | Fleet Account E | 88 | Spend down 31% over 3 months; PM overdue | $4,200 | Owner call |
| 3 | Gulf Prairie Hauling | 86 | 14 trucks; PM overdue by 22 days | $2,900 | PM reminder |
| 4 | Red Oak Transport | 83 | Declined $3,400 brake job on Sep 18 | $3,400 | Callback |
| 5 | Fleet Account D | 81 | Sends trailer work to another shop | $2,600 | Trailer offer |
| 6 | Lone Pine Logistics | 79 | Inactive 104 days; $8,400 in past 12 months | $2,400 | Win-back offer |
| 7 | Cypress Bend Freight | 77 | PM overdue by 17 days | $1,800 | PM reminder |
| 8 | Mesa Line Carriers | 75 | Declined $2,100 tire job on Sep 9 | $2,100 | Callback |
| 9 | Brazos Valley Dump Co. | 73 | Inactive 131 days; $7,800 in past 12 months | $1,950 | Win-back offer |
| 10 | Northfork Ag Hauling | 70 | Harvest season starting; last visit 96 days ago | $1,700 | Seasonal PM offer |
| 11 | Silverline Reefer | 68 | PM overdue by 19 days | $1,500 | PM reminder |
| 12 | Pecan Grove Freight | 65 | Declined $1,450 electrical repair | $1,450 | Callback |
| 13 | Ironwood Contractors | 63 | Inactive 112 days | $1,300 | Win-back offer |
| 14 | Highway 6 Towing | 61 | 3 roadside calls, never visited the shop | $1,200 | Shop-service offer |
| 15 | Bluebonnet Delivery | 58 | 6-truck fleet; one roadside call only | $900 | Shop-service offer |
| Top 15 combined | $39,200 |
Inactive customer recovery list
The 23 customers who haven't been back in 90 to 179 days, ranked by what they spent with you. This is your team's call list, with a recommended offer for each.
| Customer | Contact | Days out | Last service | 12-mo spend | Recommended offer | |
|---|---|---|---|---|---|---|
| 1 | Lone Pine Logistics | Derrick, (713) 555-0114 | 104 | PM + brakes | $8,400 | Free brake check with PM |
| 2 | Brazos Valley Dump Co. | Ray, (979) 555-0122 | 131 | Engine repair | $7,800 | Priority slot + PM special |
| 3 | Coastal Bend Aggregates | Lupe, (361) 555-0135 | 97 | Brakes & air | $5,200 | Free brake check with PM |
| 4 | Ironwood Contractors | Tasha, (281) 555-0141 | 112 | Electrical | $4,600 | Free diagnostic |
| 5 | Northfork Ag Hauling | Wes, (936) 555-0158 | 96 | PM | $4,100 | Pre-harvest PM special |
| 6 | Westfield Fuel Haulers | Marcus, (713) 555-0163 | 143 | Tires | $3,600 | Tire check + PM special |
| 7 | Trinity Mixer Services | Gina, (832) 555-0170 | 118 | Engine repair | $3,200 | Priority scheduling |
| 8 | Live Oak Livestock | Cody, (979) 555-0176 | 159 | Trailer repair | $2,900 | Trailer inspection special |
| 9 | Sandhill Water Transport | Andre, (281) 555-0183 | 101 | PM | $2,700 | PM special |
| 10 | Clear Lake Couriers | Priya, (713) 555-0189 | 125 | Brakes & air | $2,500 | Free brake check with PM |
| 11 | Old Spanish Trail Freight | Hector, (832) 555-0192 | 138 | Tires | $2,300 | Tire check + PM special |
| 12 | Bayside Pallet Co. | Jen, (281) 555-0104 | 109 | PM | $2,100 | PM special |
| 13 | Rolling Hills Hauling | Earl, (936) 555-0117 | 167 | Electrical | $1,900 | Free diagnostic |
| 14 | Prairie View Produce | Linh, (979) 555-0128 | 99 | Trailer repair | $1,700 | Trailer inspection special |
| 15 | Fort Bend Fencing | Mike, (281) 555-0131 | 121 | PM | $1,500 | PM special |
| 16 | Kingwood Lawn Fleet | Shay, (832) 555-0146 | 133 | Brakes & air | $1,300 | Free brake check with PM |
| 17 | Riverside Roll-Off | Dante, (713) 555-0152 | 148 | Tires | $1,150 | Tire check + PM special |
| 18 | Magnolia Feed Supply | Beth, (936) 555-0167 | 114 | PM | $1,000 | PM special |
| 19 | Spring Creek Movers | Omar, (281) 555-0174 | 176 | Electrical | $900 | Free diagnostic |
| 20 | Tomball Tank Lines | Kyle, (832) 555-0181 | 127 | PM | $800 | PM special |
| 21 | Humble Hot Shot | Andrea, (281) 555-0187 | 105 | Roadside | $650 | 10% off first shop visit |
| 22 | Katy Prairie Pickup | Luis, (713) 555-0195 | 152 | Roadside | $500 | 10% off first shop visit |
| 23 | Sealy Small Freight | Ron, (979) 555-0199 | 170 | Brakes & air | $400 | Free brake check with PM |
| 23 customers | $61,200 |
Missed opportunities and next steps
Revenue the shop can realistically recover in October, based on its own records.
| Opportunity | Est. value | |
|---|---|---|
| 1 | Fleet Account C: PM visits down from 9 to 3 per month since June Likely moving PM work elsewhere. Highest-value account at risk. | $9,800 |
| 2 | 12 fleets overdue for PM based on service history Last PM 75+ days ago on a typical 60-day interval. | $14,400 |
| 3 | 23 customers inactive 90 to 179 days $61,200 spent with you in the prior 12 months. | $10,200 |
| 4 | 38 declined or deferred repairs in September Mostly brakes and tires. No follow-up recorded. | $8,700 |
| 5 | Roadside calls up 73% with no follow-up offer 18 one-time roadside customers never offered shop service. | $3,100 |
| Total recoverable | $46,200 |
Estimates use each customer's average order value and a conservative 30 to 40% response rate.
Recommended actions
| Action | Owner | Due | Priority | |
|---|---|---|---|---|
| 1 | Call Fleet Account C owner this week; review PM pricing and turnaround | Owner | Oct 9 | High |
| 2 | Send PM reminder to the 12 overdue fleets with a book-by date | Service writer | Oct 7 | High |
| 3 | Run a 90-day win-back offer to the 23 inactive customers | Blacktop Engine | Oct 14 | High |
| 4 | Call back the 38 declined repairs, starting with brakes and tires | Service writer | Oct 16 | Medium |
| 5 | Add a shop-service offer to every roadside invoice | Front desk | Oct 10 | Medium |
Next month we'll track
| PM revenue back above $30,000 | Declined repairs converted |
| Fleet Account C visits | Roadside customers returning for shop work |
| Win-back replies and booked repairs | First-week revenue vs September |
Tap Next, use your arrow keys, or swipe to turn the page.
Book your free consultation
Takes 60 seconds. We'll call to set a time that works around your shop.
You're on the list!
We'll reach out shortly to set up your free 30-minute consultation. Keep your phone close. While you wait, flip back through the sample report: that's what we'll build from your repair orders.
Your free consultation
Want this report for your shop?
It starts with one free 30-minute call. We'll look at how your shop tracks sales today, what you most want to know, and what your monthly report would show. If it's not a fit, you've lost nothing.
30 minutes with Mani about your shop's sales. No cost, no pressure.
Every month, you get:
I'm Mani, Founder & Lead Analyst of Blacktop Engine. Nearly a decade in trucking, and I've generated $4M+ in annual revenue for a small carrier. I read your numbers like an owner, not an accountant.
Seen enough? Let's find what your shop is missing.
Quick test
Can you answer these about your shop?
If you can't answer all six in under a minute, money is slipping past you. The answers are already in your repair orders. Nobody has pulled them out yet.
Every monthly report answers all six. The longer a customer stays quiet, the harder they are to win back. Let's find yours now.
The math
Win back five. Do the math.
Take the sample shop: 23 customers who spent money there last year haven't been back in 90 to 179 days. Their average repair order is $598.
And that's before PM reminders, declined repairs, and the next visit after that. These customers already know your shop. Someone just has to call them with a reason to come back. Your numbers will be different. The free consultation is where we look at yours.
Your quiet customers are getting harder to win back every month. Find out who they are.
Smarter, then better
Knowing isn't enough. Every report ends in action.
A report nobody acts on is just paper. Each month ends with clear actions, an owner for each one, and a due date. Then we track what happened.
Know
See what's working, what's slipping, and where the money is hiding.
Act
Get the call list, the offers, and who does what by when.
Grow
Next month's report shows what worked, so every month gets sharper.
Then next month, we track:
- Declined repairs converted
- Win-back replies and booked repairs
- PM revenue back on track
- Slow-week revenue vs last month
Ready to run your shop on real numbers? Start with a free consultation.
How it works
Simple to start. Sharper every month.
STEP 1Book your free consultation
Fill out the form. It takes 60 seconds. We'll call to set a time that works around your shop.
STEP 2Talk through your shop
On a 30-minute call, we look at how your shop tracks sales today and what you most want to know.
STEP 3Send your sales data
Export your repair orders from your shop software or spreadsheet. We handle the cleanup. Happy to sign your NDA first.
STEP 4Your report every month
Your report arrives each month with a walkthrough, the call list, and the actions to take next.
Step 1 takes 60 seconds. Book your free consultation now.
Quick answers
Before you book
What happens on the free consultation?
We talk for 30 minutes about your shop: how you track sales today, what you most want to know, and what your monthly report would look like. You'll leave knowing where to look first, even if you never hire us.
What data do you need from my shop?
Your repair orders or invoices: date, customer, service, and total. An export from your shop software, QuickBooks, or a spreadsheet works. We'll walk you through it on your free consultation.
Is my shop's information kept private?
Yes. Your data is only used to build your reports, and we're happy to sign your NDA before you share anything.
Do I need special software?
No. If you can export your sales to Excel or CSV, that's enough. Even paper-heavy shops can start; we'll talk through options on the call.
Do you call my customers for me?
No. Your team makes the calls, because your customers know your shop. Every report gives them a ranked call list with the reason to call and a recommended offer for each customer, so they know exactly what to say.
Does the report show my profit?
The report is built on your sales: revenue, repair orders, customers, and services. Profit needs your parts and labor costs, which we can discuss adding on your free consultation.
How much does monthly sales analysis cost?
Every shop is different, so pricing is a custom quote. You'll get it after your free consultation, before you pay anything.
Is the sample report real?
The format is exactly what you'd receive. The shop, accounts, and figures in the sample are fictional, so no real shop's data is shared.
Your repair orders already hold the answers. Let's pull them out together.