Book & Go Portal - Travel Agency Operations & Invoicing Engine

Book & Go Portal: Travel Agency Operations & Invoicing Engine

Problem & Operational Context

Regional travel agencies handle complex booking arrangements spanning multi-city flight segments, hotel reservations, and custom group tour packages. Managing these itineraries manually across disjointed spreadsheets frequently leads to pricing errors, unrecorded currency exchange discrepancies, and delayed voucher issuance.

I was the sole developer responsible for designing and implementing Book & Go Portal as a centralized operational platform for Book & Go Egypt. It consolidates booking workflows, passenger list manifests, supplier cost tracking, and automated multi-currency tax invoicing into a structured NestJS management system.

Architectural & Technical Implementation

1. Modular NestJS Architecture

The backend is structured into decoupled domain modules:

• BookingsModule: Manages travel reservation lifecycles, confirmation statuses (Draft, Confirmed, Voucher Issued, Cancelled), and room allocation rules.
• FinanceModule: Handles multi-currency pricing, exchange rate snapshots at booking time, and customer invoice calculations.
• CustomersModule: Maintains passenger profiles, passport details, and historical travel records.
• VouchersModule: Automates the generation and delivery of bilingual travel vouchers.

2. Multi-Currency Financial Ledger & Invoicing

Travel bookings often require quoting in USD or EUR while collecting payments and generating tax invoices in EGP. To prevent accounting drift:

• Exchange rates are locked at the time of quotation and stored immutably on the booking record.
• Invoicing utilities calculate subtotal, seasonal surcharges, and applicable taxes with strict rounding rules.
• Generates bilingual Arabic/English tax invoices with structured line items and payment milestone tracking.

3. Server-Side PDF Document Pipeline

Built a dedicated document compilation pipeline for travel vouchers and official invoices:

• Formats passenger itineraries, flight numbers, hotel check-in dates, and payment summaries into clean, printable A4 layouts.
• Handles Arabic text shaping and Right-to-Left (RTL) character ordering correctly so customer documents render cleanly across devices.

Technical Challenges & Trade-offs

• Exchange Rate Snapshots: Floating market exchange rates required storing the exact conversion rate and timestamp on each invoice item rather than recalculating from live rates at query time.
• Relational Integrity in Booking Schedules: Group bookings involve one-to-many passenger relationships and multi-leg flights. Used Prisma ORM schema relations with cascade deletion rules to ensure no orphaned booking records.

Related Resources

• Technologies: NENestJS, TYTypeScript, PRPrisma ORM, MOMongoDB
• Direct Contact: Contact Me