1 / 24

FIXED ASSET REGISTER

FIXED ASSET REGISTER. Instruction of excel template Fixed assets register with two currencies. FIXED ASSET REGISTER.

nessa
Download Presentation

FIXED ASSET REGISTER

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. FIXED ASSET REGISTER Instructionofexcel template Fixed assets register withtwocurrencies KGG financial reporting

  2. FIXED ASSET REGISTER Thisexcel template is specific a goodtoolwhen a branchneedtoreportfixed assets in twocurrenciesduetothat the original company has an anothercurrency. An otherexample is when a company do report in anothercurrencythan the homecurrency. In thiscases the companyneedsto still tohavecontrollof the localcurrency. The template onlytakecareofhistoricalvalues, no currencyconversioncan be madeafterenter the asset. KGG financial reporting

  3. The start is the Menusheet. From hereyouwill be ableto cover all features in the template. FIXED ASSET REGISTER KGG financial reporting

  4. Enter new Identity FIXED ASSET REGISTER KGG financial reporting

  5. Enter new investment FIXED ASSET REGISTER Following data is mandatory toenter a new investment: Identfication nr Part Description Acquistioncostlocal Acuistioncostgroup Acquistion date At leastoneEconomic Life time and Depreciation from KGG financial reporting

  6. Enter new Identity FIXED ASSET REGISTER In somecasesyouneedtoadjusteconomiclifetimeafter the firstentry. Youhave the possibilitytoadd 10 different economiclifetimes. The accumulatedadjustementdue the changeof a economiclifetimewill be treated in the period when the change has beendone and will be treated as depreciation. If the asset has been sold youhave the possibilitytoenter the sales date and salesvalue. KGG financial reporting

  7. Enter new Identity FIXED ASSET REGISTER Afterthatyoupushed the save button all data is saved and youhave the possibilitytoenter the next item. If youneedto do a changeyouhavetoclosethissheet on the Close button, youare back at the Menusheet. KGG financial reporting

  8. FIXED ASSET REGISTER To change an asset thatalready has beenenteredyouneedto push the buttonOpen investment. KGG financial reporting

  9. FIXED ASSET REGISTER Enter the Identification and Part for the investment youwanttochange. KGG financial reporting

  10. FIXED ASSET REGISTER Youhavenow the possibilitytochange all data exceptIdentification and part numberofcourse. If youchangeeconomiclifetime for a period thatalready has beencalculated the program willrecalculatebackward in time. KGG financial reporting

  11. FIXED ASSET REGISTER If youwanttodelete an investement push the buttonDelete investment. KGG financial reporting

  12. FIXED ASSET REGISTER After an controllquestionyouwillhave the possibilitytoselect the investment youwanttodelete. KGG financial reporting

  13. FIXED ASSET REGISTER Youneedto push the buttonRundepreciationifyouwantto make depreciations. KGG financial reporting

  14. FIXED ASSET REGISTER Specify the year and month. If youspecify a period there prior month has not be calculated the program will ask youif it is alrighttocalculatemorethan 1 month. KGG financial reporting

  15. FIXED ASSET REGISTER Push Total reportto get a reportof all investment for a specific period. KGG financial reporting

  16. FIXED ASSET REGISTER Select the Year and Monthyouwanttosee. KGG financial reporting

  17. FIXED ASSET REGISTER Youwill get a report the the specific period in local and groupcurrency KGG financial reporting

  18. FIXED ASSET REGISTER Push Individualreportifyouwanttosee data for a specific investment. KGG financial reporting

  19. FIXED ASSET REGISTER SelectIdentficationnumber and Part. KGG financial reporting

  20. FIXED ASSET REGISTER Thisreportwillgive all the data for a specific investment. It willofcourseonlygiveyou the depreciationsthat has beendone. KGG financial reporting

  21. FIXED ASSET REGISTER If youwanthave a reportshowing all investment that has beenentered in the register push the button All investment report. KGG financial reporting

  22. FIXED ASSET REGISTER If youwanttoseewhatentriesthatneedsto be done for a specific period, push the button Journal. KGG financial reporting

  23. FIXED ASSET REGISTER Select the year and monththatyouwanttosee. KGG financial reporting

  24. FIXED ASSET REGISTER The journal is divided in one part for a yearly journal and one for a monthly journal. The yearly journal shouldofcourseonly be madeonetime. Youcanofcourseusethiseverymonthifyoureverse the journal from prior month. Monthly journal should be usedifyoumadeone journal everymonthduring the year. KGG financial reporting

More Related