Triva isn't available right now.
Check out the support page for our phone number and hours
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.
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
|
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
|
Max Deemed Ownership Percent | X
note
|
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 |