Does WorthIT Fixed Assets have an importing utility?

Absolutely! WorthIT Fixed Assets can import your Assets, G/L Account Segments and Vendors provided that they are in comma-separated value (CSV) files.

If you were maintaining your fixed assets in a spreadsheet system, it is possible to take that data, manipulate it and import it directly into our system. Conversely, if you were using another fixed asset management system and can export or extract the data into a spreadsheet, you can also import this into our system as well.

The help files within the import screen in Fixed Assets provide enough information for you to import in your assets. However, here are some quick hints:

• Company IDs, Category IDs, Tax Classes and Account Segments must all be set up in your asset book before you begin to import your data.
• The first seven columns on the CSV file are mandatory for every asset. You must have a value for each of these columns at the time of importing. If one of the fields is blank, the asset will not be imported.
• All dates must include a four-digit year and be in the format CCYYMMDD (century, year, month, day) no matter what the settings are in Fixed Assets. Do not use any slashes or dashes to separate the values. For instance, 20001231 is a valid date whereas 2000/12/31 is invalid.
• All numerical values should not contain any dollar signs or commas. You may use decimal points if needed. However, it is not necessary if there are no cents.
• It is possible to import your Accumulated Depreciation as well. This will enable you to balance with your general ledger system accurately. Enter the Accumulated or Life-to-Date Depreciation amount in column I. This amount MUST be at of the end of the fiscal year. Column J is the corresponding fiscal year for the Life-to-Date Depreciation amount. Just use the format CCYY, i.e., 2000. 2000 would represent the last day of your year, i.e. December 31, 2000.
• No commas are allowed in this import file. Because it is a CSV file, a comma in any fields would shift the values over, thus causing importing problems. After your file is complete, perform a Search in the file for a comma. Delete any commas. If they are used in asset descriptions, try using a dash instead as asset descriptions can handle dashes.
• All fields must be formatted as test or general.
• Data is case-sensitive. E.g. if the division number is 00500 it must be 00500 in the spreadsheet. 500 will not import. E.g. If the category ID is COMP, it must be COMP in the spreadsheet. Comp will not import.

We have provided a sample CSV file that you can download by clicking here. Please note that this is just a sample CSV file. The asset cannot be imported in your asset book unless all the criteria from the above first point is met.

If you are lacking time and resources, WorthIT Software provides asset book setup and conversion services. This ensures that your asset book is set up correctly and quickly. Please call 1 (888) 967-8411 for further inquiries.