Tag: forex gain loss

  • Step-by-Step Guide to Multi-Currency in TallyPrime (Export, Import & Forex Gain/Loss)

    🌍 Multi-Currency Transactions in TallyPrime

    🔹 Step 1: Enable Multi-Currency Feature

    1. Open TallyPrime → Press F11 (Features) → Accounting Features.
    2. Under General, set “Enable Multiple Currencies” → Yes.
    3. Save settings.

    🔹 Step 2: Create Currencies

    1. Go to Create → Accounts Info → Currencies → Create.
    2. Example:
      • Currency Name: US Dollar
      • Formal Name: USD
      • Symbol: $
      • Is symbol suffixed to amount: Yes
      • Number of decimal places: 2
      • Show amounts in millions: No
      • Specify Rate of Exchange: 1 USD = ₹84 (as on today’s rate)

    Repeat for other currencies (Euro, Pound, etc.).


    🔹 Step 3: Create Ledger Accounts

    • Bank Ledger (USD A/c) → Bank A/c under Bank Accounts, select currency as USD.
    • Customer Ledger (ABC Inc., USA) → Sundry Debtor, set Currency: USD.
    • Sales Ledger → Invoicing → Use default Base Currency (INR).

    🔹 Step 4: Record Multi-Currency Sales Voucher (Example 1: Export Sales)

    Scenario:

    👉 You sold goods worth $1,000 to ABC Inc. (USA).
    👉 Exchange Rate: 1 USD = ₹84

    Steps:

    1. Go to Sales Voucher (F8).
    2. Select Customer: ABC Inc. (Currency USD).
    3. Enter item details, amount will show in USD.
      • Example: 1,000 USD.
    4. Tally automatically converts → ₹84,000 (in INR books).

    📌 Entry shown in Tally

    • Dr. ABC Inc. (USD) → $1,000 (₹84,000)
    • Cr. Sales A/c → ₹84,000

    🔹 Step 5: Record Receipt Voucher (Example 2: Payment Received in USD)

    Scenario:

    👉 Customer pays $1,000 later, but now exchange rate = ₹85.

    1. Go to Receipt Voucher (F6).
    2. Dr. Bank A/c (USD) $1,000 (₹85,000).
    3. Cr. ABC Inc. (USD) $1,000 (₹84,000).

    📌 Tally automatically shows Forex Gain: ₹1,000 (difference due to exchange rate).


    🔹 Step 6: Import Purchase Example (Vendor in USD)

    Scenario:

    👉 You import raw materials worth $500, exchange rate ₹83.
    👉 Bank pays later at ₹84.

    1. Purchase Voucher (F9) → Select Supplier (USD Ledger).
    2. Purchase recorded as $500 = ₹41,500.
    3. At payment time (Payment Voucher F5):
      • Dr. Supplier $500 = ₹42,000
      • Cr. Bank A/c = ₹42,000
      • Forex Loss = ₹500

    🔹 Step 7: Reports & Analysis

    • Check Ledger → Customer/Supplier → Display → Tally shows both foreign currency & INR equivalent.
    • Balance Sheet / P&L → Consolidated in base currency (INR).
    • Forex gains/losses shown separately.

    ✅ Practical Example Summary

    TransactionCurrencyRateLedger Impact (INR)Forex Effect
    Sales to US Client$1,00084₹84,000–
    Receipt from Client$1,00085₹85,000Gain ₹1,000
    Import Purchase$50083₹41,500–
    Payment to Supplier$50084₹42,000Loss ₹500

    👉 This way, TallyPrime auto-tracks exchange rate fluctuations and shows real forex gain/loss in your accounts.