Overview
The K1 Aggregator ProSystem fx integration allows you to export validated K-1 data directly into CCH ProSystem fx using the ProSystem fx Retrofit desktop application.
The process consists of three phases:
1. Prepare your data
2. Export from K1 Aggregator
3. Import into ProSystem fx
Once your initial setup is complete, future exports can be completed in just a few steps.
Supported Return Types
|
The ProSystem fx integration supports the following return types: Return Type |
Supported |
|
Form 1040 |
✓ |
|
Form 1041 |
✓ |
|
Form 1065 |
✓ |
|
Form 1120 |
✓ |
|
Form 1120-S |
✓ |
|
990 Series |
✓ |
Supported Data
|
The following data can be transferred from K1 Aggregator into ProSystem fx. Data Type |
1040 |
1041 |
1065 |
1120 |
1120-S |
990 |
|
General Information |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|
Federal Line Items |
✓ |
✓ |
✓ |
✓ |
✓ |
✗ |
|
Section 199A |
✓ |
✓ |
✓ |
✓ |
✓ |
✗ |
|
UBI |
✗ |
✗ |
✗ |
✗ |
✗ |
✓ |
|
State QBI |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|
Multiple Activities |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
|
Schedule K-3 |
✓ |
✓ |
✗ |
✗ |
✗ |
✗ |
Before Your First Export
Before exporting data for the first time, complete the following setup.
Enter the Return ID
Each Instance must contain the truncated ProSystem fx Return ID.
|
ProSystem fx Return ID |
Enter in K1 Aggregator |
|
25I:5281:V1 |
5281:1 |
|
24I:527000:V3 |
527000:3 |
Assign Activity Numbers
All investment activities being sent to ProSystem fx require an Activity Number that matches the corresponding activity in ProSystem fx.
If an investment contains multiple activities, each underlying activity must also have an Activity Number before it can be exported.
Activity Numbers are used to map K1 Aggregator data to the correct activity within the ProSystem fx return.
Note: Activity Numbers are maintained in K1 Aggregator as part of your investment data. Once assigned, they typically roll forward each tax year.
Review Your Data
Before exporting, verify that:
● Extraction results have been reviewed.
● Any required edits have been completed.
● Your data is ready for export.
Launch the Export Wizard
Option 1: From the Instance Dashboard
1. Select the Instance you want to export.
2. Open the Actions menu.
3. Select Send Data to ProSystem fx Integration.
Option 2: From Within an Instance
1. Open the desired Instance.
2. Open the Data Integration menu.
3. Select Send Data to ProSystem fx Integration.
Both options open the same export wizard.
Export Wizard
The Export Wizard guides you through selecting investments, validating your data, and creating the export package for ProSystem fx.
Step 1 — Confirm Instance
Confirm the correct Instance is selected.
Otherwise:
1. Select the desired Instance.
2. Click Next.
Step 2 — Select Investments
Select the investments you want to export.
For each selected investment:
● Verify or enter the ProSystem fx Entity ID.
● Confirm the investment information is correct.
Tip: The ProSystem fx Entity ID determines where imported data is placed within the return.
Click Next.
Step 3 — Validate Data
K1 Aggregator validates the selected investments before export.
Review any validation messages and resolve them before continuing.
Common validation issues include:
● Missing Return ID
● Missing ProSystem fx Entity ID
● Missing Activity Numbers
When validation completes successfully, click Next.
Step 4 — Send to ProSystem fx
Enter your Office Group ID.
If you do not know your Office Group ID, contact your ProSystem fx administrator.
Click Export.
A ZIP file containing your ProSystem fx export package will be downloaded.
Import into ProSystem fx
After exporting:
1. Close the return in ProSystem fx.
2. Open the Retrofit desktop application.
3. Select the ProFX workflow.
4. Select the exported ZIP file.
5. Enter your ProSystem fx username.
6. Click Start.
When the import is complete, reopen the return in ProSystem fx.
Verify Your Import
After importing, verify that the expected information appears in ProSystem fx.
Review:
● General information
● Federal line items
● State information
● Section 199A data (if applicable)
● Schedule K-3 data (Forms 1040 and 1041 only)
● Activity-level data
Troubleshooting
Validation Cannot Be Completed
Verify that:
● The Return ID has been entered using the correct format.
● Each investment has a ProSystem fx Entity ID.
● Activity Numbers have been assigned.
● The correct Office Group ID has been entered.
Missing Data After Import
If expected data is missing after import:
● Confirm the investment was reviewed before export.
● Verify the Entity ID is correct.
● Verify the Activity Number is correct.
● Confirm the ProSystem fx return was closed before importing.
If the issue persists, contact K1x Support.
Quick Reference Checklist
Before Export
☐ Return ID entered (truncated format)
☐ Activity Numbers assigned (if applicable)
☐ Investment(s) selected
☐ ProSystem fx Entity IDs verified
☐ Validation completed successfully
☐ Office Group ID available
Before Import
☐ ZIP file downloaded
☐ ProSystem fx return closed
After Import
☐ Review imported data in ProSystem fx