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.
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)
Was this article helpful?
Thank you for the feedback!