A comprehensive database is designed for managing various partners, including individuals, businesses, travel agencies, and corporate clients, enabling effective oversight of both online and offline reservations, tracking booking statuses, service categories, commissions, and service fees, as well as managing statements, invoices, travel documents, and reports. This system allows for the importation of bookings from reservation platforms via API/XML, with the capability to export data in formats such as XML, Excel, and PDF. Furthermore, invoices can be generated automatically when payments are made online or triggered by specific events, with the ability to print sales invoices, export them to PDF, or effortlessly send them via email. The system also ensures that collections are accurately associated with their corresponding invoices, and it allows for the registration of purchase invoices linked to bookings through settlements. Payments are systematically aligned with invoices, while travel documents like vouchers and airline tickets are automatically created for printing or emailing. Additionally, all elements, including booking items, sales and purchase invoice items, collections, and payments, are integrated through a streamlined settlements process. This interconnected framework not only enhances efficiency but also improves overall user experience by simplifying transaction management.