Inspiration

Managing personal finances often feels like a part-time job. Between downloading CSVs from different banks, tracking physical receipts, and trying to understand complex investment statements, most people give up before they even start. As someone deeply passionate about finance and the markets, I personally manage my own portfolio and know first-hand how fragmented financial data can be. I built FinanceFlow to bridge the gap between "messy data" and "actionable wealth." My goal was to create a tool that doesn't just show you numbers, but understands them, giving users the same clarity I strive for in my own investment journey.

What it does

FinanceFlow is an all-in-one financial ecosystem that leverages the power of the Google Gemini API to automate the most painful parts of money management. Intelligent Data Ingestion: Upload a Bank Statement PDF, and FinanceFlow extracts every transaction while automatically identifying upcoming bill due dates. Investment Benchmarking: Upload your brokerage portfolio PDF, and our AI analyzes your risk level, compares your holdings to industry benchmarks, and suggests optimization strategies. Omni-Channel Tracking: Whether it's a physical receipt (scanned via Gemini Vision), a CSV file (auto-mapped via AI), or an PDF file, FinanceFlow captures it all. AI Financial Coaching: Context-aware insights that help you visualize future wealth. See how an extra $100/month grows over 10 years using the compound interest formula: $$A = P \left(1 + \frac{r}{n}\right)^{nt}$$ Secure by Design: Powered by Better Auth, ensuring your sensitive financial data is protected with industrial-grade authentication.

How we built it

Architecture: A full-stack TypeScript application with a React 19 frontend and a Node.js/Express backend. Frontend: Styled with Tailwind CSS for a sleek, modern, and translucent aesthetic. Visualizations are powered by Recharts, providing dynamic Area and Pie charts. Intelligence Layer: We integrated multiple next-generation Gemini models: gemini-3-flash-preview: For lightning-fast CSV header mapping, transaction categorization, and instant financial insights. gemini-3-pro-preview: For complex, high-reasoning tasks like bank statement PDF parsing, investment portfolio analysis, and deep financial coaching. Persistence: MongoDB with Mongoose ensures high-performance data storage, while Better Auth handles complex Google OAuth flows seamlessly.

Challenges we ran into

The "Unstructured Data" Problem: Bank statements come in thousands of different formats. We spent significant time prompt-engineering Gemini to reliably extract tabular data from raw PDF text without losing precision. Asynchronous Syncing: Ensuring that local state remained synchronized with the server-side Better Auth session across page refreshes required a robust React context and custom hook architecture. UI/UX for Finance: Finance apps can be overwhelming. We focused on "micro-animations" and "gamified insights" to make the dashboard feel alive and encouraging rather than stressful.

Accomplishments that we're proud of

Seamless Data Fusion: We are incredibly proud of how FinanceFlow handles data from multiple sources. Being able to take a messy brokerage PDF and a grainy receipt photo and turn them into a unified financial picture feels like magic. Polished User Experience: We built a high-end, responsive dashboard that doesn't just look good—it provides real utility. The combination of glassmorphism design with real-time AI insights created a premium feel that we're thrilled with. Robust Security Integration: Successfully implementing Better Auth with all its complexities (session management, persistent logins) was a major milestone for us, ensuring that user data is handled with the care it deserves.

What we learned

LLMs as Data Parsers: We learned that LLMs are surprisingly effective at transforming "dirty" data (like poorly formatted CSVs) into structured JSON when provided with the right context. Authentication Complexity: Integrating a full-scale auth framework like Better Auth taught us the nuances of session management, CSRF protection, and secure cookie handling.

What's next for FinanceFlow

Direct Brokerage Integrations: Moving beyond PDF uploads to real-time sync with platforms like Robinhood, Fidelity, and Yahoo Finance to track portfolio progress automatically. Predictive Analytics: Using historical spending to predict future cash flow dips. Collaborative Budgeting: Multi-user accounts for families and small businesses.

Share this project:

Updates