Interactive Dashboard–Based Analysis of Personal Financial Transactions for Budget Control and Savings Enhancement

Abstract

Personal financial management has become increasingly complex due to the rapid growth of digital payments and diverse spending channels. Individuals often struggle to track expenses, understand spending behaviour, and maintain consistent savings. This paper presents an interactive dashboard–based analytical framework for personal financial transaction analysis aimed at supporting effective budget control and savings enhancement. The proposed system integrates a relational database for structured data storage, spreadsheet-based preprocessing for data refinement and indicator computation, and a business intelligence platform for real-time interactive visualization. The framework enables users to explore category-wise expenses, payment mode patterns, monthly trends, and savings performance through intuitive dashboards. Experimental evaluation demonstrates that the proposed system significantly improves visibility of financial behaviour and supports informed decision-making for sustainable financial planning.