Auto Forex Adjustments
Contents
1. POWER OF SIMPLICITY USER MANUAL Auto Forex Adjustments Ramjaya RJ INFO MATRIX M SDN BHD Kuala Lumpur Malaysia Suite 1007 10th floor Wisma Lim Foo Yong 86 Jalan Raja Chulan 50200 Kuala Lumpur Tel 603 40451796 Fax 603 40417386 Penang Malaysia Unit 5 1 Floor 23 Lebuh Pantai 10300 Penang Tel 604 2612831 Fax 604 2613573 Johor Bahru Malaysia No 41 Jalan Berlian Kim Teng Park 80300 Johor Bahru Tel Fax 607 2268450 Email sales ramjaya com Web WwWw ramjaya com 2012 RJ Info Matrix M Sdn Bhd All rights reserved Tally Tally 9 Tally9 Tally ERP Tally ERP 9 Shoper Shoper 9 Shoper POS Shoper HO Shoper 9 POS Shoper 9 HO TallyDeveloper Tally Developer Tally Developer 9 Tally NET Tally Development Environment Tally Extender Tally Integrator Tally Integrated Network Tally Service Partner TallyAcademy amp Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt Ltd in India and or other countries All other trademarks are properties of their respective owners Version RJ Info Matrix M Sdn Bhd Auto Forex Adjustments 1 8 March 2012 Auto Forex Adjustments 1 INTRODUCTION When exchange rates fluctuate Tally automatically reports a gain or loss to balance the reports These unadjusted gain loss balances may be resolved using the voucher class in journal voucher type and manually selecting each customer or supplier and then by se2. 0 00 Dr USD1 000 00 RM 3 30 USD 1 2 2012 Supplier A USD500 00 RM 3 30 USD Purchases USD500 00 RM 3 30 USD 3 2 2012 Supplier A USD200 00 RM 3 30 USD Purchases USD200 00 RM 3 30 USD 26 2 2012 Customer A USD1 000 00 RM 3 30 USD Sales 3 300 00 Cr USD1 000 00 RM 3 30 USD 27 2 2012 Customer A USD500 00 RM 3 30 USD Sales 1 650 00 Cr USD500 00 RM 3 30 USD 27 2 2012 Customer B USD900 00 RM 3 30 USD Sales 2 970 00 Cr 1 650 00 Dr 660 00 Dr Sales Receipt Purchase Purchase Sales Sales Sales INV 1 INV 2 INV 3 INV 4 3 100 00 3 300 00 1 650 00 2 970 00 3 300 00 1 650 00 Tally automatically calculates and reports the Unadjusted Forex Gain Loss in all the related reports Balance Sheet Balance Sheet Auto Forex Adjustments Ctri M HI RJ Auto Forex Adjustments as at 29 Feb 2012 Assets Current Assets 10 740 00 Unadjusted Forex Gain Loss Total 10 880 00 Liabilities Capital Account Loans Liability Current Liabilities 3 720 00 Profit amp Loss A c 7 160 00 Opening Balance Current Period 7 160 00 Total 10 880 00 The Ledger vouchers report Date Particulars Customer A 2 1 2012 Cr Sales Sales INWA 3 100 00 USD1 000 00 RM 3 10 USD 1 2 2012 Dr Cash Receipt 3 300 00 USD1 000 00 RM 3 30 USD 26 2 2012 Cr Sales Sales INVI2 3 300 00 USD1 000 00 RM 3 30 USD 27 2 2012 Cr Sales Sales INWI3 1 650 00 USD500 00 RM 3 30 USD 29 2 2012 Unadjus
3. act support ramjaya com providing details of your requirements and we will support you through email or remote support
4. lecting each invoice of the respective customer or supplier This add on helps in creating the journals automatically thereby eliminating the manual selection of customer or supplier ledgers and their individual invoices by allowing the user to create the vouchers with the click of a button 2 ACTIVATATION For Tally ERP9 Series A version lower than Release 3 2 Gateway of Tally gt F11 Features gt Accounting Features gt Enable Auto Forex Adjustments gt Yes For Tally ERP9Y Series A Release 3 2 and above Gateway of Tally gt F 11 Features gt Add On Features gt Enable Auto Forex Adjustments Yes 3 SETUP Create a voucher type which will be used to automate the adjustments as shown below with the Method of Voucher Numbering set to Automatic Please note that the Voucher class is not required Voucher Type Alteration Auto Forex Adjustments Name Forex alias General Name of Class Printing Type of Voucher Journal 7 No Abbr Jrnl Types of Numbering Automatic Method of Voucher Numberina Setup separate ledgers for Realised cleared invoices and Unrealised pending invoices adjustments Ledger Alteration Ledger Alteration Name d Forex Gain loss Realised Name a Forex Gain loss UnRealised alias alias Under Indirect Expenses Under Indirect Expenses Currency of Ledger RM Currency of Ledger RM Inventory values are affected No Inventory value
5. s are affected No 4 UNADJUSTED FOREX GAIN LOSS As an example if the exchange rate between the base currency RM and foreign currency USD has been entered as follows Currency Alteration Auto Forex Adjustments Symbol TEJ Formal Name US Dollars Number of Decimal Places a Show Amounts in Millions Decimal Places for Printing Amounts in Words a Put a SPACE between Amount and Symbol Is Symbol SUFFIXED to Amounts No Symbol for Decimal Portion of Amount Cents Rates of Exchange Standard aE aaa Buying Date Specified Date Last Voucher Specified Date Last Voucher Rate Rate Rate Rate 31 Jan 2012 RM 3 10 USD 1 Jan 2012 RM 3 10 USD 1Jan 2012 RM 3 10 USD 29 Feb 2012 RM 3 30 USD 2 Jan 2012 RM 3 10 USD 3 Jan 2012 RM 3 10 USD 1 Feb 2012 RM 3 30 USD 1 Feb 2012 RM 3 30 USD 25 Feb 2012 RM 3 30 USD 3 Feb 2012 RM 3 30 USD 26 Feb 2012 RM 3 30 USD 27 Feb 2012 RM 3 30 USD And the following vouchers have been created with different exchange rates as per the specified rates in the currency master Day Book Day Book Date Particulars 1 1 2012 Supplier A Auto Forex Adjustments Vch Type Vch No Inwards Qty _ Outwards Qty Purchase Ctrl M amp 1 Jan 2012 to 27 Feb 2012 Debit Amount Credit Amount USD500 00 RM 3 10 USD Purchases USD500 00 RM 3 10 USD 1 550 00 Dr 2 1 2012 Customer A USD1 000 00 RM 3 10 USD es 3 100 00 Cr USD1 000 00 RM 3 10 USD 1 2 2012 Customer A USD1 000 00 RM 3 30 USD Cash 3 30
6. s at 29 Feb 2012 Assets Current Assets 10 740 00 Total 10 740 00 Liabilities Capital Account Loans Liability Current Liabilities 3 720 00 Profit amp Loss A c 7 020 00 Opening Balance Current Period 7 020 00 Total 10 740 00 The Profit amp Loss report will show the realized and unrealized balances Profit amp Loss A c Auto Forex Adjustments Ctrl M RJ Auto Forex Adjustments Particulars 1 Jan 2012 to 29 Feb 2012 Trading Account Sales Accounts 11 020 00 Cost of Sales 3 860 00 Purchase Accounts 3 860 00 Gross Profit 7 160 00 Income Statement Indirect Expenses 140 00 Nett Profit 7 020 00 The customer and supplier outstanding reports will show the forex adjustments made against the invoices and the revalued outstanding Bills Receivable 1 Jan 2012 Date Ref No Party s Name Pending Amount 26 Feb 2012 INV 2 CustomerA 3 100 00 26 Feb 2012 Sales INV 2 3 300 00 Dr 27 Feb 2012 INV 3 Customer A 1 550 00 27feb 2012 Sales INV 3 1 650 00 Dr 27 Feb 2012 INV 4 Customer B 2 790 00 2700 2012 Sales INV 4 2 970 00 Dr 29 Feb 2012 Forex 180 00 Cr Bills Payable 1 Jan 2012 Date Ref No Party s Name Pending Amount 1 Jan 2012 9876 Supplier A 1 550 00 t Jan 2012 Purchase 1 1 550 00 Cr 1Feb 2012 9934 SupplierA 1 550 00 71 Feb 2012 Purchase 2 1 650 00 Cr 3Feb 2012 9878 Supplier A 620 00 J Feb 2012 Purchase 3 660 00 Cr 29 Feb 2012 Forex Frequently Asked Questions Can the automatic calcula
7. ted Forex Gain Loss 100 00 8 050 00 3 400 00 Closing Balance 4650 00 6 050 00 6 050 00 Customer B 27 2 2012 Cr Sales Sales INWA 2 970 00 USD900 00 RM 3 30 USD 29 2 2012 Unadjusted Forex Gain Loss 180 00 2 970 00 180 00 Closing Balance 2 790 00 2 970 00 2 970 00 1 1 2012 Dr Purchases l 1 550 00 USD500 00 RM 3 10 USD 1 2 2012 Dr Purchases 1 650 00 USD500 00 RM 3 30 USD 3 2 2012 Dr Purchases 660 00 USD200 00 RM 3 30 USD 29 2 2012 Unadjusted Forex Gain Loss 140 00 140 00 3 660 00 Bills Receivable The Outstandings report 1 Jan 2012 Pending Amount Date Ref No Party s Name 26 Feb 2012 INV 2 Customer A 3 100 00 26 Feb 2012 Sales INV 2 3 300 00 Dr 27 Feb 2012 Forex Gain Loss 200 00 Cr 27 Feb 2012 INV S CustomerA 1 550 00 27feb M12 Sales INVA 1 650 00 Dr 27 Feb 2012 Forex Gain Loss 100 00 Cr 27 Feb 2012 INV 4 Customer B 2 790 00 27feb M12 Sales INV 4 2 970 00 Dr 180 00 Cr 27 Feb 2012 Forex Gain Loss 5 ADJUSTING THE FOREX GAIN LOSS Gateway of Tally gt Display gt EXception Reports gt Auto Forex Adjustment Press Ctrl S Change Setup button to setup the voucher types and the ledgers For Realised Forex Gain Loss Voucher Voucher Type Forex Forex Ledger Forex Gain loss Realised Ledgers For Unrealised Forex Gain Loss Vouche i Forex Gain loss Realised Voucher Type Forex Ledger Name Gain Forex Gain loss UnRealised Profit amp Loss A c Please note that you may change the Date b
8. tion of Unadjusted Forex Gain Loss be switched off in Tally No this is an in built feature and currently Tally does not allow this to be turned off Can the add on create separate forex journals for each customer or supplier The add on creates two journals combining customer and supplier ledgers If this feature is required please contact support ramjaya com for the cost and time estimates Does this add on automatically create the journals without any manual intervention Currently the add on requires the user to select the Auto Forex Adjustment report for a particular date preferably the end of the month and press the button s to create the journals If you require the feature of automatic creation of journals please contact support ramjaya com for the cost and time estimates What Tally ERP9 versions releases does this add on support This add on will work only with Tally ERP 9 Series A release 2 1 3 3 What about future releases of Tally ERP9 Series A On purchase of this add on one year updates will be available free of charge After the first year you can continue to get updates and support by paying the nominal charge of 30 of the purchase cost If I need changes to be made to the add on Please contact support ramjaya com providing details of the changes you require and we will revert to you with the cost and time estimates When I start using it if I have any questions or need support Please cont
9. y using the button F2 Date The report will display the adjustments required from both the realized and unrealized invoices Auto Forex Journals Auto Forex Adjustments Ctrl M B Creates forex gain loss journals 1 Jan 2012 to 29 Feb 2012 Particulars Debit Credit Particulars Debit Credit Date 29 Feb 2012 Forex Date 29 Feb 2012 Forex Gain loss Realised 200 00 Cr Forex Gain loss UnRealised 340 00 Dr CustomerA 200 00 Dr CustomerA 300 00 Cr INV 1 200 00 Dr Customer B 180 00 Cr SupplierA 140 00 Dr To create the forex adjustment journals press the button Ctrl B Create Both Alternatively you may select to create the journals for realized and unrealized selectively using the buttons Ctrl R Realised and Ctrl U Unreaslised respectively Realised Forex Gain Loss Unrealised Forex Gain Loss Journal Created Journal Created You may check the statistics to verify the forex journals created Voucher Register Auto Forex Adjustments Ctrl M HI List of Forex Vouchers 1 Feb 2012 to 29 Feb 2012 Date Particulars Vch Type Vch No Debit Credit Amount Amount 29 2 2012 Customer A Forex 1 200 00 Agst Ref INV 1 200 00 Dr Forex Gain loss Realised 200 00 Cr 29 2 2012 Customer A Forex 2 300 00 Customer B 180 00 Cr Supplier A 140 00 Dr Forex Gain loss UnRealised 340 00 Dr The Unadjusted Forex Gain Loss balance in the Balance Sheet will not be shown Balance Sheet __ Auto Forex Adjustments Ctri M HI RJ Auto Forex Adjustments a
Download Pdf Manuals
Related Search