222

$show=home

Welcome to Accounting Education

The Accounting University with 3400+ Accounting contents as study material which can watch, read and learn anyone, anywhere.

Start your studies

$show=home

Latest $type=blogging$count=5$author=hide$comment=hide$label=hide$date=hide$show=home

Solution of Multi Currency Accounting Problem

Question Asked by student


Dear Mr. Vinod

Hi

I am Accountant from Kuwait. I have Read About your article On Multi Currency. But it’s Not Solve My Problem. My problem is EXP: We Got a Purchase order of 40000.00 US $. We are doing Business in Kuwait so we are using the currency Kuwaiti Diner KWD. Now according the purchase order we have prepare the invoice 0f 40000.000 but in sales Amount shows as 40000KWD. And please tell me how to set the EXCHANGE Rate. And Is There is any need to change the currency in ledger. I have made change in currency in ledger. But it is not showing any changes in currency showing in account. And sale amount are not shown in debtors a/c is shown on UN adjusted forex Loss / gain. Please help me to get out from this problem.

Regards
from Accountant


Answered by Accounting Teacher

Dear Student,

Good Evening

You did not tell me which accounting software you are operating. I assume, you have operating tally 9 accounting software for recording above. Now again, I am explaining the complete procedure of recording transaction in multicurrency. I have spent two hours of my worthy time to solve your problem so please , seriously understand and if you did not understand any thing again you can mail me for further explanation , because it will also helpful for your future accounting career .

Ist basic thing
Your journal entry must be as follow

Debtor account Debit 400000 $
Sale Account Credit 400000$


but if you have passing voucher bill by bill , you need not remember this journal entry . you only mention party name and sale ledger . Tally automatically record above entry .

Now, understand the concept
1st Condition

You must keep your base currency as Diner



Allow multi currency in feature F11

Feature >> accounting feature >> allow multicurrency = yes and accept feature form

If you did not allow, then you can not pass the voucher entry in foreign currency.


2nd Condition


Create the ledger of Currency

It means

Creation of currencies

You need not make the ledger greation of diner because , it is your base currency and tally automatically create it . you only have to create USA dollar currency






After this fix rate of exchange . For this you have to see current market rate of diner in usa dollar

I have fixed Value of 1 Dollar = 0.29 per Diner according to 28 March 2009 market situation

Because value of diner in currency is more than USA dollar in world market. And show with following way .


After this you will create ledger of your debtors


Suppose ABC company of usa is your debtor and if you want to show currency ledger in usa dollar , then put the symbol of usa dollar as $ and accept the form



And also make sale ledger


And its currency will Diner automatically



You also need to create inventory ledger for recording the items . In inventory lnfo . you have to create

unit measurement

stock items

Because with this we can also track your closing stock .


After this pass the voucher entry

1st when company purchase , which is not mention in example , but I have taken an example suppose your company have bought 50000 kg dry fruit at 1 diner per kg and pay 50000 diners .




After this when you sell

Pass the voucher entry in sale voucher

Remembering that

When you show the value in sale voucher , you must write symbol of dollar as $ before showing the amount of sale , tally automatically calculate your currency value in diner . See also picture and understand by yourself . I have mention the two pin points



This is really difficult question . I have happened same problem in earlier query , I already solved same query of another student , so I remember this point .

You can also calculate your forex profit or loss

By going

Display >> trial balance unadjusted forex gain loss >> current asset >> sundry debtor >> choose debtor >> and find the report of forex gain loss



But tally profit will show automatically in your own currency means diner .

COMMENTS

: 7
  1. very informative but still the Banl account shows the base currency value only and not the USD value entered in overall BS/PF or ledger

    ReplyDelete
  2. We have same Company as a Creditors & Debtors and we would like to pass a contra entry for multy currency, plz explain me how to pass?

    ReplyDelete
  3. We have same company as a creditors and debtors and we want to pass a contra entry for that in multy currency, plz can u explain me? thanks

    ReplyDelete
  4. When creating new ledger with foreign currency, cannot use bill wise details. How can we do that.

    ReplyDelete
  5. How to disable multi currency in tallyerp 9?

    ReplyDelete
  6. Hello sir, please I want to deactivate my mutilple currency function. How can I do that?
    Am using Tally erp 9.
    Thanks
    liberalgrace@yahoo.com

    ReplyDelete
  7. how we can remove the unadjusted forex gain/loss

    ReplyDelete
In comment, you can give your feedback, reviews, ideas for improving content or ask question relating to written content.

Name

