Tax and GST

A master list of foreign accounts and assets for your CA

A master list of foreign accounts and assets for your CA: one sheet for overseas accounts, investments and property, with dates and statement sources.

Editorial illustration for A master list of foreign accounts and assets for your CA

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?

ColumnWhat to record
HolderYour name, and any joint holder
CountryWhere the account or asset is
Institution or assetBank, broker, or a description such as flat in a named city
TypeSavings, current, brokerage, retirement, property, employer shares
IdentifierLast four digits only, with the full detail kept in your secure file
CurrencyOf the account or asset
Opened and closed datesClosed accounts matter too if open during the year
Balance or value at year endIn original currency
Highest balance or value in the yearOften asked for, so note it as you go
Statement sourceWhere you download statements, not login details
NotesAnything 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?

  1. After the year ends, download a statement for each account and save it in a folder named for the year.
  2. Update the year-end balance and the highest balance for each row.
  3. Add rows for anything opened, and mark anything closed with its date.
  4. Note any account you cannot reach, and the date you last tried.
  5. 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.

SPENDIXAI JOURNAL

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

Explore your reports