CASE STUDY — INBOUND TOUR OPERATOR

How can an inbound tour operator bring arrangements, fax and billing into one business system? A Tokyo ground operator

Updated

Bringing enquiries through quotation, operation and settlement into one business system, and letting staff create documents for hotels and bus companies on screen and send them by fax, is removing the re-keying between paper, Excel and an old in-house database. SEISEI INC. (心享勢成株式会社) handles requirements, build and production operation of this system for a Tokyo ground operator (land operator) serving visitors to Japan.

What was the problem?

  • Enquiries, quotations, arrangements and settlement were split across an old desktop database, Excel and paper
  • Orders and hotel notices were filled into forms, sent by fax, and the replies were noted by hand
  • Matching receipts, refunds, supplier bills and guide expenses tour by tour took a lot of effort
  • Staff and customers worked in different languages, including Japanese, Chinese and English

How was it built?

Foundation

Odoo 18 Community Edition (Python, PostgreSQL), with custom modules for each area of the business. Customer-facing screens use Next.js. It runs in Docker, with a single reverse proxy as the only public entry and the database not exposed. Changes are released only after GitHub Actions tests pass.

From enquiry to tour

Information carries over from enquiry to quotation to tour. A tour moves through draft, confirmed, final, settled and closed. It holds the daily itinerary, cost categories, the passenger list and reusable product templates.

Hotel notices, orders and fax

Hotel notices (new, change, cancellation), bus orders and supplier requests become PDFs on screen. When staff press “Send by fax”, the document goes out through an internet-fax service’s API. The send history is then queried on a schedule, and delivery or failure is recorded. The PDF sent is attached to the tour record. Nothing is sent unless staff press Send, and fax records and PDFs are visible only to operators and managers.

Hotel replies

Hotel replies are recorded on each night’s stay with statuses such as requested, waiting, OK, NG and on hold.

Billing and settlement

Receipts and refunds (multi-currency), supplier bills, the settlement ledger and guide expenses are managed, and accounting journal entries are created from them. Japan’s qualified-invoice registration-number format check and the 10% / 8% split are supported.

Where AI is used

AI (Anthropic Claude, Google Gemini) drafts tour itineraries and quotations and imports product templates from Word files. Coupon receipts photographed by guides are read by AI as candidates, and the guide confirms them. Receipt reading has a retry limit and a daily ceiling.

Which results can be checked?

To respect confidentiality with the client, the company name, screens and figures are not published. The facts below can be checked in the system’s implementation. Volumes and time saved are not stated.

ItemCurrent state
Business systemIn production (Odoo 18, custom modules)
Hotel notices and ordersCreated as PDFs on screen
Fax sendingImplemented. Sends only when staff press Send; delivery status is queried and recorded automatically
Billing and settlementJournal entries created from receipts, refunds, supplier bills and guide expenses
AIItinerary and quotation drafts, template import, coupon-receipt reading (all confirmed by a person)
Screen languagesSeven languages in the back office, including Japanese, Chinese and English

Frequently asked questions

Are faxes sent automatically?

No. A fax goes out through the internet-fax service’s API only when staff press “Send by fax”. After that, delivery status is queried and recorded automatically.

Why Odoo?

It already connects enquiries, quotations, arrangements, billing and accounting on one data model, so only the business-specific parts had to be added as custom modules.

Does AI decide the quotation?

No. AI only drafts the itinerary and quotation. Staff check and decide the content and amounts.

Can this be built for a similar operator?

Yes. We start by reviewing your current workflow and forms and deciding what goes live first. Fees are quoted individually.

Sources you can check

Related pages

Get in touch

If arrangements, fax and billing are split across tools in your agency, tell us how it works today. Write to ceo@seisei.tokyo.