Retrieving general ledger balances using tax codes

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.

You can use tax codes to import general ledger or engagement balances into UltraTax CS from another application.

Retrieving general ledger balances from Accounting CS or Workpapers CS

Complete the steps below to transfer general ledger balances into the open UltraTax CS client from Accounting CS or Workpapers CS.

Video overview

The following video outlines the features described in the steps below.

Steps to retrieve balances

  1. Click the Accounting CS (Import) Accounting CS Import button button or the Workpapers CS (Import) Workpapers CS button button. You can also choose Utilities > Accounting CS (Import) or Utilities > Workpapers CS (Import) to open the import dialog.
  2. In the Clients available to transfer pane on the left, highlight the client(s) whose balances you want to transfer and click the Select button.

    Note: Only clients that are the same entity type as the UltraTax CS client will be listed in this dialog.

  3. Use the Data to import group box to view client information about the selected client (such as the UltraTax CS year end, Accounting CS or Workpapers CS current year end, and the Accounting CS or Workpapers CS prior year end), and to select retrieval options such as the year end, whether to retrieve balances from the adjusted trial balance or the federal tax trial balance, and whether to import detail or summary tax code information.

    Note: Select detail to list each account description and amount when importing to a field in UltraTax CS that includes a statement. Select summary to have the import process combine all amounts and only show one description and total in the statement.

  4. When you are ready to start the data transfer, click the Import button.
  5. If a message appears indicating that UltraTax CS detected invalid or blank tax codes in the selected Accounting CS or Workpapers CS client, do one of the following:
    • Click the View Tax Codes button to determine which codes are invalid or blank. To make changes to these accounts, you must open Accounting CS or Workpapers CS and make any modifications there.
    • Click the Continue button to retrieve balances only from those accounts with valid tax codes and ignore the invalid ones.
    • Click the Exit button to quit the retrieval process.
  6. When the transfer is complete, click the Done button.

Retrieving engagement balances from AdvanceFlow

Complete the following steps to transfer engagement balances into the open UltraTax CS client from AdvanceFlow.

  1. Choose Setup > User Preferences > Misc tab and mark the Enable import from AdvanceFlow checkbox.
  2. Choose Utilities > AdvanceFlow (Import) to open the import dialog.
  3. In the Clients available to transfer pane on the left, highlight the client(s) whose balances you want to transfer and click the Select button.

    Note: Only clients that are the same entity type as the UltraTax CS client are listed in this dialog.

  4. Select the appropriate engagement to import. Use the Data to import group box to choose either the current or prior year engagement balances to import. Click OK to return to the import dialog.
  5. When you are ready to start the data transfer, click the Import button.
  6. When the transfer is complete, click the Done button.

Retrieving general ledger balances from Creative Solutions Accounting (CSA)

Follow these steps to transfer general ledger balances into the open UltraTax CS client from Creative Solutions Accounting (CSA).

  1. Click the Creative Solutions Accounting (Import) CSA Import button button or choose Utilities > Creative Solutions Accounting (Import) to open the Import from Creative Solutions Accounting dialog.

    Notes

    • If you have Accounting CS installed, the Accounting CS icon is on the toolbar instead of the Creative Solutions Accounting icon.
    • If the Creative Solutions Accounting icon is not on the toolbar and any of the statements following are true, verify that the application and data files locations for Creative Solutions Accounting are correct in UltraTax CS: Accounting CS is not installed; the Creative Solutions Accounting (Import) menu command does not appear; clients are not listed in the Clients available to transfer pane.
  2. In the Clients available to transfer pane on the left, highlight the client(s) whose balances you want to transfer and click the Select button.

    Note: Only clients that are the same entity type as the UltraTax CS client will be listed in this dialog.

  3. If a message opens and indicates that UltraTax CS detected invalid or blank tax codes in the selected CSA client, do one of the following:
    • Click the Assign Tax Codes button and correct the tax codes as required.
    • Click the Continue button to retrieve balances only from those accounts with valid tax codes and ignore the invalid ones.
    • Click the Exit button to quit the retrieval process.
  4. If necessary, click the Assign Tax Codes button to assign tax codes for the CSA client highlighted in the Clients to transfer pane on the right.
  5. When you are ready to start the data transfer, click the Import button.
  6. If UltraTax CS cannot determine whether to use the general ledger client's current-year or prior-year data, a prompt appears. Complete one of the following actions.
    • To transfer current-year balances, click the Current year information option in the Year End group box, then click Continue.
    • If you have advanced the general ledger client past the UltraTax CS year end, click the Prior year information option in the Year End group box, then click Continue.
  7. When the transfer is complete, click the Done button.

Note: UltraTax CS displays in blue all data that was retrieved from a general ledger application into the UltraTax CS input screens. By default the cursor skips these fields, but you can set an option to change the default.

Retrieving general ledger balances from third party accounting applications

Follow these steps to transfer general ledger balances into the open UltraTax CS client from the following applications: Fiducial Advantage, CaseWare Working Papers, Dillner's FCAS, Universal Business Computing Company, Client Ledger System, ProSystem fx Engagement, Accountant's Relief, or Accounting for Practitioners.

  1. Choose Utilities > Third Party > [Application Name] (Import) to open the appropriate import dialog.
  2. If no clients appear in the list, click the Change Location button to browse to the directory of your accounting data.

    Note: Only clients that are the same entity type as the UltraTax CS client will be listed in this dialog.

  3. Highlight the client whose balances you want to transfer and click the Import button to begin the transfer.
  4. When the transfer is complete, click the Done button.

Related topics

Was this article helpful?

Thank you for the feedback!