Finventory
Personal finance for the Indian market, built up from a ledger.
A Django REST API and a React 19 app that cover 22 investment types, 11 liability types, goal planning and the FY 2025-26 income tax rules. Every rupee moves through one validated transaction service into an append-only ledger.
- investment instruments, each with its own maths
- 22investment instruments, each with its own maths
- liability types with amortization and prepayment analysis
- 11liability types with amortization and prepayment analysis
- Django apps behind a versioned REST API
- 16Django apps behind a versioned REST API
- routed pages in the React front end
- 33routed pages in the React front end
A finance app that starts with accounting
Most expense trackers stop at categories. Finventory treats personal finance as a bookkeeping problem. Account balances are never written directly: they are derived from posted credits and debits under row locks, and an opening balance is recorded as an adjustment you can audit. Reversing a transaction voids it and keeps the record instead of deleting it.
Seven transaction types (income, expense, transfer, investment buy and sell, liability payment, adjustment) go through a single TransactionService with validation for each type. That one path is what the analytics, tax and planning engines read from.
What it covers
- Investments. 22 instruments, from equities and mutual funds to PPF, EPF, NPS, Sovereign Gold Bonds, SSY, SCSS and crypto. SIP returns use XIRR on irregular cash flows; there are FD and RD maturity values, a 15-year PPF projection, bond yield to maturity and rental yield for property.
- Loans and cards. 11 liability types with EMI tracking, amortization schedules, the effect of a prepayment (shorter tenure or smaller EMI), credit card payoff projections, foreclosure charges, and restructure and balance-transfer history.
- Planning. Goals across 9 types, retirement corpus and future-cost calculators, avalanche and snowball debt plans, and a goal-seek solver that works backwards from a target. Any result can become a goal with a linked recurring rule in one click.
- What-if simulation. Change an EMI or a rate, add a lump-sum prepayment or a SIP step-up, and compare interest saved, months saved and extra corpus against the baseline.
- Tax. FY 2025-26 (AY 2026-27) rules with an old-versus-new regime comparison, slab tax, the 87A rebate, surcharge and cess. Salary and HRA, presumptive income under 44AD and 44ADA, house property, capital gains including the flat 30% on crypto, dividends and interest, and an advance tax schedule.
- Recurring entries. Rules on 7 frequencies with a maker-checker queue: approve, edit and approve, or skip. Rules link to SIPs, EMIs, goals and advance tax.
- Net worth. Accounts plus investments minus liabilities, with snapshots, monthly history, allocation breakdowns, a Sankey cash-flow diagram and a 0 to 100 financial health score.
Engineering notes
- Money that survives concurrency. Balance updates use
select_for_update()row locks andF()expressions. Transfers lock accounts in a consistent order to avoid deadlocks, and each change commits or rolls back together with its balance effect. - Jobs you can rerun. Recurring generation is guarded by a unique constraint on rule and date, so a rerun never posts twice. Voiding or approving twice is blocked by checking status again under the lock.
- A three-part schedule engine. For a loan or investment it reconstructs the simulated past, splices in the payments actually recorded, reconciles the drift between them and projects the future, flagging gaps and anomalies.
- Refresh tokens tied to a device. Each refresh token is bound to a SHA-256 device fingerprint. A token replayed from another browser is rejected, the session revoked and the token blacklisted.
- A SQL console with six layers. OTP-gated and read-only: a read-only database connection, an opaque subquery wrapper, server-controlled limits and a whole-word deny list that ignores string literals, among others. Each layer would stop a write on its own.
- Reset links that stay home. Password reset emails build their links only from an allow-listed host, which closes the attack where a forged Host header points the link elsewhere.
- Operations. Daily database backups with retention, an append-only audit trail with actor, IP and a JSON diff of each change, and transactional email through Microsoft Graph.
Stack
| Layer | Technology |
|---|---|
| Backend | Python 3.12, Django 5.1, Django REST Framework, SimpleJWT, django-apscheduler, pyxirr, MSAL |
| Frontend | React 19, TypeScript 5.9, Vite 8, Tailwind CSS 4, TanStack Query 5, React Router 7, React Hook Form, Zod, Recharts, Radix UI |
| Data | PostgreSQL in production, SQLite in development |
| Security | JWT rotation and blacklist, OTP email verification, device binding, role and feature based access, CSP, HSTS |
| Tooling | ESLint and TypeScript strict mode on the front end; pytest, pytest-django and factory-boy set up for the back end |
About 19,000 lines of Python (not counting migrations) and 20,000 lines of TypeScript. The repository’s technical documentation covers the formulas, the domain model and the tax logic, and DEPLOYMENT.md is a production checklist.
Questions
- Which investments and loans does Finventory track?
- 22 investment types, from equities and mutual funds to PPF, EPF, NPS, Sovereign Gold Bonds, SSY, SCSS and crypto, and 11 liability types with EMI tracking, amortization schedules and prepayment analysis.
- Does it handle Indian income tax?
- Yes. It applies the FY 2025-26 rules, compares the old and new regimes, and covers salary and HRA, presumptive income under 44AD and 44ADA, capital gains, surcharge, cess and advance tax.
- What is it built with?
- A Django 5.1 and Django REST Framework API with JWT authentication, and a React 19 and TypeScript front end built with Vite and Tailwind CSS. PostgreSQL in production, SQLite in development.