2018 UltraTax CS
You can quickly and efficiently export and import apportionment information to and from UltraTax/1065 and a Microsoft Excel workbook. When you export apportionment information from UltraTax/1065, the Excel Export / Import utility creates Excel worksheets for Property, Payroll, and Sales as follows:
- Apport Info Property: This worksheet contains information to complete the property information in the Apportionment Information window.
- Apport Info Payroll: This worksheet contains information to complete the payroll information in the Apportionment Information window.
- Apport Info Sales: This worksheet contains information to complete the sales information in the Apportionment Information window.
The table identifies the UltraTax/1065 Apportionment Information Spreadsheet information that exports to Excel and the Excel worksheet that contains the corresponding information for import into UltraTax/1065.
| UltraTax/1065 Apportionment Information Spreadsheet tab | Microsoft Excel workbook worksheet |
|---|---|
| Property | Apport Info Property |
| Payroll | Apport Info Payroll |
| Sales | Apport Info Sales |
Notes
- The Excel Export / Import utility does not import or export information from the state tabs or statement dialogs in the Apportionment Information window.
- The Excel Export / Import utility does not import year-end property amounts for depreciable property when you use detailed asset data entry to classify assets for apportionment.
- You can import information into statement dialogs from Excel or the Windows clipboard.
- To import Excel spreadsheet information into statement dialogs, follow the guidelines in Importing statement data from Excel overview.
For detailed information about UltraTax/1065 apportionment data entry, see UltraTax/1065 Apportionment procedures and reference information.
Basic procedure for importing and exporting apportionment information
Follow this basic procedure to use the Excel Export / Import utility to export or import apportionment information to and from UltraTax CS.
- Export information from UltraTax/1065 to Excel. To import apportionment information from Excel, you must first export the apportionment information from UltraTax/1065 into Excel to create the Excel workbook template. Though not required, you should add the state, city, and other returns to the client prior to export.
- Modify and save the Excel workbook. After you generate the Excel workbook, you can modify the worksheets. To modify the worksheets, follow the guidelines in Excel Export / Import Utility guidelines for apportionment information. If you do not plan to import the Excel file back into UltraTax/1065, you can modify the file using Microsoft Excel guidelines.
- Import information from the Excel workbook into UltraTax/1065. After you create the Excel workbook and, if necessary, modify the information, you can import the information back into UltraTax/1065.
Video: Exporting and importing partner, shareholder, and apportionment data (approx. 3.5 minutes)