What spreadsheets do well
They are free, or close to it, and everyone on your team already knows how to use one. They bend to whatever your station does: a new column for toll tags, a tab for a pop-up station, a color for vans waiting on a part. Nobody has to ask a vendor for anything.
They also make you look at the numbers. An owner who reconciles the fleet invoice by hand every month knows the fleet better than one who never opens it.
Where they break at a DSP
The problems come with more people, more vans and more weeks, not on day one.
- Version drift. The dispatcher's van list, the fleet manager's repair tracker and the copy someone emailed on Tuesday disagree, and nobody knows which one is right.
- No record of who changed what. A van marked back in service, a write-up edited, a date moved: a shared sheet rarely tells you who did it or what it said before.
- No reminders. A repair approval that nobody chased, a registration that expired, a ride-along that never got scheduled. A sheet holds the date but doesn't tell anyone it has passed.
- Nothing checks one sheet against another. The fleet invoice says a van was billed all month; the repair tracker says it was in the shop for nine days. Unless someone puts the two side by side, the charge gets paid.
- Drivers can't see their own card. Today's route, van and staging lane, or last week's scorecard, still go out by text or on a whiteboard.
What moving off them takes
Less than most owners expect, if the new tool works from the reports you already download. With SXT Ops the first step is the roster export from the Amazon Logistics portal, which creates the associate records. Then the van list, then the reports you pull each week: scorecards, route invoices, fleet invoices and timecards. Each report is mapped once, and later files in the same layout import by themselves.
History in your spreadsheets doesn't have to move on day one. You can keep the old sheets as a read-only archive and start fresh from the current week.
When a spreadsheet is still the right call
If you run one small station, the same few people touch the sheets, and the owner reconciles the invoices by hand every week, software may not save you enough to be worth its price. Keep the sheets, keep the habit, and revisit when you add a station or a fleet manager.
If you stay on spreadsheets, three habits cover most of what goes wrong: one master copy with everyone working in it, a status log for every van with dates and times, and a monthly hour with the fleet invoice next to that log. The fleet invoice audit guide has a worksheet for the last one.
Where spreadsheets are ahead
- They cost nothing beyond the office suite you already pay for.
- You can add a column or a tab whenever you like, with no vendor involved.
- Your team already knows them, so there is nothing new to learn.
- The file is yours, in a format any other tool can read.
Where SXT Ops is different
- One record per van and per associate that everyone works from, with changes to associates, vans and repair orders recorded with who made them and when.
- Repair orders with a 30-minute follow-up timer, and warnings before a van's registration or insurance runs out.
- On the Station + Back office plan, fleet invoices checked against van status and repair orders, and route invoices against your rate card, every time a file is imported.
- A driver app where each driver sees their own route card, pre-trip, scorecard and hours.
Something here out of date? Email contactus@sophiaxt.com and we'll check and correct it.