Asset template import

The Asset Template import feature helps you populate many fields on the
Depreciation and Amortization
screens across various tax applications (1040, 1041, 1065, and 1120). Each tax application has its own asset template. Here’s how you can use it effectively:
  1. 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
  2. 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

TR_Setup
  • 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.
TR_XXXX_Asset_Detail
  • 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

For 1040:
  • Business (Schedule C): Organizer > Income > Business Income > (Name) > Depreciation and Amortization > Asset Detail
  • Employee Business Expense (Form 2106): Organizer > Itemized Deductions > Employee Business Expense > (Name) > Depreciation and Amortization > Asset Detail
  • Farm (Schedule F): Organizer > Income > Farm Income > (Name) > Depreciation and Amortization > Asset Detail
  • Farm Rental (Form 4835): Organizer > Income > Farm Income > (Name) > Depreciation and Amortization > Asset Detail
  • Rental Real Estate (Schedule E): Organizer > Income > Rent and Royalty > (Name) > Depreciation and Amortization > Asset Detail
  • Schedule K-1 (Estate): Organizer > Income > Schedule K-1 > (Name) > General Business Expense > Depreciation and Amortization > Asset Detail
  • Schedule K-1 (Partnership): Organizer > Income > Schedule K-1 > (Name) > General Business Expense > Depreciation and Amortization > Asset Detail
  • Schedule K-1 (S Corp): Organizer > Income > Schedule K-1 > (Name) > General Business Expense > Depreciation and Amortization > Asset Detail
For 1041:
  • General (Page 1): Organizer > Deductions > General Depreciation and Amortization > General Depreciation > Asset Detail > (Asset) > Depreciation Detail
  • Business (Schedule C): Organizer > Income > Business Income > (Name) > Depreciation and Amortization > Asset Detail
  • Rent and Royalty (Schedule E): Organizer > Income > Rent and Royalty > (Name) > Depreciation and Amortization > Asset Detail
  • Farm (Schedule F): Organizer > Income > Farm Income > (Name) > Depreciation and Amortization > Asset Detail
For 1065:
  • Page 1: Organizer > Ordinary Income and Deductions > Depreciation and Amortization > (Name) > Asset Detail
  • Rental Real Estate: Organizer > Activity Information > Rental Real Estate > (Name) > Depreciation and Amortization > Asset Detail
  • Other Rental Real Estate: Organizer > Activity Information > Other Rental > (Name) > Depreciation and Amortization > Asset Detail
  • Multiple Trade or Business: Organizer > Activity Information > Multiple Trade or Business > (Name) > Depreciation and Amortization > Asset Detail
  • Farm: Organizer > Activity Information > Farm > (Name) > Depreciation and Amortization > Asset Detail
  • Pass Through: Organizer > Activity Information > Pass-Through
For 1120:
  • General (Page 1): Organizer > Income and Deductions > Deductions > Depreciation and Amortization > General Depreciation and Amortization > Asset Detail
  • Rental Real Estate (Ordinary): Organizer > Income and Deductions > Rental Activity > (Activity Name) > Depreciation and Amortization > Asset Detail
  • Rental Real Estate (Form 8825): Organizer > Income and Deductions > Rental Activity > (Activity Name) > Depreciation and Amortization > Asset Detail
  • Rental Real Estate (Other): Organizer > Income and Deductions > Rental Activity > (Activity Name) > Depreciation and Amortization > Asset Detail
  • Rental Real Estate (Portfolio): Organizer > Income and Deductions > Rental Activity > (Activity Name) > Depreciation and Amortization > Asset Detail
  • Farm: Organizer > Income and Deductions > Farm Income and Expense > (Name) > Depreciation and Amortization > Asset Detail
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close