Knowledge Base Solution - How do I Export and Import Schedule K-2 data to and from Microsoft Excel spreadsheet with a 1065 and 1120S return using CCH® ProSystem fx® Tax?

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

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

Objectives

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

Environment

CCH® ProSystem fx® Tax
Partnership - 1065
S Corporation - 1120S

Procedure

K-2 Import Export became available with release 2021.04010.

Save the return: File > Save.
Go to File > Export > K-2/K-3 Data to Spreadsheet.
Select Browse to designate a Path and file name.
- Default location wfx32\client\K-2 Import and Export
Select Finish.
Open Windows browser and navigate to the K-2 export file.
Open the file created and populate with applicable information.
Save and Close the K-2 Excel file.
In the return, go to File > Import > K-2/K-3 Data from Spreadsheet.
Select Browse to navigate to the K-2 Excel file.
Select Next.
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.
Select Finish.
A Pop-up window "Spreadsheet K-2/K-3 Import Validation Log" will appear asking to Continue Import, Cancel Import and allow to print or copy the text to clipboard.
Select Continue Import.
Select OK.
Review information imported into the return.
Calculate return.

Note

Step 11 option above mentions it will delete depreciation data. However, this is general text with the Import from Spreadsheet Wizard, not relevant to Schedule K-2/K-3 Import from Spreadsheet.

Additional Information

If the K-2/K-3 Export to Spreadsheet does not create a spreadsheet file, or if the K-2/K-3 Import from Spreadsheet does not successfully import, please review the following article and consult with your IT administrator.

Prosystem fx Tax Partnership and S Corporation Schedule K-2/K-3 Import and Export to / from Spreadsheet does not create a file during export or receive a file during import?

Solution Id	000232174/000147677
Direct Link