Offline-First Personal Finance App

A full-stack offline first solution with modern design and seamless user experience.

Project Overview

This project is a privacy-focused, offline-first personal finance web app designed to help individuals and families manage income, expenses, debts, savings, and budgets across devices. Built with modern technologies like React, TypeScript, and SQLite via WebAssembly, it offers full offline functionality with seamless syncing to Google Sheets using Google Apps Script.The app addresses common pain points in traditional budgeting tools such as limited platform support, lack of data ownership, and risk of data loss by giving users complete control over their financial records. With a clean, user-friendly interface and support for AI powered natural language insights, the app is designed to be accessible, responsive, and tailored to real world needs. Whether working solo or sharing finances with family, team, users can confidently track their financial journey online or offline.

Key Features

Offline-First with WebAssembly + OPFS + SQLite
Progressive Web App (PWA) for cross-platform support
Google Sheets sync via Google Apps Script
AI-Powered Budget Queries using Local & Cloud LLMs
Local Data Storage with Full Ownership
Optional Multi-User Collaboration via Shared Sheet
No Centralized Backend Required
Import & Export Capabilities (CSV/JSON)

Problems

Requires constant internet connection to access data
Stores financial data on third-party servers
Charges subscription fees for basic budgeting features
Limited ability to collaborate with partners or family members
No easy access to raw or exportable financial data
Risk of data loss during device changes or app uninstalls
Locked into vendor ecosystems with little flexibility

Goals

Make it offline-first, so users can access and manage their finances anytime, even without internet.
Ensure data privacy and ownership by storing everything locally, with no third-party dependency.
Support optional syncing and collaboration using simple tools like Google Sheets.
Build it as a Progressive Web App (PWA) so it works across devices without needing to go through app stores.
Keep the design simple and user-friendly, with a clean interface anyone can understand.
Add smart insights with AI that feels helpful—but also respects user privacy.

My Roles

UX Researcher, UX Designer,Frontend Developer

Frontend Developer

Translated Figma prototypes into reusable React components using TypeScript.
Implemented responsive, accessible, and performant UI elements aligned with the design system.
Integrated service workers and offline storage (SQLite via WebAssembly) to support offline-first functionality.
Worked cross-functionally with backend and AI teams to connect UI with data syncing and AI-powered features.

UX Researcher

Conducted user research to understand pain points, needs, and behaviors related to personal finance apps.
Performed competitive audits to analyze existing solutions, identify gaps, and gather best practices.
Synthesized research findings into actionable insights to guide design and development decisions.
Created user personas and journey maps to keep the team focused on real user goals.

UX Designer

Designed wireframes and interactive prototypes based on user research and product requirements.
Iterated on designs with user feedback to improve usability and accessibility.
Developed clear information architecture and intuitive user flows for both offline and online experiences.
Collaborated closely with stakeholders to ensure design met both user needs and business goals.