Integration with UltraTax CS
For Onvio Workpapers and Onvio Trial Balance users
When you are licensed for Onvio and UltraTax CS, you can take advantage of the integration capabilities that enables you to import a contact's account balances — based on how the accounts are grouped in Onvio — into UltraTax CS via the Utilities > Onvio Workpapers (Import) or Onvio Trial Balance (Import) command.
Steps in Onvio
As a best practice, use these steps to set up your client's accounts and balances in Onvio Workpapers or Onvio Trial Balance so that they can be imported into UltraTax CS.
- Set up the contact with the appropriate tax entity.
Onvio entity type UltraTax CS entity type Individual 1040 C-Corporation 1120 Limited Liability Partnership 1065 Partnership 1065 S-Corporation 1120S Sole Proprietorship 1040 Exempt Organization 990 Trust 1041 - Open your project in Onvio Workpapers or Onvio Trial Balance, and then click the Trial Balance tab to add and/or import accounts and balances.
- Click the Groupings tab to add or modify one of the pre-defined tax grouping schedules that are unique to each tax entity.
Steps in UltraTax CS
- Verify that your UltraTax CS licenses are up to date.
- Choose Utilities > Onvio Workpapers (Import) or Onvio Trial Balance (Import) to import the contact's account balances based on the groupings that you've assigned.
Note: The entity type for the contact in Onvio must match the entity type in UltraTax CS.
Troubleshooting tips
Use the following tips to assist you when you prepare accounts and balances in Onvio Workpapers or Onvio Trial Balance to import into UltraTax CS. If steps in the process are incomplete or incorrectly entered, the import may fail and produce errors.
- Adding a client: Avoid using special characters such as a slash "/" or period "." in the Client name or Client ID fields in the Setup > Clients screen.
- Creating the trial balance: As a best practice, we recommend that you use account numbers in Onvio so that descriptions map correctly between years on subschedules in UltraTax CS.
- Assigning codes: Be sure to assign tax codes to ungrouped accounts in the Groupings tab. (UltraTax CS requires this information to correctly map each account to a corresponding form and line number.)
Internal notes
Here are the links to the known issues in TFS.
- Error when importing into UltraTax if a slash ( / ) is used in the Onvio client name or client ID
- Error when importing into UltraTax if a period is at the end of the Onvio client name or client ID
- Error message appears when importing from Onvio into UT if accounts are not assigned tax codes
- Amounts may not import correctly into UT if account numbers are not used in Onvio Workpapers or Onvio Trial Balance