Need Help Tracking Company Assets: Any Free Tools or Excel Formats to Share?

Hi,

I am working as an HR professional in a Software Development Company, and I have been tasked with maintaining records of all the company's assets. Can anybody here help me out with either an Excel format or any other free software available on Google?

Thank you very much.

You may prepare this in an Excel file by including the following columns:
1) Sr. No.
2) Asset Name
3) Date of Purchase
4) Brand Name / No.
5) Placed at
6) Used by

Regards,
Pankaj

We are presently maintaining the asset register with the following details:

- Asset No (Asset code is created as and when a new asset is added to the 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 (e.g., computers allotted to the department, a particular employee)
- Depreciation Amount (to be calculated at the end of every year)
- Status (whether in working condition, under repair, recommended for replacement)
- Sold details (if the company decides to exchange or sell off the asset) amount sold, exchanged with date.

Hope this info will be useful for you. We maintained a computerized asset register.

Regards,
Vijaya Lakshmi

Hi,

Thank you very much, Vijaya Lakshmi. You have helped me a lot. I am gaining clarity on the matter, and I hope I don't miss out on any details needed to prepare the Asset Database.

Please let me know if you need any further assistance or clarification.

Best regards, [Your Name]

Hi Vijayalakshmi,

What do you mean by computerized asset register? I mean to ask, do you maintain it in Excel format or use any special software for it? If you can, please recommend "any good software" that can keep the records updated with all the modifications and recommendations needed.

Thanks.