Require Format For Asset Managment Of An IT Company

Grace79
Hi,
I am working as HR in a Software Development Company and I have been asked to maintain the records of all the assets of my company.
Can anybody here help me out either with an excel format or any other free software available in the google.
Thank you very much
Pankaj Sharma Jaipur
You may prepare this in excel file by including the following columns :
1) Sr.No.
2) Asset Name
3) Date of purchase
3) Brand Name / No.
4) Placed at
5) Used by
Regards,
Pankaj
vijaya Lakshmi Y
We are presently maintaining the asset register with following details :
Asset No (Asset code is created as and when a new asset is added to list)
Make (Brand name)
Model
Specifications
Supplier
Invoice No
Invoice Date
Invoice Amount
Duty paid (Sales tax/Vat/import duty)
Place of delivery
Location Place / allocated to ( for eg. computers allotted to dept, particular employee)
Depreciation Amount (to be calculated at end of every year)
Status (whether in working condition, under repair, recommended for replacement)
Sold details (if the company decides to exchange or sell of the asset) amount sold, exchanged with date.
Hope this info will be useful for you. We maintained a compurterized asset register.
Rgds
Vijaya Lakshmi
Grace79
hi,
Thanks a lot Vijaya lakshmi. you have help me out a lot. i am getting clarity over the matter. i hope i dont miss out on any of the matter needed to prepare the Asset Database.
Grace79
Hi Vijayalakshmi,
what do you mean by computerized asset register? I mean to ask, do you maintain in excel format or any special software for it?
If you can, pls recommend me "any good software" which can keep updated the records of all the modifications, recommendations needed.
Thanks.
vijaya Lakshmi Y
Hi,
Ours is a medical e.learning company. We developed our own software for asset management.
To your asset register, you can add AMCs to be maintained for assets like Generators, elevators, A/cs and all such assets for which continuous maintenance is required. In addition insurance coverage details with amounts paid and insurer's details etc would assist you in better asset management.
We maintain a similar register for all consumables like stationery, CDs and video related requirements such as video tapes, batteries etc.
Rgds
Vijaya Lakshmi
Payroll Insights
There is a fixed asset management software for excel import & export functionality.
For more information -
http://farsightitsolutions.com
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute