Excel Import Template Instructions

Parent Previous Next

The same list of business assets that can be written on a hard-copy Tangible Return or entered via the Tangible Online Filing Application are required when using the IMPORT ASSET option. The data in the Excel Template should be formated as shown below.


Column Name

Size

Description

AssetDescription

50

A brief description of the leased item.  For example, "Cannon 3200G Copier" or "Kubota Fork Lift".

YearAcquired


4

The 4-digit year that the asset was originally purchased or the 4-digit year that the lease began.

OriginalPrice

n/a

The original purchase price of the asset

Asset Lease ID

30

Your internal asset/leased item identification number

LeaseName

50

Lessee Name

LeaseAddressStreetNumber

10

Lessee or Lessor Street Number

LeaseAddressStreetName

50

Lessee or Lessor Street Name

LeaseAddressStreetSuffix

8

Lessee or Lessor Street Suffix

LeaseStreetDirection

2

Lessee or Lessor Street Direction

LeaseAddressCity

50

Lessee or Lessor City

LeaseAddressZip

10

Lessee or Lessor Zip