Travel and vehicles

Tracking freelance income when clients pay in dollars, euros and pounds

Gig workers paid in several currencies can keep one income ledger that adds up in rupees. See the columns to keep, a three-currency example and a month-end check.

Editorial illustration for Tracking freelance income when clients pay in dollars, euros and pounds

When your clients pay in dollars, euros and pounds, keep one income ledger with a line per invoice, the foreign amount, the currency and the rupees that reached your bank. Add the rupee column and you have total income; filter by currency and you see which client base is carrying you. This is for gig workers and freelancers whose income comes from platforms and clients in more than one currency.

Why do multi-currency freelancers lose track?

Each currency has its own invoice numbers, its own payout day and its own rate. Add them up in your head and you mix amounts that cannot be added: 300 dollars plus 200 euros is not 500 of anything. The fix is a single common column, rupees at the actual credit, so every line can be summed without translation.

Which columns does the ledger need?

  • Invoice number or payout reference
  • Client or platform name
  • Currency and foreign amount
  • Date invoiced and date credited
  • Rupees credited to the bank
  • Working rate: rupees credited divided by foreign amount
  • Status: raised, part-paid, paid

A three-currency month with invented numbers

ClientForeign amountRate worked outRupees credited
Studio in the US$30083₹24,900
Agency in Germany€20090₹18,000
Magazine in the UK£150105₹15,750

The month's income is 24,900 plus 18,000 plus 15,750, which is ₹58,650. Group by currency and you get ₹24,900 from dollars, ₹18,000 from euros and ₹15,750 from pounds. The dollar client brings about 42 percent, which is 24,900 divided by 58,650. If that client leaves, you know what hole you need to fill.

What if an invoice is paid in parts?

Make one line per credit, not one per invoice, and put the invoice number on each. A 300 dollar invoice paid as 150 and 150 over two weeks becomes two lines with two rates. Keep a status column on the invoice list, not on the income list, so unpaid invoices never look like income.

How do I spot a client who underpays?

Compare the amount you invoiced with the amount credited, in foreign terms, whenever the platform shows it. If the foreign amount you received is lower than invoiced, someone deducted something. The rate is a separate question. Keeping the foreign amount and the rupee amount apart tells you which of the two is moving.

Platform payouts deserve a note of their own. A platform may batch several tasks into one payout, so one credit can cover many small jobs. Record the credit as one line and put the platform name and payout date in the note; if you also want to see jobs, keep that detail in the platform, not in the ledger. Otherwise the ledger fills with tiny lines and the monthly total gets harder to check against the bank statement.

Where can SpendixAI help?

It lets each transaction sit in its own currency and shows totals in one base currency using the rate saved with that transaction, so the numbers in a month add up. Choose rupees as the base currency before you import, since it cannot be changed once transactions exist. Reports can be filtered and downloaded as CSV for your CA.

Month-end check

  1. List every invoice raised this month and mark which are credited.
  2. Total the credited rupees and compare with your bank statement credits.
  3. Look at income by currency to see your concentration.
  4. Chase invoices that are older than your usual payment time.
  5. Save the ledger for the April to March year-end file.

Rules on foreign receipts change, so ask your CA what extra details to keep for each credit.

SPENDIXAI JOURNAL

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

Explore your reports