NEMT Dispatch Spreadsheet vs Software: When the Spreadsheet Stops Working

What a spreadsheet does well

A spreadsheet costs nothing extra, everyone already knows how to use it, and you can add a column in five seconds. For one van running fixed dialysis runs, a clean sheet and a phone can carry the day. The layout that works is one row per trip leg, not one row per rider, so an outbound ride and its return each get their own line.

A workable sheet has these columns: date, trip or authorization number, rider, pickup address, scheduled pickup time, appointment time, drop-off address, level of service, escort, driver, vehicle, status, actual pickup time, actual drop-off time, miles, and notes. The free daily manifest template uses the same structure if you want a starting point.

The trouble is not that spreadsheets are bad. It is that NEMT days change after they are planned, and a spreadsheet has no idea what is happening on the road.

Where the spreadsheet breaks

The problems fall into three groups: coordination, documentation, and billing.

The documentation row is the one payers audit. CareOregon’s transportation provider manual (February 2024) sets a minimum record for every trip: member name, pickup location, scheduled and actual pickup times, destination, appointment time, drop-off time, mode of transport, provider and driver names, date, authorization or trip number, trip cost, mileage, and the vehicle’s ID or plate. It requires providers to keep that documentation for at least six years. A spreadsheet can hold those columns. Keeping them complete for every leg, every day, by hand, is where it fails.

The HIPAA gap in shared spreadsheets

A dispatch sheet is full of protected health information: names, addresses, phone numbers, dates of birth, Medicaid IDs, and where each person gets treatment. CareOregon’s manual names member names, dates tied to a person, phone numbers, street addresses, and health plan beneficiary numbers as protected information that providers must guard.

The HIPAA Security Rule asks for specific safeguards on systems that hold electronic health information (45 CFR 164.312):

• Unique user identification. Each person who opens the data needs their own name or number, so activity can be traced to them.
• Audit controls. The system must record and let you examine activity.
• Integrity. You need a way to protect the data from improper change or deletion.

A spreadsheet shared by link, or a dispatch email account the whole office signs into, cannot tell you who opened or changed a row. There is also the storage question. A company that maintains health information on your behalf is a business associate under 45 CFR 160.103, so the service that stores your sheet needs a signed business associate agreement with you. Texting manifests to drivers’ personal phones adds one more copy of the data you do not control.

None of this makes spreadsheets illegal. It means a compliant spreadsheet setup takes deliberate, ongoing work.

What the spreadsheet really costs

The spreadsheet is free. The hours around it are not. Here is a worked example with assumptions labeled so you can swap in your own numbers.

A hypothetical fleet of 6 vans runs 48 legs a day on 22 working days a month.

At an assumed loaded cost of $22 an hour for the person doing it, that is $1,474 a month in admin time. Software will not erase all of it, since someone still plans and approves the day. If it removes half, that is about $737 a month back. For comparison, an illustrative price of $75 per vehicle per month comes to $450 for this fleet. Current published prices are on the NEMT software pricing comparison.

The table leaves out the costs that are hardest to count: a missed dialysis pickup because a change never reached the driver, a broker complaint, or a claim you cannot support because the actual times were never written down.

Signs it is time to switch

• More than one person edits the schedule on a normal day.
• Two or more drivers are on the road at the same time.
• You carry standing orders and will-call trips alongside one-off rides.
• A broker, plan, or auditor has asked for trip logs you had to rebuild.
• Month-end billing takes more than a day.
• A pickup was missed because a change never reached the driver.

If two or more of these sound familiar, run the cost math above with your own numbers.

If you stay on a spreadsheet for now

You can make a spreadsheet safer and more useful while you grow into software:

1. Keep one row per leg and one tab per day.
2. Give each person their own login, and turn off open link sharing.
3. Store the file only with a provider that signs a business associate agreement.
4. Lock the columns that hold formulas so nobody overwrites them.
5. Record the actual times at pickup and drop-off the same day, not at month end.
6. Keep a separate trip log for each driver’s day with the rider’s signature.
7. Stop emailing the sheet. Share access instead.

When you are ready to move, the buyer’s checklist covers what to test, and the switching guide covers how to carry your riders and recurring rides across without losing a trip.

Doing it faster in HealthRide

HealthRide replaces the sheet with a dispatch board where you assign a trip in one motion, and it warns you before a wheelchair trip goes to a van without a lift. Drivers work from the driver app, so status changes arrive live and signatures are captured on screen instead of typed in later. Recurring rides stay on the schedule by themselves: schedule it once, and HealthRide keeps it going. When the day needs planning, Ryder Go plans and assigns it in one click.