How do I migrate the data from CCH® ProSystem fx® Trial Balance to CCH Axcess™ Financial Prep?

  • Article Type:
  • How To
  • Last Modified:
  • 05/24/2022


To migrate the data from CCH ProSystem fx Trial Balance to CCH Axcess Financial Prep using new features added with the August 2020 release of CCH® ProSystem fx® Trial Balance version 2019.a01.


  • CCH ProSystem fx Trial Balance
  • CCH Axcess Financial Prep


The following video provides the process to migrate your data from CCH ProSystem fx Trial Balance to CCH Axcess™ Financial Prep.

To export the company data from CCH ProSystem fx Trial Balance, do the following:
  1. Open CCH ProSystem fx Trial Balance.
  2. Go to File > Batch Export Companies.
  3. On the Company Data Export dialog, select the appropriate options (for Tax entity and Tax year) and click Run Query.
  4. With the company to be exported showing in the lower pane, click Export.
  5. In the Export for CCH Axcess Financial Prep section, do the following:
    • In Create an Excel File for each company's account balances, select the checkbox.
    • In Prior period balance type, use the drop-down to select None, Unadjusted, or Adjusted to bring in prior period balances.
  6. Click Yes to continue.
    • Note: This will create the Excel files that will be used to import the data into CCH Axcess Financial Prep.
    • Note: In order to successfully export the Adjusted Prior Period balances for a company configured with a fiscal year end, the Grids - Years start and end dates will need to be adjusted to a 01/01 start and 12/31 end for the current and prior year(s).

To import the company data into CCH Axcess Financial Prep, do the following:
  1. Open CCH Axcess Financial Prep.
  2. Click Start New Engagement.
  3. On the New Engagement dialog, enter Client, Engagement Name, and Tax entity type
  4. Click Create.
  5. On the Import Trial Balance dialog, click Microsoft Excel.
  6. Browse to the folder that was created during the export process above, select the appropriate company trial balance file.
  7. Click Open.
    • Note: This will now import the trial balance information for both current and prior year that was found.
  8. During the import process, CCH Axcess Financial Prep will group many accounts using intelligent grouping. Review the trial balance and group any accounts needing grouped to complete the process. 

Important Note: If the ProSystem fx Trial Balance company databases are located on a server, you must run this batch export process from the Network Installation of the application on the server.

Additional Information


  Solution Tools
 Solution Id 000114362/How-do-I-migrate-the-data-from-CCH-ProSystem-fx-Trial-Balance-to-CCH-Axcess-Financial-Prep
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!