Skip to main content
Integrate with CS Suite
Search
Search UltraTax CS Support Help and Support.

This article applies to:

  • Product: UltraTax CS
  • Return type: 1040 Individual,1120 Corporation,1065 Partnership,1041 Fiduciary,990 Exempt Organization

Import general ledger balances with tax codes

Import balances with tax codes

UltraTax CS uses tax codes to summarize and transfer related account balances from the following general ledger applications into the tax return.
  • CS Professional Suite
    • Accounting CS.
    • Workpapers CS.
    • Creative Solutions Accounting (which includes Write-Up CS and Trial Balance CS).
  • 3rd party applications:
    • Dillner's Full Contact Accounting System (FCAS).
    • Universal Business Computing Company.
    • CaseWare Working Papers.
    • Client Ledger System.
    • ProSystem fx Engagement.
    • Accounting for Practitioners.
    • Accountant's Relief.
UltraTax CS examines and summarizes the general ledger balances in the client write-up files, applies whole dollar rounding, then transfers amounts to input screens according to the tax codes. Use the Tax Code Listing table to determine the correct tax codes.
note
UltraTax CS also makes the following adjustments:
  • Total Assets or total Liabilities to balance sheet balances
  • Accounts Payable account or, if this doesn't exist, then to the Cash account.

Import Accounting CS or Workpapers CS data

You can only assign or correct tax codes for Accounting CS and Workpapers CS clients from within these applications. Open the application and change or select the tax code for each account. You can then retrieve general ledger balances into UltraTax CS.

Import Engagement Manager data

You can only assign or correct tax codes for Engagement Manager clients from within Engagement Manager. Open the application and change or select the tax code for each account. You can then retrieve general ledger balances into UltraTax CS.
You can't edit tax codes for Engagement Manager clients while in UltraTax CS; tax codes can only be assigned or corrected in Engagement Manager.
  1. Open Engagement Manager and modify or select the tax code for each account.
  2. In UltraTax, go to
    Setup
    ,
    User Preferences
    , then the
    Misc
     tab.
  3. Verifying that the
    Enable import from Engagement Manager
     checkbox is marked
  4. Retrieve trial balances from Engagement Manager into UltraTax CS.

Import Creative Solutions Accounting data

  1. Verify that UltraTax CS knows the location of your general ledger application and data files.
  2. Assign valid tax codes or correct any invalid or blank tax codes.
    note
    UltraTax CS would have found invalid or blank tax codes when you tried to transfer data from Creative Solutions Accounting's Write-Up CS or Trial Balance CS modules.
  3. Retrieve the general ledger balances into UltraTax CS.

Import third-party data

  1. Verify that UltraTax CS knows the location of your general ledger application and data files.
  2. Assign valid tax codes in the source application.
  3. Retrieve general ledger balances into UltraTax CS.

Import into UltraTax CS

  1. Open UltraTax CS
    : Launch the UltraTax CS application.
  2. Select the Client
    : Open the client file.
  3. Access Import Feature
    :
    • Go to the
      Utilities
       menu.
    • Select
      Trial Balance Excel Import
      .
    • Select
      Import Trial Balance
      .
  4. Select Import Source
    : Select
    Excel
     in the import window.
  5. Locate Excel File
    : Select
    Browse
     to find and select the Excel file.
  6. Map Columns
    : Map the Excel columns to UltraTax CS fields (account number, description, unit, tax code, amount).
  7. Validate Data
    : Ensure the data is accurately mapped.
  8. Complete Import
    : Select
    Import
     or
    Finish
    .

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close