Glossary · Accounting & Bookkeeping
Multi-Currency Bank Feed
Definition
A multi-currency bank feed is an automatic import of transactions from a foreign-currency bank account into accounting software. Each line keeps its original currency, such as US dollars, and is converted into rupees at the exchange rate for its date. The feed is also where exchange gains and losses on settled invoices are worked out.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- What it means for Indian businesses How it works · Example
In practice
01 What it means for Indian businesses
Exporters, importers and IT firms with foreign clients meet this on every foreign receipt or payment. A software exporter invoicing a US client in dollars may receive the money into an EEFC or export account. The feed imports the dollar amount, converts it at the rate on the receipt date, and the difference from the invoice-date rate becomes a realised exchange gain or loss. Export receipts are also matched to the business's FEMA export records.
| Point | Position |
|---|---|
| Accounting standard | AS 11 for companies on the Accounting Standards; Ind AS 21 for Ind AS companies |
| Realised difference | Arises when a foreign-currency invoice or bill is actually settled |
| Unrealised difference | Arises when an open foreign-currency balance is restated at the closing rate on the reporting date |
| GST value of an export | Converted under the GST valuation rules, which may use a different rate from the accounting entry (rule 34 of the CGST Rules: goods at the rate notified under the Customs Act, services as per generally accepted accounting principles on the time-of-supply date) |
How it works
02 How it works
- Set up the account
In its own currency in the software.
- Import each line
At its foreign-currency value.
- Convert
To rupees at the rate for the transaction date.
- Match
The line to the open foreign-currency invoice or bill it settles.
- Post the exchange difference
Between the invoice-date and payment-date rates as a realised gain or loss.
- At period end
Revalue open foreign balances at the closing rate.
Multi-currency features vary by software and plan, and some tools need rates entered by hand. The exchange difference is only as accurate as the rate applied on each date.
Worked example
03 Example
An example, not advice on your facts.
An IT services firm raises an export invoice for USD 12,000 when the rate is ₹83.00. The money arrives when the rate is ₹83.50.
| Item | Working | Amount (₹) |
|---|---|---|
| Invoice recorded | 12,000 × 83.00 | 9,96,000 |
| Receipt converted by the feed | 12,000 × 83.50 | 10,02,000 |
| Realised exchange gain | 10,02,000 − 9,96,000 | 6,000 |
If instead a USD 10,000 invoice raised at ₹83 is still unpaid on 31 March, when the rate is ₹84, an unrealised gain of ₹10,000 is recorded at the year end.
Watch out
04 Common mistakes
- Using an old or manual exchange rate.
- Recording only the rupee amount, so the line cannot be matched to the foreign-currency invoice.
- Not revaluing open foreign balances at the year end.
- Booking bank conversion charges as an exchange loss. Keep charges separate.
Need help with foreign-currency bank feeds? See our Accounting Services or Xero Accounting Services.
For hands-on help, see Accounting for IT and SaaS.
Review and sources
Sources: CBIC Tax Information Portal, IGST Act s.2(6), s.16; CGST Rules 34, 89(4), 96A: official copy 1, official copy 2, official copy 3
