KharchaBook
Cashflow and financial operations platform for tracking income, expenses, recurring liabilities, and multi-account financial activity.
Overview
KharchaBook is a financial operations and cashflow tracking platform designed to manage real-world personal finance workflows including multi-account expense tracking, recurring liabilities, SIPs, EMIs, family transfers, and monthly cashflow visibility. The system focuses on operational financial clarity rather than bloated fintech-style features.
Problem
Traditional expense trackers and spreadsheet-based systems become unreliable as financial activity grows across multiple accounts, recurring obligations, cash transactions, and monthly liabilities. Most existing tools prioritize visual dashboards over accurate financial operations and low-friction transaction management.
Solution
Built a structured financial ledger platform with normalized accounting-safe architecture, recurring transaction workflows, category analytics, account-level visibility, and scalable transaction aggregation. The system was engineered for long-term maintainability, financial consistency, and rapid daily transaction logging.
Features
- Multi-account financial tracking across bank accounts and cash wallets
- Income, expense, and transfer transaction management
- Recurring liability engine for SIPs, EMIs, subscriptions, and bills
- Monthly cashflow summaries and spending analytics
- Category-level financial insights and trend analysis
- Protected financial data using Supabase authentication and RLS
- Migration-driven PostgreSQL schema management
- Responsive dashboard optimized for rapid transaction entry
- Transaction filtering, grouping, and searchable ledger views
- Financially consistent transfer workflows between accounts
Architecture
Frontend Architecture
Built using Next.js App Router with modular feature-driven architecture, server components, authenticated route protection, and reusable UI systems using shadcn/ui.
Database & Financial Modeling
PostgreSQL schema designed with normalized financial entities, relational consistency, indexed transaction flows, UUID-based entities, and migration-driven database management.
Authentication & Security
Supabase Auth integrated with row-level security policies to isolate financial data securely at the user level.
Recurring Transaction Engine
Designed recurring financial workflows capable of handling monthly liabilities, future due tracking, and scheduled transaction generation architecture.
Analytics Layer
Aggregation-driven analytics system for category breakdowns, monthly trends, spending analysis, and operational cashflow visibility.
Challenges
- Maintaining accounting consistency while supporting account-to-account transfers
- Designing recurring transaction systems without creating duplicate financial records
- Structuring scalable financial schemas while keeping transaction queries performant
- Balancing fast transaction entry UX with strict financial validation rules
- Implementing secure row-level financial isolation using Supabase RLS policies
Outcomes
- →Built a scalable finance operations platform with production-ready relational architecture
- →Reduced friction for daily financial tracking through optimized transaction workflows
- →Enabled operational visibility into recurring liabilities and monthly spending behavior
- →Established a migration-first backend workflow for long-term maintainability
Learnings
- Financial systems fail quickly when accounting consistency is treated casually
- Transaction speed and operational clarity matter more than feature-heavy dashboards
- Recurring financial workflows introduce significant complexity in state management and aggregation logic
- Well-designed relational schemas dramatically simplify analytics and reporting layers
Next project
PlantArk