Asset Register PRO 5.2 For Excel

Asset Register PRO 5.2 - Excel add-0n.

Our new version 5.2 released July 1, 2005 is separated into two separate zip files. Version 5.2/S/L provides customers with an easy to use Asset Register which can be used within any country with S/L depreciation rules. Calculates straight line monthly depreciation and book values by item and by asset category (office supplies, computers, equipment..etc). The Summary report combines depreciation totals , book values, disposals to the current or adjusted month end date

The second version 5.2/S/L/Macrs (US version) provides exactly the same as 5.2/S/L with US MACRS depreciation calculations included within the asset register. MACRS yearly depreciation values are calculated by item record applying specific macrs depreciation rates for the macrs class and year. Combined MACRS depreciation totals are combined within each asset category. MACRS depreciation write down periods cover 3/5/7/10/15 & 20 years.

Version 5.2 provides capacity expansion up to 10,000 asset records plus 25 asset categories. The user can define asset Categories so that their register fits their business needs exactly.

Version 5.2 harneses the powerful lookup features of Excel. Look up features are incorporated so that users can retrieve any asset record, and look up the total depreciation and current net book values of each individual asset class quickly and easily. The program calculates the numbers of assets held in total and by class and calculates average costs by class.

Among the new features built into version 5.2, the user can switch depreciation calculations backwards or forwards in time, instructing your register to calculate depreciation totals and book values at any month end date. Very useful for checking previous year end balances or forecasting cumulative depreciation and book values ahead when preparing financial forecasts.

Summarises year to date depreciation balances and written down book values.

Depreciation periods can be any number of months for each asset record. No limits.

Calculates net gains/losses on disposals.

Photo file album included.

Demo files are provided with each version so that you can quickly learn how to set up and run your Asset Register.

Really useful and easy to use Asset Register for small and medium sized organizations. Used by school boards, libraries, and small and large businesses in the USA, Canada, Australia and the United Kingdom.

PLEASE READ THIS IF YOU REQUIRE THE US MACRS VERSION!!
The file that is downloaded when you purchase is the Straight line edition plus demo (without MACRS). The US MACRS version is available as a separate zip file download on request after purchase. You will receive our email address within your order confirmation. Please contact us and we will set up a download web page for you straight away containing the S/L/MACRS version plus demo.