Portfolio Tracking
Manual investment tracking in India: a practical workflow
Most Indian investment accounts don't auto-sync. A practical manual investment tracking workflow—what to download, from where, how often, and how to stay accurate across EPF, NPS, PPF, MF, and equity.
Many Indian investors assume a portfolio tracker must connect directly to their accounts to stay accurate. In reality, the infrastructure for that kind of live sync simply does not exist for most Indian investment platforms. EPFO, NPS CRA portals, post-office PPF accounts, and a large share of broker platforms do not offer real-time data feeds to third-party applications. Manual investment tracking is not a workaround for an inconvenient gap — it is the standard workflow for most Indian investors, and a systematic approach to it makes a measurable difference to the accuracy of your records over time.
This post covers the practical mechanics: which accounts need manual updates, what to download, which portal to use, how often to pull a fresh statement, and where manual records most commonly go wrong.
Why most Indian accounts require a manual update step
The missing infrastructure is worth naming clearly, because many investors blame themselves for having "disconnected" portfolios when the limitation is structural.
EPFO does not publish a machine-readable API for individual members. Your EPF passbook is accessible through the UAN portal or the UMANG app, but only when you retrieve it yourself. Automated pulls are not available to third-party tools.
NPS CRA portals — operated by NSDL and Protean — provide subscriber dashboards but no open-data connection that a portfolio tracker can query on your behalf. Transaction statements and fund-level NAV history are available, but you download them.
PPF accounts are held at banks or post offices, each with their own internet banking systems. A PPF balance at SBI is accessible through SBI Net Banking; one at a post office requires a branch visit or the India Post app. Neither publishes a feed.
Mutual fund platforms come closest to offering a consolidated data source via the Consolidated Account Statement from MF Central and the two RTAs — CAMS and KFintech. But even here, the CAS is a point-in-time document you request, not a continuous stream.
Direct equity held in demat accounts can be viewed in broker apps, but a broker's displayed holdings are specific to securities custodied there. An investor with two demat accounts sees two fragmented views. The full picture requires pulling statements from both and combining them.
This is the environment. A practical manual investment tracking workflow works with it rather than waiting for infrastructure that may not arrive soon.
Account-by-account: what to download and where
EPF
Where: EPFO UAN member portal (unifiedportal-mem.epfindia.gov.in) or the UMANG app under the EPFO section.
What to download: The passbook PDF. It shows employer and employee contributions month by month, plus interest credited once at the end of the financial year.
Cadence: Quarterly is sufficient for most salaried employees, since contributions post monthly but the statement changes meaningfully only after interest credits at year-end. Pull a fresh passbook after the April interest credit posts for the most accurate balance.
Watch for: A delay between when your payslip shows the deduction and when the passbook reflects the credit — employer remittances sometimes run a month or two behind. If you changed employers, the old account may still show a balance that was not transferred.
NPS
Where: Your CRA portal. NSDL CRA subscribers use cra-nsdl.com; Protean (formerly NSDL e-Gov) CRA subscribers use a different portal. Your employer's HR team or your PRAN welcome kit should indicate which CRA handles your account.
What to download: The transaction statement, which shows contributions, NAV-based unit allocation, and current value across Tier I and Tier II. If your employer makes a co-contribution, confirm it appears in the statement.
Cadence: Quarterly, or after any voluntary top-up to either tier. NPS balances change with market NAVs daily in principle, but for tracking purposes a quarterly snapshot is accurate enough unless you are making frequent voluntary contributions.
Watch for: Keep Tier I and Tier II as separate line items in your tracker — they have different withdrawal rules and it matters when you are modeling retirement liquidity. Also note the fund-level split (equity, corporate debt, government securities) if you track asset allocation across the whole portfolio.
PPF
Where: Depends on where the account is held. SBI PPF holders can download a statement from SBI's internet banking. Other bank-held accounts work similarly through their respective internet banking. Post-office PPF accounts require the India Post mobile app or a passbook update at the branch.
What to download: The updated passbook or transaction statement showing the current balance and interest credited.
Cadence: After each deposit, and again in April after the year-end interest credit posts (interest for the year gone by is credited in March). Many investors top up in March but forget to pull the updated balance after the interest posts in late March or early April — leaving the tracker understating the actual value for months.
Watch for: PPF interest is calculated on the minimum balance between the 5th and the last day of each month. A deposit made after the 5th of March does not earn interest for that month, which is why the advice around a pre-5th deposit exists. This does not affect tracking directly, but it is the reason a passbook update right after the March credit matters.
Mutual funds
Where: MF Central (mfcentral.in) for a combined CAS covering CAMS and KFintech folios, or separately from CAMS (camsonline.com) and KFintech (kfintech.com). Your registered email or mobile number is the identifier.
What to download: The CAS, which shows every folio across all AMCs, transaction history, units held, and current value at the date of the statement.
Cadence: Monthly, timed after your SIP cycle completes. If you run SIPs on the 5th, a CAS pulled on the 10th will capture the completed cycle. If you also hold lumpsum units or have IDCW (income distribution) reinvestments, those appear in the same CAS.
Watch for: The CAS date is the date of accuracy — units bought after that date are not reflected. An October CAS does not include a November SIP. This is obvious in principle but easy to overlook when the CAS is opened weeks after it was downloaded.
Direct equity
Where: Your broker's platform (Zerodha Console, Upstox Pro, Angel One, and others). Most brokers provide a holdings report and a transaction history report, usually in CSV or PDF.
You can also download a holding statement from CDSL (cdsl.com) or NSDL (nsdl.co.in) via their investor portals, which shows all demat-held securities across brokers using a single CDSL or NSDL login.
What to download: Contract notes for each transaction (for cost-basis accuracy), or at minimum a full transaction history CSV. For a holdings-level snapshot, the CDSL or NSDL statement is the authoritative source.
Cadence: After each transaction for active equity investors. For buy-and-hold portfolios, a monthly or quarterly broker statement covers the period.
Watch for: Corporate actions — bonus issues, stock splits, rights entitlements, and mergers. These change your share count and effective cost per share. A 1:1 bonus doubles your holding quantity and halves the cost per share at the same total investment. If you do not update records at the time of the action, your tracker will show an inaccurate quantity and inflated per-share cost until you catch it.
International holdings
Where: The platform through which you hold international assets — Vested, INDmoney, or a direct international brokerage account.
What to download: A holdings statement or transaction history. For currency conversion, use the exchange rate on the date of each transaction, not today's rate, to compute accurate INR cost basis.
Cadence: Quarterly, or after any meaningful transaction.
Watch for: Currency movement can change the INR value of a US sleeve independent of the underlying price. A tracker that holds the USD cost and applies a current exchange rate will show a different number than one locked to the historical rate. Decide on a consistent conversion approach and apply it uniformly. The US stock tracking guide covers this in more detail.
A practical update cadence
Most investors find that grouping updates by account type rather than doing everything at once makes the routine sustainable.
| Account | Suggested frequency | Key trigger |
|---|---|---|
| Mutual funds | Monthly | After SIP cycle completes |
| Direct equity | After each transaction | Corporate action or trade |
| EPF | Quarterly | After interest credit in April |
| NPS | Quarterly | After voluntary top-up |
| PPF | After each deposit + April | Year-end interest credit |
| International holdings | Quarterly | After significant transactions |
A monthly mutual fund update combined with a quarterly sweep of retirement accounts covers the full picture for most investors without requiring a dedicated session every week.
Three places where manual records go wrong
Forgetting corporate actions. This is the most common source of inaccurate direct equity records. A 2:1 stock split means you hold twice the shares at half the cost per share. If you do not update the record at the time, every subsequent view of that holding will show the wrong quantity and an incorrect gain. Brokers update their own displayed holdings, but if you also track positions in a separate tool, that tool needs a manual update.
Leaving a stale CAS in place. A mutual fund CAS downloaded in September is accurate as of September. It does not reflect October SIPs, a November dividend reinvestment, or a December switch. When a CAS is treated as a persistent reference rather than a point-in-time snapshot, small discrepancies accumulate. Replacing it with a fresh CAS once a month keeps the folio view close to current.
Missing the PPF interest credit. PPF interest is credited at the financial year-end, typically visible in late March or early April. Investors who top up before 31 March often pull a statement immediately after the deposit, capture the deposit, and call it done — without waiting for the interest credit to appear. The balance then understates actual value until the next review.
Building the routine
The practical version of a manual investment tracking habit is not a single monthly session where every account is updated at once. It is a set of triggers tied to events.
A completed SIP cycle prompts a CAS request. A trade execution prompts a contract note check. An employer payslip showing the EPF deduction is a reminder to note the contribution, with a quarterly passbook pull to confirm. A PPF deposit in February is automatically followed by a passbook check in early April after the interest posts.
A portfolio tracker that accepts statement uploads makes this incremental approach work — each upload updates the relevant section without requiring a full re-entry of the portfolio from scratch.
You can use Invesh.io to track EPF, NPS, PPF, mutual funds, stocks, and international holdings in one place, uploading fresh statements as each becomes available rather than needing a continuous API connection that most Indian platforms do not support.
For related workflows: How to do a full annual investment review — How to read your mutual fund CAS — Tracking US stocks from India
Frequently asked questions
How often should I update my investment tracker manually?
It depends on account type. Mutual fund SIPs benefit from a monthly update after each cycle completes. EPF and NPS move slowly, so quarterly is usually sufficient. PPF needs an update after each contribution and again after the year-end interest credit posts. Direct equity positions should be updated after each transaction, or at least after each month of activity.
Where do I download my mutual fund CAS?
You can request a Consolidated Account Statement from MF Central (mfcentral.in), which covers both CAMS and KFintech registrars in one document. Alternatively, you can request separate statements from CAMS (camsonline.com) and KFintech (kfintech.com) directly. CDSL also provides a holdings statement from its investor portal, though that covers demat-held securities rather than mutual fund folios.
Why can't I auto-sync my EPF balance to a tracker?
EPFO does not provide a real-time data feed to third-party applications. You can pull your passbook from the EPFO UAN portal yourself, or check through the UMANG app, but these are manual retrieval steps. The balance also lags because interest is posted to individual accounts once at the end of the financial year, not in real time.
What is the difference between a mutual fund CAS and a CDSL CAS?
A mutual fund CAS shows your folio-level holdings and transaction history across all AMCs—units bought, sold, switched, and current NAV-based value. A CDSL or NSDL CAS shows your equity shares, bonds, and ETFs held in your demat account at the depository level. Both are useful and cover different parts of a portfolio. A complete picture requires both, along with separate statements for EPF, NPS, and PPF.
How do I handle a stock bonus or split in my manual records?
When a company announces a bonus issue or stock split, your depository account reflects the new quantity after the record date. Your broker typically adjusts the displayed holding in their app, but the effective cost per share changes—a 1:1 bonus halves the per-share cost since you now hold twice the quantity at the same total investment. Download a fresh demat or broker statement around the time of the corporate action and verify the quantity and adjusted cost are both reflected correctly.
Can Invesh.io work with manually uploaded statements?
Invesh.io is designed to work with statement imports. You can upload a mutual fund CAS, broker statements, and other documents, and the tracker organises the data in one portfolio view across account types without needing a live API connection for every account.
See everything in one place
Invesh brings stocks, mutual funds, PPF, NPS, EPF, and US stocks into a single dashboard with P&L and Artha for document import.