1 / 12

Accounting Multi Currencies

Accounting Multi Currencies. Instruction of excel template Accounting mult currencies. Accounting Multi Currencies.

yetty
Download Presentation

Accounting Multi Currencies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Accounting Multi Currencies Instructionofexcel template Accountingmultcurrencies KGG fiancial

  2. Accounting Multi Currencies Thisexcel template is a toolto understand what is happening in the general ledger for different kind of journal entries. Is not a bookkeeping system or a consolidation system. Youcanuse multi numberofcompanies and multi numberofcurrencies. Youareabletosee the resultofyourentries in a trial balance or as T-accounts. KGG fiancial

  3. The start is the Menusheet. From hereyouwill be ableto cover all features in the template. Accounting Multi Currencies KGG fiancial

  4. Push the button Settings. This is somethingyouneedtospecify. Add the curreniesthatyouwanttouse in the template. Year and Group currency is also mandatory toenter. Accounting Multi Currencies KGG fiancial

  5. Next step is the Accountsthatyoushoulduse. It is importanttoaddwether the account is a Profit and loss or a balancesheetaccount. It will not be showed in anyreportsifthis has not beenspecified. Accounting Multi Currencies KGG fiancial

  6. NextbuttonCurrency rates – Specify the currency rates for each period. Group valueswill not be calculatedifcurrency rate is missing. The averagemethod is used for currencytranslation. Accounting Multi Currencies KGG fiancial

  7. Company list button – Specify the companiesyouwanttohave in the template and whatcurrency rate thesecompanieshave. Accounting Multi Currencies KGG fiancial

  8. Company list button – Specify the companiesyouwanttohave in the template and whatcurrency rate thesecompanieshave. Accounting Multi Currencies KGG fiancial

  9. Next step is actualy the journal. Youcan in thissheet do entry for severalcompanies in severalmonths. Youneedtospecifyfolliwing parameters, if not the template will not calculateproperly. Period Nr Company Accounts Accounting Multi Currencies KGG fiancial

  10. Youcannowsee the result from yourentries. Firstselect the period youwantto analys. Accounting Multi Currencies KGG fiancial

  11. Afteryouhaveselected the period youwillsee the result in a trial balance. In the cell ”Company” youcanchange the company. If youleave it blank it will be the consolidatedfigures. Accounting Multi Currencies KGG fiancial

  12. Youhavealsopossibilitytoanalyse the entries in a classic T account. All companieswillshowed in the reportboth in localvalues and groupvalues. Accounting Multi Currencies KGG fiancial

More Related