Migrating asset data to AssetManager Pro (including historical data)

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.


 

    • Related Articles

    • Disposing of an Asset

      Disposing of an Asset Disposing of an asset usually refers to the sale of an asset. When you dispose of an asset you need to create an asset transaction to record the details of the disposal. There a number of rules governing the disposal of assets ...

    • AssetManager Pro OnlineAudit (inc AssetManager Pro Mobile Scan for iOS)

      AssetManager Pro OnlineAudit (inc AssetManager Pro MobileScan) Asset Audits are a key part of Asset Management. Without accurate asset records, your financial balance sheets will be incorrect, losses may occur, or necessary assets may not be ...

    • AssetManager Pro 2019 v8 Release Info

      Overview Information on the AssetManager Pro 2019 (v8) Release. AssetManager Pro 2019 Upgrading from MYOB AssetManager Pro? If you are a current MYOB AssetManager or MYOB AssetManager Pro user you will find a lot has changed with AssetManager Pro! ...

    • Setting up Asset Groups

      Each asset group, , will be set up to include default accounts, depreciation methods, and the basis of depreciation calculations.  By default, an asset will use the properties that are associated with the asset group to which it is assigned. As such, ...

    • AssetManager Pro - Back Home!

      GRAGA Software Solutions and MYOB AssetManager Pro In 1996 MYOB commissioned GRAGA Software Solutions to develop what was later to be called MYOB AssetManager. Over the past 18 years GRAGA continued to develop MYOB AssetManager and MYOB AssetManager ...