An easy ledger for family expenses paid in India has five columns: date, purpose, amount in rupees, the exchange rate on the day, and the cost in your own currency. Divide rupees by the rate to get your cost. Add a purpose tag such as parents, property or school and you can see where the year went in both currencies.
What columns do I need?
- A: Date of payment
- B: Purpose tag (Parents, Property, School, Other)
- C: Amount in rupees
- D: Exchange rate on the day, in rupees per one unit of your currency
- E: Cost in your currency, which is =C2/D2 in row 2
- F: Note and reference number
Use the rate your bank or transfer provider actually applied to that transfer, which should appear on the confirmation, rather than a rate looked up later. If the money was converted earlier and sent in a batch, use the rate for that batch.
What does a ledger look like?
Here are invented figures; the rates are only for the example.
| Purpose | Rupees | Rate | Cost in your currency |
|---|---|---|---|
| Parents, monthly support | ₹30,000 | 75 | 400 |
| Property maintenance | ₹12,000 | 80 | 150 |
| School fees | ₹45,000 | 72 | 625 |
| Total | ₹87,000 | about 74 on average | 1,175 |
The effective rate across the three payments is ₹87,000 ÷ 1,175, which is about 74.04. In a sheet: =SUM($C$2:$C$200)/SUM($E$2:$E$200). The rate varies with the day, so the same rupee bill costs different amounts of your own currency at different times. Seeing that in a column is the point.
Why tag by purpose?
People paying from abroad often cover several different things: parents' daily needs, a flat that needs upkeep, a child's school. Each has a different pattern. Parents' support is regular, property costs come in bills, school fees come in lumps. With tags you can answer: how much have I spent on each, and is any of it rising?
What if someone in India pays and I reimburse later?
Record it when you pay them, not when they pay the bill, and note who spent it. If you give a lump sum to a relative to cover several items, record the lump sum and ask for a list of what they spent. Any difference stays as money held by the relative until it is used or returned.
How does SpendixAI handle two currencies?
In SpendixAI each expense can be in its own currency, and totals appear in a base currency using the rate saved with each transaction. Pick the base currency before importing, because it cannot be changed once transactions exist. A Foreign-currency spend report shows the picture. Rupee transactions from an Indian account can be imported from the statement.
What if the money comes from different places?
Some people pay from an Indian account funded by a transfer, others from a card abroad, and others use a family member's account. Write down for each payment which account it left, because the rate and the date can differ. If a relative advances the money and you repay later, record the date you repay, with the rate on that date, as the cost to you. The original bill date can go in the note. Keeping both dates avoids confusion when a bill is due on one day and settled on another.
How do I check the ledger once a year?
- Add up each purpose tag in rupees and in your own currency.
- Compare the average rate with the range of rates in the year.
- Look for any tag that has grown faster than the others.
- Match the total with your transfer records, so no payment is missing.
Monthly routine
- Record each payment with the date and reference.
- Add the rate from the transfer confirmation.
- Tag the purpose.
- At month end, total by tag in rupees and your own currency.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
