-
-
This page allows users to add their daily expenses manually or upload a CSV bank statement.
-
Sample_Output [1]
-
Sample_Output [2]
The idea for SpendWise came from a very common problem that almost every student and young professional faces — keeping track of daily expenses. Small, unplanned purchases like snacks, cab rides, or online subscriptions often pile up and by the end of the month, it becomes difficult to understand where the money actually went. This everyday struggle inspired me to build a tool that could make expense tracking effortless, insightful, and even a little fun.
To bring this idea to life, I designed a simple web app using Python and Flask as the backbone. The system allows users to either add their expenses manually through a clean form or upload CSV/Excel bank statements directly. With the help of Pandas, the data is preprocessed and stored securely in an SQL database. Once structured, the data comes to life through a Power BI dashboard that displays category-wise spending, monthly savings, and even budget alerts. The frontend, though minimal with HTML and CSS, ensures smooth interaction and keeps the focus on insights rather than complexity.
Building SpendWise was a valuable learning journey. I gained hands-on experience in preprocessing messy financial data, embedding Power BI into a Flask-based application, and designing a full data pipeline that connects input, storage, processing, and visualization seamlessly. I also realized how important it is to design user-friendly systems when working with finance-related tools, since clarity and simplicity make adoption much easier.
Of course, the journey wasn’t without challenges. Different banks have different CSV/Excel formats, so parsing inconsistent headers and columns was tricky. Categorizing expenses into groups like Food, Travel, Shopping, and Bills required designing a logical, automated system. Embedding Power BI smoothly into Flask also took some extra effort. However, overcoming these obstacles was rewarding because it made the solution stronger and more practical.
In the end, what I am most proud of is that SpendWise turned into a complete working solution within the hackathon timeframe. The app not only tracks expenses but also provides meaningful insights that can genuinely help people manage their money better. Looking ahead, I plan to integrate AI-powered financial tips, real-time UPI or Google Pay connections for automatic tracking, and a mobile app version to make SpendWise even more accessible and powerful.
Log in or sign up for Devpost to join the conversation.