Travel and vehicles

Tracking rupees and dollars when your clients are overseas

How an India-based freelancer paid by overseas clients can track INR and USD together: what to log on each line, a worked month and a month-end routine.

Editorial illustration for Tracking rupees and dollars when your clients are overseas

If you invoice overseas clients in dollars but pay rent, groceries and the internet bill in rupees, log every entry in the currency it actually happened in and keep one rupee figure beside it. That gives you two views: what the client paid and what really landed in your account. This is written for freelancers who live in India, or split their year between India and abroad, and whose income arrives in a foreign currency.

Why one rupee column is not enough

A client invoice of 850 dollars is not worth any fixed number of rupees until the bank credits it. The credit can differ from what you expected because of the day's exchange rate and whatever the payment route deducted on the way. If you only note the rupee credit, you can never answer the question 'did this client pay what we agreed?'. If you only note dollars, your monthly rupee budget makes no sense. Keep both.

What should each line carry?

  • Date the money moved, not the date you raised the invoice
  • Original amount and its currency, exactly as on the invoice or card slip
  • Rupee amount you can see in your bank statement
  • The working rate: rupee amount divided by original amount
  • Which account it touched (savings, card, wallet)
  • A note with the client name or invoice number
  • A category such as Income, Software, Rent or Groceries

A worked month with made-up numbers

Say two clients pay in one month and you also have a dollar-billed software subscription. The rates below are invented for the example and are not market rates.

EntryOriginalRupees in bankWorking rate
Client A invoice paid$850₹70,55083.0
Client B invoice paid$400₹33,60084.0
Design software subscription$20₹1,70085.0
Rentnone₹16,000not applicable
Groceries and billsnone₹9,500not applicable

Income for the month is 70,550 plus 33,600, which is ₹1,04,150. Costs are 1,700 plus 16,000 plus 9,500, which is ₹27,200. What is left is ₹76,950. The two clients converted at different rates, and that is normal: each rate belongs to its own day, so never overwrite one with the other.

What if a client pays late or in parts?

Record the money when it is credited, not when you invoiced. For a part payment, make one line per credit and put the invoice number in the note, so a later look at the invoice shows two credits adding up to the whole. Keep a separate list of invoices raised but unpaid; it is a to-do list, not income.

Who will ask you for proof?

Clients ask for invoice copies, your CA asks for a clean list of foreign credits for the April to March year, and a lender or visa office may ask for several months of income. Rules and limits for foreign receipts change, so confirm what your CA needs and in what format. Having the original amount, the rupee credit and the invoice number on one line makes every one of those requests a filter, not a hunt.

Where an app earns its place

A sheet works for this until the lines run into hundreds. SpendixAI lets each expense carry its own currency and shows totals in one base currency using the rate saved with each transaction. Choose the base currency before importing, because it cannot be changed once transactions exist; for a freelancer living in India that is normally rupees.

A ten-minute month-end routine

  1. Add up the foreign credits and compare them with the invoices you sent.
  2. List any invoice still unpaid after its due date.
  3. Check that each subscription in dollars has a line with a rupee figure.
  4. Look at the working rates; a line far from the others deserves a second look at its statement.
  5. Save the month's list for your CA before the new month starts.
SPENDIXAI JOURNAL

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

Explore your reports