A highly sophisticated, locally hosted, AI-accelerated Personal Finance and Ledger Management Application built for high productivity, real-time analytics, and uncompromised financial tracking.
Featuring an innovative dual-tier AI Architecture, the platform utilizes ultra-fast local inference (llama3.2:1b) for instant expense parsing and cloud inference (Google Gemini) for advanced multi-dimensional chat intelligence—while natively guaranteeing 100% data security and quota optimization.
- Annual Spending Trends: Dynamic bar charts graphing current year income vs expense flows.
- Categorical Proportions: High-fidelity Doughnut visualizations breaking down spending metrics.
- Top 5 Single Expenses: Autonomous leaderboard sorting out your highest outlays for the period.
- Automated Due Date Feed: Directly highlights custom recurring card statement deadlines and EMI due days.
- Configured Accounts Grid: Support for native Archetypes (
Cash,Wallet,Bank,Credit Card,Loan). - Real-Time Configuration Override: Dedicated inline Edit (✎) trigger controls letting you instantly recalibrate Names, Limits, Destinations, Tenures, and Reminders natively.
- Loan Foreclosure Engine: Negotiate and input final settlement agreements. The platform dynamically records the cash settlement alongside non-cash Foreclosure Interest Waiver logs, marking your remaining balance to
₹0while retaining unfragmented traceability. - Flat-Fee Inter-Account Transfers: Move money smoothly between configured accounts with decoupled destination tracking and instant optional flat Gateway transaction fee deduction records.
- Cascading Ledger Protection: Safe account deletions (
✕) autonomously drop related log subsets to prevent dangling balances.
- Network Cards: Tracks unique contacts automatically extracted from your historical
Lent OutandBorrowedfeeds. - Live Net Balances: Instant calculations detailing net owed balances (
Owes You: ₹XorYou Owe: ₹Y). - Interactive Action Triggers: Quick Settle / Repay and + More flows auto-calculating exact settlement fractions.
- Automated Entity Defragmentation: Natively reconciles fragmented initialism inputs (e.g., rolling up
"K"entries into"Kanha") automatically across view cards and LLM summary context. - Liquid-Isolated Baseline Logging: Register existing debts seamlessly without deflating visible cash liquidity totals.
- Global Data Hub: View unified master logs supporting simultaneous filter options by Type, Category, Target Context, and Date Ranges.
- Native Inline Record Editors: Fully update pre-existing transaction amounts, categories, labels, and timestamps on the fly.
- Global History Auto-Completion: Query-backed
<datalist>dropdown engines for fast field inputs matching historical strings while shielding against database typos. - Unified Custom Categories: Fully mutable standard and personal categories stored persistently in your local database array.
- Consistent Premium Typography: Uppercase string short-month date renderings globally (
13 MAY , 2026).
- Local Feed Intake (
Ollama): Configured to parse real-time quick inputs via deterministic models (llama3.2:1b) ensuring local zero-latency runtime bounds. - Global Context Advisor (
Google Gemini): Formulates deep answers over aggregated account subsets while respecting local currency rules (₹ exclusively) and complete identity string preservation.
The platform completely separates public open-source JavaScript logic from confidential API secrets:
.gitignoreHardening: Explicitly protects private local.envkeys from appearing in Git branches.- Dynamic Backend Proxy: A pure server PHP router (
api/env.php) scans, cleanses, and maps configuration settings securely to client window memory on handshake.
- PHP Server Environment: XAMPP, WAMP, or equivalent stack with MySQL / MariaDB.
- Ollama Client (Optional): Installed locally if you wish to run
llama3.2:1bauto-feed parsing natively.
git clone https://github.com/yourusername/expenses-tracker.git
cd expenses-trackerCopy the public configuration template file to initialize your private setup parameters:
cp .env.example .envOpen .env in your code editor and populate your Google Gemini Token:
# Active Google Gemini API Configuration
GEMINI_API_KEY=your_actual_google_gemini_api_key_here- Open phpMyAdmin (
http://localhost/phpmyadmin/). - Create a blank database named
expenses_tracker. - Select the database, click the Import tab, and upload the pre-packaged
setup.sqlfile located in the project root directory.
Start your local Apache and MySQL instances inside your server manager dashboard, and visit:
http://localhost/Expenses/
(Adjust the directory sub-path based on your root htdocs or public directory structure).
Distributed under the MIT License. Open-source pull requests, optimizations, and feature expansions are fully welcome! Feel free to branch, customize, and fork to elevate personal finance management.