Skip to main content

Legal

Featured

Questions? We are here to help
Contact us

Tax & Accounting

Featured

Questions? We are here to help
Contact us

Trade & Supply

Featured

Questions? We are here to help
Contact us

Risk & Fraud

News & Media

Books

Developers

Import-export

Valid entries for 1065 Spreadsheet partner information

The table summarizes valid entries for items in the worksheet titled
1065 Spreadsheet
.
note
If you don't plan to import the Excel file into UltraTax CS/1065, you can modify the file in accordance with Microsoft's Excel guidelines.
Valid entries for items in the worksheet titled "1065 Spreadsheet"
Column heading
Entry
Ptr Num
If you use custom partner numbers, enter any alphanumeric value up to 5 characters. Each partner needs to have a unique partner number. If you don't use custom partner numbers, UltraTax CS will ignore entries in this column.
note
To use custom partner numbers, select
Setup
,
Partner Data Entry
, the
Partner Information
 window, then
Custom Partner Numbers
.
SSN/EIN
xxx-xx-xxxx = Social Security Number
xx-xxxxxxx = Employer Identification Number
A = Applied For
D = Died
F = Foreign US
note
If a 9-digit number is entered without hyphens and the entity is Individual, Disregarded Entity, or Estate, the number will be formatted as a social security number. Otherwise, the number will be formatted as an employer identification number upon import to UltraTax CS/1065.
State
Enter only if the partner has a U.S. address.
Zip
Enter only if the partner has a U.S. address.
Resident State
If the partner has a U.S. address, enter the resident state at year end. If the partner has a foreign address, enter
.
(a period).
Province or state
Enter only if the partner has a foreign address.
Foreign Country Code
See Publication 4163 for a list of acceptable foreign country codes.
note
  • Enter only if the partner has a foreign address.
  • This field is required if the partnership return is being electronically filed.
Country
Enter only if the partner has a foreign address.
note
UltraTax CS ignores information in this field if the partnership return is being electronically filed.
Postal code
Enter only if the partner has a foreign address.
Entity
I = Individual
C = Corporation
S = S Corporation
L = Disregarded Entity
P = Partnership
T = Trust
G = Grantor Trust (Subject to SE)
E = Estate
O = Exempt Organization
R = IRA
F = Foreign Government
Nominee
X
Partnership Rep
X
note
Select only 1 partner as the partnership representative.
Rep Phone
xxx-xxx-xxxx
note
Enter only if the partner has been selected as the partnership representative.
Des Individ SSN
xxx-xx-xxxx
note
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ Phone
xxx-xxx-xxxx
note
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ Last Name
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ First
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ Address
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ City
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ State
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Des Individ Zip
Enter only if the partner has been selected as the partnership representative and the partner isn't an individual.
Type
1 = General Partner
2 = Limited Partner
3 = LLC Member (No SE income)
4 = LLC Member (SE Income)
5 = LLC Member (SE on Services)
LLC Member Manager
X
Active
X
Final K1
X
Foreign
X
Rounding Ptr
X
note
Select only 1 partner as the rounding partner.
1040 Client
X
Print partner's letter in Spanish
X
Disreg entity TIN
xxx-xx-xxxx = Social Security Number
xx-xxxxxxx = Employer Identification Number
A = Applied For
D = Died
F = ForeignUS
note
Enter only if the entity of the partner is disregarded entity. If a 9-digit number is entered without hyphens, the number will be formatted as a social security number. Number upon import to UltraTax CS/1065.
Missing ID reason
Unknown
None
note
Enter only if the entity of the partner is disregarded entity.
Disreg entity Name
Enter only if the entity of the partner is disregarded entity.
Bene Owner Entity
I = Individual
C = Corporation
S = S Corporation
L = Disregarded Entity
P = Partnership
T = Trust
G = Grantor Trust (Subject to SE)
E = Estate
O = Exempt Organization
R = IRA
F = Foreign Government
note
Enter only if the entity of the partner is disregarded entity.
Indirect pct for max profit, loss, or capital
xxx.xxxxxx
note
Enter the indirect percent to be added to the greater of the direct profit, loss, or ownership of capital percentage for Schedule B-1.
Country code (if not US)
See Publication 4163 for a list of acceptable foreign country codes.
note
Enter only if partner owns, directly or indirectly, 50 percent or more in the partnership for Schedule B-1.
Country (if not US)
Enter only if partner owns, directly or indirectly, 50 percent or more in the partnership for Schedule B-1.
note
UltraTax CS ignores information in this field if the partnership return is being electronically filed.
Report grantor trust as an individual
X
note
Select only if the partner is a grantor trust and should be treated as an individual on Schedule B-1.
Eligible Foreign Entity
X
note
Select only if the partner should be treated as an eligible foreign entity on Schedule B-2.
Decr Due to Trans
X
Group At-risk
X
Group Passive
X
Reportable Entity Partner
X
note
  • Select only two partners as the reportable entity partners for Schedule M-3.
  • This field is applicable only to partners with entity type Partnership, Corporation, or S Corporation.
Max Deemed Ownership Percent
X
note
  • Enter only for the 2 partners marked as the reportable entity partners for Schedule M-3.
  • This field is applicable only to partners with entity type Partnership, Corporation, or S Corporation.
8805 Frgn Country
Enter only if the partner is a foreign partner. See the Form 8805 instructions for a list of acceptable foreign country codes.
8805 Account Num
Enter only if the partner is a foreign partner.
8805 Tax Exempt
X
note
Select only if the partner is a foreign partner.
8805 De Minimis Partner Certificate
X
note
Select only if the partner is a foreign partner.
Suppress basis worksheet
X
note
Select to suppress the printing of the partner basis worksheet for a specific partner. To suppress the calculation of the partner basis worksheets for all partners, use the
Suppress calculation of partner basis worksheets
 field on Screen Basis in the Partner Info, Basis folder.
8938 specified individual
X

This article applies to:

  • PRODUCT: UltraTax CS
  • Return type: 1065 Partnership
  • Subject: Export,Import,schedule-k1-subject

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close