Tax and GST

A master list of every bank account, folio and policy you hold

A one-sheet master list of every bank account, folio, policy and deposit you hold, with the columns to use and example rows for a typical Indian household.

Editorial illustration for A master list of every bank account, folio and policy you hold

A master list is one sheet with a row for every bank account, deposit, folio, policy and loan your household has. For each, record the institution, type, holder, status, nominee, where its statements come from and where the papers are kept. Never write passwords, PINs or full card numbers on it.

What columns should the sheet have?

  1. Institution and branch or platform.
  2. Type: savings account, fixed deposit, mutual fund folio, demat account, insurance policy, loan, post office account and so on.
  3. Holder, including joint holders.
  4. Identifier: only the last four digits or a folio number you would be comfortable seeing on a printed page.
  5. Status: active, dormant or closed, with the date.
  6. Nominee, as recorded with the institution.
  7. Statement source: app, email, branch or passbook, and how often it arrives.
  8. Where the papers live: a folder name, a drawer, a locker.
  9. Last reviewed date.

What do example rows look like?

These rows are made up for a household with two earners. Use your own details.

InstitutionTypeHolderIdentifierStatusStatementsPapers
Bank ASalary accountMeeraends 4821ActiveApp, monthly PDFFolder Banks/A
Bank BJoint savingsMeera and Karanends 7730ActiveEmail, monthlyFolder Banks/B
Bank AFixed depositKaranDeposit 2Active, matures 5 April 2027Advice on paperDrawer 2
Fund house CFolioMeeraFolio ends 118ActiveEmail, yearlyFolder Investments
Insurer DTerm policyKaranPolicy ends 5502ActivePortal, yearlyLocker
Post officeSavings accountKaranPassbookDormantPassbookDrawer 1

How do I fill it in without overdoing it?

Start with the accounts you use every month, then work outward. Each time a statement arrives, check that it belongs to a row. After a month, you will have a fairly complete list, and the gaps will be obvious. Old statements are a good source of forgotten rows, as is a search of your email for the words statement, policy and folio.

Add a column for the next action, even if it is usually blank. A line such as ask the branch about the nominee form, or collect the maturity advice in April, turns the sheet from a passive list into a to-do list that surfaces at every review.

Why bother with status and nominee columns?

Status shows which accounts need attention. An account that has not been used for a long time may be dormant, which your bank can explain, so mark it and check. The nominee column catches the common mistake of a nominee who is out of date after a marriage, a birth or a death. Update the institution and then update the sheet. The list is a record of what each institution holds, not an instruction to it.

Who else should know about it?

One trusted person in the family should know the list exists and where it is kept, in print or in a shared drive. Review it twice a year, perhaps at the start of April and in October after Diwali, and change the last reviewed date each time.

How does it relate to a tracker?

They support each other. In SpendixAI you pick an account, whether a bank, card or wallet, before importing a statement, and each transaction keeps that account. The accounts you set up there should match the active bank and card rows on your master list. The master list also covers things a tracker does not, such as policies, folios and papers in a locker.

A starting checklist

  • List every bank and card account, active or not.
  • Add deposits, folios, demat accounts and policies.
  • Add loans and the papers that go with them.
  • Record the nominee for each.
  • Save the sheet in two places and tell one person where it is.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports