Udom Delivers AI Consulting to Earth Travel Mito, Streamlining Data Reconciliation

In an era where efficiency is crucial, Udom Co., Ltd., located in Mito City, Ibaraki Prefecture, has set a new standard by providing innovative AI consulting services to Earth Travel Mito Co., Ltd. This partner company focuses on experiential travel business and has benefited from a significant reduction in time spent on data reconciliation tasks. By leveraging cutting-edge generative AI technology, Udom has managed to cut the time spent on these tasks from several hours down to just two minutes, achieving remarkable results in less than a month since the project’s initiation in April 2026.

Background and Objectives: Breaking Free from Manual Reconciliation

Udom recognized the pressing need for organizations to evolve away from outdated manual processes. With the rapid advancements in generative AI, the consulting firm has made it its mission not just to develop systems but also to foster a culture within organizations that embraces AI capabilities. Earth Travel Mito specializes in planning and operating educational trips and experiential learning programs, collaborating with over 100 local businesses in agriculture, tourism, welfare, and manufacturing across Ibaraki Prefecture. Their programs aim to reduce the administrative burden on teachers while offering students the freedom to choose experiences that pique their interests.

Previously, the manual reconciliation process for confirming payment data from guardians against various formats of student rosters (including paper, PDF, and Excel) was a time-consuming and mentally taxing ordeal. For efficiency improvements, Udom targeted this significantly burdensome task first in their consulting strategy.

Solution: Automating Data Extraction and Reconciliation with Google Workspace Studio

To tackle this challenge, Udom adopted the recently released Google Workspace Studio, available to all users with a Google account since March 2026. The strategy incorporated several essential components:

1. Reading Non-Standard Data: Utilizing Gemini, the AI accurately extracts necessary information from rosters whose layouts vary considerably, including PDFs and images.
2. Advanced Automatic Matching Logic: By employing Google Apps Script (GAS), the system automates matching while considering factors such as the presence or absence of furigana (phonetic characters) and discrepancies in Kanji representation.
3. Cost-Effective and Rapid Implementation: Constructing the tool on the existing Google Workspace framework, the project curtails the need for substantial investments, completing the shift from development to operation in a mere one month.

As a result, the formerly tedious task of reconciling files was transformed dramatically; now, users only need to place two files in a designated folder, and the task is finished within minutes, all while achieving enhanced accuracy and operational speed.

Future Prospects: Expansion into Accounting and Project Management

The collaboration between Earth Travel Mito and Udom doesn't stop here. Future plans include streamlining accounting tasks such as automated invoice and receipt generation, enhanced project management systems integration with calendars, and the automatic creation of itineraries and estimates. This initiative represents a pivotal push toward greater digital transformation (DX).

Udom aims to address similar challenges faced by various businesses handling “regular yet complex administrative tasks” through their generative AI consulting services, ultimately contributing to productivity improvement for local enterprises.

About Earth Travel Mito Co., Ltd.

Founded with the vision of connecting children with local people, nature, and culture, Earth Travel Mito provides experiential and educational travel programs centered on the concept of “Astabi” (Traveling to Live Tomorrow). The company aims to ignite children’s passion for learning through engaging, hands-on experiences.

About Udom Co., Ltd.

Established in 1976, Udom has grown into a prominent IT firm based in Mito City, Ibaraki Prefecture, upholding a mission to contribute to local communities through technology. With plans to exceed 500 employees by 2025, Udom continually strives for progress by supporting local infrastructure and business transformations through innovative system development.

Google, Google Workspace, and Google Apps Script are trademarks of Google LLC.