access,2,account,86,accountant,94,Accounting,680,accounting definitions,99,accounting ebook,3,Accounting education,85,Accounting Education Ads Help,1,accounting procedure,2,accounting process outsourcing,2,Accounting Software,52,advance,3,advertising,6,africa,7,Amalgamation,6,amendments,16,announcements,62,Annuity,2,assets,53,audit,46,auditing,41,Australia,2,B.Com.,22,balance sheet,86,bank,111,Bank reconciliation,12,banking,33,basic accounting,110,BBA,1,benefits,13,best,50,bill,12,black money,3,blog,12,bloggers,7,book keeping,4,bookkeeping,3,Branch Accounting - full tutorial,8,budget,35,Budget variance,13,business,65,businessman,9,CA,30,calculator,4,canada,3,capital,72,capital budgeting,27,career,21,cash,40,cash book,8,cash flow statement,11,Chiense,1,children,13,china,6,class,3,coaching,2,coins,2,college,6,commerce,10,commerce students,7,company,36,computer,9,computer accounting,1,conference,4,Contact vinod kumar,1,Control Your Spending,27,corporate accounting,69,cost,160,cost accounting,195,cost center,8,cost centre,1,CPA,2,credit,18,credit card,11,cs,10,currency,35,data,11,Debit and credit,17,debit cards,1,debt,62,debtor,21,degree,6,depletion,2,depreciation,38,Diwali Messages,12,documents,4,dollar,5,domain,3,Downloads,3,Dubai,1,e-accounting,17,earning,17,education,247,Education Loans,6,email,15,employee,4,EPF,2,ERP,7,euromoney,1,examination,7,excel,17,excise duty,6,expenses,65,facebook,7,factor of loan,1,fans,2,feature,32,fifo,5,FII,4,fiji,1,finacle,1,finance,823,Finance Journal Entries,4,Financial,134,financial accounting,145,Financial Statements,3,fire insurance,3,flickr,2,flow,4,forensic,4,forex,21,formula,8,france,1,fraud,6,free,2,fun,34,function,1,fund,48,GAAP,36,GDP,1,gdr,5,germany,1,gold,7,goodwill,4,goodwill accounting,3,google,34,google apps,3,google apps,1,google base,1,google buzz,1,google calendar,1,Google docs,38,google finance,3,google fusion tables,1,google talk,5,govt.,5,GST,33,guide,85,health,6,Hindi,2,Hindi Language,3,history,3,holding company,3,How to treat FBT in Tally 9,1,HRA,3,ICAI,11,ICAWI,3,ICICI Bank,1,IFRS,11,income,17,income statement,19,Income Tax,7,India,57,indian railway,1,Indonesia,1,inflation,4,inflation accounting,3,infographics,8,information,7,inspiration,176,insurance,14,insurance accounting,2,Intangible,3,interest,26,international,7,Internet,41,Introduction of Tally 9,1,inventory,41,investment,135,investment in Shares,6,invoice,3,IT,1,Japan,1,Job costing,4,journal entries,140,Journal Entries eBook Help,4,Kalculate,1,keyboard,3,kuwait,2,laptop,2,law,4,LBT,1,learning,36,lease,5,lecture,11,ledger,17,leducation,1,Leverage Analysis,7,liabilities,16,lifo,3,linkedin,1,loan,74,logical point,1,loss,5,loss of profit,1,M.Com.,5,m.phil,2,malaysia,3,management accounting,129,manual accounting,4,manufacturing account,1,market,11,marketing,3,mastercard,2,material,13,MBA,14,MCA,1,media,4,migration,2,mobile,9,money,61,ms word,3,ms. excel,14,multi currency in tally 9,1,Multicurrency Accounting,3,mutual fund,30,national security,1,new and sacrifice ratio,1,new york times,1,new zealand,1,news,1,NGO,5,nonprofit-accounting,6,North Georgia Mountains,1,Notification,1,NPV,17,NSE,1,odbc,2,office,10,oman,1,online application,2,online accounting,11,Online Accounting Course,5,otcei,1,pakistan,3,parents,3,Partnership,1,pay pal,3,pdf,4,Personal Finance,6,pie chart,1,pie chart of income,2,pnb,5,podcast,1,ppf,1,presentation,10,price,7,privacy policy,2,prof. vinod kumar,13,profit,24,profit and loss account,12,project management,11,provision,13,purchase,9,puzzles,2,quickbooks,2,Quote,22,quotes,42,quotes of svtuition,1,rating agency,2,ratio analysis,34,RBI,7,readers,13,real estate,13,rectification of errors,11,remote control,2,reports,10,reserves,8,responsibility accounting,4,retirement,2,revenue,3,Revenue reserves,2,review,7,risk,11,rupees,9,salary,5,sale,12,SAP,3,saudi arabia,1,saving,19,sbi,9,scholarship,2,school,1,SEBI,13,security,30,service tax,23,share,20,share trading,15,Shares,16,shri lanka,3,singapore,2,sms,6,social accounting,7,society,5,solution,218,South Africa,1,stock,24,stock exchange,22,structure,6,student,39,students,70,study,21,subsidiary company,2,svtuition,14,swiss bank,2,tally,100,tally 9,8,Tally 7.2,8,Tally 9,42,Tally.ERP 9,59,TallyPrime,1,tanzania,2,tax,94,Tax Accounting,30,TDS,15,teacher,62,teaching,112,technology,33,test,40,testimonial,15,testimonials,15,thailand,1,tips,60,trading,5,trading on equity,2,transaction,7,trend,12,trial balance,14,truthfulness,1,tuition,3,twitter,10,UAE,5,UGC - NET Commerce,13,UK,11,United Arab Emirates,1,university,9,usa,25,valuation,9,VAT,22,Video,36,Voucher and vouching,4,Wealth,8,wikipedia,25,working capital,29,youtube,14,
ltr
item
Accounting Education: Solution of Multi Currency Accounting Problem
Solution of Multi Currency Accounting Problem
https://1.bp.blogspot.com/_DJEIRrK4tl4/Sc5EGdrTG7I/AAAAAAAADGQ/cX2fu4TgV_E/s400/diner.PNG
https://1.bp.blogspot.com/_DJEIRrK4tl4/Sc5EGdrTG7I/AAAAAAAADGQ/cX2fu4TgV_E/s72-c/diner.PNG
Accounting Education
https://www.svtuition.org/2009/03/solution-of-multi-currency-accounting.html
https://www.svtuition.org/
https://www.svtuition.org/
https://www.svtuition.org/2009/03/solution-of-multi-currency-accounting.html
true
2410664366776677676
UTF-8
Loaded All Posts Not found any posts VIEW ALL Reply Cancel reply Delete By Home PAGES Contents View All RELATED CONTENTS FOR YOUR LEARNING Topic ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy