Importing Apportionment Data from a Spreadsheet

You can import apportionment data from a spreadsheet to Corporation, S Corporation, and Partnership returns. Apportionment data is in the following areas of the Common State > Allocation and Apportionment worksheets: 

  • Property
  • Payroll
  • Sales
  • Non-business income (for Corporation and S Corporation only)
  • Transportation (for Corporation and S Corporation only)
  • Insurance (for Corporation only)

Note: You must have Microsoft® Excel® installed to perform a spreadsheet import or export.

When you import apportionment data, any existing apportionment data in the return is overwritten. If data is successfully imported into a return, a notation is added in the return history when you save and close the return. If you discard the imported changes when you close a return, the return history notation is also discarded.

ClosedPreparing for the Import

You must enter the import data into a spreadsheet that is formatted according to Tax specifications. You can either use a template provided by Tax, or you can export from another return of the same type and tax year to create a template.

Tip: For most imports, we recommend entering import data in a template provided by Tax. However, you might want to consider using an exported spreadsheet from a return if both of the following are true:

  • The return you are importing data into already contains apportionment data.
  • You need to retain at least some of the existing apportionment data in the return after the import.

Use a Provided Template

Tax provides templates that meet these specifications. You can find the templates in the following location on the computer where you have installed Tax:

X:\Program Files (x86)\WK\ProSystem fx Suite\Smart Client\SaaS\IXResources\yyyy

Note: In the file path, X is the drive where CCH Axcess is installed and yyyy is the tax year.

The templates provided for apportionment imports are:

  • APyyyyC.xls (Corporation)
  • APyyyyP.xls (Partnership)
  • APyyyyS.xls (S Corporation)

The templates are tax year specific, with the yyyy in the template name representing the tax year.

Export from a Return

You also can generate a spreadsheet that meets Tax specifications by exporting the apportionment worksheets from a return. Any data that is in the exported worksheets is also exported. You can add to, revise, or delete the exported data as needed before reimporting the spreadsheet data back into the return. See Exporting Apportionment Data to a Spreadsheet for more information

ClosedTips for Entering Data in an Import Spreadsheet

Regardless of whether you use the provided templates or create a template with an export, keep in mind the following when entering import data in a spreadsheet.

  • Do not add blank columns to a spreadsheet. The import processor interprets a blank column as the end of the data to import.
  • If you add rows, do not skip more than a single row. The import processor interprets two consecutive blank rows as the end of the data to import. Also, be sure to use Insert > Row. Selecting this option, rather than simply adding data to unused cells, will ensure that proper cell and print formatting is maintained for new rows. Inserting new rows also prevents potential problems in the return once the data has been imported.

ClosedPerforming the Import

The detail logs are not retained when you exit the wizard. If you need to keep a copy of a log for your reference, click Print to send the log to a printer. You can also click Copy to add the information to the Windows Clipboard, then paste the log information into another document.

  1. Open the Corporation, Partnership, or S Corporation return into which you want to import data.
  2. Click Apportionment Data in the Import group on the Import / Export tab.
  3. Click Browse.
  4. Navigate to and select the file to be imported.
  5. Click Open.
  6. Click Validate. The system reviews the data in the file to ensure that it can be imported. The status of the validation process displays in the Validation log summary box. When validation completes, one of the following messages displays:
    • Validation succeeded. All data in the source file can be imported. You can continue to the next step in the import.
    • Validation partially succeeded. Some data in the source file cannot be imported. You can continue with the import without fixing the errors. However, only the data that passed validation will be imported.
    • Validation failed. The data file cannot be imported in its current form.To view information about the problematic data, click Details. You must exit the wizard and fix the errors. Then, you can repeat the import process.
  7. Click Import.

    Important: You cannot cancel an import once it has begun.

  8. When the import completes, click Details to view information about the imported data.

    Note: The detail logs are not retained when you exit the wizard. If you need to keep a copy of a log for your reference, click Print to send the log to a printer. You can also click Copy to add the information to the Windows Clipboard, then paste the log information into another document.

  9. Click Finish.