Depre123 is a cloud based application to manage fixed assets and generate a variety of depreciation reports on any desktop or mobile device. Get all of your depreciation answers based on just 3 key values (cost, date, asset class) and then utilize the open design to add all necessary fixed asset detail.
If you currently have your fixed asset data in a spreadsheet or another system that can export to a spreadsheet then you can easily import that data into Depre123. Here are the 5 basic steps:
1.Format your data in Excel:
The key to converting data is to format all of the fields to match your asset layout. Depre123 includes a utility to create a spreadsheet template by clicking on the “Download CSV Import Template” button. This is a dynamic process that will build the template based on your current asset configuration. You can then use this template to map each column of the spreadsheet to the corresponding field in Depre123. Below is a sample spreadsheet:
2.Launch the data import wizard:
The import wizard allows you to replace any existing data on an initial data load. Going forward you can then append any new assets through the import processing.
3.Select the file to process and set a few options:
Select the spreadsheet file from step 1 with all of your asset detail. Since this is an append you do not need to match on asset number so you can just click the Next button to advance to the mapping page.
4.Review field mapping:
The field mapping shows each field of the Dpere123 Asset object and the associated column in your import file. Before you proceed, you can verify everything is mapped correctly.
5. Process the import:
The final screen displays that you are about to add new records to your assets. Click the Start import button to begin processing. Depre123 will then respond with a message indicating the import has started. Based on the number of records being processed, you can view the results of your import and see when the update is complete. At this point your new assets are available for further maintenance and reports.
The data import wizard makes it very easy to add asset records from another system or spreadsheet into Depre123. Once the assets are added then Depre123 will generate all of the depreciation calculations and fixed asset reports.
Questions? Comments? Let us know in the comments section below.
More information about Bassets eDepreciation software can be found at Bassets.net or depre123.com. At Bassets register for our live webinar, download a free evaluation copy and get a personalized pricing estimate. At depre123 try out our Free Depreciation Calculator and check out our cloud based fixed assets application.