International Journal of Science, Engineering and TechnologyAuthors: Dr. Rajkumar, Vipin Kushwaha, Vasu Aggarwal, Vishal Singh, Ujjawal Charnotia
Abstract: Effective personal financial management is a critical life skill that many individuals struggle to practice consistently. Conventional approaches such as paper ledgers and basic spreadsheet files are error-prone, difficult to analyze, and inadequate for modern financial needs. This paper presents the design, implementation, and evaluation of a web-based Expense Tracker Application intended to help users record, categories, and visualize their daily financial transactions in a structured and user-friendly manner. The proposed system is built on a three-tier architecture comprising Angular 14 on the client side, ASP.NET Core on the server side, and a MySQL relational database for persistent data storage. Communication between the front-end and back-end layers is facilitated through RESTful Application Programming Interfaces (APIs) transmitted over the Hypertext Transfer Protocol (HTTP). The application supports secure user authentication using JSON Web Tokens, category-based expense classification covering food, transportation, entertainment, utilities, and shopping, and dynamic report generation through interactive charts and tabular summaries. The system was designed with responsiveness in mind to perform consistently across desktop computers, laptops, tablets, and mobile devices. The study adopts the Software Development Life Cycle (SDLC) model encompassing requirements analysis, system design, implementation, and systematic testing. Evaluation results demonstrate that the proposed application significantly simplifies personal budgeting, enhances financial awareness, and addresses key limitations of commercially available tools. The paper further discusses the system architecture, database design, API structure, security mechanisms, and future enhancement directions.
