Monday, September 8, 2008

How to manage Unadjusted Forex Gain \ Loss in Tally 9?

When we deal with foreign currencies while importing (Purchasing) or exporting (Selling) our goods, we’ll sometime get difference between the amount of our Purchase /Sales invoice and Payment / Receipt due to foreign currency fluctuation rates. We’ll face gain / loss due to these transactions. To explain further with example, assume that you made a foreign sale of 100 nos. of your Men’s Garments at the rate of $43 on 1st Sep 08. So the total value of your invoice amount is $4300/- i.e. Rs.184900/-. But you received $4400/- i.e. Rs.189200/- against this invoice on 25th Sep 2008, due to sudden rise in the dollar value. So, the difference of Rs.4300 would be treated as Forex Gain and gets displayed in the Liabilities side of your Balance Sheet automatically. This amount can be adjusted with the Profit or Loss by passing a Journal with voucher class as explained under.

Create a 'Class' in the normal way (Accounts Info > Voucher Types > Alter > Journal) & name it as ‘Forex Class’. Now pass a journal selecting the class during Voucher Entry. You will find only those Ledger Accounts appearing which have a Gain / Loss to be adjusted as of the date of voucher and auto-calculation of these amounts.


You’ll find now the Unadjusted Forex Gain / Loss appeared earlier in the Balance Sheet would be now added with the Profit or Loss amount.



9 comments:

Unknown said...

Hi :

Thanks for the information on the Tally 9 - Unadjusted forex gain or loss.

I am in import bsuiness. There are two scenarios

1) We make payment at say 49 per USD and at the time of import after a month the dollar depriciates or appreciates leading to forex gain or loss.

2) We send USD 10000 @ 49 and receive good worth only 9500 @ 48 leading to two options
a) forex gain of rupee 1 on USd 9500 = 9500 rupees
b) credit balance of supplier for USD 500 @ 49 = 45000

Now the problem is that tally 9 also takes (b) result in unadjusted forx gain or loss which is incorrect. How do we solve this ? Can you provide us a solution

Regards,
Sammarth Loya

Unknown said...

helo , i am writing from mumbai . i have a query. I pass sales entry in foreign currency. the amount i receive against this invoice is deposited in dolar account. the dollar accumulated is sold after 6 months when we get good rate and transferred to my current account. how should i do the entries in tally. my bank dollar account balance should tally with bank dolar act balance. pls help

kappimala said...

Hai, thanks for your helpful article.

Unknown said...

Thanks for some great points i learned a few things, This is a nice little blog 3rd one on google keep up the good work..........Tally Training

Unknown said...

do we hve to make ledger of forex gain/loss??

Blogger said...

GPS robot tripled the $100k deposit [live proof authenticated by myfxbook and broker]

I just completed a webinar with Mark and his partner, Antony, two days ago and it was GREAT.

During the webinar Mark and Antony shared their secrets to success and answered questions about their new release of the GPS Forex Robot that came out TODAY!

Unknown said...

How to remove the fire gain loss entry to tally

Blog27999 said...

Your Affiliate Money Making Machine is waiting -

And earning money online using it is as simple as 1---2---3!

Here is how it all works...

STEP 1. Input into the system what affiliate products you intend to promote
STEP 2. Add PUSH BUTTON traffic (it takes JUST 2 minutes)
STEP 3. See how the system explode your list and up-sell your affiliate products all on it's own!

Are you ready??

Click here to check it out

وليد العروي said...

كشف تسربات المياه
عزل اسطح
تسليك مجاري
مكافحة حشرات
شركة لمسات الابداع