The story
A private, single-user web application for tracking the money involved in a house purchase: loans from family and friends, property sale proceeds, bank balances, recurring expenses, freelance receivables and pooled savings goals.
The modelling decision
A loan is a ledger, not a number. Every loan tracks disbursements and repayments over time, so a loan that grows because someone sends more money later, or shrinks through partial repayment, stays correct without anyone editing a balance by hand. Storing the current figure instead would have been simpler and wrong within a week.
What it tracks
Properties record installments received, expenses, and what has been distributed to lenders from each sale. Alongside those sit bank accounts, fixed expenses, freelance clients, and commitment plans, which are pooled goals with pledges, contributions and a progress bar.
Stack notes
Next.js with libSQL on Turso, Vercel Blob for document storage and Recharts for reporting. Login-protected and single-tenant by design; this is a personal system, published here as a work sample rather than as a product.
What made it hard
Loans that move
Representing a loan as a running ledger so later disbursements and partial repayments stay accurate without manual correction
Money in several shapes
Reconciling loans, sale proceeds, bank balances, receivables and pooled goals into one view without double counting
Distribution tracking
Recording what each property sale has already paid back to which lender
