After years of refining my personal finance sheet, wrote a script that emails me a snapshot of my entire finances
retained text
For years I tracked everything in one spreadsheet: every holding, monthly spends, payslips, tax computations, dividend and coupon payouts, even locker visits. My income and tax history goes back to FY 2014-15. The structure kept changing as I learnt what I actually needed: a five-level hierarchy for holdings (group, class, category, vehicle, instrument), liquidity tiers, a purpose for each holding (core, satellite, safety), and XIRR for every investment. The sheet held the data, but I still had to open it and hunt for the answers. So I finally wrote a Google Apps Script that reads the sheet and emails me a snapshot on a schedule I set. What the email covers, in order: * **Net worth and target:** the total, its change over 24 hours, 7 days and 30 days, and two bars comparing the share of the target reached with the share of the financial year gone. * **Movers and markets:** which holdings moved the number, plus Nifty, Nasdaq, currencies and metals. * **Cash flow:** income, then tax, deductions, take-home, spend, and what was left over. * **Salary and tax:** a full-year estimate from the latest payslip, new versus old regime, and the advance-tax schedule with interest under sections 424 and 425 of the new Income-tax Act, 2025. * **Spend:** month to date, monthly average, year to date, and the top and bottom categories. * **Loans:** months remaining, worked out from the outstanding amount, rate and EMI. * **Allocation, liquidity and returns:** how many holdings beat inflation and FD, and the top and bottom XIRRs. * **Personal ratios:** savings rate, emergency cover, liquidity, debt service, housing cost, debt to assets. Everything is calculated from the sheet itself. The only thing I typed into the script is who receives the email. Each run also saves a copy of the figures to a hidden tab, which is where the 24-hour, 7-day and 30-day changes come from. ***All amounts in the screenshots are up or down scaled by a hidden factor, so the ratios are real but the numbers aren’t.*** Happy to answer questions on the structure or the logic. The entire email layout in the below email. https://preview.redd.it/d5k5sl5eri0i1.png?width=979&format=png&auto=webp&s=0126e897eb8865777473b2aec9d4ebfe2f69d54b
document fetched 2026-11-10 00:43 · canonical https://reddit.com/r/IndiaInvestments/comments/1xrj0gm/after_years_of_refining_my_personal_finance_sheet