How to track IPO applications for your whole family

When several family members apply for the same IPO, the hard part is not applying. It is knowing afterwards who applied, who got shares, and where the money is.

What to write down for every application

The IPO and the category, the person, the number of lots and the amount, and the bank account or UPI ID used. Whether the UPI mandate was accepted. After the allotment: allotted or not, how many shares, and when the money is released.

Later, the date and price when the shares were sold, and the charges, for your tax return.

Set it up in a spreadsheet

One row per application, with columns for the IPO, person, PAN (keep it protected), category, lots, amount, status, shares and sale price, and a sheet for each financial year. It works for a small family with few IPOs.

Checking the results

Registrar sites take one PAN at a time, so every family member's result is a separate search. Check the result of each person who applied, even if they think the application did not go through. An application with no record at the registrar usually means the UPI mandate was not accepted or the bid was rejected.

Using an app instead

An app like IPO Khata keeps the applications for the whole family, checks the results at the registrar for each PAN and emails you, reminds you on the day an IPO closes, and totals profit by financial year. You still apply in your own broker apps.

Related guides

More on applying for an ipo

See today’s IPOs with live GMP and subscription

Information, not investment advice. GMP is an unofficial grey-market indicator; figures come from public sources (InvestorGain) and may be late or wrong. Not registered with or affiliated to SEBI, the exchanges, the registrars or InvestorGain.