Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Data import templates

1040 K-1 template import

The Crypto gain template import feature helps you populate many fields on the
1040 Schedule K-1
 screens. You will need the K-1 data import mapping fields for this import.
  1. Get the
    1040_2023_Sch K_1_Template.xlsm
     file from the file download page and download the template. This is your starting point for data import.
    Required fields for import:
    • TR_Setup tab
      • Firm ID
      • Account ID
      • Year
      • Tax Type
      • Locator
    • TR_1040_Sch_K_1_Detail
      tab
      • Ownership
      • Activity
      • Activity Number
      • K-1 Name
      • Federal EIN
    • TR_1040_Sch_K_1_Group_Detail
       tab (only required if group detail will be imported)
    • Ownership
    • Activity
    • Activity Number
    • K-1 Name
    • Federal EIN
  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_1040_Sch_K_1_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.
TR_1040_Sch_K_1_Detail
  • Data Entry
    : Enter your data here. The first and second rows are fixed.
  • Column Order
    : The first five columns must remain as they are. The remaining columns can be moved or deleted to fit your needs.
  • Rows
    :  Subsequent rows will import into a single locator (locator number entered on the
    TR_Setup
     tab). Each row will consist of a separate description to be imported into the program.
TR_1040_Sch_K_1_Group_Detail
  • Data Entry
    : Enter your data here. The first and second rows are fixed.
  • Column Order
    : The first 5 columns and the first 2 rows are fixed. You can import multiple rows of data.

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.

Navigation for fields in the K1 template

For 1040: Organizer > Income > Schedule K-1 > (Name) > Schedule K-1 Information.

This article applies to:

  • Product: ONESOURCE Income Tax Express RS
  • Subject: Export, Import
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close