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 this procedure to enter apportionment data by state for the client.
Notes
- The level of detail entered into the spreadsheet must support the most complex apportionment form attached to the client.
- Because all apportionment information is entered on a state-by-state basis, we recommend organizing the client's apportionment information by state before you enter data.
- Generally, UltraTax CS uses the white fields in the state column(s) and the corresponding fields in the Everywhere / (Override) column to complete the state's apportionment form. For additional information about how the white fields on the spreadsheet are combined onto the apportionment forms, refer to the Apportionment Form Combination Tables Guide (links to PDF, which requires the Adobe Reader). UltraTax CS does not use the information entered in the shaded fields on that state's apportionment form. However, the amounts in the shaded fields do accumulate in the Everywhere / (Override) column, which UltraTax CS uses in the everywhere amount on the apportionment forms for other states that require information for that component. For both white and shaded fields, if a state does not follow the general rule, this information is explained in the state's Special information for processing returns section of the apportionment help. View an example.
- Choose View > Apportionment to open the Apportionment Information window.
Note: You must have a state return attached to the current client in order to open this window. See Adding a state or city return for a client.
- Click the Property, Payroll, or Sales tab, and enter information in the Apportionment Information spreadsheet for the selected factor.
Note: Some fields in the Apportionment Information spreadsheet and state tabs have statements to enter detailed information for this factor's component. UltraTax CS uses the information entered in the statement's Everywhere column as the everywhere amount for that component. UltraTax CS ignores the amount in the Apportionment Information spreadsheet's Everywhere / (Override) column for that component.
- If the state requires additional information that cannot be entered into the spreadsheet (including city and other return apportionment information), use the state tab at the bottom of the window. (If the state does not require additional information, no state tab appears in this window.)
- Repeat steps 2 and 3 to complete data entry for the remaining factors / states.
Notes
- With detailed asset data entry, you can classify assets for the property factor and UltraTax CS automatically transfers the year-end amounts to the corresponding field in the Property tab in the Apportionment Information window and the Cities and other returns dialog. See Classifying assets for apportionment property factors (1065).
- The Excel Export / Import utility allows you to quickly and efficiently import and export apportionment information to and from UltraTax/1065 and a Microsoft Excel workbook.
- Use the Overview of Importing Statement Data from Excel procedures to import information into statements.
Tips
- By default, the cursor moves down to the next row in a column when you complete a field. Switching to Cursor Right mode causes the cursor to move to the next column in the same row. To switch to Cursor Right mode, choose Movement > Cursor Right.
- For information about deleting apportionment information, see Deleting apportionment data (1065).
- If necessary, you can override the amount in the Everywhere / (Override) column for all states or on a state-by-state basis. See Overriding everywhere amounts for apportionment forms overview.
Related topic: Apportionment Information window (1065)
Was this article helpful?
Thank you for the feedback!