Life events

Foreign income and Indian expenses: track both in year one back

Track foreign income and Indian expenses together: record each credit date and rate, then compare monthly spending to a rolling average.

Editorial illustration for Foreign income and Indian expenses: track both in year one back

To track foreign income and Indian expenses together, record each salary credit with the foreign amount, the rupees that actually arrived and the date, then divide to get the rate you really received. Put your rupee spending next to it, and compare each month to a rolling three-month average. That shows whether a rate move is changing your room to spend.

What should you record each time income arrives?

  • Date the money was credited in India.
  • Foreign amount sent, in its own currency.
  • Rupees credited to your account, which may differ from any quote you were shown.
  • The real rate, worked out by dividing rupees by the foreign amount.
  • Any fee or deduction on the way, if you can see it.

Using the rupees credited, not a rate from a website, means your sheet agrees with your bank statement. A web rate is a guide; your bank credit is a fact.

What does a three-month sheet look like with made-up figures?

Say your income is 3,000 USD a month. Your sheet has columns for month, dollars sent, rupees credited, rate, rupee spending and left over.

MonthUSD sentRupees creditedReal rateSpendingLeft over
13,000₹2,52,000₹84₹1,70,000₹82,000
23,000₹2,49,000₹83₹1,85,000₹64,000
33,000₹2,58,000₹86₹1,90,000₹68,000

The rate column is rupees credited divided by dollars: 2,52,000 / 3,000 = 84. In a sheet, with dollars in column B and rupees in column C, put =C2/B2 in the rate cell. Left over is credited minus spending: 2,52,000 - 1,70,000 = ₹82,000.

How do you compare spending to a rolling average?

A single month tells you little, because rent, festivals and travel bunch up. A rolling average smooths that. With spending in column E and months in rows 2 to 4, type =AVERAGE(E2:E4) in row 4. In the example that is (1,70,000 + 1,85,000 + 1,90,000) / 3 = ₹1,81,667. In row 5 use =AVERAGE(E3:E5), and so on, so the range moves down one row each month.

Compare each month's spending to that average. Month 3 spending of ₹1,90,000 is about ₹8,300 above the average, which is worth a glance at what changed rather than a worry.

How much does the exchange rate really move your budget?

A ₹1 change in the rate moves 3,000 dollars by ₹3,000 (3,000 x 1). Between month 2 and month 3 in the example the rate rose ₹3, so the same salary was worth ₹9,000 more (3,000 x 3). That is real, and larger than the ₹5,000 rise in spending over the same period, so the rate gave you more room than your spending used.

What about tax and reporting on foreign income?

This article is about records only. How foreign income is treated for tax or reporting in India depends on your residency status and the rules at the time, which change. Keep your credits, rates and dates in one place, and confirm the position with your CA or the official source.

When does a sheet stop being enough?

A formula-driven sheet handles this well until your spending comes from many accounts and cards. SpendixAI lets you upload bank and card statements as PDF, CSV or Excel and review the rows before saving, and add cash spending by hand. You choose your base currency before importing and cannot change it once transactions exist, and a foreign-currency spend report covers spending in other currencies. The income side stays in your sheet.

Monthly routine

  1. On credit day, enter dollars sent, rupees credited and the date.
  2. At month end, enter total spending.
  3. Update the rolling average.
  4. Note the lowest credit of the last six months and check it against your limit.
SPENDIXAI JOURNAL

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

Explore your reports