An NRI's Indian card statement often shows rupee amounts for spending in India and sometimes a foreign-currency amount for purchases made abroad. Messy wrapped descriptions plus two currencies is where sheets go wrong. Keep one row per purchase, keep the original currency in its own column, and only then total in rupees.
Why are NRI statements harder?
There are more moving pieces. You may pay for a parent's medicines, a family subscription and an Indian utility bill from the same card, and a trip home adds restaurants and taxis. If your statement shows a foreign amount beside the rupee figure, you lose information the moment a converter drops that second figure.
Step by step
- Download the statement PDF from your own card account and copy the table into a raw tab.
- Join wrapped lines using =IF(A2="","",B2&IF(AND(A3="",B3<>"")," "&B3,"")) in a helper column, where A is date and B is description.
- Add two columns: Original amount and Currency. Fill them where the statement shows a foreign figure; leave them blank for pure rupee rows.
- Keep the rupee amount column exactly as printed. Never recalculate a rupee figure from a rate you looked up yourself.
- Check the total of the rupee column against the statement.
A hypothetical example
Say a statement line shows 40.00 in a foreign currency and ₹3,360.00 as the rupee amount. The rate implied is 3,360 / 40 = ₹84 per unit. That rate is made up for the example; your statement carries its own. Another line shows ₹1,150.00 for a pharmacy in India with no foreign figure.
| Description | Original amount | Currency | Amount in ₹ |
|---|---|---|---|
| SAMPLE ONLINE STORE | 40.00 | USD | 3,360.00 |
| SAMPLE PHARMACY PUNE | - | - | 1,150.00 |
| SAMPLE UTILITY BILL | - | - | 2,640.00 |
The rupee column adds up to 3,360 + 1,150 + 2,640 = ₹7,150, which is the figure to compare with the statement's purchases total.
How do I keep family spending in India separate?
Add a column called For and write Self, Parents or Home. Then =SUMIFS($D$2:$D$200,$E$2:$E$200,"Parents") shows what you spent on them in rupees this month. If you also send money by transfer, keep those records on a separate tab so card spending and transfers do not get mixed.
When the sheet needs more
SpendixAI lets each expense sit in its own currency while totals show in a base currency, using the rate saved with each transaction. You choose the base currency before importing, and it cannot be changed once transactions exist, so decide with care. It reads card statements as PDF, CSV or Excel, with rows reviewed before saving. It does not connect to your bank, and layouts vary, so check totals.
What if a line has only a foreign amount?
Sometimes a statement shows a foreign figure and the rupee amount sits on the next line, which a converter treats as a wrapped row. The joining formula will merge the description, but the numbers stay in different rows. Look at your first month's file by eye and decide where each figure sits before you write any formula. Then use the same layout every month, and write a single sentence at the top of your sheet saying where the rupee figure lives. It saves you from rebuilding the logic when you return to it after a gap.
It also helps to colour any row where you typed a value by hand. Typed values are where later mistakes hide, and a coloured cell is easy to revisit. Keep the original statement PDF, since it is the only thing that settles a disagreement between your sheet and the bill.
Short checklist
- One row per purchase, wrapped lines joined
- Foreign amount and currency kept in their own columns
- Rupee column untouched and totalled
- Family spending tagged by who it was for
- Total compared with the statement
Useful ideas start with a clearer picture of your own spending.
Explore your reports

