Skip to main content

HandiTax - How do I import assets from a CSV file into a deprecation worksheet?

Updated over a month ago

HandiTax allows you to import assets into the Depreciation worksheet from a CSV file. The Depreciation worksheet is not transmitted to the ATO. The worksheet is used to calculate depreciation for the taxpayer, with certain figures being transferrable to other sections of the tax return in order to be lodged.

When the CSV file has been imported into HandiTax, you will then have the option to transfer your Depreciation worksheet from HandiTax to HandiLedger.

Details and mapping required to import the CSV file

To be imported into the Depreciation worksheet the CSV file needs to have the Header Details on the first line.

The order and data fields need to be separated by commas and be in the following order:

  • Description, Total Cost, Private use percentage, Effective life, Asset Type, Intangible, Open Written Down Value, Acquisition Date, Asset Cost, Depreciation rate, and Type of depreciation.

  • Save the file as a CSV


Example: Taxpayer has a rental property and purchased new depreciable assets, he has the assets saved in an Excel file.

Importing the file

To import the CSV file:

  1. Open the Depreciation Worksheet for the client.

  2. In the Depreciation Worksheet window, click Import.

3. In the Open window, locate the CSV file you want to import and click Open.

4. The information window will confirm how many items have been imported. Click OK.

Tip: This article illustrates how to transfer your Depreciation Worksheet from HandiTax to HandiLedger:

Did this answer your question?