UNADJUSTED FOREX GAIN/LOSS IN TALLY

Dear Bhuvanesh,

Did you solved this issue?,

I have same problem. If you got solution please share with me.

Dear Rajasekar,

I got solution from your file.

It's very useful.

Thanks a lot for your help and sharing knowledge 

Good Day to All, We are in export business and using tally 9, whenever i book a sales entry AUTOMATICALLY MY tally shows some amount in unadjusted gain /loss. Normally after the receipt of the money only we can know whether it's gain / loss. CAN ANYBODY SOLVE THIS PROBLEM.  

 

simple in how many ledger showing that error check once then create new ledgers with same name and transfer all enries in new ledger than delete old  ledger...

the reason is in master ledgerin curency ledger put only inr simble(),, dont write Rs. and dont leave MT

Good Day to All, We are in export business and using tally 9, whenever i book a sales entry AUTOMATICALLY MY tally shows some amount in unadjusted gain /loss in balance sheet.. Normally after the receipt of the money only we can know whether it's gain / loss. 

Now how to pass the entry as we have not receive the payment from client?  

Requesting to please update me as early as possible

Read more at: https://www.caclubindia.com/forum/unadjusted-forex-gain-loss-in-tally-17124.asp

Good Day to All, We are in export business and using tally 9, whenever i book a sales entry AUTOMATICALLY MY tally shows some amount in unadjusted gain /loss in balance sheet.. Normally after the receipt of the money only we can know whether it's gain / loss. 

Now how to pass the entry as we have not receive the payment from client?  

Requesting to please update me as early as possible

Read more at: https://www.caclubindia.com/forum/unadjusted-forex-gain-loss-in-tally-17124.asp

To simplify and automate your forex accounting process, you can use our tool – XLTool – Excel to Tally Import Tool. It helps you manage foreign currency entries with correct exchange rates and eliminates manual errors that lead to unadjusted gain/loss issues.

Here's how you can address the issue you're facing:

1. In Tally 9, when you pass a foreign currency sales entry, Tally automatically calculates the exchange rate difference based on the rate entered at the time of invoice versus the rate defined in the currency master (standard or last rate).

2. This results in an unrealised gain/loss being shown even before actual payment is received.

3. To avoid this, make sure:

   • The correct exchange rate is used while creating the sales invoice.

   • In F11 → Accounting Features, you can disable "Adjust Forex Gain/Loss Automatically" if enabled.

4. Ideally, you should book the invoice with the actual exchange rate agreed with the buyer, and later, once the payment is received, pass a journal entry to record the actual gain/loss if there’s any difference.

To streamline this and ensure accurate entries with real-time exchange rates, you can use XLTool – Excel to Tally Import Tool. It helps automate the sales and receipt entries from Excel with correct forex data, including currency, rate, and gain/loss calculation.

Download Link at: https://xltool.in/excel-to-tally-import/