Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Data import templates

Capital gain template import

The Capital Gain (Loss) template import feature helps you populate many fields on the
Capital Gain (Loss)
 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_Capital_Gain_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
    • TR_XXXX_CapGain_Detail tab
       (XXXX = 1040, 1041, 1065, 1120)
      • Asset Description
    • TR_XXXX_CapGain_Group_Detail tab
       (XXXX = 1040, 1041, 1065, 1120)
      • Asset Description (only required if group detail is imported.)
    • TR_XXXX_CapGain_Group_Detail2 tab
      , if available (XXXX = 1040, 1041, 1065, 1120)
      • Asset Description (only required if group detail is imported.)
  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_XXXX_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_CapGain_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
    : Subsequent rows will import into a single locator (locator number entered on the TR_Setup tab). Each row will consist of a separate asset to be imported into the program.
TR_XXXX_CapGain_Group_Detail
  • Data Entry
    : Enter your data here. The first and second 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 capital gains template

  • For 1040: Organizer > Gains and Losses > Capital Gains and Losses > Add New
  • For 1041: Organizer > Gains and Losses > Stocks, Bonds, etc. > Add New
  • For 1065: Organizer > Gains and Losses > Capital Gains and Losses > Gains Distributions, Stocks, and Bonds > Add New
  • For 1120: Organizer > Gains and Losses > Capital Gains and Losses > Add New

This article applies to:

  • PRODUCT: GoSystem Tax 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