Custom Booking Management System
Developed a comprehensive booking and customer management system for a growing tourism company, featuring online reservations, payment processing, and automated confirmations.
Project Overview
Connectra's IT team designed and built a fully custom booking management system for a fast-growing tourism company in Rwanda. The platform replaced a fragmented workflow of spreadsheets, WhatsApp messages, and manual payment tracking with a unified, automated system that handles the entire booking lifecycle.
Platform Architecture
Built on Laravel 10 with a Vue.js 3 frontend, the system follows a modular architecture designed for scalability. The backend uses a RESTful API pattern, allowing future integrations with third-party platforms like TripAdvisor and Booking.com. The database layer (MySQL) is optimized for complex availability queries, supporting real-time seat/room availability across multiple tour packages simultaneously.
Key Features
The booking engine features real-time availability calendars, dynamic pricing (seasonal rates, group discounts, early bird offers), multi-currency support (RWF, USD, EUR, GBP), and a multi-step checkout optimized for mobile devices. Payment processing integrates both mobile money (MTN MoMo, Airtel Money) and international card payments via Stripe, with automatic receipt generation and confirmation emails.
The CRM dashboard provides the client with a 360-degree view of each customer — booking history, communication logs, preference notes, and lifecycle analytics. Automated email sequences handle booking confirmations, pre-trip checklists, post-trip feedback requests, and re-engagement campaigns for past customers.
Admin Dashboard
A comprehensive admin panel allows the client's team to manage tour listings, view real-time booking analytics, process refunds, generate financial reports, and configure automated marketing campaigns. The dashboard features role-based access control, audit logging, and exportable reports in PDF and Excel formats.
Performance & Reliability
Deployed on AWS with CloudFront CDN, the platform achieves sub-2-second page loads globally and maintains 99.8% uptime. Automated database backups run hourly, with disaster recovery procedures tested quarterly.
Challenges
Mobile Money Integration
Rwanda's primary digital payment method is mobile money (MTN MoMo). Integrating with their API required navigating complex documentation, sandbox testing, and handling asynchronous payment confirmations reliably.
Multi-Currency Pricing
Tours are priced in USD but customers pay in multiple currencies. We built a real-time exchange rate engine that updates daily and handles currency conversion transparently during checkout.
Migration from Spreadsheets
The client had 3 years of booking data in scattered spreadsheets with inconsistent formatting. We developed custom data migration scripts and validated every record manually.
Our Solutions
Robust Payment Pipeline
We built a webhook-based payment confirmation system with retry logic and manual reconciliation tools, ensuring zero payment losses even during MTN API downtime.
Smart Currency Engine
An automated exchange rate service pulls rates from the Central Bank of Rwanda daily, with admin override capability for custom promotional rates.
Automated Data Migration
Custom Python scripts cleaned, normalized, and imported 15,000+ historical records with 99.7% accuracy, preserving all customer relationships and booking histories.
Key Results
Technologies & Services
Client Testimonial
"Before Connectra built our booking system, we were drowning in spreadsheets and WhatsApp messages. Now everything is automated — from booking to payment to follow-up emails. Our team can focus on delivering great experiences instead of chasing paperwork. The system paid for itself within three months."
Project Details
Quick Stats
Tags
Want Something Similar?
Let Connectra deliver the same quality and professionalism for your project.
Contact UsRelated Projects
Network Infrastructure Setup
Designed and deployed network infrastructure including LAN/WAN setup, WiFi coverage, and server configuration for educational institutions across Rwanda.
E-Commerce Website Development
Built modern e-commerce platform with product catalog, shopping cart, secure payments, and inventory management for a growing local retailer.
Software Maintenance Contract - NGO Network
Annual IT maintenance contract providing software updates, system monitoring, and technical support for a network of NGOs across Rwanda.
Have a Project in Mind?
Let's transform your vision into reality. Connectra delivers smart, integrated solutions tailored to your needs.