In this article, you will learn how to import assets into a Depreciation Worksheet using a csv template provided in Class. You will learn:

1. Downloading the csv Template
2. Completing the csv Template
3. Uploading the csv Template

It is recommended to utilise this method of setting up a Depreciation Worksheet when you have five or more assets to add to the Depreciation Worksheet.

Downloading the csv Template

Navigate to Fund Level > Investments > Depreciation Worksheet

1. Select the property
2. Select the Export button

You can download either a blank csv template or one that is pre-filled. This is useful if you need to move a Depreciation Worksheet e.g. if moving the entity to another Class business.

Completing the csv Template

Completing the csv template.

1. Code (this is a unique identifier for each fixed asset under the property)
2. Property Code (this is the holding code of the property, you can find this in the Browse Holding Accounts screen)
3. Description (free text field, description of the asset)
4. Purchase Date (this is the date the capital item was purchased)
5. Purchase Cost (this is the initial gross cost to purchase the asset)
6. Opening Written Down Value ("Purchase Cost" less "Accumulated Depreciation" at year-end).
7. Depreciation Method (Options "DiminishingValue", "PrimeCost", "LowValuePoolFirstYear", "LowValuePoolFullYear" or "NotApplicable" must be entered the way it is shown here)
8. Depreciation Rate (This is the rate applied)
9. Depreciation Type (Options "CapitalAllowance", "CapitalWorksDeduction", "NotApplicable" must be entered the way it is shown here)
   Below is an example of a depreciation worksheet entered in CSV:
   
   
   

   Ensure the Excel sheet is saved in a CSV format.

Uploading the csv Template

Navigate to Fund Level > Investments > Depreciation Worksheet 

1. Select the property
2. Select the Import button
   
   

Once the file has been loaded, ensure there is nil 'Residual Book Cost' (i.e. it must equal to $0). If you still have a value ensure that you have entered an asset for the non-depreciable component e.g. land and record the remaining residual against this asset.

What's Next?

Learn how to capitalise further capital purchases for the property, New Fixed Asset.