Cities and other returns spreadsheet (1065)

Alerts and notices

Use the Cities and other returns spreadsheet to enter city and other returns information for the apportionment factors. The spreadsheet consists of three tabs, one for each factor: property, payroll, and sales.

To open the Cities and other returns spreadsheet, choose View > Apportionment, click the appropriate state tab at the bottom of the window, and click the Cities or other return button. The spreadsheet is located at the top of the Cities and other returns dialog. Note that you must have a city or other return attached to this client to open the Cities and other returns dialog.

Apportionment data entry

  • White fields: UltraTax CS uses the white fields in the city and other return columns to complete the city's or other return's apportionment form. The amounts for the everywhere fields on the city or other return form transfer from either the Everywhere / (Override) column or the state column in the Apportionment Information window, depending on the applicable law. For additional information about how the white fields on the spreadsheet combine onto the apportionment forms, refer to the Apportionment Form Combination Tables Guide.
  • Shaded fields: You cannot enter data in the shaded fields in the city or other return columns. These fields are for components that are not used on the city's or other return's apportionment form.
  • Statements: Some fields in the Cities and other returns spreadsheet and city and other return tabs have statements to enter detailed information for this factor's component.

    If the Statement Statement dialog button button is underlined and purple in color, then the amount imported from Excel (using the Excel Export / Import utility) or transferred from the Asset tab (using asset detail for apportionment) does not equal the amount within the statement. Open the statement and update the detail.

  • Column totals: UltraTax CS calculates the amounts entered in city and other return columns and displays the total at the bottom of the column. The amounts are calculated in the same manner as they are calculated for the apportionment form. For example, annual rents are multiplied by eight, and returns and allowances are deducted from sales.

Spreadsheet columns

  • Component: This column lists the most frequently used elements for this factor. Components that are not listed in this column are available in the appropriate city or other return tab at the bottom of the Cities and other returns dialog.
  • City / Other return: Enter the in-city amounts for the apportionment forms in these columns. Most apportionment data entry is completed in these columns. Note that only cities and other returns attached to the current client appear as columns. Data entered in a city or other return column is not included in the Everywhere / (Override) column in the Apportionment Information spreadsheet.

Related topic: Cities and other returns dialog (1065)

Was this article helpful?

Thank you for the feedback!