Fixed Asset Register

Fixed Asset Register

Can't help with Sage as I've never used it. We have a different register for different types of equipment. Computer equipment has it's own for example. I have a column for date of purchase,Item detail (eg Ergo laptop), serial number, location within the company or person assigned to, value, depreciation charge, accum dep, and disposal. For laptops, mobiles and other equipment that can be taken off site, I have an equipment register with items either signed out on a daily basis, or permantly signed off site for items which are taken home every day.<BR><BR>Don't know if this is what you are looking for, hope someone else can help you on the software side.

Fixed Asset Register

This sounds like an ideal project for Excel, using formulae to automatically calculate depreciation and a different sheet for each category of assets. I remember completing a fixed asset register task for the intermediate simulation and during my feedback I was asked how the register could be improved. The only thing I could think of was perhaps a column to show total depreciation to date for each asset and then total for category - this seemed to be the answer which they were looking for so may be something worth thinking of. <BR><BR>The beauty of this scenario is that you can set up a basic register and then adapt and modify to suit your needs as you go along which will go a long way to impress.<BR><BR>I know that Excel will integrate with Sage okay and your consultant will be able to help in this area. Good luck with everything.

Fixed Asset Register

Hi Rebecca,<BR>I'm a fixed asset guru with 28 years under my belt. I've worked manual systems and 5 different types of computer software systems. Firstly to design it, you need to realise what type of workplace you are in. Do you work with cost centres? As this is what you can use for asset location as well as charging depreciation.<BR>You need to have make, model and serial numbers of all types of equipment, especially that which is mobile!<BR>Also, you need the different rates of depreciation for all categories of assets.<BR>columns are usually, cost centre/asset account, description, location, Asset cost, cumulative depreciation, monthly charge, ytd charge, net book value, no of months depreciated, date depreciation started.<BR>If you have this info, you should have no problem. Oh, and if you constantly work with the idea of remaining months depreciation, then if you change policy or merge with another company and the year end happens to be at a different time of the year, then you will have no problem adjusting.<BR>Hope this helps?