Retrieving general ledger balances into UltraTax CS

Show expandable text

New (tax) year, new help!

Fixed Assets and UltraTax CS 2023 help is now on Help and Support. We're still moving articles, but you can find most content for the 2023 tax year there. Continue using the Help & How-To Center for tax years 2022 and older.

Importing balances with tax codes

UltraTax CS uses tax codes to import balances from the following general ledger applications: Accounting CS, Workpapers CS, Creative Solutions Accounting (which includes Write-Up CS and Trial Balance CS), Dillner's FCAS, Universal Business Computing Company, CaseWare Working Papers, Client Ledger System, ProSystem fx Engagement, Accounting for Practitioners, and 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 the general ledger balances in the client write-up files, summarizes those balances as needed, applies whole dollar rounding, and then transfers relevant amounts to the corresponding input screens according to the tax codes. UltraTax CS also makes adjustments to the total Assets or total Liabilities so that the balance sheet balances.

Note: If the client has an Accounts Payable amount, UltraTax CS makes the adjustment to the Accounts Payable account. If not, UltraTax CS makes the adjustment to the Cash account.

To determine the correct tax codes, view or print the appropriate federal application's Tax Code Diagrams PDF. You can open this PDF by opening the UltraTax CS Home Page, clicking the Products Information link, clicking the appropriate federal application's tab, clicking the Federal link, and then clicking the Product guides link.

For more information, see Tax code diagrams for UltraTax CS applications.

Importing Accounting CS or Workpapers CS data

You cannot edit tax codes for Accounting CS or Workpapers CS clients while in UltraTax CS; tax codes can only be assigned or corrected in the Accounting CS or Workpapers CS application. To assign or correct tax codes, open Accounting CS or Workpapers CS and modify or select the tax code for each account. Then, you can retrieve general ledger balances into UltraTax CS.

For more information, see Specifying client data and integrated application file locations, and Retrieving general ledger balances using tax codes.

Importing AdvanceFlow data

You cannot edit tax codes for AdvanceFlow clients while in UltraTax CS; tax codes can only be assigned or corrected in AdvanceFlow. To assign or correct tax codes, open AdvanceFlow and modify or select the tax code for each account. After verifying that the Enable import from AdvanceFlow checkbox is marked on the Setup > User Preferences > Misc tab in UltraTax CS, you can retrieve trial balances from AdvanceFlow into UltraTax CS.

Importing Creative Solutions Accounting data

Before you can assign or correct tax codes in CSA, you need to verify that UltraTax CS knows the location of your general ledger application and data files. Then, you can assign valid tax codes or correct any invalid or blank tax codes that UltraTax CS found when you attempted to transfer data from Creative Solutions Accounting's Write-Up CS or Trial Balance CS modules. After you have assigned or corrected the tax codes, you can retrieve general ledger balances into UltraTax CS.

For more information, see Specifying client data and integrated application file locations, Assigning or correcting tax codes for CSA clients, and Retrieving general ledger balances using tax codes.

Importing third-party data

Before you can assign or correct tax codes in third-party applications, such as Dillner's FCAS, Universal Business Computing Company, CaseWare Working Papers, Client Ledger System, Accounting for Practitioners, Accountant's Relief, and ProSystem fx Engagement, you need to verify that UltraTax CS knows the location of your general ledger application and data files. Then, you can assign valid tax codes in the source program. After you have assigned the tax codes, you can retrieve general ledger balances into UltraTax CS.

For more information, see Specifying client data and integrated application file locations, and Retrieving general ledger balances using tax codes.

Was this article helpful?

Thank you for the feedback!