DESIGNING A WEB APP TO MANAGE TRAVEL EXPENSES WITH SQL BACKEND

Abstract

Managing travel expenses is critical for both individuals and organizations, involving the tracking of costs, receipts, reimbursements, and budget adherence. The traditional system relies heavily on manual data entry and physical receipt handling, which are time-consuming and prone to human error. Additionally, these methods lack real-time data sharing, multi-user accessibility, and comprehensive reporting capabilities. The limitations of traditional expense management systems include their inability to scale, delayed processing times, and increased likelihood of errors and data loss. These systems do not support automated data processing or remote access, making it difficult for users to manage expenses efficiently and transparently. Therefore, this research develops a user-friendly web app that can streamline the process of managing travel expenses and offers real-time data entry, automated receipt processing, remote access, and multi-user functionality, significantly reducing administrative overhead and improving data accuracy. The significance of designing a web app with an SQL backend lies in its ability to provide a robust, scalable, and efficient solution for travel expense management. An SQL backend ensures reliable data storage and management, while the web interface allows for accessible, real-time interaction with the system. This integration not only enhances data accuracy and accessibility but also supports better financial oversight and decisionmaking. By transitioning to a modern, integrated web-based system, users can benefit from streamlined operations, reduced manual workload, enhanced compliance with financial policies, and improved overall efficiency in managing travel expenses