Skip to content

v1.6.0 — Honest returns, and the taxman's view

Choose a tag to compare

View all tags
@github-actions github-actions released this 18 Jul 11:59
v1.6.0
4b7d567

Two things this release: your return figure now tells the whole truth, and
the file can finally answer the year-end question — "how much tax on what
I sold?"

  • Dividends count in your return now. Every dividend your shares pay —
    and every sale you record — goes into the XIRR maths. So the return you
    see is the return you actually got. Your figure may shift a little on
    the first update — that's it becoming more honest, not a bug.     Each
    family member's sheet also shows their own share of this year's
    dividends.

  • A record of what you sold. The new Equity_Sells tab: one row per
    sale, copied straight from your contract note. (Keep the Equity tab as
    what you own now — the sheet reminds you.) Fund sales need nothing new:
    a minus amount on MF_SIP already is the record.

  • The Capital Gains tab. Switch it on in Settings (it's off until you
    want it) and the update builds you a tax view: short-term and long-term
    gains per year, how much of the yearly tax-free allowance (₹1.25 lakh)
    you've used, an indicative tax figure — and, for planning, what each
    holding would gain if sold today plus the exact date it turns
    long-term    . Sold shares you bought before 2018? The kinder
    "grandfathering" rule (the official 31-Jan-2018 value) is applied for
    you — even if you left the old buy price blank. Bought and sold the same
    day? That's speculative income (taxed at your slab, not as capital
    gains) — it gets its own column and rows, clearly labelled, instead of
    being mixed in or hidden.

  • Charts no longer sit on top of your columns. The Dashboard charts
    move right as you switch on more asset classes, and each family member's
    pie now sits clear of their holdings table — nothing to drag out of the
    way anymore.

  • The tax rules live in YOUR file, not in our code. The new Tax_Rules
    tab ships filled in with the current law — rates, holding periods, the
    ₹1.25 lakh allowance. When a Budget changes any of it, edit the number
    (or add a row from the date the change applies) and run the update.
    No new app version needed.

Straight talk, as always: the tax view is indicative — for planning, not
for filing. It knows the current rules (including the mid-2024 rate
change), but it doesn't know your slab, your other income, or loss
set-offs across years. Anything it can't work out honestly, it says so on
the sheet instead of guessing.

Everything is explained where you see it — hover any new heading (STCG,
LTCG, grandfathering…) and a plain note tells you what it means. The Guide
has a new "Selling & tax" section with the three steps.

And one more thing: there is now a complete illustrated user guide —
every feature walked through with real screenshots and worked examples,
from first open to the tax view:
https://github.com/jay-parikh/NetWorth/blob/main/docs/USER-GUIDE.md

Get it: download the zip for your computer below (Windows or Mac) and
unzip it. Updating? Keep your own Excel file; just replace the Update
Portfolio app with the new one.

Full changelog: v1.5.1...v1.6.0

Assets 4
Loading