To find forgotten investments, download twelve months of statements from every account you have used, look for debits that repeat at the same amount and credits from names you do not recognise, and write each one on a suspect list. Then match every line to a folio, policy, deposit or loan.
What am I looking for in the statements?
- Debits of the same amount every month or every quarter, which suggest a SIP, a recurring deposit or a premium.
- A single yearly debit around the same date, which suggests an annual premium or a renewal.
- Narrations that mention a mandate, an auto-debit or a standing instruction.
- Small credits from names you do not recognise, which might be interest, dividends or maturity proceeds.
- Transfers to a brokerage or a fund house with no matching statement in your files.
Use the narration text itself. Banks word narrations in their own way, so read the lines instead of expecting a pattern.
How do I do the scan? A worked example
Download the statements as CSV or Excel where you can, or copy the table from the PDF into a sheet. Put the amount in column C. Then add a helper column that counts how often each amount appears, for example =COUNTIF($C$2:$C$300,C2) in D2, copied down. Sort by that column. Say the following lines float to the top, all invented.
| What you see | How often | Yearly total | Guess |
|---|---|---|---|
| Debit of ₹2,000 on about the 5th, narration mentions an auto-debit mandate | 12 times | 2,000 x 12 = ₹24,000 | A monthly SIP or recurring deposit |
| Debit of ₹18,500 in March, narration mentions an insurer | Once | ₹18,500 | An annual premium |
| Credit of ₹312 each quarter from an unfamiliar name | 4 times | 312 x 4 = ₹1,248 | Interest or a payout from a holding you forgot |
The sorted list takes minutes to read. You now have a suspect list of three items, without having opened a single portal.
How do I match a suspect to a real account?
- Copy the full narration and the date into your list.
- Search your email for the name or the amount, since confirmations often exist there.
- Look through old physical papers, passbooks and welcome kits for the name.
- Contact the institution named in the narration, using the contact details from its own site, and ask for the folio, policy or deposit linked to your bank account and the debit.
- Ask for the latest statement and save it in the right folder.
What if the trail goes cold?
Write down what you know and ask the bank itself. The bank can usually tell you what mandate or standing instruction a debit belongs to, and who the payee is. If a recurring debit is something you no longer recognise or want, speak to the institution first and then ask the bank to stop the mandate, following the proper channel for each. Do not stop a payment before you know what it is, because a missed premium can lapse a policy.
Can an app speed up the scan?
It can. If you upload your old statements to SpendixAI, rows are reviewed before saving and each transaction keeps its account, so a report grouped by merchant makes repeated payees stand out. The Report builder lets you filter and group, and a CSV download gives you the list to work from. The matching to a folio or policy is still done by you.
What do I do with the finished list?
- Create a row in your master list of accounts for each find.
- Note the status: active, dormant or closed.
- Record the nominee and where the papers now live.
- Tell your family where the list is.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

