How do I Export and Import Schedule K-2 data to and from Microsoft Excel spreadsheet with a 1065 and 1120S return using CCH Axcess™ Tax?

  • Article Type:
  • How To
  • Last Modified:
  • 11/05/2022


Create a template spreadsheet file for the purpose of importing Schedule K-2 data from information compiled in a .xlxs file.


  • CCH Axcess™ Tax
  • Partnership - 1065
  • S Corporation - 1120S


  1. Save the return.
  2. Select Import / Export > Export > K-1 Data > K-2/K-3 Data to Spreadsheet.
  3. Select Browse to designate a Path and file name.
  4. Default location is the user Documents folder.
  5. Select Export.
  6. Select Finish to open the file created and populate with applicable information.
  7. Save and Close the K-2 Excel file.
  8. In the return, Select Import / Export > Import > K-1 Data > K-2/K-3 Data from Spreadsheet.
  9. Select Browse to navigate to the K-2 Excel file.
  10. Select Validate.
  11. Select from the following two options:
    • Match and update existing input.
      • This option matches the imported data to existing input data in the return. Revised spreadsheet figures will carry to the return, but blank spreadsheet fields will not overwrite existing data in the return.
    • Delete applicable input, replacing with imported data.
      • This option deletes any existing input data, including depreciation, in the return. Imported spreadsheet data, including blanks, will completely replace existing data on these forms.
  12. Select Import.
  13. Select Finish.
  14. Review information imported into the return.
  15. Calculate return.


Additional Information


  Solution Tools
 Solution Id 000232163/000147680
 Direct Link
To provide feedback on this solution, please login.

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