Private & confidential
Where your team's time really goes — and the easiest ways to get it back.
We measured 10 business days across 28 computers — Dispatch (9) · Operations (8) · Sales (6) · Finance (5). Not a survey, not interviews: how the work actually happened.
Things worth knowing
Nothing here is anyone doing a bad job. It's work that repeats, or happens in two places at once — exactly the kind that's easiest to hand off.
Quotes, loads, and invoices get carried by hand between email, spreadsheets, and your TMS about 1,120 times a week. Nobody is doing a bad job — the systems just don’t talk, so people are the integration.
Eight people check carrier portals, copy statuses into a spreadsheet, and email updates — each doing it their own way. One shared automated feed replaces all of it.
Dispatchers switch windows 96 times a day; the median quiet stretch is 7 minutes. That costs real hours, and it’s why after-hours email is 14% of the total.
Microsoft 365, your TMS, and QuickBooks Online all expose modern connections. Most of what we found needs setup, not new software purchases.
Every new-carrier onboarding in the window ran through a single person. If they’re out, it stops. Worth writing down — then automating the checklist.
Where the day goes
Share of active time by kind of tool, across all 28 measured machines — and where information gets carried by hand between programs.
| Information moves by hand | Into | Times / week |
|---|---|---|
| Spreadsheets | 340 | |
| Carrier portals | Spreadsheets | 260 |
| Spreadsheets | Your TMS | 230 |
| Email / PDF attachments | Your TMS | 180 |
| Your TMS | Email (status updates) | 110 |
Every row is a person being the integration between two programs. Connect the programs and the row disappears.
The opportunities, ranked
Ordered by where we'd start — payoff weighed against effort. The list adds up to the headline; where two touch the same hours, we sequence them rather than count twice.
| # | Opportunity | Team | Hours/yr | Value/yr | Effort |
|---|---|---|---|---|---|
| 1 | An assistant for email — sorting, drafts, follow-ups | Everyone | 940 | $42,300 | quick win |
| 2 | Protecting stretches of focused time | Whole team | 2,240 | $100,800 | bigger project |
| 3 | Instant answers on carriers & customers | Sales · Ops | 610 | $27,450 | bigger project |
| 4 | Automatic shipment-tracking updates | Dispatch | 520 | $23,400 | quick win |
| 5 | Reading rate sheets so nobody re-types them | Operations | 410 | $18,450 | medium |
| 6 | A head start on quotes (email → TMS) | Sales | 380 | $17,100 | medium |
| 7 | Keeping invoices and QuickBooks in sync | Finance | 350 | $15,750 | medium |
| 8 | Driver-log reconciliation, automated | Operations | 290 | $13,050 | medium |
| 9 | Status reports that write themselves | Dispatch · Ops | 240 | $10,800 | quick win |
| 10 | Retiring duplicate tracking tools | Whole team | 310 | $13,950 | medium |
A simple plan to get started
Start small; let the early wins pay for the bigger steps. The dollar figures are time you get back each year — not what setup costs.
- →An assistant for email — sorting, drafts, follow-ups
- →Automatic shipment-tracking updates
- →Status reports that write themselves
Low-effort, high-certainty. These pay for the engagement inside the first quarter.
- →Reading rate sheets so nobody re-types them
- →A head start on quotes (email → TMS)
- →Keeping invoices and QuickBooks in sync
- →Driver-log reconciliation, automated
- →Retiring duplicate tracking tools
This is where the copying stops: your TMS, M365, and QuickBooks talking to each other.
- →Protecting stretches of focused time
- →Instant answers on carriers & customers
Worth planning deliberately — the largest numbers, and the most change-management. Plus easing the single-person carrier dependency (not counted in dollars).
What year one looks like
Phases come online in months 2, 4, and 8. Monthly run-rate of time recovered, cumulative — conservative by design.
How you compare
Against the typical operation of your size and industry that we measure. Illustrative benchmarks — the point is where you sit, not decimal precision.
| Metric | You | Typical |
|---|---|---|
| Share of day spent re-keying between systems | 24% | 14–18% |
| Median uninterrupted focus stretch | 7 min | 11 min |
| After-hours email share | 14% | 8% |
| Core systems API-ready | Yes | Usually |
A day for Dispatcher 1 — before and after
Same person, same job, same morning. The difference is what the systems do on their own.
- ·7:05am — opens 6 carrier portals, copies overnight statuses into the tracking sheet, emails the morning update (50 min)
- ·All morning — new loads arrive by email; each one typed into the TMS from a PDF (9 a day)
- ·2pm — a customer asks “where’s my load?”; portal → TMS → reply, 14 times a day
- ·4pm — re-types today’s statuses into the ops spreadsheet for the evening shift
- ·Focus never exceeds ~5 minutes; 74 re-keys this week
- ✓7:05am — the tracking feed already pulled every carrier status; the morning update drafted itself for review
- ✓New loads: read from the email/PDF and staged in the TMS — dispatcher confirms instead of types
- ✓“Where’s my load?” — answered from the connected systems in one lookup, or self-served by the customer
- ✓4pm hand-off happens in the shared system; nothing re-typed
- ✓The recovered ~90 minutes a day goes to exceptions — the work that actually needs a dispatcher
Your systems can already do this
Most of what we found needs connection, not new software. Meridian Managed IT sets these up and runs them for you.
Modern APIs, already licensed — the email assistant plugs straight in.
API-ready. The two busiest re-keying arrows both point into it; connecting it removes both.
Standard connection. Invoice matching becomes a nightly sync instead of an 18-minute manual routine.
A scheduled fetch replaces the 58-times-a-week manual checking routine.
Document reading turns attachments into structured rows — nobody re-types them.
What we measured, computer by computer
Twelve of the 28 machines shown. Roles, never names — the goal is fixing workflows, not scoring people. Click any card for that machine's detail.
How this rolls out without breaking your week
The change-management is the product. Four rules we run every engagement by.
One person per team helps tune their own workflow first and shows the rest. Adoption follows proof, not announcements.
Every automation runs in draft-first mode before it acts — you see what it would have done for a week, then turn it loose.
Each change can be switched off in one step, independently. The old way keeps working until the new way has earned trust.
A standing monthly review: what saved time, what needs tuning, what to add next. The plan updates with the evidence.
| Wk 1–2 | Systems connected read-only; draft-mode assistants watching, not acting |
| Wk 3–4 | Quick wins go live team by team, champions first |
| Wk 5–8 | The system connections: the copying between programs stops |
| Wk 9–12 | First monthly review with measured savings; bigger bets scoped with real usage data |
How this was measured — openly
- ✓Every person was informed in writing before measurement began; signed acknowledgments on file.
- ✓Never captured, at any tier: keystrokes, clipboard contents, email bodies.
- ✓Roles are shown instead of names throughout this report — the goal is fixing workflows, not scoring people.
- ✓All captured data is encrypted, scoped to this company alone, and hard-deleted five business days after this report is delivered.
What happens next
Three items, a few weeks, measured time back. The engagement fee credits against it.
M365, your TMS, and QuickBooks joined behind the scenes — the copying stops, and every number in this report stays measured, not estimated.
Not a one-time snapshot: a live view of where the hours go, what the automations saved, and what to do next — reviewed with you by Meridian each month.
This is the deliverable your clients receive — under your brand. Automated Edge runs the measurement through your RMM, writes the report, and builds what it recommends; your name is on every page. Pair it with the MSP portal demo to see your side of the same engagement.