IPO Reconciliation Checklist: Sale Proceeds, Bank Returns and Profit Shares
Close an IPO record with a practical account-level checklist: verify allotments, match sale proceeds to the receiving bank, record charges once and review profit shares.
A sold status is only one part of closing an IPO record. You also need to know which account was allotted, what was received, where it arrived, which expenses are already included, and how the remaining result is shared.
1. Start from the correct demat and outcome
Open the specific IPO and demat record rather than starting with a combined dashboard total. Confirm the application, allotted quantity and sale outcome against the corresponding official or broker record. An unsuccessful application and a sold allotment follow different cash paths; do not record a sale for an account that received no shares.
If a confirmation is missing, leave the record pending and add a note about what you are waiting for. Do not use a zero amount as a substitute for an unknown result.
2. Separate application money from sale proceeds
| Event | What to check | Common mix-up |
|---|---|---|
| Application / block | The account and amount associated with the application | Treating a temporary block as the final cost |
| Allotment / debit | The amount actually used for allotted shares | Assuming the full applied amount was debited |
| Refund / unblocking | Actual availability in the bank record | Counting an expected release as confirmed money |
| Sale / return | Proceeds, receiving bank and included charges | Counting the same receipt in two places |
The application funding bank and the bank receiving sale proceeds may differ. Keep both identities correct; changing a receiving bank should not rewrite the original application history.
For the underlying application mechanism, see SEBI’s ASBA explainer: application funds remain blocked in the account until the allotment process determines the debit.
3. Choose the result entry mode deliberately
IPOxCards offers an amount-returned mode and a profit/loss mode. Read the selected mode and its helper text before entering a figure. Total returned money includes recovered capital; profit alone does not. Entering one in the other field can materially distort the result.
4. Match the receiving bank before crediting the ledger
Select the account that actually received the sale proceeds before enabling the returned-amount bank credit. Check the bank name, owner and last four digits together; the bank name alone may match several records.
Review the existing ledger first. If the receipt was already entered manually, adding it through the sale-return option as well can duplicate it. Resolve that discrepancy before saving another credit rather than compensating with an unexplained debit.
5. Keep internal transfers separate from IPO returns
A movement between two of your recorded bank accounts is an internal transfer, not IPO profit. Record it with the correct source and destination, transaction date, amount, fee and reference after verifying the actual bank movement.
For an illustrative ₹10,000 transfer with a ₹10 source-bank fee, the source reduces by ₹10,010 and the destination increases by ₹10,000. Combined balances reduce only by the fee. Do not also classify the destination credit as sale proceeds if it represents the same movement.
6. Review the share rule and close the account trail
Confirm the applicable user-share setting and review the displayed user and administrator amounts with the charges. Check the underlying account record when a total looks unexpected. Avoid changing a share rule merely to force a dashboard total to match another number.
- IPO and demat identity verified against the source record.
- Allotment and sale outcome confirmed, or explicitly left pending.
- Returned amount versus profit/loss mode checked.
- Expenses included once, with their treatment understood.
- Receiving bank matched by owner and last four digits.
- Existing ledger reviewed to avoid duplicate credits.
- Internal transfers recorded separately from IPO proceeds.
- User share, administrator share and remaining discrepancies reviewed.
What to do when the numbers do not match
Compare one event at a time: cost, sale amount, expenses, ledger entry and share setting. Check dates and duplicated records before changing amounts. Keep a short explanatory note when you resolve a discrepancy, and preserve the original supporting evidence. A record should remain unfinished while the explanation is missing.
New to the platform? Follow the IPOxCards setup guide →