Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Data import templates

1040 Brokerage Statement template import

The Brokerage Statement template import feature helps you populate many fields on the 1040
Brokerage Statement
 screens. This template is only for 1040.
  1. Get the
    1040_2023_BrkStmt_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_BrkStmt_Detail
       tab
      • Payer Name
      • Ownership
      • Activity Number
    • TR_1040_Sch_BrkStmt_Group_Detail
      tab (only required if group detail is imported.)
      • Payer Name
      • Ownership
      • Activity Number
  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_BrkStmt_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_BrkStmt_Detail
  • Data Entry
    : Enter your data here. The first and second rows are fixed.
  • Column Order
    : The first three 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 broker statement to be imported into the program.
TR_1040_BrkStmt_Group_Detail
  • Data Entry
    : Enter your data here. The first four columns and the first two rows are fixed.
  • Multiple Rows
    : 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 brokerage statement template

For 1040: Organizer > Income > Brokerage Statements > (Name) > Brokerage Statement 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