Migrating asset data to AssetManager Pro (including historical data)

AssetManager Pro has the ability to accept via import all your historical asset data making it easy to get started.

To support this we have developed a excel template that helps you format the data for easy import into AssetManager Pro

NOTE : Free Migration: For all new customers we provide a free migration of your excel based asset data to AssetManager Pro. To support this process this template is used.

Template

Refer to the attachment below. The template includes some sample data (based on the sample Clearwater file) to help show some sample values. This sample data needs to be removed when you supply your data.

Migrated Data

The following data can be provided and migrated to AssetManager Pro:

Assets
Asset Groups
Cards (Locations, Cost Centres, Custodians and Vendors)
Accounts

Asset Data

Includes data to clearly identify the asset, define depreciation settings and to define other asset properties.

Mandatory Fields Include:

Asset Identification Fields - Asset ID, Asset Description Name, Asset Group

Asset Acquisition Fields - Acquisition Date, Acquisition/Purchase Cost

Depreciation Fields: Either Book or Tax Depreciation Method, Depreciation Rate (or Life). You can provide values for EITHER Book or Tax or BOTH.

Current Value Fields - Opening Written Down Value (OWDV) as at the START of the Financial Year you want to start using AssetManager Pro in?

NOTE : Asset ID Characters: The barcode supports a limited range of printable characters, so restrict the asset ID to the following: upper case letter only (A–Z), digits (0–9), special characters (-. $ / +%), and the word space (spacebar).

NOTE : Asset Group: See Asset Group below for more info.

NOTE : OWDV for Historical Assets: The OWDV reflects the opening balance (value) of the asset at the start of the financial year you wish to start AssetManager Pro in. For example if you are running a July to June 2016 FY - it would be the opening balance of the asset as at 1/7/2015. Assets that have been acquired in the current financial year should NOT have an OWDV.

Asset Group Data

Providing the actual Asset Group details is OPTIONAL - however the Asset Group Name must be provided as part of the Asset Data (see above)

Providing actual Asset Group data enables you to provide key information as to the linked general ledge accounts and the default depreciation settings for assets assigned to that group. However these can be simply updated via the user interface at a later stage.

Card Data

Card Data is only needed if you want to track any of the following asset properties (Locations, Cost Centers, Custodian, Vendor). Setting these fields against an asset enable you report (including depreciation by Card) on them.

If you are using Cards then the Card name must be assigned against the Asset as part of providing the Asset Data - the Card Data then lets you define additional card data including address and contact details. Again this extra detail is optional and can be added via the user interface (or an update import) at a later stage.