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 |
Required Fields for Successful Data Mapping
| K1A field | What to enter | Why it matters |
|---|---|---|
| Return ID | Truncated Return ID (see above) | Identifies the target return |
| Identifying Number | Exact primary taxpayer SSN or entity EIN from Pfx, including hyphens | Used to match the export to the target return |
| Entity Type | Must correspond to the Pfx return type | Determines the Pfx return/export structure |
| Entity ID | Entity ID from Pfx | Entity ID is required to target the correct passthrough activity |
| Activity # | Activity Number from Pfx | Activity Number is required to target the correct entity activity |
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.
Many firms use the default Office Group ID of All, but your environment may differ.
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.
* Admin permissions are required for ProSystem fx users to run the import.
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
Known Limitation: ProSystem fx Interview Workflow
Important: The K1 Aggregator ProSystem fx Desktop integration supports the IRS K-1 worksheet workflow within ProSystem fx.
Firms that prepare returns using the legacy Schedule K-1 Pass Through Income or Loss Interview workflow should be aware that these Interview forms are not part of the worksheet-based data structure used by the integration.
As a result:
- Data imported from K1 Aggregator is written to the supported IRS K-1 worksheet input.
- Imported data will not populate the Schedule K-1 Pass Through Income or Loss Interview forms.
- Existing Interview-based K-1 activities, including underlying activities, cannot be automatically migrated to the worksheet workflow through the integration.
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.
● The user has supervisor permissions.
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.
Current Considerations
- The integration has been validated against supported ProSystem fx Desktop versions, however behavior may vary following ProSystem fx updates.
- If imported data does not appear in the expected activity or worksheet, contact K1x Support before attempting extensive manual troubleshooting.
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
☐ Retrofit utility installed on the same drive/network as ProSystem fx
☐ User has ProSystem fx admin permissions
Before Import
☐ ZIP file downloaded
☐ ProSystem fx return closed
After Import
☐ Review imported data in ProSystem fx