Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    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.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    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

    1. Set up the account

      In its own currency in the software.

    2. Import each line

      At its foreign-currency value.

    3. Convert

      To rupees at the rate for the transaction date.

    4. Match

      The line to the open foreign-currency invoice or bill it settles.

    5. Post the exchange difference

      Between the invoice-date and payment-date rates as a realised gain or loss.

    6. 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

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    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

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →