To access the State allocation spreadsheet, the following conditions must be present in the current client.
The client being processed must include at least one state return.
You must be viewing Client Organizer Data Entry or Input Screen Data Entry.
For the 4835 and F screens, data must exist in the
Description
field.
For the C screen, data must exist in
Principal business
field.
For the Rent screen, data must exist in
Property kind/location
field.
When these conditions have been met, access the spreadsheet by clicking the Allocation icon in this screen.
Two methods (percentage or amount) of allocation can be used to allocate federal unit net income to the applicable states displayed in the State allocation spreadsheet.
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). Amount fields that are not shaded are considered enabled for the applicable state.
Percentage:
Enter a percentage in XXX.XX format in the first field available in the State allocation spreadsheet. Select the state to which this percentage applies from the fieldview. Select the Apply button. UltraTax CS will automatically calculate the amounts attributable to that state and display the amounts in the spreadsheet. The percentage entered for that particular state will appear below the state name for easy reference. If enabled, individual item amounts can be changed (overwritten) on the spreadsheet from UltraTax CS-calculated amount.
Amount:
In cases where a percentage of the federal amounts do not apply, individual item amounts, if enabled, may be entered in the spreadsheet for the applicable state. Zero (0) is a valid entry and will prevent the state amount from defaulting to the federal calculated amount. If an individual item amount field is left blank, the federal amount, if present, will be used in the state's calculation.
Build-up states that report or otherwise calculate income from these Schedules C, E, and F and Form 4835 activities on an amount by amount basis may be allocated using a percentage only, while passive carryover amounts may be allocated by entering the state- specific carryover amounts within the State allocation spreadsheet.
Other states, which are typically AGI states that require net activity amounts only, may be allocated by percentage or by entering the net amount of activity income/(allowable loss) attributable to the specific state.
Passive activity carryover amounts are disabled for AGI states other than Arkansas (Schedule C only), Connecticut, Kentucky, Montana, New York, and Oregon. Unlike income allocations, passive activity and section 179 carryover amounts apply to all residency statuses for AL, CA, CT, HI, KY, MA, MT, OR, and WI, and part-year resident and nonresident statuses for NY.
The State allocation spreadsheet may be printed in a report format for future reference. Select the Print or Preview button in the lower portion of the spreadsheet. If licensed, you can also print to FileCabinet CS.