Most transport services start on paper. A diary for bookings, a spreadsheet of drivers, printed run sheets on the dashboard and a folder of mileage claims. It works when there are a handful of journeys a day. It stops working, often quietly, as bookings, drivers and passenger needs grow.
This article explains where paper and spreadsheets break down in community, patient, SEND and demand responsive transport, how to tell when you have outgrown them, and how to move to a digital system without disrupting passengers or volunteers. It is written for coordinators, managers and trustees, and for the councils and NHS teams who rely on them.
Key Takeaways
- Paper is still the norm. Only 37% of community transport operators in England use journey planning software, 22% take bookings online and 2% use an app (CTA).
- Paper and spreadsheets cause double bookings, missed expiry dates, mileage errors and slow reports, and they depend on one or two people knowing how everything fits together.
- Run sheets hold health data, which is special category data under UK GDPR, so a lost sheet is a real data protection risk (ICO).
- Passengers do use digital booking. 87% of Rural Mobility Fund journeys were booked in an app, but phone booking still matters for a large minority (DfT).
- The best moves are phased: clean your data, run old and new side by side, train drivers, and keep a phone line for passengers.
Why do so many transport services still run on paper and spreadsheets?
Because they are free, familiar and good enough at the start. A spreadsheet needs no contract, no training and no procurement. The Community Transport Association's Mapping England research found only 37% of operators use journey planning software, 22% take bookings online and just 2% use an app.
There are good reasons for caution too. Many schemes run on tight grants, older volunteers and one or two paid staff. Changing systems feels risky when the current one mostly works. The trouble is that the costs of paper are hidden. They show up as overtime, missed journeys and stressed coordinators, not as a line in the budget.
Pressure on services keeps rising. NHS England's patient transport criteria direct people without a medical need towards other options (NHS England), volunteer numbers are stretched, and councils want better evidence before they fund a service. Each of those makes a manual system harder to run.
What goes wrong with paper and spreadsheets?
Paper and spreadsheets rarely fail in one dramatic moment. They fail in small ways, every day, that add up. These are the problems coordinators describe most often.
Double bookings and version chaos
When bookings live in a diary, a spreadsheet and a coordinator's head, they drift apart. Two people edit different copies, a driver is booked twice, or a cancellation never reaches the run sheet. Each mistake is small, but the passenger left waiting at the window does not see it that way.
No live picture of the day
Paper cannot tell you when things change. If a clinic overruns or a driver is stuck in traffic, the office finds out by phone, if at all. Nobody can see where vehicles are, who has been collected or which journeys are at risk until something has already gone wrong.
Missed expiry dates
Driver licences, DBS checks, MOTs, insurance and permits all expire. On a spreadsheet, nobody is reminded until someone happens to look. Volunteer DBS checks are free (DBS), yet a lapsed check can still mean a driver carrying vulnerable passengers without up to date clearance.
Mileage and invoicing errors
Manual mileage claims invite mistakes, and rate changes make it worse. HMRC's approved rate rose from 45p to 55p a mile from 6 April 2026 (HMRC). Every spreadsheet formula, claim form and fare table using the old rate had to be found and changed by hand.
Data protection risks
Run sheets list names, addresses, phone numbers and health or mobility needs. Health data is special category data under UK GDPR and needs extra protection (ICO). Our article on why a paper run sheet is your biggest data breach risk explains how easily these sheets are lost or left in cars.
Reports that take days
Funders, councils and boards want to know how many journeys you ran, for whom, why and at what cost. With paper, that means days of counting and cross checking. The numbers are often late and hard to trust, which weakens funding bids at exactly the moment they matter most.
Everything depends on one person
Many schemes rely on one coordinator who knows which driver likes which passenger and where the spreadsheet formulas live. When that person is off sick or leaves, the service can stall overnight. A shared system keeps that knowledge in the organisation rather than in one head.
How do you know you have outgrown spreadsheets?
There is no fixed number of journeys at which paper stops working. The signs are practical, and most coordinators will recognise several of them straight away. If three or more of these sound familiar, it is time to look seriously at a digital system:
- You regularly find double bookings or journeys missing from run sheets.
- Drivers call the office several times a day to check or change jobs.
- You have turned journeys down but could not say how many or why.
- Monthly reports take more than a day to put together.
- You have found an expired DBS, MOT or insurance certificate by accident.
- Only one person really understands how the spreadsheet works.
- Printed run sheets with passenger details are left in cars or bins.
What does a digital system do differently?
A digital transport system puts bookings, drivers, vehicles, passengers and money in one place that everyone works from. The table below compares the three approaches across the tasks that take most of a coordinator's week. The gap grows with every extra journey, driver and funder.
| Task | Paper | Spreadsheet | Transport software |
|---|---|---|---|
| Taking bookings | Diary and phone | Shared file, easy to overwrite | One live record, by phone, web or app |
| Matching drivers | From memory | Manual lookup | Suggests the nearest available driver |
| Driver jobs | Printed run sheets | Emailed or printed | Secure app that updates live |
| Expiry dates | Filed paperwork | Manual column | Automatic alerts before anything lapses |
| Mileage and fares | Hand written claims | Formulas to maintain | Calculated from each journey |
| Reports | Days of counting | Hours of cross checking | Ready in minutes |
| Passenger data | Printed and portable | Often shared by email | Access controlled and logged |
Our guide to software for transport management follows one journey from booking to report, showing what changes day to day. If budget is the worry, our breakdown of what community transport software really costs covers the full picture, not just the licence fee.
Will older passengers and volunteers cope with a digital system?
Usually yes, as long as nobody is forced to use an app. In the DfT's Rural Mobility Fund pilots, 87% of journeys were booked in an app and 11% by phone (DfT). On the Travel Derbyshire on Demand pilot, app bookings rose from 54.6% in 2024 to 64.4% by 2026.
Those figures show two things. Many passengers are happy to book online, and a large minority still want to talk to a person. A good system takes both routes into the same place, so the coordinator enters phone bookings exactly as passengers enter their own.
Drivers are similar. Most are comfortable with a simple app, especially one that shows only their own jobs. For the few who are not, a coordinator can phone through details or a scheme can pair them with a confident driver at first. Our article on overcoming the fear of change covers how to bring volunteers with you.
How do you move from paper to software without disruption?
The schemes that switch smoothly treat it as a project, not a purchase. Passengers should notice nothing except that things run more reliably. A typical move follows these steps:
- Clean your data first. Remove duplicate passengers, check addresses and update every driver's expiry dates.
- Choose a quiet start date, away from holidays and funding deadlines.
- Run both systems side by side for a week or two, so you can check the new one against what you know.
- Train coordinators first, then drivers in small groups, with written guides to keep.
- Keep your phone line and tell passengers nothing changes for them unless they want to book online.
- Securely destroy old paper records once the new system is live and checked.
For a deeper look at data protection during the switch, download our free guide to paper run sheets and data compliance, which sets out what trustees and coordinators need to check before, during and after the move.
What going paperless means for each role
Moving away from paper touches everyone involved in a transport service. Here is what matters most to each group.
Coordinators and transport managers
You get time back. Less time on the phone, retyping bookings and chasing mileage forms means more time for passengers and volunteers. You also get a live view of the day, so you can spot a late driver or a clash before a passenger is left waiting.
Charity CEOs, trustees and board members
Trustees are responsible for safeguarding, driver checks and data protection. A digital system gives you a clear, current view of all three, instead of a folder you hope is up to date. Our guide to trustee liability sets out what boards should ask to see.
SEND, school and DRT operational leads
Routes for pupils and demand responsive services change constantly. Spreadsheets struggle with daily changes, passenger assistants and strict pickup windows. A system that rebuilds routes as bookings change, and records who travelled with whom, makes those services safer and easier to evidence.
Councils, NHS teams and public sector buyers
Ask operators how they record journeys, protect passenger data and check drivers. Services that can show reliable, timely data are easier to fund, easier to audit and better placed to take on contracts. Paper based services often have the passengers and the goodwill but not the evidence.
Drivers, passengers and carers
For drivers, it means clear jobs on a phone, accurate mileage and fewer calls. For passengers and carers, it means reliable pickups, fewer mix ups and the same friendly phone line if they prefer it. Most notice the change only because things simply work more smoothly.
Where Road XS fits
Road XS is community transport software built in the UK to replace the diary, spreadsheet and paper run sheet. Bookings by phone, web or app land in one place, the nearest available driver with up to date checks is suggested automatically, and drivers see their jobs in a secure app instead of on paper.
Mileage and fares are worked out from each journey, expiry alerts arrive before anything lapses, and reports are ready in minutes. It supports car schemes, Dial-a-Ride, DRT, patient and school transport, so one system can run a mixed service.
Frequently asked questions
Why do paper and spreadsheets no longer work for transport management?
They cannot show a live picture of the day, they rely on manual updates that drift apart, and they make reporting, expiry checks and mileage slow and error prone. Paper run sheets also carry passenger health data, which is special category data under UK GDPR.
How many community transport operators still use paper?
Many. The Community Transport Association found only 37% of operators in England use journey planning software, 22% take bookings online and just 2% use an app. Most of the rest rely on diaries, spreadsheets and printed run sheets.
Are paper run sheets a GDPR risk?
Yes. Run sheets usually hold names, addresses and health or mobility needs. Health data is special category data under UK GDPR and needs extra protection. Lost or unsecured sheets can lead to a reportable data breach and harm to passengers.
How do I know if my service has outgrown spreadsheets?
Common signs include double bookings, drivers phoning in several times a day, reports taking more than a day, expiry dates found by accident, and only one person understanding how the spreadsheet works. Three or more of these usually means it is time to change.
Can older passengers still book by phone after going digital?
They should be able to. Good transport software takes phone bookings into the same system as app bookings. In the DfT's Rural Mobility Fund pilots, 11% of bookings still came by phone, so keeping a phone line matters.
How long does it take to move from paper to transport software?
It depends on the size of the service and the state of your data. Many schemes plan a few weeks for data cleaning, training and a short period running both systems side by side before switching over fully.
What should we do with old paper records after going digital?
Once the new system is live and checked, keep only what you need for legal, financial or safeguarding reasons, and securely destroy the rest, for example by shredding. Check your retention policy and data protection obligations before you dispose of anything.
Ready to leave the diary and spreadsheet behind? Book a Road XS demo or talk to our team about moving your service across.
