Skip to content
Cockpit dashboard with paperwork
Why it works7 minAug 11, 2026

Why your Excel rate card is costing you charter trips (and how to fix it)

Stale rate cards, missing margin visibility, inconsistent pricing between salespeople, and 90-minute quote turnaround times. Here's what quoting in Excel actually costs you — and what happens when you replace it.

I ran a flight school as general manager. I quoted charter trips in Excel. I'm writing this article because I know exactly how bad it is — and I know exactly why we kept doing it anyway.

Excel is free. Excel is flexible. Excel is already on your computer. You have a rate card that works, more or less. You have a template that produces a quote, more or less. Why would you pay for software when the spreadsheet works?

Because it doesn't work. Not really. Here's what's actually happening.

1. Stale rate cards

Your current rate card is version 4. Fuel surcharge went up last quarter. Someone in your team quoted the YBAF→YSSY leg on version 3 numbers. The trip flew at a $14,000 loss and nobody noticed until the accountant reconciled the invoice three months later.

This is not a hypothetical. FlightStratix uses this exact example on their website because it happens. Every operator who has quoted in a spreadsheet for more than two years has a version-control horror story. The spreadsheet that gets emailed around, downloaded locally, modified, and sent back. Nobody knows which version is current. Everyone assumes their copy is right.

The fix: a single, cloud-based rate card that is the source of truth. When you update a fuel surcharge, every quote from that point forward uses the new number. No version control. No "which spreadsheet are you on?"

2. No margin visibility

In Excel, you see total cost in one cell and total price in another. Margin is a formula you maybe have, maybe don't, maybe forgot to copy down. You send the quote and hope it's profitable.

The problem: the trip you priced sharp to win the business was the one you lost money on. You find out two months later in the P&L review. By then, the client has already booked three more trips with your competitor because your price was low — but your service was the same.

The fix: margin on every line, before you send. Block time, landing fees, handling, crew, fuel surcharge — each line shows cost, rate, amount, and margin percentage. Green means profitable. Red means you're quoting below cost. You make a decision before the quote goes out, not after the invoice comes back.

3. Inconsistent pricing between salespeople

Two people on your team quote the same route in the same week. One quotes $148,000. The other quotes $172,000. The client sees both quotes, calls it out, and moves to a competitor with more discipline.

This happens because Excel rate cards are personal. Each person has their own copy, their own assumptions, their own markup habits. There's no single source of truth, no route history, and no consistency check.

The fix: route history. Every quote you've ever sent, indexed by ICAO pair. When you type YBAF→YSSY, you see that you've quoted this route 4 times, the average was $5,200, and the last quote was $4,800. Your team quotes consistently because the data is in front of them.

4. Quote turnaround time

An RFQ arrives at 09:15. Your quote goes back at 13:40. The broker had already accepted a quote sent at 09:47. The aircraft wasn't the problem. The four-hour turnaround was.

In charter, the first credible response wins a disproportionate share of the business. Hamilton AI's internal data shows quotes sent within 15 minutes convert at 2–3× the rate of quotes sent after 2 hours. Not because the later quotes are worse — because the broker already had a conversation with whoever responded first.

Excel quoting takes 45–90 minutes per quote. That's not because you're slow. It's because the process is manual: look up the rate card, calculate the distance, find the landing fees, add the crew costs, apply the markup, format the PDF, write the email. Every step is a place to make a mistake or lose time.

The fix: auto-calculation. Enter the origin, destination, aircraft, and pax count. The system calculates distance, block time, costs, and pricing from your rate card. You review the margin. You send. Total time: 3–5 minutes.

5. The client experience

Your client receives a PDF attached to an email. They open it. It looks like every other charter quote PDF they've seen this week — a Word document exported to PDF, with your logo in the header and a table of numbers in the body. They compare it to three other quotes that look exactly the same. They make a decision based on price, because there's nothing else to differentiate.

The fix: a branded online quote page with a secure share link. Your client sees your logo, your colours, your terms. They see the itinerary, the aircraft, the line items — without the cost column. They click "Accept" or "Decline" right there. You get a notification. No more "did you get my email?" follow-ups.

What it actually costs

A 3-aircraft operator quoting 15 trips per week in Excel spends roughly 20 hours per week on quoting — that's half a full-time position. At $30/hour, that's $2,400/month in labour cost alone, before you count the trips lost to slow response times, the margins eroded by stale rate cards, and the clients lost to inconsistent pricing.

CharterQuote AI is $99/month. It's not cheaper than Excel — Excel is free. It's cheaper than the time, the errors, and the lost trips that Excel quoting actually costs you.

Stop quoting in Excel.

Join the CharterQuote AI waitlist. Beta is free for 3 months. Launch pricing is $99/month — flat, not per aircraft.

Join the waitlist