1040-US: Allocating federal amounts to states via the 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 amounts to the applicable states displayed in the State allocation spreadsheet?

Answer

Two methods (percentage or amount) of allocation can be used to allocate federal amounts to the applicable states displayed in the State allocation spreadsheet.

Note: 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). Amounts 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 on the State allocation spreadsheet. Select the state to which this percentage applies from the drop-down list. Click 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 the application-calculated amount.

Amount: In cases where a percentage of the federal amounts do not apply, individual item amounts, if enabled, may be entered on 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.

Related topic: Form 6198 - At-risk calculations FAQs (1040)

Was this article helpful?

Thank you for the feedback!