Do you need an easy to use, flexible Fixed Assets Register?

This asset tracking system is intended for anyone who has to keep track of assets in their employer’s Fixed Assets Register. With so many ways of doing business, is it any wonder that your company’s asset management software is not flexible enough to handle fixed assets the way you want? Add in annual license fees for an asset tracking module you don’t use and it becomes obvious why so many small to medium sized businesses look for an alternative. Depending on your business, there is a wide choice of options: from a simple Excel spreadsheet (a list), to an Access database with a user-friendly interface, to custom built stand-alone programs. My solution is somewhere in between the first two options: an Excel workbook using hidden functions, VBA, hidden sheets, and with a simple-to-use point-and-click interface (or you can stick with the keyboard only). No more copy and paste errors; no more bloated spreadsheets with dozens (or hundreds) of columns and thousands of rows to check and make sure all the formulas are correct; no more checking each asset to ensure depreciation hasn’t exceeded the original cost.

Steps to track your capital assets in your Fixed Assets Register:
One, use the Setup form to set your Preferences, Asset Categories, Depreciation methods/rates, etc.
Two, enter your assets one at a time using a user-form – or all at once using the Import function
Three, using the Find and Delete user-form, get rid of disposed assets – or fix an asset entered with an error
Four, run monthly/annual reports: Cost-Accumulated Amortization-NBV; Amortization Journal Entry data; Full List with Cost and Amortization; and more (fully customizable – let me know what you need)

There are two versions available: a free Trial version – play with it, test it out and see if this solution will meet your needs; and the (free) unrestricted full version with 10 asset categories, 5 depreciation methods, unlimited assets, and flexible fiscal year start. This (first) version was built using Excel 2003, so you should not have any problems using it in later Excel versions. At less than 500KB it is a small download. You are able to accumulate up to 20 years of depreciation data: you could, for example, enter assets purchased 15 years ago and still have 5 years ahead of you to use the Fixed Assets Register. I plan on building a more robust solution after getting suggestions for improvement/added functionality. Contact us to get the full version and you’ll automatically get any news on upgrades. Click here to get the PDF Help file.