, is available to map each item. It maps all 22 Entity Import items in the following order:
*Entity Type, *Return Type, *Company Name, Company Name Line 2, Company Number, Street Address, City, State, Zip/Postal Code, Country, Province, Federal Employer I.D. Number, Fiscal Year Beginning Date, Fiscal Year Ending Date, Date of Incorporation/Date Business Started, Incorporation State, International Filing Type, International Div Con Data Entry Level, International Div Con Intercompany Data Entry Level, Binder Name, Binder Year, and Reference ID Number.
Items marked with an asterisk are mandatory.
To use the default template, make sure your import file includes all 22 columns in this specified order, with data starting on row 2.
This shared template is available for everyone and you can't edit it.
Data Query
: Added tax year 2022, Form 5471 Schedule E – General Category lines.
Excel Add-in
: Version 20.0.1 release for Microsoft Office updates for Excel Version 2411 and above. This install updates to include Thomson Reuters in the Trust Publisher list.
note
This update is only required if you are unable to access the Data Import menu bar.
This installation package does not include any new fields or maps.
Excel Add-in data import
1065 Schedule K missing fields will be added in a future release:
Net 4797 specifically allocated g/s Exclude from QBI checkbox.
Qualified commercial clean vehicle credit for vehicles acquired after tax year 2022.
Binder tags
: We resolved an issue where Binder Tags could not be added or renamed in the
Binders
,
Manage Tags
window.
1065 partnership
The following forms are currently under development:
Connecticut
PTE forms.
Delaware
: Updating e-file for the composite return.
Oklahoma
561-PTE and 561-P for tax forms, e-file and print.
Federal
We updated or addressed the following:
Form 8453
: Updated print alignment for the 1042 signature form.
Form 8308
: Updated the e-file schema for element Section1h5CollectiblesGainGrp.
State
We updated or addressed the following:
Arkansas
:
Various calculations on Page 4 and Page 1 of the AR1100PET.
The K-1 logic for the Pass-Through Entity Tax checkbox.
Added print suppression for AR1100-WH and AR941PT.
Calculations for the AR1100PET Page 2 to ensure the total and AR column are identical for partnerships operating only in Arkansas.
Modified the calculation for AR100PET Page 2 line 20.
Added a print suppression option for the AR1050.
Moved AR1100REC to the main state return area in Organizer and the Tax Form view.
The e-file time stamp for the extension.
California
: Increased the length of the K-1 partner description in the print preview window
Illinois
: Corrected a print issue causing estimates to print into the wrong state navigation folder.
Nebraska
:
The e-file schema for K-1N element ApportFactor.
The e-file schema for Schedule A lines 3a and 3b.
Modified the attachment logic for the PTC to ensure that it attaches in the e-file.
New Jersey
:
Added direct deposit to the e-file schema for NJ-1065, NJ-CBT-1065 and PTE-100.
Updated e-file schema for Columns I, J and K on Schedule PD.
Oregon
: Updated spreadsheet logic for the OR-CAT so the create row shows, even if the return has not been activated in the Organizer.
South Carolina
:
An e-file issue that caused validations not to process.
Updated the SCK-1 schema for the element TaxYear.
Vermont
: Update print for BI-477 line 32.
Wisconsin
:
Updated the print condition for the Form 3 location when more than 1 location is present.
Updated the calculation for Form 3 line 23 total income to include noncash contributions.
1120 corporate
State
We updated or addressed the following:
Arkansas
: Arkansas AR1100PET, Schedule K-1, Box 20 is empty.
Idaho
: Corrected the print alignment for Idaho 41ES Extension, line 7.
Indiana
:
Updated the print for Indiana Schedule K-1, Page 2, Part 4, line 5.
Populated Indiana IT-20, Page 1, line 20.
Iowa
:
Resolved the rate issue for Iowa, PTE-C, Page 4, Column H.
Computation for Iowa K-1, Part II, Column B is updated so residents are populated.
Massachusetts
: Corrected the print alignment for Massachusetts Schedule U-ST and Schedule U-MSI.
New Jersey
: Updated the statement print for New Jersey Form CBT-100, Page 2, Question line 17.
Oklahoma
: Computation for Oklahoma 512-S, Page 1, line 2a is populating correctly.
Rhode Island
: Corrected the Rhode Island Extension schema missed elements.
International
Form 5471, 8858 and 8865 Organizer Options to Turn Off Transfers from International Computes
important
After rolling your foreign entity binders to the new tax year and before transferring to the forms, decide whether to file Form 5471 Schedules I & P by Shareholder or Summary. Use the Enterprise Control Panel > Organizer INTL Transfer Options to block the transfer to the alternate approach. For example, if you choose to file Schedule I by Shareholder, select "Yes/On" for the Schedule I by Shareholder option and "No/Off" for the Summary option.
The International Compute transfers information directly to the "face" of Form 5471, 8865, and 8858 Organizer pages. Unlike the Income Statement and Balance Sheet, which use hidden screens, the following schedules transfer information directly. By default, the transfer checkboxes below remain unchecked, allowing you to permit the transfer.
Form 5471 Schedule E
Form 5471 Schedule E-1
Form 5471 Schedule G
Form 5471 Schedule H
Form 5471 Schedule I (defaults to checked, no transfer)
Form 5471 Schedule I by Shareholder
Form 5471 Schedule I-1
Form 5471 Schedule J
Form 5471 Schedule M
Form 5471 Schedule P (defaults to checked, no transfer)
Form 5471 Schedule P by Shareholder
Form 5471 Schedule Q
Form 5471 Schedule R
Form 5471/Form 8990
Form 8858 Schedule H (959(b) Dividends and Return of Capital)
Form 8858 Schedule J
Form 8865 Schedule K-2, Part II, Sections 1 and 2
Form 8865 Schedule K-2, Part III, Section 1
Form 8865 Schedule K-2, Part III, Section 4, Line 1
Form 8865 Schedule K-2, Part V
Before transferring new results, the International Compute will delete all existing information in the specified schedules. To prevent additional transfers from International Compute from overwriting manual overrides entered in Organizer, ensure you select the appropriate options on the INTL Transfer Options pages within the Foreign Corporation (5471), Foreign Partnership (8865), and FDE and FB (8858) navigation tree. If you do not check these individual boxes, any overrides in Organizer will be lost during the next International Compute transfer to US5471, US8865, or US8858, even if the Organizer field is locked.
Transfer to US5471 and US8858 Available in Tax Year 2024 Binders
In the 2024 tax year, you can now transfer information from Form 5471 and Form 8858 using the International Computes screen to a top consolidation and foreign entity binder. A future release will enable transfers to Form 8865 Schedule K-2 and Form 5471 Schedule Q.
Form 8858
Page 1 Organization Chart
Schedule H: Current Earnings and Profits or Taxable Income (959(b) Dividend and Return of Capital Adjustments)
Schedule J: Income Taxes Paid or Accrued
Form 5471
Schedule C: Income Statement (Other Comprehensive Income)
Schedule E Part I Sections 1 & 2: Taxes for Which a Foreign Tax Credit is Allowed
Schedule E-1: Taxes Paid, Accrued or Deemed Paid on Earnings and Profits (E&P) of Foreign Corporation
Schedule G: Other Information (Subset of Line 14 Questions)
Schedule H: Current Earnings and Profits (including 959(b) Dividend and Return of Capital Adjustments)
Schedule I (Summary & by Shareholder): Summary of Shareholder’s Income from Foreign Corporation
Schedule I-1: Information for Global Intangible Low-Taxed Income
Schedule J: Accumulated Earnings and Profits (E&P) of Controlled Foreign Corporation
Schedule M: Transactions between Controlled Foreign Corporation and Shareholder or Other Related Persons
Schedule O, Part II, Section F Organization Chart: Organization or Reorganization of Foreign Corporation
Schedule P (Summary & by Shareholder): Previously Taxed Earnings and Profits of U.S. Shareholder of Certain Foreign Corporations
Schedule R: Distributions from a Foreign Corporation
Form 5471/8890
Individual CFC Instance
Limitation on Business Interest Expense Under Section 163(j) (including Safe Harbor statement)
Schedule A: Summary of Partner’s Section 163(j) Excess Items
Schedule B: Summary of S Corporation Shareholder’s Excess Taxable Income and Excess Business Interest Income
CFC Specified Group Parent Instance
Limitation on Business Interest Expense Under Section 163(j) (including Safe Harbor statement)
New Effective U.S. Ownership Report Available for Tax Years 2014 and Later
For tax years 2014 and later, the International Reports folder includes a new report called the
Effective U.S. Ownership Report
. This report identifies the direct owners of each foreign entity and the individual U.S. shareholders. It also details the related U.S. ownership percentage and foreign entity tier through each step of the ownership chain to the U.S. entity.
To generate this report, you must have successfully run Subpart F computations for at least one foreign entity. The report provides information about the foreign members of the top consolidation binder.
Member Entity Number: International Members > Foreign Entity Number
Member Entity Name: Foreign Entity Name
Direct Owner Entity Number: International Members > Parent Entity Number of the foreign entity (may be foreign or FTC)
Direct Owner Entity Name: Parent Entity Name
US Parent Entity Number: First FTC Entity up the chain from the direct owner (may be listed more than once for a Member + Direct Owner pair depending on the ownership structure)
US Parent Entity Name: FTC Entity Name
Actual Tier: Foreign entity tier for a given ownership leg to the US parent entity
Effective Ownership Percentage: US parent entity ownership percentage for a given ownership leg
Ownership Path: Details of the ownership path (leg) from the foreign entity through a given direct parent to a US parent entity
Error Saving Changes to Exchange Rate Chart when Saudi Riyal Selected
We corrected the issue when the SA – Saudi Riyal is selected in the Exchange Rate Chart, the