How to organize your rate sheets and supplier information before automating quotes

To automate quotes at an inbound travel agency or DMC, each rate first needs to live in a single place, with the same structure, along with its validity, its conditions and the person responsible for updating it. That data-organizing work is not visible in the final quote, but it determines whether the system will quote accurately or just produce, faster, numbers that someone still has to check.

When implementing quoting systems, what takes the most time is almost never generating the answer. The challenge is the information behind it: many rate rules, a lot of supplier information and, almost always, everything scattered across spreadsheets, emails, WhatsApp chats and PDFs. This guide proposes an order of work to sort out that foundation before and during automation.

Why data comes before automation

A quoting engine, with or without artificial intelligence, applies rules to the data it receives. If a rate is expired, duplicated or has an exception written in a free-text note, the system is not going to guess it. As we explain in why a chat layer on top of your current system won't quote accurately, faster writing does not fix a price that was loaded wrong. And since suppliers renew rates and send exceptions mid-season, getting organized is an ongoing process with owners and rules, not a one-off cleanup.

Step 1: take an inventory of sources

Before moving a single piece of data, you need to know where it is. A simple inventory answers three questions for each source:

• What does it contain? Hotel rates, excursions, transfers, guides, entrance tickets, payment terms.
• What format does it arrive in? In-house spreadsheet, supplier Excel file, PDF, email with a negotiated price, WhatsApp message.
• Who uses it today? Which team member looks it up when quoting, and whether they keep their own copy.

It is common to discover the same rate in several places with different values at this stage. That finding determines which source is treated as valid.

Step 2: define a single structure per service

Every service should be described with the same fields, no matter which supplier it comes from. A minimum structure includes:

• Supplier: a single name, with no variants or different abbreviations.
• Service: exactly what is being sold (for example, standard double room, private airport–hotel transfer).
• Season and validity: start and end dates, not just "high season."
• Rate type: net or commissionable, and the commission percentage where applicable.
• Passenger basis: per person, per room, per vehicle or per group, with the passenger ranges that change the price.
• Currency: the supplier's currency, kept separate from the currency the client is quoted in.
• Conditions and exceptions: minimum nights, supplements, children, cancellation, non-operating days.

The details of each variant by service type are in the guide to rate types in inbound tourism.

Exceptions are data, not comments

If a condition changes the price, it has to live in a field, not in a note. "Except public holidays" or "commissionable only in low season" are business rules; as free text, nobody applies them consistently. We go deeper into this in AI, rates and business rules.

Step 3: agree on names and versions

Without naming conventions, duplicates come back even after they have been cleaned up. It is worth defining:

• An official name for each supplier and service, and a list of equivalents for the names each person uses.
• A way to identify the version of each rate sheet (for example, supplier + season + date received).
• What happens to the previous version: it is archived, not deleted, so you can trace where an already-sent quote came from.

Step 4: assign update owners

Each supplier or group of suppliers needs one person responsible for three things: receiving the new rate sheet, loading it with the agreed structure and retiring the previous one.

A calendar of renewals and upcoming expirations also helps. In how to structure the quoting department there is more on how to split these tasks across the team.

Common pitfalls when organizing rate sheets

• Exceptions hidden in notes. The price is loaded correctly, but the condition that changes it sits in a comment nobody reads when quoting.
• Expired rates that are still active. If there is no end date, last year's rate stays available and gets used without warning.
• Duplicates with different values. The same service loaded twice, with slightly different names and prices that do not match.
• Prices that only live in PDFs. Every quote means opening the document and transcribing by hand.
• Deals made over WhatsApp or email without being recorded. A special rate that never gets linked to the supplier or its validity.
• Converting currency when loading. The original figure is lost and the exchange rate gets locked in without anyone deciding it.

Organize during automation, not just before

You do not need one hundred percent of your rate sheet cleaned up to get started. A practical approach is to pick the most frequently quoted services and suppliers, organize them first and test automation on them. Whatever is missing should show up as pending, not as an estimated price. That principle, which we also cover in what AI can and cannot automate in a travel quote, turns every gap into a concrete loading task.

Checklist before automating quotes

• Inventory of all sources of rates and supplier information.
• One source defined as valid for each rate.
• A single structure per service: supplier, service, validity, rate type, passenger basis, currency and conditions.
• Exceptions that change the price loaded as fields, not as notes.
• Every rate with a start and end date.
• Official supplier and service names, with no duplicates.
• Versioning criteria and archiving of previous rate sheets.
• Update owner and calendar for each supplier.
• Priority services identified to start the test.

How Outtrip approaches this work

Outtrip is AI-powered software for DMCs (Destination Management Companies) and inbound travel agencies. It centralizes rates, business rules and supplier information, and on that foundation automates quotes, itineraries, bookings and client communication. It operates in Latin America and Spain, and is implemented through a pilot on each agency's real operation.

In that pilot, organizing the information is part of the implementation: the work is done on the agency's real rate sheets and suppliers, not on sample data. If you want to see how it would look with your own rate sheet, you can request a demo or a pilot.