E-TRAVEL.SK, s.r.o.

About the client

E-TRAVEL.SK, s.r.o. is a Slovak travel agency headquartered in Varín that prepares tailor-made programs for its customers — from booking accommodation and transport, through contract preparation, to final billing. The central working tool of the consultants was an Excel sheet “Rozpisy” (Schedules), which combined data on workers, guides, and clients. Alongside it ran the Omega accounting system and the external Bokun reservation system — all three without any automated mutual linkage.

The challenge

The “Rozpisy” Excel sheet became a bottleneck — duplicate data entry, a high error rate, and no audit trail:

• Each change in the schedule required manual updates of multiple cells and tables
• Invoices, proforma invoices, and orders were generated manually outside Excel — without a link to the schedule
• Orders from the Bokun reservation platform were transferred to internal records manually
• Data from Omega accounting were not synchronized with the schedules and invoicing
• Guides received lists of their schedules by email, which someone had to prepare manually
• Documents needed to be issued in both Slovak and English, which meant additional manual rekeying

The solution

Modulario implemented a system covering 10 use cases within the scope of Annex No. 3 Specification of the Work, delivered within 3 months of contract signing:

Functional modules

• Schedules module — the original Excel sheet split into multiple interconnected data structures with input validation, intuitive table and modal display by role (worker, guide), and the option to send a guide an email with selected schedules
• Invoices, proforma invoices, and orders module — generation of documents in the order Order → Proforma invoice → Invoice, matching of documents to schedules, issuing a document based on selected rows in the schedules, drag & drop ordering of line items, automatic data filling from enumerations
• Documents in two languages — generation in Slovak or English
• Enumerations module — prepared from the original Rozpisy Excel, with automatic update of dependent records and integrity checks
• Charts and statistics module — selection of time period, report generation, export to PDF/Excel
• Email module — predefined text templates (up to 10 different types), automatic attachments, sending to the recipient
• User and permission management — access by role

External integrations

• Omega — bidirectional automated transfer of accounting data with validation and conflict resolution
• Bokun — one-way integration (orders only) with automatic download of orders to the internal system

Migration and training

• Data migration from the original system (export, transformation, cleaning, import) with integrity verification
• Operator training for the consultant team