Accounting for Unadjusted Forex Gain or Loss: Tally Entry Guide

Forex trading involves inherent complexities, especially when accounting for gains and losses arising from currency fluctuations. This article provides a comprehensive guide on how to handle unadjusted forex gains or losses within Tally ERP 9, focusing on accurate journal entries and reporting. Tailored for the TradingView audience, this guide offers clear verdicts and informed predictions for long-term advantages.
Understanding Unadjusted Forex Gain or Loss
Definition of Unadjusted Forex Gain or Loss
Unadjusted forex gain or loss refers to the difference between the recorded value of a foreign currency transaction and its value at the reporting date, which has not yet been formally accounted for through an adjustment entry. This typically arises due to timing differences between the transaction date and the period-end valuation.
Why Unadjusted Balances Occur in Forex Trading?
Unadjusted balances occur due to:
- Fluctuating Exchange Rates: Exchange rates constantly change, leading to differences between the initial transaction value and the closing value.
- Timing Differences: Transactions may occur close to the reporting period-end, leaving insufficient time for adjustment.
- Accounting Policies: Differing accounting policies may delay the recognition of forex gains or losses.
Impact on Financial Statements
Failure to account for these unadjusted balances can lead to:
- Inaccurate Financial Reporting: Misrepresentation of assets, liabilities, and profitability.
- Non-Compliance: Violation of accounting standards and regulatory requirements.
Tally ERP 9: Forex Transactions Setup
Enabling Forex Functionality in Tally
To manage forex transactions in Tally:
- Go to Features (
F11). - Select Accounting Features.
- Enable Maintain foreign currency ledger.
Creating Ledgers for Forex Transactions
Create necessary ledgers such as:
- Foreign Currency Debtors: For customers paying in foreign currency.
- Foreign Currency Creditors: For suppliers paid in foreign currency.
- Forex Gain/Loss Account: To record the adjustments.
Configuring Currency Masters
- Go to Info
(Alt + K)-> Currency -> Create. - Define the foreign currency (e.g., USD, EUR) with its exchange rate.
- Update the exchange rate regularly to reflect market values.
Recording Forex Transactions in Tally
Entering Purchase Transactions with Forex Impact
When recording a purchase, enter the invoice in the foreign currency. Tally automatically converts the amount to your base currency using the exchange rate on the transaction date.
Entering Sales Transactions with Forex Impact
Similarly, for sales, record the invoice in the foreign currency. Tally calculates the base currency equivalent using the prevailing exchange rate.
Recording Forex Payments and Receipts
When recording payments or receipts, Tally calculates the forex gain or loss based on the difference between the exchange rate at the time of the transaction and the original invoice rate. This gain or loss is automatically reflected in the forex gain/loss account.
Passing Adjustment Entry for Forex Gain or Loss
Identifying Unadjusted Forex Gain or Loss in Tally
Run reports to identify open invoices in foreign currencies. Calculate the difference between the recorded value and the value at the current exchange rate.
Creating a Journal Voucher for Adjustment
Go to Accounting Vouchers and select Journal (F7).
Debit and Credit Entries Explained
- For Forex Gain: Debit the Foreign Currency Debtor/Creditor account and credit the Forex Gain/Loss account.
- For Forex Loss: Debit the Forex Gain/Loss account and credit the Foreign Currency Debtor/Creditor account.
Example Journal Entry with Figures
Assume a receivable of USD 1,000 recorded at an exchange rate of 75 INR/USD. The current exchange rate is 76 INR/USD. The unadjusted gain is (76-75) * 1000 = 1,000 INR.
Journal Entry:
- Debit: Foreign Currency Debtor (Sundry Debtors) – INR 1,000
- Credit: Forex Gain/Loss Account – INR 1,000
Reporting and Reconciliation
Viewing Forex Gain/Loss Reports in Tally
Use the Trial Balance and Profit & Loss reports to view the impact of forex gains and losses on your financial statements. Drill down into the Forex Gain/Loss Account for detailed transactions.
Reconciling Forex Transactions
Regularly reconcile foreign currency transactions with bank statements and supplier/customer confirmations. Investigate and resolve any discrepancies promptly.
Best Practices for Forex Accounting in Tally
- Regularly Update Exchange Rates: Keep the currency master updated with current exchange rates.
- Use Appropriate Accounting Standards: Adhere to relevant accounting standards for forex transactions.
- Document Everything: Maintain detailed documentation of all forex transactions and adjustments.
By following these guidelines, you can accurately account for unadjusted forex gains and losses in Tally, ensuring compliance and providing reliable financial information.



