Why Excel starts costing a carrier more than a CRM

Almost every carrier starts the same way: a notebook, an Excel spreadsheet, calls to the dispatcher, and messages on Viber or Telegram. While there is one bus, the route is familiar and there aren't many bookings, this is enough. The spreadsheet is clear, accessible and seemingly free.

The problems begin as the business grows. Another bus is added, parallel trips appear, tickets are sold through several channels, and passengers want to choose seats and pay online themselves. Information has to be transferred manually, and every new booking increases the risk of error.

At this point manual record-keeping stops being free for the carrier. Its real price is hours of the team's time, unsold seats, double bookings, unhappy passengers and decisions made without accurate data.

Why manual record-keeping only seems free

Excel has no monthly bill for each trip — which is exactly why the costs are easy to miss. They are spread across dozens of daily operations and show up not as one large sum, but as constant small losses.

A carrier effectively pays for manual record-keeping when:

• a dispatcher transfers the same data several times between the spreadsheet, a messenger and the driver's list;
• a passenger can't buy a ticket after hours and goes to a competitor;
• two sales channels sell the same seat at the same time;
• an error in a name, date or trip requires extra calls and corrections;
• a manager spends hours reconciling payments and cash;
• passenger contacts stay in personal chats instead of a single customer base;
• the schedule has to be updated separately on the website, on social media, in spreadsheets and in messages.

Each operation seems trivial. Together they turn into a systematic drain of time and money.

The hidden costs of manual record-keeping

Double sales and seat confusion

A passenger books a seat by phone. Almost at the same time another buys it through a different channel. The dispatcher hasn't updated the spreadsheet yet — and two people arrive for boarding counting on the same seat.

Even if the situation is resolved on the spot, the carrier has already paid for the mistake: with the dispatcher's and driver's time, a refund, a delayed boarding, a spoiled impression and the risk of a negative review.

In a system with a single ledger, the seat is blocked in real time. In a spreadsheet, protection depends on whether a person managed to enter the change.

Sales stop together with the working day

Excel doesn't sell tickets at three in the morning. A messenger doesn't help either if no one answers. A passenger who has already decided on a trip doesn't want to wait until morning — they choose a carrier where they can immediately check the trip, pick a seat and pay.

After-hours time is not a pause in service. It is a period in which part of ready demand moves to competitors.

The business depends on one specific person

In a manual process, information exists not only in Excel but also in the dispatcher's head: who was allowed to pay later, who to seat closer to the driver, who changed the date. When this person is ill or leaves, part of the business's operational memory disappears with them.

A centralised system with role-based access keeps the history and unified rules. The process no longer rests on the "right file" and one person who knows all the nuances.

Passenger data is lost after the sale

Manual record-keeping often ends the moment the ticket is paid for. The contact stays in Viber or a notebook, and travel history is never built. Without a single base it is hard to segment passengers, remind them about trips, offer a repeat journey and win customers back. Every next sale has to start almost from scratch.

The manager doesn't see the full picture

A spreadsheet shows a list of passengers, but doesn't always give a quick answer: which trip brought the most revenue, what the actual occupancy is, which destinations are weaker, how much cash the driver must hand over, when demand peaks. If answering requires merging several files by hand, analytics is always late — and decisions are made on gut feeling.

A typical dispatcher's morning: where the mistake happens

Imagine an ordinary ten minutes before a popular trip:

• 08:15 — a passenger calls and asks for a window seat;
• 08:16 — a request to reschedule a ticket arrives on Viber;
• 08:17 — the driver reports a change of bus and a different seat map;
• 08:18 — a payment needs to be checked;
• 08:19 — another passenger asks about free seats on Telegram;
• 08:20 — an agent sends a new booking;
• 08:21 — the first passenger needs their seat confirmed and payment details sent;
• 08:22 — the driver asks for an updated passenger list.

All these requests concern one trip but come from different channels. The dispatcher has to switch instantly between chats, calls, payments, the seat map and Excel.

"We don't have time to double-check everything" is not an excuse but a diagnosis. When a trip goes wrong or a seat is sold twice, the dispatcher says: "too much work, I can't reconcile everything." And they are right. With manual record-keeping, one person simultaneously takes calls, updates the spreadsheet, looks for free seats, messages passengers on Viber and reconciles cash from drivers. Under such a load it is physically impossible not to make mistakes.

The errors here are not the negligence of a specific person, but an inevitable consequence of the process. The problem is not the dispatcher, but the fact that they have been given work that a system should do. And as long as the process is manual, any control is a matter of "will I manage or not" — that is, a lottery.

