Import Asset Data
Use this option to import asset data into Web Depreciation
- Access this option from menu Maintenance\Import Assets.
- Data can be imported from Excel, using the template MtwImportAssests.xls.
- This template can be downloaded from the Import Asset Page.
- Data must be in the format of this template or it will not be imported.
- Columns with a red heading are required while the ones with a black heading are optional.
- Do not delete the sample asset row. It aids in importing the data due to problems that may occur by cutting & pasting data to the spreadsheet. Once the data has been imported you can use Asset Maintenance to delete this asset.
- Required fields.
- Company Id - This number is displayed on the Import Asset Page.
- Description - This field have a length of 50 characters.
- In Service date - This is the date the asset was put in service. Use the calendar date, not the fiscal period. Assets with Invalid dates will not get imported, and will not cause an error.
- Depreciation method - This is the method Id found on the Reference sheet of MtwImportAssests.xls.
|
Method
|
ID
|
|
ADS
|
16
|
|
Amortize
|
18
|
|
MACRS
|
14
|
|
MACRS - Auto - Electric
|
10
|
|
MACRS - Auto - Gas
|
12
|
|
MACRS - Listed
|
8
|
|
MACRS - Trucks\Vans
|
6
|
|
Non - Depr
|
5
|
|
S/L
|
4
|
- Convention - This is the Convention Id found on the Reference sheet of MtwImportAssests.xls.
|
description
|
id
|
|
Half Year
|
1
|
|
Mid Quarter
|
2
|
|
Mid Month
|
3
|
|
None
|
4
|
- Asset Cost - Dollar amount.
- Business Percent - Use a decimal for the Business percent. 1 = 100%, .5 = 50%.
- Life - years
- Type 179 - 0 for False or 1 for true. Use to exclude or include an asset as 179 property.
- G/L Account Id - First setup your accounts. Then this Id can be obtained form the G/L Account Maint Page.
- Book Cost
- Book Life
- Optional fields.
- 179 Deduction
- Salvage
- Bonus Depreciation
- Sold Date - Calendar year.
- Sold Amount
- Tag Nbr
- Amortize Code
- Serial Nbr
- Misc text
- Location
- Note
- Use The upload Import asset file to server option to copy the Excel file to the website.
- Clicking the Import button will validate the data, input it into the application and calculates the depreciation.
- If there are any errors the data will not be imported. An Import log will be written detailing the problems. The errors can be viewed by clicking the Display Errors button.
- Once the data has been imported run the various reports to ensure that there are no errors.
Copyright © 2009 - 2011 , MicroTechWare