Excel Export / Import utility guidelines for partner information

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on [[date]]. However, limited UltraTax CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline.

Links to our most popular tax processing topics are available in the Alerts and notices section on the right side of most pages.

Consider the following guidelines when you modify the Microsoft Excel workbook data you want to import into UltraTax/1065.

Column heading Entry
Ptr Num

If you use custom partner numbers, enter any alphanumeric value up to five characters. Each partner must have a unique partner number. If you do not use custom partner numbers, UltraTax CS will ignore entries in this column.

Note: To use custom partner numbers, choose Setup > Custom Partner Numbers in the Partner Information window in Partner Data Entry.

SSN/EIN

xxx-xx-xxxx = Social Security Number

xx-xxxxxxx = Employer Identification Number

A = Applied For

D = Died

F = ForeignUS

Note: If a nine-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/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.

Notes

  • 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
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 one partner as the rounding partner.

Tax Matters Ptr

X

Note: Select only one partner as the tax matters partner.

TMP Representative Name Enter only if partner has been selected as the tax matters partner and is not an individual.
TMP Rep Phone Enter only if partner has been selected as the tax matters partner.
1040 Client X
Print partner's letter in Spanish X
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 disregarded entity as a corporation

X

Note: Select only if the partner is a disregarded entity and should be treated as a corporation on Schedule B-1.

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.

Reportable Entity Partner

X

Notes

  • 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

xxx.xxxxxx

Notes

  • Enter only for the two 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.

Section 752 information not provided X
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

Note: If you do not plan to import the Excel file into UltraTax/1065, you can modify the file in accordance with Microsoft's Excel guidelines.

Related topic: Excel Export / Import Utility for partner information overview

Share This