Home screen.
User's dashboard to add/delete expenses and access their settings.
Using AI to analyze and gain insights into your expenses.

Project Story: SpendFlow AI

Inspiration

In today’s fast paced world, many people struggle with keeping track of their expenses, leading to financial stress. Studies show that around 72% of Americans feel helpless when faced with financial challenges, while 80% of them face significant issues due to improper financial tracking. This inspired us to create SpendFlow AI, an expense tracker powered by AI that simplifies budgeting and helps users gain clarity over their finances.

Our goal with SpendFlow AI is to tackle 90% of financial challenges related to expense management. We wanted to build an intuitive platform that not only tracks expenses but also leverages AI to provide deeper insights and actionable recommendations.

What We Learned

Through this project, we gained significant knowledge in full stack development, working with the following key technologies:

Next.js enabled us to quickly set up a responsive and optimized UI.
Clerk was used for seamless user authentication, ensuring a secure login experience.
MongoDB provided a scalable solution for storing user expenses.
Prisma ORM simplified database interactions, allowing us to efficiently perform CRUD operations.
OpenAI API integration gave users AI powered insights into their expenses, transforming raw data into meaningful analysis.

Working on this project deepened our understanding of full stack development, database management, and AI integration.

How We Built SpendFlow AI

Frontend Development with Next.js: We began by setting up the basic UI using Next.js, focusing on creating an intuitive interface that works smoothly across both desktop and mobile devices. The flexibility and server-side rendering capabilities of Next.js made it ideal for building a modern, SEO-friendly web app.
Authentication with Clerk: User login and authentication were handled using Clerk, which allowed us to implement secure user management without building everything from scratch.
Expense Management with MongoDB & Prisma: For the core functionality, we used MongoDB to store expenses. Prisma was then used as the ORM (Object-Relational Mapping) tool to easily create, read, update, and delete expenses within a user's account.
AI-Powered Insights with OpenAI API: The integration of the OpenAI API was a major highlight of the project. By analyzing users’ expenses, the AI provides personalized insights and answers to common financial questions, giving users a closer analysis of their spending patterns.
Polishing the UI: Once the core features were built, we refined the user interface, ensuring a smooth and visually appealing experience. Special attention was given to mobile responsiveness to cater to users on the go.

Challenges We Faced & Solutions

Challenge 1: Database Issues

Initially, we faced difficulties in setting up a reliable connection between the backend and the MongoDB database. We resolved this by optimizing our Prisma schema and carefully managing our database connections to handle larger datasets effectively.

Challenge 2: API Integration

Integrating the OpenAI API presented hurdles in terms of ensuring accurate data analysis for different users. We improved the API's accuracy by adjusting our queries and fine-tuning the AI to better understand the expense data.

Challenge 3: Testing and Debugging

Throughout development, we encountered various bugs, especially when testing the app across different scenarios. By implementing automated testing for critical features and conducting rigorous manual testing, we ensured that the app's core functionalities worked as expected.

Challenge 4: UI Issues

Creating a responsive and seamless user experience was challenging, especially when ensuring compatibility across different devices. We tackled this by using Next.js’s built in CSS support and thorough testing to iron out UI inconsistencies.

Conclusion

Building SpendFlow AI was a rewarding experience. We’ve combined AI with modern web technologies to create a tool that empowers users to manage their finances effortlessly. As we continue to refine the app, we hope to make a meaningful impact by addressing the financial challenges faced by millions of people.