A master list of foreign accounts and assets is a single sheet with one row for every overseas bank account, investment account, property or other asset you or your family hold, showing who holds it, where, since when, in which currency and where its statements come from. Give it to your CA at the start of each year and they can ask the right questions instead of discovering accounts one by one.
Which columns belong on the sheet?
| Column | What to record |
|---|---|
| Holder | Your name, and any joint holder |
| Country | Where the account or asset is |
| Institution or asset | Bank, broker, or a description such as flat in a named city |
| Type | Savings, current, brokerage, retirement, property, employer shares |
| Identifier | Last four digits only, with the full detail kept in your secure file |
| Currency | Of the account or asset |
| Opened and closed dates | Closed accounts matter too if open during the year |
| Balance or value at year end | In original currency |
| Highest balance or value in the year | Often asked for, so note it as you go |
| Statement source | Where you download statements, not login details |
| Notes | Anything unusual: a name change, a dormant account |
What kinds of items are easy to forget?
- A bank account opened while you lived or studied abroad and never closed.
- A brokerage or retirement account from an overseas job.
- Shares or stock units granted by a foreign employer or parent company.
- Property owned abroad, whether in your name or jointly.
- Accounts held jointly with a spouse or parent.
- Insurance or savings policies bought overseas.
Write down everything you can find, then let your CA decide what belongs in a particular filing. They are better placed than a template to tell you which items matter for your situation.
How do I record values in two currencies?
Record every amount in its original currency first. Ask your CA which exchange rate source and date to use, because it depends on the purpose, and then add a column that multiplies. Say, purely as made-up rates, the rate used is ₹80 per US dollar for an account holding USD 5,000 and ₹100 per pound for another holding GBP 1,200. The formula is =E2*F2 for each row, giving ₹4,00,000 and ₹1,20,000, so the two together come to ₹5,20,000. The point is the layout: original amount, rate and rupee value side by side, so the CA can change the rate in one cell.
Which year basis should I ask about?
Different filings may look at different periods, and some ask for a balance on one date, others for the highest amount in a period. Ask your CA which dates and which year they want you to report against, then add those dates as headings. Do not guess; a quick question at the start saves rework.
How do I keep this safe?
What yearly routine keeps it current?
- After the year ends, download a statement for each account and save it in a folder named for the year.
- Update the year-end balance and the highest balance for each row.
- Add rows for anything opened, and mark anything closed with its date.
- Note any account you cannot reach, and the date you last tried.
- Send the sheet to your CA with a line on anything that changed.
A spending tracker is a different tool from this list. SpendixAI records expenses, including in other currencies, with a Foreign-currency spend report, but it is not an investment or asset tracker, so keep this register separate and use the tracker for what you spend, not for what you own.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


