1040 Brokerage Statement template import

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
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.
note
Enter accurate values for the best results.

Template tabs

Header Information
: includes firm ID, account ID, locator number, year, and tax type. These fields are fixed.

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.
note
Data in the return will be deleted prior to import. If you have data in the return you wish to save, export first for the detail.
An export will prepopulate the required columns on the Detail and Group Detail tabs based upon return data. This can be useful as we have had support calls in the past about how data relates between the Detail and Group Detail tabs.

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