Opening the State allocation spreadsheet (1040)

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.

Use the State allocation spreadsheet to enter information for the federal items to be allocated. The spreadsheet consists of a series of tabs. For example, Schedule K-1 (for UltraTax/1065 & UltraTax/1120) consists of: Income; Itemized Ded, WH, Depletion; Self-employment; Foreign Transactions; AMT Items Affecting Basis; Other Information; PAL Carryovers and Depr; Partner Basis Info; Partner Basis Carryovers; AMT Partner Basis Carryovers; Shareholder Basis Info; Shareholder Basis Carryovers; and AMT Shareholder Basis Carryovers. You can assign percentages of federal amounts to a specific state, provided that state is being processed for the current return, or you can enter unique values for one or more items within a particular state, or a combination of both.

In addition, reports of the allocated amounts can be sent to your printer, or to FileCabinet CS if you are licensed for that application and have it installed.

To access the State allocation spreadsheet, open a 1040 client and choose View > Allocation. Note that you must have at least one state return attached to the open client to access the spreadsheet, and the State field on the main activity screen must have a postal code entered.

Note: You can also click the Allocation button which is available on applicable input screens. The text on the Allocation button will be red if data is present, or blue if data is not present, in the State allocation spreadsheet.

Related topic: State allocation spreadsheet

Was this article helpful?

Thank you for the feedback!