How do I export K-1 data from a business return to another return using worksheet view in CCH Axcess™ Tax or CCH® ProSystem fx® Tax?

The video below explains how to export Schedule K-1 data from a business return to another return using CCH Axcess™ Tax or CCH® ProSystem fx® Tax.


The export process is completed using three steps:

Note: If the source return is passing multiple activity information to the target return, use the Other > Export translation of activity numbers worksheet to maintain the multiple activity status in the export file. Enter the source return activity number, the partner/shareholder/beneficiary number, and the partner’s/shareholder/beneficiarie’s target return activity number.


Step 1: Setup The Export In The Source Return - [Return

Based on the return type, do one of the following:

For a Partnership 1065 Return

  1. Go to the General > Return Options worksheet.
  2. Select Section 7 - Export Options.
    • In Lines 1-3 - Export Options, enter the applicable export information.
  3. Go to the Partners > Partner Information worksheet.
  4. Click Detail.
  5. Select Section 6 -  Export Partner Information to 1040 / 1041 / 1065 / 1120 / 1120S.
    • In Lines 1-4 - Export Partner Information to 1040 / 1041 / 1065 / 1120 / 1120S, enter the applicable export information.
  6. Calculate the return.


For an S Corporation 1120S Return

  1. Go to the General > Return Options worksheet.
  2. Select Section 7 - Export Options.
    • In Lines 1-3 - Export Options, enter the applicable export information.
  3. Go to the Shareholders > Shareholders Information worksheet.
  4. Click Detail.
  5. Select Section 4 - K-1 Export Options.
    • In Lines 1-4 - K-1 Export Options, enter the applicable export information. 
  6. Calculate the return.


For a Fiduciary 1041 Return

  1. Go to the Beneficiaries > All Beneficiary or Grantor Options worksheet. 
  2. Select Section 1 - All Beneficiary or Grantor Options.
    • In Lines 12-13 - Export options, enter the applicable export information. 
  3. Go to the Beneficiaries > Beneficiary Information worksheet.
  4. Click Detail.
  5. Select Section 3 - Export Beneficiary Information  to 1040 / 1041 / 1065 / 1120 / 1120S.
    • In Lines 1-5 - Export Beneficiary Information  to 1040 / 1041 / 1065 / 1120 / 1120S, enter the applicable export information.
  6. Calculate the return.
Note: Grantor trusts are not able to use this option as Form K-1 is not generated. 


Step 2: Export The Data - [Return

Option 1: Manually Create the K-1 Export File.
  • For CCH Axcess™ Tax.
    • On the Ribbon, Go to Import / Export tab.
    • In the Export section, Click K-1 Data > K-1 Data to Other Returns.
  • For CCH® ProSystem fx® Tax.
    • On the Menu Bar, Go to File > Export > K-1 Data to Other Returns.
Option 2:​ Create the K-1 Export File During Calculation.
  1. Go to the General > Return Options worksheet. 
  2. Select Section 7 - Export Options.
    • In Line 2 - Create Schedule K-1 export files during calculation, use the lookup value (double click or press F4) to select Yes.
  3. Calculate the return.
Note: This option is only available for Partnership 1065 and S Corporation 1120S returns.


Step 3: Open The Target Return - [Return

Once the export files have been created, open the target return to begin the import process.
  1. On the Import K-1 Files into the return window, select items in the Import files pane and click Add.
  2. Once all the desired import files are added to the Files selected for import pane, click OK.
  3. On the K-1 Import File Log window, review the log to verify the K-1s imported and see any import errors.
  4. Click Print or Close to exit the log report.
  Solution Tools
  Attachments
 Solution Id 000167295/sw526
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!