Importing from Excel

These imported items usually tie into a Beginning Balance/Balance Forward Entry, so Importing from G/L won’t work.

This import is found under Fixed Assets > Utilities > Import from Excel. First, the Import Type will need to be selected.

• Master: the following fields include two decimal places: PurchAmt, SalvageValue, SoldAmt, DepAmtUsed, and PurchaseCost.
• Detail: You will need to fill in an import date, which will be used as the Accumulated Depreciation amount as of that date.
• Impairment is rarely used and will not be covered in this doc.

The rest of the information outlines how the Excel file must be laid out. There are Required Columns, Optional Columns, and columns for individual sets of books. As long as the headers of your columns match the items you need (as listed on this screen), you can customize your import. The “*” items after the field name are to help you determine what needs to go into that field and what it will affect.

Notes:

• Once the import has been successfully completed, the system will generate an Import Stamp. Make sure to note this and keep it in a safe place.
• The system will automatically generate depreciation based on the imported information.
• If information is imported from another system, there may be some differences. Manually adjust Asset Maintenance to get the systems to match.

UNDO

It is best practice to back up your company before completing the import. This way, if there are any major issues, you have a starting point you can revert to. NOTE: This would restore the entire company, not just Fixed Assets.

The Undo button at the bottom of the screen will allow you to back out a recent import if you have the Import Stamp Number. This will remove all records added during a specific import.

Also, see Import from G/L

Regenerate All

This utility will regenerate depreciation details for all assets and books. It should rarely be used, and data should be backed up before executing it. The system defaults to Keep Manual Overrides, but they can be removed and will then defer to the original Asset Class Settings. To accomplish this, uncheck the option.
(NOTE: Year Lock will be ignored).

Mass Delete Assets

This utility allows you to mass delete a range of assets. Check the box Delete Locked Assets also to delete assets that have been locked. For more information, see Year Lock.

Mass Transfer Assets

This will transfer ALL assets under a designated Account Code to a different cost center. This is rarely done, but it would be an option if there were a move to a new location and assets needed to be transferred to the new location.