Manual record-keeping turns control into a lottery. A system makes it a rule.

What changes after automation

Automation of passenger transport begins with something simple — removing manual routine from the person. BUSPORTAL takes on the operations that don't need constant manual control:

• available seats are shown in a single system, and the chosen one is blocked during checkout;
• the passenger finds the trip themselves, picks a seat and pays for the ticket online, immediately receiving an electronic ticket;
• booking data is updated centrally — the dispatcher works with current information instead of reconciling versions of a spreadsheet;
• the manager sees trip metrics, revenue and occupancy;
• contacts and history build the carrier's own passenger base.

This does not make the dispatcher unnecessary. On the contrary — their time is freed for situations where a human is truly needed: helping a passenger, handling a non-standard rescheduling, coordinating a delay. Manual record-keeping forces the dispatcher to constantly "manage to check." Automation makes basic control part of the process itself.

How to calculate the real cost of Excel

You don't need a complex financial model. It is enough to track four figures for one or two weeks:

1. How many hours the team spends entering bookings, reconciling, sending mailings and preparing lists.
2. How many enquiries arrive after the working day.
3. How many corrections, refunds and conflicts occur due to outdated data.
4. How much time the manager or accountant spends consolidating payments and reports.

Cost of manual record-keeping = team time + lost sales + cost of errors + cost of management delays.

A hypothetical example. If a dispatcher spends two hours a day on operations that could be automated, over 22 working days that is 44 hours a month — more than five full working days. If at least one potential sale is lost after hours each day, add the value of up to 30 tickets a month, plus refunds and time spent fixing errors.

This is not BUSPORTAL statistics but an example of a method. Plug in your own average ticket price, hourly cost of work and actual number of lost enquiries — and you will see the real cost of the manual process in your own company.

Excel and BUSPORTAL: a comparison of capabilities

In short — Excel helps store data. BUSPORTAL helps manage a carrier's sales and operations.

When the spreadsheet stops coping

There is no magic number of buses after which Excel "suddenly breaks." The complexity of the process matters more. A move to a system is worth planning if:

• a second or third bus and parallel trips have appeared;
• bookings come from the website, phone, messengers, agents or aggregators;
• passengers want to see the seat map and choose seats themselves;
• more and more time goes into reconciling payments;
• different fares, transfers or connections are needed;
• drivers regularly receive new versions of lists;
• the manager can't quickly get data on revenue and occupancy;
• errors already affect service and reputation;
• growing sales require hiring another person just to process data manually.

If several points already sound familiar, the problem is not that the team "keeps Excel badly." The business has simply outgrown a tool made for spreadsheets, not for managing passenger transport.

BUSPORTAL is not another spreadsheet

Automation makes sense not when it just makes Excel prettier, but when it changes the sales and control process itself. BUSPORTAL is a bus ticket sales and transport management system that combines what a carrier needs every day:

• online sales and payment acceptance, electronic tickets;
• seat maps and real-time seat control;
• a workspace for dispatchers and an app for drivers;
• a passenger base, financial accounting and trip analytics;
• SEO route pages and presence on Google Maps;
• fleet control, including GPS monitoring.

Instead of several scattered sources — a single loop: the passenger buys a ticket, the dispatcher sees the current booking, the driver gets the data they need, the manager controls the result.

It's not about "old" versus "modern"

Excel for a carrier remains an excellent tool for calculations — it shouldn't be criticised for what it wasn't created for. But a transport business needs more than storing rows: to sell, accept payment, control seats, update the schedule, coordinate the team and see the financial result all at once.

So the choice is not between "free Excel" and "paid software." In reality the carrier is choosing between two ways of working:

• a manual process with hidden costs that increasingly depends on the speed and attentiveness of people;
• a systematic process where routine operations are automated and the team works with single, current data.

Conclusion: how much longer will working without a system cost

Excel can well be the right solution at the start. But as the number of trips, buses, sales channels and passengers grows, manual record-keeping takes more time, creates more errors and hides more losses.

The main question is no longer whether you can keep running a spreadsheet. Of course you can. The question is different: how much time, sales and team attention is the business willing to spend on constantly updating it by hand?

Excel helps keep records. BUSPORTAL helps manage and grow a carrier's business.

If manual reconciliations already take hours and errors affect passengers and revenue, BUSPORTAL helps move these processes into one system without stopping your current work. The first 30 days are free, with full launch support. Learn more at busportal.app.