Do you want to Learn Tally TDL?

forex in tally erp 9 How to do Bill wise Details for export-import

Forex in tally erp 9 is requires If you are engaged in the business of imports-exports then you have to record purchase-sales in a foreign currency other like USD $ other then the base currency. But the common problem is that its difficult to set up Bill wise transactions in Tally.ERP 9.

Here in this tutorial we will see how to record Forex in tally erp 9 with a little explanation and quick how to do method.

But before you start recording your Forex transaction, be care full and enter the base currency while creating a suppliers/ customer’s  ledger account as INR rupee or your local currency and Don’t set your base currency a foreign currency.This is necessary to get the bill wise details for your exports-imports transactions

In tally.erp 9 if we maintain suppliers/customers account in foreign currency then it is not possible to manage bill wise details for sundry creditors/sundry debtors. I have raised the query with tally solutions and they suggested me to maintain suppliers/customer account in base currency and then to enter sales/purchase in a foreign currency. in that case we will also be able to view forex transaction as well as INR amount along with bill wise details.

Trust that the information will help users a lot

Forex in Tally Erp 9

Maintenance of Forex in tally erp 9 is requires to find out dues receivables or payable in multi currency other wise it would be difficult to find out which bill is due for payment or receipts. The problem is that if you set up a currency in a supplier/customer ledger other then the base currency then you will not be able to get reports of bill wise details in Tally.ERP 9.


Forex in tally erp 9 Solutions:

Set up the base currency in supplier or customer ledger master and then while recording the transactions prefix the actual dealing currency and record the transactions normally. By this way, you will be able to generate bill wise details Forex in Tally.Erp 9.

We believe Tally Solutions should work on this and should fix this bug


About the Author

Mahendra is founder and CEO of the I Vision Infotech, Authorised Tally Sales and Service Partner and helping Tally users to learn Tally and accounting free through this site

Leave a Reply 7 comments

nikhil mittal - 5 years ago Reply

Greetings of the day dear sir/ mam,
am using tally 9.0, in our office coming material on rent and i want to know that how can i maintain stock material on rent basis in-which i get monthly report (total material period, total rent after one month etc.)
is it possible in tally?
please revert me as soon as possible.

Thanking you
Nikhil Mittal

Deewan Singh - 4 years ago Reply

is there is option for sundry creditor details export from tally erp9 like name,address,pan no… if yes kindly share with me in my mail id

SURESHKUMAR .R - a couple of years ago Reply

I have working tally erp 9 more than six years and above. currently i am searching accountant [TALLY ERP] job. Any vacancy kindly inform to me.

rajendra mehta - a couple of years ago Reply

thanks for free help to tally users, it’s great sir, i like your valuable thoughts. i have interest to learn Service & TDS. How to use in tally. you have it’s ppt please send to my e mail.

Tarun Kumar - last year Reply

Hi. Myself Tarun from Thailand. I have just setup tally in my company in last year at bangkok and i enabled forex gain or loss in tally.erp 9. I am happy with all of it’s function. But i have a problem it is not meeting with thai direct tax requirement while adjust UNADJUSTED FOREX GAIN OR LOSS.

In thailand while closing of books for financial year. We have to show our foreign creditor ( supplier accounts) with $-Thai Baht as per bank Selling Rate ( because taxation of thailand said that if we will pay to our supplier then we have to purchase dollar from bank. So in this case revenue department want us to book forex gain or loss adjustment for supplier as per bank $ selling rate and opposite for foreign debtors ( customer ), here revenue department want us to book forex gain or loss adjustment entry with bank $ purchase rate (which will less than bank $ sale rate).

Here as per above detail, i have to book (example – 31st december- 2014 , bank selling rate 32 baht/$ for supplier and bank purchasing rate 31 baht/$ for customer) two separate rate on year end date for supplier and customer. but in tally i am able to book forex gain or loss entry only with one specify rate.

Hope my explanation will easy to understand. But if you find any problem to understand then please feel free to write me on my email

it will a great help to me if you can fix / advice me solution for same.

thanks a lot for your time.

Best Regds

Mahendra Rana - last year Reply

I believe in Tally.ERP 9, there are purchasing rate as well as selling rate conversion rates can be specify.

Have you checked the master currency ledger by setting seller/purchasing rate!

Gopal - 9 months ago Reply

I am tally erp 9 helps provide

Leave a Reply:

error: Alert: Content is protected !!