When an asset has reached the end of its estimated useful life, such as when it has been scrapped, lost, or decommissioned with no sale value, you need to write it off. 

In some cases you might need to write-off a large number of assets on a certain date in which case you can use the Bulk Write-off function

To Prepare the Bulk-Write-Off File

The Bulk Write-Off process is done via an Import routines that takes a list of Asset IDs that need to be written off. In Excel or equivalent spreadsheet program you will need to create a spreadsheet that has a single column that lists the Asset IDs to be Written-Off.

Note You can label column with a name (for example Asset ID) but that is not required. Later on when importing you will be able to select if the file has a Column Header for the first record or is a Data Record.

To import it into AssetManager Pro you then need to save the MS Excel (or Spreadsheet equivalent as a Text based Comma Seperated (CSV) or Tab Delimited .txt file.

To Process the Bulk-Write-Off File

1 Go to the Import Menu and select Import Bulk Write-off Transactions. The Import
window appears.

2 Select if the file you are Importing is a Tab-Delimited or Comma-Seperated file and if the First Record is a Header or Data Record

3 Select/Enter the Write-off Date you wish to apply to all the Assets being Written Off

4 Click Continue and the File Explorer window will appear to select the .TXT file that contains the list of assets to be Written-off. Select the file you are importing and the Import Data Matching window will appear

5 Click Match All to match the Asset ID column in the Import File to the Asset ID field in AssetManager Pro and then click Continue to process the Bulk Import

6 On completion of the Import Process Import Summary showing records imported without errors, records imported with warnings and records that were skipped. You can click on the link to refer to the AMPROLOG.TXT file that will provide details of the Errors that caused the records to be skipped and the warnings.