Entering 1120 apportionment data for state returns

Show expandable text

Use this procedure to enter apportionment data by state for the return.


  • The level of detail entered into the spreadsheet needs to support the most complex apportionment form attached to the return.

    When you enter apportionment data, you need to enter data to the level of detail required to support the most complex apportionment form attached to the return. when you do this, you ensure the correct calculation of the everywhere amount is included on all state apportionment forms.

    • A summary apportionment form requires information for only a few components. Ohio Form IT 1140, Schedule C is a good example of a summary apportionment form.
    • A complex apportionment form requires information for many components. R2L Pennsylvania RCT-106 is no longer a good example of complexity; it is now a single sale factor.
  • Because all apportionment information is entered on a state-by-state basis, we recommend that you organize the apportionment information by state before you begin entering data.
  • 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 on how the white fields on the spreadsheet are combined onto the apportionment forms, refer to the Apportionment Form Combination Tables guide.) UltraTax CS does not use the information you enter in the shaded fields on that state's apportionment form. However, the amounts in the shaded fields 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. View an example.
    • Scenario: A client is filing both an Iowa and Oklahoma return. Iowa uses only the sales factor to calculate apportionment, while Oklahoma uses all three factors. As a result, all of the fields in the Iowa columns of the Property and Payroll tabs of the Apportionment spreadsheet are shaded.
    • Data entry: When you enter land information in the Property tab, you enter the value of Oklahoma land in the Oklahoma column and the value of Iowa land in the Iowa column. UltraTax CS combines these two amounts and displays the total in the Everywhere / (Override) column.
    • Results: When UltraTax CS calculates the return, the Iowa return will not include any land information on its apportionment form because Iowa does not use the property factor. The Oklahoma apportionment form will include the value of the Oklahoma land in the in-state column and the value of all land owned, which is the amount from the Everywhere / (Override) column in the everywhere column.
  1. Choose View > Apportionment to open the Apportionment Information window.

    Note: You need to have a state return attached to the current client in order to open this window.

  2. Click the Property, Payroll, or Sales tab and enter information in the Apportionment spreadsheet for the selected factor.

    Note: Some fields in the Apportionment spreadsheet and state tabs have statement dialogs to enter detailed information for this factor's component. UltraTax CS uses the information you enter in the Everywhere column in the statement dialog as the everywhere amount for that component. UltraTax CS ignores the amount in the Everywhere / (Override) column in the Apportionment spreadsheet for that component.

  3. 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.)
  4. Repeat steps 2 and 3 to complete data entry for the remaining factors.



  • By default, the cursor moves down to the next row in a column when you complete a field. When you switch to Cursor Right mode, the cursor moves to the next column in the same row. To switch to Cursor Right mode, choose Movement > Cursor Right.
  • To delete data from the spreadsheet, highlight the required data and then do one of the following: press the DELETE key, click the Cut button on the toolbar, or choose Edit > Cut.
  • To select an entire spreadsheet column, click the heading at the top of the column.
  • To select an entire spreadsheet row, click the component heading at the beginning of the row.
  • To select the entire spreadsheet, click the main component heading in the upper-left corner of the spreadsheet.
  • If necessary, you can override the amount in the Everywhere / (Override) column for all states or on a state-by-state basis.

Was this article helpful?

Thank you for the feedback!