Asset template import

Get the
XXXX_YYYY_Asset_Template.xlsm
file where XXXX is the tax application. Go to the main product page, select Data imports and exports and download the template in the file download table. This is your starting point for data import.
Required fields for import:
TR_Setup tab
Firm ID
Account ID
Year
Tax Type
Locator
Activity Type
Activity Number (if applicable)
Activity Name (if applicable)
TR_XXXX_Asset_Detail tab
(XXXX = 1040, 1041, 1065, 1120)
Asset Description
note
Make sure you enter the correct values for the best results.
If macros are enabled, selecting a field with a fixed value will trigger a pop-up dialog. Choose the correct value from the description provided, and it will automatically populate the field. If you prefer not to use macros, refer to the
TR_XXXX_Asset_Strings
tab for the necessary values.

Template tabs

Header Information
: includes firm ID, account ID, locator number, year, and tax type. These fields are fixed.
Activity Number
: You must enter an activity number that matches the tax return’s activity number for a successful import. If you are unsure, export the file first to get the correct details.

Data Entry
: Enter your data here. The first and second rows are fixed.
Column Order
: The first column must stay as the first column. You can move or delete the remaining columns as needed.
Multiple Rows
: Each row represents a separate asset. Ensure each row has the correct locator number from the TR_Setup tab.

Important Tips

Save Existing Data
: If you have existing data you want to keep, perform an export first. Importing new data will delete current asset data in the return.
Column Headings
: Refer to the
TR_XXXX_Asset_Map
tab for details on column headings and field lengths.
Vehicles Data
: Vehicle information isn’t imported or exported for the 1041 application. Enter vehicle data manually after the import if needed.

Checking Field Details

Field Info
: To see which column heading transfers to which field, right-click on the field in the Organizer screen, select
Field Info
, and check the details.

Troubleshooting

Duplicate Assets
: If the first asset is duplicated, ensure row two on the
Asset Detail
tab is blank.
Totals in Fields
: Totals in any fields can throw off data for the first asset imported.

Navigation for fields on the asset template