Data column federal requirements
Show all hidden content
Federal partner information a-h
Column | Column name | Details | Range or character maximum |
|---|---|---|---|
A | partner number | enter a partner number | 1-99,999 range |
B | partner name line 1 | enter partner's name | 35 |
C | partner name line 2 | enter partner's name | 35 |
D | partner name line 3 | enter partner's name | 35 |
E | partner street address line 1 | enter street address | 35 |
F | partner street address line 2 | enter street address | 35 |
G | partner city | enter city for address | 20 |
H | partner state code | enter 2-digit state USPS code |
Federal partner information i-n
Column | Column name | Details | Range or character maximum |
|---|---|---|---|
I | partner zip code | ZIP code portion of the partner's domestic address | 5-digit ZIP Code (12345) or a 10-character ZIP Code comprised of 9 digits with a hyphen separator (12345-7890) |
J | partner foreign country code | if partner's address is domestic leave blank if partner's address is foreign enter the country code from the Foreign worksheet | Column J foreign country code is a control value that affects the audit of partner address information. If the cell is not populated (no code), the partner’s address is assumed to be domestic, and all segments of the partner’s address will be audited as such. If the cell is populated, even with an invalid foreign country code, the partner’s address is assumed to be foreign, and all segments of the partner’s address will be audited as such. No other column on the worksheet has any effect upon the classification of the partner’s address as domestic or foreign. |
K | partner foreign postal code | if partner's address is domestic leave blank if partner's address is foreign, enter the foreign province or state name | This is mandatory. 20 character |
L | partner foreign province name | if partner's address is domestic leave blank if partner's address is foreign, enter the foreign province or state name | This is mandatory. 20 character |
M | partner taxpayer ID status | partner SSN or EIN | blank or Z X if partner has applied for SSN or EIN |
N | partner taxpayer ID | enter partner SSN (enter as 9-digits with 2 hyphens) or EIN (enter as 9-digits with a hyphen) | blank or Z X must be blank |
Column O: Partner beginning profit ratio expressed as a decimal fraction
Enter the ratio expressed as a decimal fraction with a maximum of 8 digits to the right of the decimal point as in 0.12345678. The smallest allowable decimal fraction is -1.0 (negative 1.0 is a smaller value than is negative .00000001), and the largest allowable is +1.0. The alphabetic notation NONE is allowed and is interpreted as a zero.
note
Partner Bridge Ending Ratios
Import: All partner ratios (beginning and ending) are imported to Organizer. If ending ratios are imported, they are considered to be overrides and must be imported in decimal format. If ending ratios are imported, a value must be imported for every partner. If a particular partner does not have an ending ratio, enter NONE. The reason for providing this column in the templates is to enable the user to maintain or update the spreadsheets from year-to-year using the Export function.
Export: Ending ratios are exported from the partners’ actual Schedules K-1. Beginning ratios are exported from Organizer. The ending ratios on the partners’ Schedules K-1 are displayed and printed as percentages. (For example, .25 is displayed and printed as 25%.) Therefore, the ratios are exported as percentages and need to be converted to decimal format for the following year’s import operation.
Column P: partner ending profit ratio expressed as a decimal fraction
See column O.
Column Q: partner beginning loss ratio expressed as a decimal fraction
See column O.
Column R: partner ending Loss Ratio expressed as a decimal fraction
See column O.
Column S: partner beginning ownership ratio expressed as a decimal fraction
See column O.
Column T: partner ending ownership ratio expressed as a decimal fraction
See column O.
Column U: partner beginning capital balance expressed as a dollar amount
See column O.
Column V: partner’s capital account type
Code:
- Blank - not applicable
- T - tax basis
- G - GAAP basis
- S - section 704(b)
- O - other (enter description at next column)
Column W: partner's capital account other description
- T, G, S - must be blank
- O - mandatory description, 20 characters maximum
Column X: domestic/foreign partner code
- blank - not applicable
- D - partner is domestic
- F - partner is foreign
Column Y: partner schedule k-1 final/amended code
- blank - not applicable
- A - amended schedule k-1
- F - final schedule k-1
- Z - schedule k-1 is both amended and final
Column Z: partner exempt/taxable
- blank - not applicable
- T - partner is taxable
- E - partner is exempt
Column AA: partner participation active/passive code
- blank - not applicable
- A - partner is active
- P - partner is passive
Column AB: partner type general/limited
- blank - not applicable
- G - partner is a general partner
- L - partner is a limited partner
Column AC: partner entity type
- blank - not applicable
- C - corporation
- D - disregarded entity
- E - estate
- F - fiduciary
- G - grantor trust
- I - individual
- L - limited liability company
- M - limited liability partnership
- N - nominee
- P - partnership
- R - IRA
- S - S corporation
- T - trust
- V - foreign government
- X - exempt organization
Column AD: partner suppress statutory depletion
- X - suppress computation of statutory depletion
- blank - not applicable
Column AE: partner self employment income
- X - Include the partner in the computation of self employment if the partner is not an individual and is not a general partner
- blank - not applicable
Column AF: partner resident state code
If the partner’s address is not foreign or nonresident, enter the USPS code for the state, territory, or Armed Forces designation from the States worksheet (see Column H).
- FC - partner's address is foreign
- NR - partner's address is nonresident
- blank - not applicable
Column AG: partner federal schedule k-1 heading
This description prints at the top of the partner’s Schedule K-1 and attachments – optional with a maximum of 60 characters.
Column AH: partner's alternative schedule k-1 package print filename
This is optional with a maximum of 45 characters.
Column AI: partner telephone number
Optional with a maximum of 12 characters in a range of formats.
- 7 - 1234567
- 8 - 123-5678
- 10 - 1234567890
- 12 - 123-567-9012
Column AJ: partner contribute property with built-in gain/loss
- Y - yes
- N - no
- blank - not applicable
Column AG: partner federal schedule k-1 heading
This description prints at the top of the partner’s Schedule K-1 and attachments – optional with a maximum of 60 characters.
Column IE: termination ending profit ratio
Represents the partner’s ending profit ratio if the partner terminates his partnership participation during the tax year. The value is expressed as a decimal fraction. Enter the ratio expressed as a decimal fraction with a maximum of eight (8) digits to the right of the decimal point, as in 0.12345678. The largest allowable decimal fraction is 1.0.
Column IF: termination ending loss ratio
Represents the partner’s ending loss ratio if the partner terminates his partnership participation during the tax year.
Refer to column IE for the requirements of the data field for format and value range.
Column IG: termination ending ownership ratio
Represents the partner’s ending ownership ratio if the partner terminates his partnership participation during the tax year.
Refer to column IE for the requirements of the data field for format and value range.
Column IH: beginning profit ratio
Represents the partner’s beginning profit ratio participation if the partner enters into an existing partnership during the tax year.
Refer to column IE for the requirements of the data field for format and value range.
Column II: beginning loss ratio
Represents the partner’s beginning loss ratio participation if the partner enters into an existing partnership during the tax year.
Refer to column IE for the requirements of the data field for format and value range.
Column IJ: beginning ownership ratio
Represents the partner’s beginning ownership ratio participation if the partner enters into an existing partnership during the tax year.
Refer to column IE for the requirements of the data field for format and value range.
Column JY: Federal K-1, Item 1: Is this partner a retirement plan?
- Y - yes
- N - no
- B - blank
Column LB: Federal K-1 - type for schedule B-2
- E - estate of decease partner
- F - eligible foreign entity
- B - leave blank (default)
Column JY: Federal K-1, Item 1: Is this partner a retirement plan?
- E - estate of decease partner
- F - eligible foreign entity
- B - leave blank (default)
Column LC: partner sale or exchange of partnership interest
- X - decrease is due to sale of partnership interest
- E - decrease is due to exchange of partnership interest
- B - blank
Column LD: disregarded entity
- X - partner is a disregarded entity
- B - leave blank (default)
Column LE: disregarded entity's taxpayer identification number (TIN)
Enter the Disregarded Entity’s TIN (use dashes in the EIN/SSN). You can use numbers, FOREIGNUS , or APPLD_FOR. Maximum of 11 characters.
Column LF: disregarded entity individual name
Enter the Disregarded Entity Individual name (if a Business Name, leave blank). Maximum of 30 characters.
Column LG: disregarded entity business name line 1
Enter the Disregarded Entity Business Name Line 1. If an Individual Name, leave blank. Maximum of 30 characters.
Column LH: disregarded entity business name line 2
Enter the Disregarded Entity Business Name Line 2. If an Individual Name, leave blank. Maximum of 30 characters.
Column LI: item K partner's share of liabilities
Enter X if the Item K includes liability amounts from lower tier partnerships. Begin on line 6. Maximum of 1 character.
note
You can only enter either an Individual Name (Column LF) or a Business Name (Columns LG/LH), but you cannot enter both.
Column LR: federal K-1
Enter IRA Partner unique EIN. Maximum of 11 characters.
Column LZ: federal K-1
Enter X if liability is subject to guarantees or other payments.
Column LY: beneficial owner line 1
Use for the first line of the beneficial owner’s name. This column is common for domestic and foreign beneficial owners with a maximum of 35 characters.
Column LZ: beneficial owner line 2
Use for the second line of the beneficial owner’s name. This column is common for domestic and foreign beneficial owner with a maximum of 35 characters.
Column MA: beneficial owner street address line 1
Use for the first line of the beneficial owner’s street address. This column is common for domestic and foreign beneficial owner and is mandatory if Beneficial Owner name exists (for e-file purposes) with a maximum of 35 characters.
Column MB: beneficial owner street address line 2
Second line of the address. This column is common for domestic and foreign beneficial owner and is optional with a maximum of 35 characters.
Column MC: beneficial owner city
City of the address. This column is common for domestic and foreign beneficial owner and is mandatory if Beneficial Owner name exists with a maximum of 20 characters.
Column MD: beneficial state code
Leave blank if the beneficial owner address is foreign. If domestic, use for the state code portion of the beneficial owner’s domestic address. This column will contain the 2-character USPS code from the States worksheet.
Column ME: beneficial owner zip code
Leave blank if the beneficial owner address is foreign. If domestic, use for the ZIP Code portion of the beneficial owner’s domestic address. You can enter this information as a 5-digit ZIP Code (12345) or a 10-character ZIP Code comprised of 9 digits with a hyphen separator (12345-7890).
Column MF: beneficial owner foreign country code
If the beneficial owner’s address is domestic, leave blank.
If the beneficial owner’s address is foreign, enter the country code from the Foreign worksheet.
The column MF foreign country code is a control value that affects the audit of beneficial owner address information. If the cell is not populated (no code), the beneficial owner’s address is assumed to be domestic, and all segments of the beneficial owner’s address will be audited as such. If the cell is populated, even with an invalid foreign country code, the beneficial owner’s address is assumed to be foreign, and all segments of the beneficial owner’s address will be audited as such. No other column on the worksheet has any effect upon the classification of the beneficial owner’s address as domestic or foreign.
Column MG: beneficial owner foreign postal code
If the beneficial owner’s address is domestic, leave blank.
If the beneficial owner’s address is foreign, enter the foreign country postal code. This is mandatory if Beneficial Owner name exists with a maximum of 10 characters. There is no required format or punctuation.
Column MH: beneficial owner foreign province name
If the beneficial owner’s address is domestic, leave blank.
If the beneficial owner’s address is foreign, enter the foreign province or state name. This is mandatory if Beneficial Owner name exists with a maximum of 20 characters.
Column MI: beneficial owner taxpayer ID status
Code: Blank or Z - Beneficial owner SSN or EIN entered in next column (default)
Code: X - Beneficial owner has applied for SSN or EIN
Column MJ: beneficial owner taxpayer ID
- Blank or Z - enter beneficial owner SSN or EIN as described below.
- X - must be blank
- SSN - enter as 9 digits with 2 hypens (123-45-6789)
- EIN - enter as 9 digits with a hyphen (12-3456789)
Related Content
-
Data values instructions
Format:
Article,
1 min read
