1040-US: Allocating income to states in the K1 state allocation spreadsheet

Show expandable text

New (tax) year, new help!

Fixed Assets and UltraTax CS 2023 help is now on Help and Support. We're still moving articles, but you can find most content for the 2023 tax year there. Continue using the Help & How-To Center for tax years 2022 and older.

Question

How do I allocate federal net income to the applicable states displayed in the State allocation spreadsheet? (K1 state allocation)

Answer

Allocating income to states in the State allocation spreadsheet

Two methods can be used to allocate income to the states appearing in the spreadsheet. Please note that amount fields applicable to one state may not be applicable to another state. Those amount fields that do not apply to a particular state have been disabled (shaded). Each section of Screens K1, K1-2, K1-3, K1-4, K1-5, K1-6, K1-7, PBasis1, PBasis2, SBasis1, SBasis2, K1T, K1T-2, K1T-3, and 6198 (if present) has been assigned a separate tab for ease of data entry.

  • Percentage: Enter a percentage in XXX.XX format in the first field available on the State allocation spreadsheet. Select the state to which this percentage applies and click the Apply button. All current-year federal amounts present for this unit will appear in the selected state's column, multiplied by the percentage entered for that state. The percentage entered for that state will also appear below the state name for future reference. Individual amounts can be changed from the calculated amount. Note that carryover amounts are not multiplied by the percentage. Carryover amounts, when applicable to the state, should be entered individually.
  • Amount: In cases where percentages of federal amounts do not apply, individual amounts may be entered for the applicable state. Zero is a valid entry and will prevent the state amount from defaulting to the federal amount. If an amount field is left blank, the federal amount, if present, will be used in the state's calculation.

    Ohio Note: If Ohio amounts are entered instead of a percentage of federal, additional data entry is required. In the Ohio system, go to Screen BUS in the Income and Adjustments folder. For the purpose of calculating Form IT-NRC, it is necessary to enter either an Ohio apportionment ratio, or the factors for apportionment of business income.

Primary state behavior

The postal code entered in Screen K1 or Screen K1T, regardless of residency, will be considered the primary state for that unit if that state is attached to the client being processed. The primary state always appears first within the State allocation spreadsheet and the SID fields in Screen K1 or K1T will be used to populate the first column of the spreadsheet. If an SID amount is not entered and remains blank in the spreadsheet, the federal amount will be used to process income for that state.

If the primary state for that unit is attached as a nonresident or part-year resident, a second primary state will appear in the State allocation spreadsheet if a resident state is attached and being processed for the client. The purpose of a second primary state is to allow for blank spreadsheet amounts to default to federal amounts for the resident state being processed. The second primary state, if present, always appears second in the State allocation spreadsheet.

All other attached states for this client will appear in the State allocation spreadsheet, in alphabetical order as secondary states. These other nonresident and part-year resident processed states will automatically be assigned zero in every applicable spreadsheet amount field. Until an amount has been entered for a secondary state, no income will be transferred to that state from this unit.

If the postal code represents a non-UltraTax/1040-process state (Nevada, for example), the amounts entered in the SID fields will be reported as "Other" next to the last column in the spreadsheet. The last column within the spreadsheet represents federal amounts which may be used for reference only during data entry within the State allocation spreadsheet. In this case, the primary state will be determined by searching for any states being processed as resident, and if none, the first alphabetically attached state being processed.

Data entry for different categories of states

States fall within certain categories based on their calculation needs. Full build-up states, AL, CA, HI, MA, and WI, normally require that differences - depreciation, for example - be presented in a format similar to the federal return presentation. Partial build-up states, KY, NJ, and PA, require less detail or specialized calculations that differ from the federal return presentation. AGI states, AR, AZ, CO, CT, DC, DE, GA, IA, ID, IL, IN, KS, LA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NM, NY, OH, OK, OR, RI, SC, UT, VA, VT, and WV, require that the in-state portion of federal AGI be reported for part-year resident and nonresident returns. These part-year resident and nonresident amounts are transferred and calculated using the AGI Worksheet. States that are not affected by the State allocation spreadsheet are NH and TN, and the Trust paid state estimated tax field within the K1T allocation spreadsheet is used by all processed states.

  • AGI states: Applicable SID fields are available for use for all part-year resident and nonresident AGI states. There is a limitation to the calculation that will result for part-year resident and nonresident AGI states, except New York. Amounts entered in the SID fields must be entered as limited or allowable. For example, if a (10,000) SID amount is entered in Screen K1 or within the State allocation spreadsheet for Ordinary income (loss) from trade or business, a 10,000 loss will be transferred, as entered, directly to the state without regard to at-risk or passive loss limitations. The federal amount columns on the AGI Worksheet will not be affected by any spreadsheet data entry. Screen 6198 SID fields are not intended for use by AGI states, except for New York part-year residents and nonresidents.

    New York Note: Amounts entered for part-year resident and nonresident New York taxpayers are used to complete Form IT-182, Passive Activity Loss Limitations, basis and at-risk worksheets. Only New York source amounts are used to complete Form IT-182. Therefore, the calculation may differ from federal Form 8582.

    Montana Note: Montana-sourced passive activity losses should be entered in the State allocation spreadsheet.

    Kentucky Note: Kentucky-sourced passive activity losses, basis, and at-risk amounts should be entered in the State allocation spreadsheet.

    Connecticut Note: Connecticut-sourced passive activity losses and basis amounts should be entered in the State allocation spreadsheet.

Was this article helpful?

Thank you for the feedback!