Import Assets
Use this option to import asset data into Depreciation 4562 Pro
- Access this option from menu File\Import Assets.
- Data will be imported from Excel using the template ImportAssests.xls.
- This template can be found in the My Documents\MTW-Files directory.
- Data must be in the format of this template or it will not be imported.
- Required fields.
- The Fields with the red column headings are required.
- The Fields with the black column headings are Optional.
- The Field in blue are required to do book depreciation.
- Company Id - This number is displayed on the Select Company Form under the menu Defaults\Set Company Option.
- Use calendar date for the In Service date. Date format mm/yyyy.
- Depreciation method - This is the method Id found on the Reference sheet of ImportAssests.xls.
|
Method
|
ID
|
|
MACRS
|
1
|
|
ADS
|
2
|
|
Amortize
|
3
|
|
S/L
|
4
|
|
Listed
|
9
|
|
Non-Depr
|
10
|
|
MACRS 150
|
11
|
- Type 179 - TRUE or FALSE. Whether the property qualifies as 179 property.
- Use decimal for the Business percent. 1 = 100%
- Book Fields - required if you want to do book depreciation.
- Book Life
- Book Cost
- G/L Account Id this is listed on the Chart of Accounts report. Menu Book \Chart of Accounts.
- Auto & trucks cannot be imported they will need to be entered manually.
- These notes are also included on the reference worksheet of the Excel workbook.
- Convention - This is the Convention Id found on the Reference sheet of ImportAssests.xls.
|
description
|
id
|
|
Half Year
|
1
|
|
Mid Quarter
|
2
|
|
Mid Month
|
3
|
|
None
|
4
|
- The asset data will be validated before being imported. If there are any errors the data will not be imported. An Import log will be written detailing the problems.
- The log can be read using menu option File\Import Log.
- The log name is ImportLog with the date & time of the validation.
- This log can be found in My Documents\MTW-Files folder.
- Once the data is imported it can be accessed from the Asset Maintenance form.
- Retrieve the imported assets using the search function.
- Review the data in the form, correcting any wrong or missing fields and then re-save the asset.
- The Federal Book depreciation is calculated as the assets are imported.
- Book depreciation will need to be calculated by running the monthly depreciation function.
- Use Book Depreciation for a Range feature to initially calculate book depreciation.
Copyright © 2005 - 2011, Microtechware