# After years of refining my personal finance sheet, I wrote a script that emails me a snapshot of my entire finances — retained record

> Retained reddit record from reddit:indianstockmarket.

Canonical: https://highsignal.app/data/records/acce99ae8eec653f

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:indianstockmarket)  published 2026-11-09 05:08 ingested 2026-11-10 02:43

[original source ↗](https://www.reddit.com/r/IndianStockMarket/comments/1xrj1vb/after_years_of_refining_my_personal_finance_sheet/)

## 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 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 below.

https://preview.redd.it/qwxiwx5asi0i1.png?width=979&format=png&auto=webp&s=adaba18bc9668998f27ecc4dcb67d570ecdd3b5a


```



document fetched 2026-11-10 00:44 · canonical https://reddit.com/r/IndianStockMarket/comments/1xrj1vb/after_years_of_refining_my_personal_finance_sheet
