Import account balances into UltraTax CS
Transfer general ledger account balances from
Workpapers CS
to UltraTax CS using tax code assignments to populate the correct tax form lines.Before you begin
important
Verify that you've installed the most recent version of
Workpapers CS
and UltraTax CS, and that you've applied all updates.Before transferring account balances from
Workpapers CS
to UltraTax CS, print the following reports.- Tax Code Groupings
- Tax Code Worksheet
- Tax Reconciliation Worksheet
Steps in Workpapers CS
Workpapers CS
Assign the proper tax codes for the selected client. You can enter these codes in either of the following screens.
- In theTax informationsection of theSetup,Chart of Accountsscreen.
- In the data-entry table in theActions,Enter Trial Balancescreen.
Make sure that the entity types (1040, 1120 or 1065, 1041, 990, and 5500) are the same in
Workpapers CS
and UltraTax CS.For multiple-unit entities, select the unit to designate the input screen location when transferring data to your tax application.
For example, if you transfer utilities expenses for a farm and the 1st unit uses tax code 632 with unit 1, transfer the 2nd unit's utilities using tax code 632 with unit 2.
If the Trial Balance grid doesn't have a Tax Code column, select
View Maintenance
and add it. If you want to include Units
in the trial balance view, mark the Include Unit Column
checkbox.Steps in UltraTax CS
- In UltraTax CS, selectSetup, thenUser Preferences.
- Select theFile Locationstab.
- SelectCS Accounting Products, then verify the location for theWorkpapers CStype of client data file.
- If it's not the location where yourWorkpapers CSclient data is stored, selectModify Location. Go to the correct location, selectOK, thenOKagain to close the window.
- Open the UltraTax CS client, selectUtilities, then select.Workpapers CS(Import)note
- isn't available unless you've installedWorkpapers CS(Import)Workpapers CSand set up the correct data location.
- If you've opened a 1040 client, make sure that you haven’t selectedView, thenClient Organizer. In the Client Organizer view, the Import icon is inactive, andis unavailable from theWorkpapers CS(Import)Utilitiesmenu.
- In theClients available to transferpane, select the clients you want to import into UltraTax CS, thenSelectto move them to theClients to transferpane.
- Select your options in theData to importsection, thenImport.note
- SelectAdjusted Trial Balanceto import the adjusted balances fromWorkpapers CS.
- SelectFederal Tax Trial Balanceto import the tax balances as defined in theSetup,Clients,Accounting Informationtab inWorkpapers CS.
- SelectDetailto list each account description and amount when importing to a statement field.
- SelectSummaryto have the import process combine all amounts and only show 1 description and total in the statement.
- SelectDonewhen the import is complete.noteUltraTax CS will import data from theWorkpapers CSFIRM database only. If client data is stored in a different database, that data won’t be available for import into UltraTax CS.
Best practices for tax codes
UltraTax CS tracks assets, capital gains, retained earnings/partner's capital, and other fund balances in detail. To avoid conflicts, exclude these tax code areas when you import from
Workpapers CS
into UltraTax CS:- All entities:
- Depreciation amounts
- Capital gains - specifically book figures for the sales of capital assets
- Section 179 expenses
- 1120/1120S - Retained earnings
- 1065 - Partners capital account
- 990 - Unrestricted fund balances, accumulated income, other funds
note
In
Workpapers CS
, assign either the 88888 or 99999 tax codes to these accounts to exclude them from importing. Tax code units shouldn't be assigned to tax codes 88888 or 99999.
- Tax code 88888 - account will print on the Tax Code Groupings Report inWorkpapers CS.
- Tax code 99999 - account won't print on the Tax Code Groupings Report inWorkpapers CS.
Resolve issues with importing for account balances
If you're troubleshooting an issue importing account balances that requires you to recreate the XML file, you'll need to do the following:
- Close the client in UltraTax.
- Go to the XML file location (default: \WinCSI\Workpapers CSData\Data\Integration\Tax).
- Rename the existing XML file by adding.OLDafter the file extension.
- Try the import again.
Internal use only
- Accounting CS and Workpapers CS require a FIRM database for integration and data sharing to work with UltraTax CS. The format of the database name needs to beACS_<FirmID>_Firm. (For example,ACS_0_Firm,ACS_999_Firm,ACS_798046_Firm.) Workpapers CS standalone database will still be named beginning withACS_. Also, integration and data sharing doesn’t work if there are multiple FIRM databases.
- Integration data is stored inX:\WINCSI\Accounting CS Data\Data\Integration\Tax, or for Workpapers CS standalone inX:\WINCSI\Workpapers CS Data\Data\Integration\Tax. The files are named asClientID_BalanceInfo.xml. As part of troubleshooting, you may need to verify these files exist, whether they’ve been modified recently, and even open the files to verify the tax codes and corresponding balances that are included in the file.
- If 1 of the applications is on VO/SAAS and one is local, the option for importing balances won’t be available.
Related Content
-
Recreate XML file when importing account balances
Format:
Article,
1 min read