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:
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
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