Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate with CS Suite

Import general ledger balances

Import balances with tax codes

UltraTax CS uses tax codes to import balances from the following applications:
  • CS Professional Suite
    • Accounting CS.
    • Workpapers CS.
    • Creative Solutions Accounting (which includes Write-Up CS and Trial Balance CS).
  • 3rd party applications:
    • Dillner's FCAS.
    • Universal Business Computing Company.
    • CaseWare Working Papers.
    • Client Ledger System.
    • ProSystem fx Engagement.
    • Accounting for Practitioners.
    • Accountant's Relief.
If you already maintain a client's general ledger information in Accounting CS, Workpapers CS, Write-Up CS, Trial Balance CS, or another general ledger application, using tax codes to import balances saves you time as you prepare a client's tax return.
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. It also makes adjustments to the total Assets or total Liabilities to balance sheet balances.
To determine the correct tax codes:
  1. Select
    Products Information
     from the UltraTax CS homepage.
  2. Select the federal application's tab.
  3. Select
    Federal
    , then
    Product guides
    .
  4. View or print the federal application's Tax Code Diagrams PDF.

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.
  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
    .

This article applies to:

  • Product: UltraTax CS
  • Return type: 1040 Individual, 1120 Corporation
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close