Open Thema mit Navigation

UltraTax Export

Before attempting to export data to a US tax package, you must enter the relevant codes in the Tax Code column in the Tax setup in the Working Trial Balance.

Note: Working Papers does not currently support the exporting of tax codes for all existing tax forms and schedules.

To create an UltraTax export file

1. On the File menu, click Export, and then Tax Software.

2. In the Tax Software box, select UltraTax.

3. In the Export Path box, enter the path to the directory where the export files are to be placed. Use the Browse button to locate the directory. When importing into UltraTax, this path is required.

4. In the Export Filename box, enter a file name.

5. In the Export File Extension box, the default extension for the export file is DWI and must not be changed.

6. In Tax Year, select the year for which the tax return is being prepared.

7. If you are exporting data for a consolidated company, do the following:

   1. To export the information about a single entity, select Entity Specific Export.

   2. To export any associated sub entities along with the entity, select Include Sub Entities. Note that you will be exporting a consolidated total of the parent company and all its subsidiaries.

8. If using multiple currencies in the trial balance and you want to convert a foreign tax balance to the default currency before exporting, select the Apply Foreign Exchange check box.

9. To include other basis adjustments in the exported balances, select the Include Other Basis Adjustments check box.
   
   If you do not wish to include the other basis adjustments in the export, clear the check box.

10. Select the type of book balance to export.

11. Click OK to process the export.

If there are any errors or problems during export an export log file appears. Review the log and resolve the issues before rerunning the export.

Export files that Working Papers creates

????.dwi

Where, ????, represents the name entered in the Export Filename field.

To import the file into UltraTax:

1. Launch UltraTax.

2. Create a new document in UltraTax, which is of the same tax entity as the Working Papers import file.

3. From the Utilities menu, select Third Party, and then CaseWare Working Papers.

4. From the import box click the Change Location button and point UltraTax to the location of the file you intend to import.

5. Select the file from the choices that appear.

6. Click the Import button to complete the import

In order to use the Working Papers import into UltraTax, you must obtain a license file from Creative Solutions (CSI). Working Papers will not display in UltraTax as a menu selection without this license file.

To obtain your license, call the CSI helpline at 1-800-968-0600 and press 4 for customer service. Customer service will update your customer file and send you the needed license file. They will also ensure that future licenses are automatically forwarded.

Note: The top-level company name and address will be included for all tax exports. If you are exporting entity-specific data from a consolidated file, you will need to modify the company name and address in the tax package once the import to the tax package is complete.